, 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 histogram2. 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 followstreated untreated22 37 41 55 52 20 37 37 50 1219 32 39 44 40 26 21 46 31 4950 28 44 38 24 13 21 40 18 2840 31 43 47 54 26 39 24 33 48a. 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 numberchrome 05dents 25paint 30upholstery 10windshield 054. 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 24 3 3 1 1 1 5 69 5 8 12 11 10 11 127 9 9 5 14 3 4 24 1 4 4 4 11 14 116 8 5 8 5 11 2 31 4 3 1 2 4 10 1219 18 18 17 15 16 4 38 6 7 9 7 7 6 212 8 9 3 11 12 19 24use 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.

### Other questions on the subject: Mathematics

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! ❤
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?
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
Mathematics, 22.06.2019 01:30, jackievelasquez3424
Apply distributive property to write equivalent equation 105×35m