Needing help with-data analysis: forecasting with smoothing | management science through spreadsheets | Southern New Hampshire University

Hello all,

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

I’m really lost on this week 6 sample assignment.  See prompt:

 Prompt: 10.24  The choice of the smoothing constants, α and β, has a considerable effect on the accuracy of the forecasts obtained by using exponential smoothing with trend.  

For each of the following time series, set α = 0.2 and then compare MAD obtained with β = 0.1, 0.2, 0.3, 0.4, and 0.5. 

Begin with initial estimates of 50 for the  average value and 2 for the trend.  a. 52, 55, 55, 58, 59, 63, 64, 66, 67, 72, 73, 74  b. 52, 55, 59, 61, 66, 69, 71, 72, 73, 74, 73, 74  c. 52, 53, 51, 50, 48, 47, 49, 52, 57, 62, 69, 74  

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Step 1) Change the Beta Value and create a graph for each of the 5 given Beta values in each of the 3 databases. You could also create one graph per tab with 5  separate lines. The graphs is already part of the spreadsheet, you need to create the lines for the Beta values. There is no need to create additional tabs in the  spreadsheet.  

Step 2) Briefly describe the impact of the Beta value on the 3 databases. You should submit a written paragraph with explanation either in a separate Tab in the  Excel Template for a separate word document. No references needed.  **************

I’ve uploaded the page from the assignment book, screenshot 1 is the data sets while screenshot 2 is a data chart with sales metrics.  The 2nd I think is only for reference as needed.

Also attached is the work template we’re suppose to complete.  I’d like the full steps and template done if possible.  Thanks so much in advance!

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.
Open chat
Order through WhatsApp!
You Can Now Place your Order through WhatsApp

Order your essay today and save 30% with the discount code ESSAYHELP2