Helme

solve the following problems using microsoft excel.

. answer each quest...

Mathematics, 08.11.2019 16:31, babiibri4771

#
Helme

solve the following problems using microsoft excel.
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.

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.

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.

Answers: 2

Mathematics, 21.06.2019 18:30, macylen3900

Jamie went to home depot. she bought 25 bags of soil that cost $9 per bag. she bought 15 pots at $8 each, and she bought 23 bags of pebbles at $15 each. she used a coupon that gave her $5 off for every 100 dollars she spent. how much did jame pay at the end?

Answers: 1

Mathematics, 22.06.2019 00:00, camila9022

Tatiana reads 40 pages of her book every night for x number of nights. write an expression that shows the number of pages she has read

Answers: 3

Mathematics, 22.06.2019 01:30, jackievelasquez3424

Apply distributive property to write equivalent equation 105×35m

Answers: 1

Mathematics, 04.09.2020 17:01

Mathematics, 04.09.2020 17:01

Mathematics, 04.09.2020 17:01

French, 04.09.2020 17:01

English, 04.09.2020 17:01