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 22:00
The customer price index(cpi), which measures the cost of a typical package of customer goods,was 208.8 in 2011 and 244.1 in 2016.let x=11 corresponding to the year 2011 an estimate to cpi into 2013 and 2014. assume that the data can be modeled by a straight line and the trend to continue idenfinitely.use data points to find such a line and then estimate the requested quantities
Answers: 1
Mathematics, 21.06.2019 22:20
Question 9 of 10 2 points suppose your sat score is 1770. you look up the average sat scores for students admitted to your preferred colleges and find the list of scores below. based on your sat score of 1770, which average score below represents the college that would be your best option? o a. 1790 o b. 2130 o c. 2210 od. 1350
Answers: 3
Mathematics, 21.06.2019 23:50
Apolynomial has two terms. check all of the factoring methods that should be considered. common factor difference of cubes sum of cubes difference of squares perfect-square trinomial factoring by grouping
Answers: 3
Mathematics, 28.04.2021 17:00
Mathematics, 28.04.2021 17:00
Mathematics, 28.04.2021 17:00
Physics, 28.04.2021 17:00
Mathematics, 28.04.2021 17:00
Mathematics, 28.04.2021 17:00
History, 28.04.2021 17:00
Mathematics, 28.04.2021 17:00
Mathematics, 28.04.2021 17:00
Mathematics, 28.04.2021 17:00
Social Studies, 28.04.2021 17:00