Explore BrainMass

Explore BrainMass

    Typical Seasonal Demand for Summer Highs

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

    1. Compute the standard deviation in Microsoft Excel using the data (raw data from years 1-4)
    2. Generate a normal distribution of the data using Microsoft Excel.
    3. Compare the range with the standard deviation of the data.

    Typical Seasonal Demand for Summer Highs

    Actual Demands (in units)

    Month Year 1 Year 2 Year 3 Year 4
    1 18,000 45,100 59,800 35,500
    2 19,800 46,530 30,740 51,250
    3 15,700 22,100 47,800 34,400
    4 53,600 41,350 73,890 68,000
    5 83,200 46,000 60,200 68,100
    6 72,900 41,800 55,200 61,100
    7 55,200 39,800 32,180 62,300
    8 57,350 64,100 38,600 66,500
    9 15,400 47,600 25,020 31,400
    10 27,700 43,050 51,300 36,500
    11 21,400 39,300 31,790 16,800
    12 17,100 10,300 31,100 18,900
    Avg.

    © BrainMass Inc. brainmass.com June 4, 2020, 12:44 am ad1c9bdddf
    https://brainmass.com/statistics/normal-distribution/typical-seasonal-demand-summer-highs-356439

    Solution Preview

    Please see the attached files.

    1. Compute the standard deviation in Microsoft® Excel® using the data (raw data from years 1-4)
    Use Excel, we find out the standard deviation is 18349.47, see the attached spreadsheet.
    2. Generate a ...

    Solution Summary

    The expert examines the typical seasonal demands for summer highs. Standard deviation of normally distributed data is examined.

    $2.19

    ADVERTISEMENT