Question: I need help on questions 5a & 5b , 6a & 6b. I will need them fully answered and explained with corresponding chart located above

I need help on questions 5a & 5b , 6a & 6b. I will need them fully answered and explained with corresponding chart located above each. Thank you for your time and assistance!

Questions 5a, 5b, 6a, and 6b are about forecasting methods. (5 points each) Weighted Weighted Exponential Exponential 3-year 4-year 3-year 4-year Smoothing Smoothing MA MA MA MA Alpha. 1 Alpha 3 MAD .679 .592 .640 .616 1.257 .697 MSE .595 .472 .503 .479 1.865 .692 Regression .420 .233 Sa. Which method appears to provide the best forecast? Why? 5b. What is the difference between the MAD and the MSE? Sales Forecasting (million) Regression Statistics Multiple R 0.876 R Square 0.768 Adjusted R Square 0.752 Standard Error 0.514 Observations 17 ANOVA df 1 15 16 Significance F 0.0001 Regression Residual Total MS 1313 0.264 49.687 SS 13.133 3.965 17.100 Intercept Coefficients -353.65 0.179 Standard Error 51.134 0.0255 Star -6.916 7.049 p-value 0.0001 0.0001 Lower 95% 46264 0.125 Upper 95% -244.660 0.234 Year 6a. What is the regression equation for this forecasting model? 6b. What does the regression equation output tell you about the sales forecast? Questions 5a, 5b, 6a, and 6b are about forecasting methods. (5 points each) Weighted Weighted Exponential Exponential 3-year 4-year 3-year 4-year Smoothing Smoothing MA MA MA MA Alpha. 1 Alpha 3 MAD .679 .592 .640 .616 1.257 .697 MSE .595 .472 .503 .479 1.865 .692 Regression .420 .233 Sa. Which method appears to provide the best forecast? Why? 5b. What is the difference between the MAD and the MSE? Sales Forecasting (million) Regression Statistics Multiple R 0.876 R Square 0.768 Adjusted R Square 0.752 Standard Error 0.514 Observations 17 ANOVA df 1 15 16 Significance F 0.0001 Regression Residual Total MS 1313 0.264 49.687 SS 13.133 3.965 17.100 Intercept Coefficients -353.65 0.179 Standard Error 51.134 0.0255 Star -6.916 7.049 p-value 0.0001 0.0001 Lower 95% 46264 0.125 Upper 95% -244.660 0.234 Year 6a. What is the regression equation for this forecasting model? 6b. What does the regression equation output tell you about the sales forecast

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

On February 12, 2003, Nancy Trout and Delores Lake formed Kingfisher corporation to sell fishing tackle. Pertinent information regarding Kingfisher is summarized as follows: > Kingfisher's business...

Need help filing out the Form 706 that goes along with the Estate Tax Problem. Specifically, what is the amount entered in line 10, part 5 of the Form 706? Estate\tTax\tProblem...

Hi, Please calculate "Dividend Yield" for Toyota Motor Corporation for Year 2018 and 2019 from the attached report. Also explain from where we get the figures or how to calculate them like: DPS and...

CONTENTS 1. INTRODUCTION.. 3 2. TASK A KNOWLEDGE QUESTIONS. 5 3. TASK B PRODUCE A CONTENT STRATEGY. 7 4. TASK C DEVELOP AND PUBLISH CONTENT. 13 5. TASK D REVIEW CONTENT PERFORMANCE. 17 6. ASSESSMENT...

Write 2 paragraphs about THE FUTURE OF INTERNATIONAL TRADE GOVERNANCE IN A PROTECTIONIST WORLD: THEORIZING WTO NEGOTIATING PERSPECTIVES article. No word count, page count, or formatting requirements....

v Dr. Uma Kotagal, Senior Vice President (SVP) of Quality and Transformation, reflected on the beehive of improvement activity under way in 2009 at the Cincinnati Children's Hospital Medical Center...

Justin Stone was an employee of DataCare Services, Inc. His salary was $45,000 through November 10, 2021, when he was laid off. DataCare Services provided medical insurance for Justin and his family...

a brief summary what was understood on the aspect of the causes or effects of segregation in city ( any kind of city within US). 1000word. Thank you REFERENCE: CHAPTER 5 Residential Segregation and...

Peter is a notorious for using Internet technology to hype stocks. He made over $500,000 by posting false messages on online chats, encouraging people to buy coin stocks he already owned. He used AOL...

What is the problem statement in the following situation? (1 statement) Employee Loyalty: Companies benefit through employee loyalty. Crude downsizing in organizations during the recession crushed...

To account for a stock dividend, a company increases retained earnings and reduces contributed capital accounts. True False

2023 1040 form 1.Phillip and Claire are married and file a joint return. Phillip is self-employed as a real estate agent, and Claire is a flight attendant. Phillip and Claire have three dependent...