Make linear regression forecast generally

Assignment Help Operation Management

Reference no: EM132300254

The data below provides monthly sales for 18 months.

Month = 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38

Sales =4241, 3989, 4776, 4347, 4545, 4328, 4644, 4472, 4755, 4917, 5155, 4920, 4995, 4823, 5098, 4921, 5289, 5334

a) Use a four period weighted moving average with weights of 0.5, 0.25, 0.15, and 0.1 to forecast the month 39 sales. Forecast of sales for month 39 = _______

b) What is the linear regression equation for forecasting, and what is the R2 value? Equation: R2 = ________

c) Use linear regression to make a forecast for months 39 and 45. Forecast of sales for month 39 = _______ Forecast of sales for month 45 = ______

d) What about this data above will make a linear regression forecast generally greater than a weighted moving average forecast?

Reference no: EM132300254

Questions Cloud

Identify current evidence-based treatment modalities : Identify current evidence-based treatment modalities for the selected syndrome or disease and discuss how the treatment impacts the disease process.

What is the minimum number of servers required : What is the minimum number of servers required? What is the average time a customer spends waiting in line if there are 5 identical servers?

Microsoft project software in operations-project management : Explain the purpose of Microsoft Project software in Operations and Project Management.

Analyze current evidence-based treatment modalities : Analyze current evidence-based treatment modalities specific to the aging population and include evidence-based treatment guidelines for iron deficiency.

Make linear regression forecast generally : What about this data above will make a linear regression forecast generally greater than a weighted moving average forecast?

Explain psychological issues that may result from your topic : Explain the psychological issues that may result from your topic. Describe the most effective assessment measure that could be used, and explain why you.

Social media to attract and retain customers : The Main Topic is: Social Media - How to use Social Media to Attract and Retain Customers in a sales organization.

Discuss how social networks and cloud computing : Discuss how social networks and cloud computing increase IT security risks. How do you recommend that the risks be reduced?

Rewards contribute to high performance : How Adobe’s People and Rewards Contribute to High Performance

User Account

All Pages