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.
. 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 12:50
In the final round of trivia competition, contestants were asked to name as many states that begin with the letter m as they could in 15 seconds. the bar graph shows the number of states the contestants were able to name. how many contestants participated in the final round of the competition?
Answers: 2
Mathematics, 21.06.2019 15:00
1. are the triangles similar and if so why? what is the value of x? show your work.
Answers: 2
Mathematics, 21.06.2019 19:30
Suppose i pick a jelly bean at random from a box containing one red and eleven blue ones. i record the color and put the jelly bean back in the box. if i do this three times, what is the probability of getting a blue jelly bean each time? (round your answer to three decimal places.)
Answers: 1
Mathematics, 16.12.2020 21:40
Mathematics, 16.12.2020 21:40
English, 16.12.2020 21:40
English, 16.12.2020 21:40
Mathematics, 16.12.2020 21:40
Social Studies, 16.12.2020 21:40
Biology, 16.12.2020 21:40
Health, 16.12.2020 21:40
Mathematics, 16.12.2020 21:40