Purchase Solution

Typical Seasonal Demand for Summer Highs

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution
Solution Summary

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

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 provided by:
Changping Wang, MA
Education
  • BSc , Wuhan Univ. China
  • MA, Shandong Univ.
Recent Feedback
  • "Your solution, looks excellent. I recognize things from previous chapters. I have seen the standard deviation formula you used to get 5.154. I do understand the Central Limit Theorem needs the sample size (n) to be greater than 30, we have 100. I do understand the sample mean(s) of the population will follow a normal distribution, and that CLT states the sample mean of population is the population (mean), we have 143.74. But when and WHY do we use the standard deviation formula where you got 5.154. WHEN & Why use standard deviation of the sample mean. I don't understand, why don't we simply use the "100" I understand that standard deviation is the square root of variance. I do understand that the variance is the square of the differences of each sample data value minus the mean. But somehow, why not use 100, why use standard deviation of sample mean? Please help explain."
  • "excellent work"
  • "Thank you so much for all of your help!!! I will be posting another assignment. Please let me know (once posted), if the credits I'm offering is enough or you ! Thanks again!"
  • "Thank you"
  • "Thank you very much for your valuable time and assistance!"
Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • statistics

    Please refer to spreadsheet attach below: 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

  • Time Series Forecast

    Summer Historical Inventory Data Typical Seasonal Demand for Summer Highs Actual Demands (in units) Month Year 1 Year 2 Year 3 Year 4 Forecast 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

  • Forecast inventory for next year.

    The forecasting inventory for the next year are examined. The typical seasonal demand for winter highs are determined.

  • Forecast

    354362 Forecast Future Inventory Costs Summer Historical Inventory Data Typical Seasonal Demand for Summer Highs Actual Demands (in units) Month Year 1 Year 2 Year 3 Year 4 Forecast 1 18,000 45,100 59,800 35,500 2 19,800 46,530

  • Business Management: Index Conversion and Forecasting

    DATA: Typical Seasonal Demand for Summer Highs Actual Demands (in units) Month Year 1 Year 2 Year 3 Year 4 Forecast 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

  • typical seasonal index of the surf board

    that quarter, but I have expected it because the typical seasonal index for that quarter is 1.668.

  • Forecasting: Calculate water usage for four quarters 2009.

    Q for Spring 09 = 98 [ it is 98th quarter if we consider Winter 1984 to be first quarter) demand for spring 09 = [77 + 0.43*9] x 1.1 (seasonal factor) =131.53 Summer Q = 99 Demand = [77 + 0.43*9] x 1.4 =168.00 Fall Q = 100 Demand

  • Seasonal index of lumber production

    Determine the typical seasonal pattern for the production data using the ratio-to-moving-average method. b. Interpret the pattern. c. Deseasonalize the data and determine the linear trend equation. d.

  • Time series analysis

    The following is an exercise, where you are to perform the required calculations to develop typical seasonal pattern for a given time series data, using the centered to moving average method.

View More Related Solutions