linear-regression-2

linear-regression-2

You are a consultant for the Excellent Consulting Group (ECG). You have completed the first assignment, developing and testing a forecasting method that uses Linear Regression (LR) techniques (Module 3 Case). However, the consulting manager at ECG wants to try a different forecasting method as well. Now you decide to try Single Exponential Smoothing (SES) to forecast sales.

Using this Excel template: Data chart for BUS520 Case 4, do the following:

1. Calculate the MAPE for Year 2 Linear Regression forecast (use the first spreadsheet tab labeled “Year 2 Forecast – MAPE”).
2. Calculate forecasted sales for Year 2 using SES (use the second spreadsheet tab labeled “SES – MAPE”). Use 0.15 and 0.90 alphas.
3. Compare the MAPE calculated for the LR forecast (#1 above) with the MAPEs calculated using SES.

Then

write a report to your boss in which you discuss the results obtained

above. Using calculated MAPE values, make a recommendation concerning

which method appears to be more accurate for the Year 2 data: SES or

Linear Regression.

Analysis

• Accurate and complete SES analysis in Excel.

Written Report

• Length requirements: 4–5 pages minimum (not including Cover and Reference pages). NOTE: You must submit 4–5 pages of written discussion and analysis. This means that you should avoid use of tables and charts as “space fillers.”
• Provide a brief introduction to/background of the problem.
• Complete a written analysis that supports your Excel analysis, discussing the assumptions, rationale, and logic used to complete your SES forecast.
• Give complete, meaningful, and accurate recommendation(s) relating to whether LR or SES is more accurate in predicting sales.

#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational