Middle School

please helme guys.....



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.




please helme guys Solve the following problems using Microsoft Excel Answer each question in different sheets of one excel file 1 50 companies percentages of

Answer :

Sorry this took so long! I managed to do everything except for the parts involving standard deviation. (I tried but I couldn't quite figure it out.)

~Hope this helps!~

Final answer:

This question involves the use of Microsoft Excel for various statistical and data analysis tasks including the calculation of statistical measures, construction of different charts and interpretation of data.

Explanation:

This question involves several concepts and applications within Microsoft Excel, including the creation of various graphs and charts, using statistical measures for datasets, and applying Excel functions to analyze and interpret a set of data.

For problem 1, you need to first create 7 classes for the given set of data using Excel's class function. Then, create a frequency histogram using these classes of data.

In problem 2, you will construct a sorted stem and leaf diagram for both the 'Treated' and 'Untreated' fruit bush data sets. You will then utilize Excel's statistical capabilities to calculate mean, median, standard deviation, etc. Then explain and interpret the three Standard Deviation intervals for the data set.

For problem 3, you need to construct a bar chart and pie chart using the given data on Body Defect. This can be achieved utilizing Excel's chart creation tool, where you input the given data and choose the chart type.

Problem 4 requires the application of Excel's statistical functions. You will find the mean, median, mode, and standard deviation of the data set representing years quality control technicians have been with their present employers. Following this, compute three standard deviation intervals and find the percentage of data within each interval.

Learn more about Excel Data Analysis here:

https://brainly.com/question/30396320

#SPJ12