Mathematics
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.

answer
Answers: 2
Get

Other questions on the subject: Mathematics

image
Mathematics, 21.06.2019 18:30, Braxton12
This is my question~~ ( r ^ 4 - 2r ^ 3 - 23 r ^ 2 - 4r - 32)÷(r+4) ~~ i must use long division to solve it : / i was wondering if anyone world like to solve it. and if so, share step-by-step explanations! you! ❤
Answers: 2
image
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
image
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
image
Mathematics, 22.06.2019 01:30, jackievelasquez3424
Apply distributive property to write equivalent equation 105×35m
Answers: 1
Do you know the correct answer?
Helme

solve the following problems using microsoft excel.

. answer each quest...

Questions in other subjects:

Konu
Mathematics, 04.09.2020 17:01
Konu
Mathematics, 04.09.2020 17:01
Konu
French, 04.09.2020 17:01
Total solved problems on the site: 13543662