Explore BrainMass
Share

# Statistics for Managers Using Microsoft Excel

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

The data in the file protein.xls indicate fat and cholesterol information concerning popular protein foods (fresh red meats, poultry, and fish).

For the data relating to the number of calories and the amount of cholestrol for the popular protein foods:

a. Consruct a frequency distribution and a percentage distribution.

b. Construct a histogram and a percentage polygon.

c. Form a cumulative percentage distribution and plot a cumulative percentage polygon.

d. What conclusions can you draw from these analyses?

https://brainmass.com/statistics/frequency-distribution/statistics-managers-microsoft-excel-249575

#### Solution Preview

Statistics for Managers Using Microsoft Excel Ch.2 2.78
The data in the file protein.xls indicate fat and cholesterol information concerning popular protein foods (fresh red meats, poultry, and fish).

For the data relating to the number of calories and the amount of cholestrol for the popular protein foods:
a. Consruct a frequency distribution and a percentage distribution.
b. Construct a histogram and a percentage polygon.
c. Form a cumulative percentage distribution and plot a cumulative percentage polygon.
d. What conclusions can you draw from these analyses?
Solution:
a.
Frequency Distribution - Quantitative

Calories
lower upper midpoint width frequency percent
60 < 90 75 30 0 0.0
90 < 120 105 30 6 24.0
120 < 150 135 30 0 0.0
150 < 180 165 30 2 8.0
180 < 210 195 30 8 32.0
210 < 240 ...

#### Solution Summary

This solution constructs a frequency distribution, percentage distribution, histogram, percentage polygon and also prepares and cumulative percentage distribution and cumulative percentage polygon. It also interprets the result of the popular protein foods from the graphs.

\$2.19