Helme

solve the following problems using microsoft excel.

. answer each question in different sheets, of one excel file.

1. 50 companies percentages of revenues spent on r& d are given below.

5.5 6.9 7.7 8.5 10.1

5.6 6.9 7.8 8.8 10.5

5.9 7.1 7.9 9 10.5

6 7.1 8 9.2 10.6

6.5 7.2 8 9.4 11.1

6.5 7.2 8.1 9.5 11.3

6.5 7.4 8.2 9.5 11.7

6.6 7.5 8.2 9.6 13.2

6.8 7.5 8.2 9.7 13.5

6.9 7.7 8.4 9.9 13.5

- create 7 classes of this set of data

• graph a frequency histogram

2. a new fertilizer was applied to 20 fruit bushes to see if their yield of fruit increased. another 20 trees were left untreated. the yields inkg, were as follows

treated untreated

22 37 41 55 52 20 37 37 50 12

19 32 39 44 40 26 21 46 31 49

50 28 44 38 24 13 21 40 18 28

40 31 43 47 54 26 39 24 33 48

a. construct a sorted stem and leaf diagram to compare the two sets of data and comment on the effects of the new fertilizer.

b. use numerical measures of descriptive statistics to describe both the data set.

c. explain and interpret the all 3 sd intervals for both the data set.

3. draw a bar chart and a pie chart for the following data. (use ms excel )

body defect number

chrome 05

dents 25

paint 30

upholstery 10

windshield 05

4. a sample of 80 quality control technicians who participated in a survey where asked to report the number of years they had been with their present employer. the results follow.

5 29 26 27 26 29 4 2

4 3 3 1 1 1 5 6

9 5 8 12 11 10 11 12

7 9 9 5 14 3 4 2

4 1 4 4 4 11 14 11

6 8 5 8 5 11 2 3

1 4 3 1 2 4 10 12

19 18 18 17 15 16 4 3

8 6 7 9 7 7 6 21

2 8 9 3 11 12 19 24

use excel functions to answer the following.

a. from this data calculate the mean, median, mode and standard deviation.

b. compute the three standard deviation intervals.

c. find the percentage of data in each interval.