Explore BrainMass
Share

Explore BrainMass

    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?

    © BrainMass Inc. brainmass.com May 20, 2020, 5:53 pm ad1c9bdddf
    https://brainmass.com/statistics/frequency-distribution/statistics-managers-microsoft-excel-249575

    Attachments

    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

    ADVERTISEMENT