Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The number of cans of soft drinks sold in a machine each week is recorded below: Weekly Period 1 2 3 4 5 6 7
The number of cans of soft drinks sold in a machine each week is recorded below: Weekly Period 1 2 3 4 5 6 7 8 Soft Drinks Sold 122 85 92 98 110 108 115 102 Weekly Period 9 10 11 12 13 14 15 16 Soft Drinks Sold 95 98 105 125 85 106 140 84 Weekly Period 17 18 19 20 21 22 23 24 Soft Drinks Sold 92 85 78 105 111 152 140 108 a. Using Excel, develop forecasts for periods of 1 to 24, using a trend line. b.Calculate the MSE and MAD for your model. c. Calculate the R statistic and intepret it.
The number of cans of soft drinks sold in a machine each week is recorded below: | ||||||||
Weekly Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Soft Drinks Sold | 122 | 85 | 92 | 98 | 110 | 108 | 115 | 102 |
Weekly Period | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 |
Soft Drinks Sold | 95 | 98 | 105 | 125 | 85 | 106 | 140 | 84 |
Weekly Period | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |
Soft Drinks Sold | 92 | 85 | 78 | 105 | 111 | 152 | 140 | 108 |
a. Using Excel, develop forecasts for periods of 1 to 24, using a trend line. | ||||||||
b.Calculate the MSE and MAD for your model. | ||||||||
c. Calculate the R statistic and intepret it. | ||||||||
Explain step by step how to solve and input using excel spreadsheet.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started