The following data are for calculator sales in units at an electronics store over the past nine weeks: Week 1 2 3 Obtain the error measures. (Enter your responses rounded to two decimal places.) 4 5 CFE MSE Sales 44 46 44 51 58 Use trend projection with regression to forecast sales for weeks 10-13. What are the error measures (CFE, MSE, o, MAD, and MAPE) for this forecasting procedure? How about r²? Obtain the trend projection with regression forecast for weeks 10-13. (Enter your responses rounded to two decimal places.) Forecast, F Find the coefficient of determination (²). The coefficient of determination r² = 0. (Enter your response rounded to two decimal places.) Period 10 11 12 13 Week 6 7 6 8 9 Sales 54 63 53 61 MAD MAPE %
The following data are for calculator sales in units at an electronics store over the past nine weeks: Week 1 2 3 Obtain the error measures. (Enter your responses rounded to two decimal places.) 4 5 CFE MSE Sales 44 46 44 51 58 Use trend projection with regression to forecast sales for weeks 10-13. What are the error measures (CFE, MSE, o, MAD, and MAPE) for this forecasting procedure? How about r²? Obtain the trend projection with regression forecast for weeks 10-13. (Enter your responses rounded to two decimal places.) Forecast, F Find the coefficient of determination (²). The coefficient of determination r² = 0. (Enter your response rounded to two decimal places.) Period 10 11 12 13 Week 6 7 6 8 9 Sales 54 63 53 61 MAD MAPE %
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.3: Simple Regression Models
Problem 2P: The file P13_02.xlsx contains five years of monthly data on sales (number of units sold) for a...
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 7 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing