Cashback Offer from 22nd to 27th July 2021. Get Flat 20% Cashback credited to your account for a minimum transaction of \$50. Post Your Question Today!

Question Details Urgent
\$ 10.00

# Need Help ASAP -3

• From Mathematics, Data Analysis
• Due on 02 May, 2021 10:56:00
• Asked On 02 May, 2021 02:47:08
• Due date has already passed, but you can still post solutions.
Question posted by
• Submit one Excel file with your answers for the following questions ((a)-(b)).
• In your Excel file create two worksheets:
• P5 Forecasting: the StatTools report of your forecasting model for part (b)
• Answers: all answers for part (a) - (b)

The following data contains the annual revenue of a convenient store in thousand dollars.

Our goal is to predict the revenue for the following 4 years.

(a) Which time series forecasting method would be the best (select one)? Explain your answer.

1. Moving average
2. Simple exponential smoothing
3. Double (Holt’s) exponential smoothing
4. Triple (Holt-Winter’s) exponential smoothing
5. Linear regression model
6. Nonlinear regression model

(b) Build the model you choose using StatTools. If your model has parameters such as a span or smoothing constants, select appropriate values by manually tuning them.

1. Display the regression output as 'P5 Forecasting' in your Excel file.

2. Fill in the table below with your predictions.

3. Discuss the overall performance of you model.

Note: You may use all data for training or split the data to validate your model.

Attachment
No solution has been posted yet.Be first to post the solution!
Other Related Questions
SC2007

### Need help with statistics 200 questions

Status : 4 solution
eddie...

### Need Help ASAP - STATS

Status : 1 solution
Laure...

### Need help with some Stats problems Pt. 2

Status : 1 solution
Laure...

### Need help with some Stats problems

Status : 1 solution
mboren

### Need Help with STAT Quiz

Status : 1 solution

#### The benefits of buying study notes from CourseMerit

##### Assurance Of Timely Delivery
We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.
##### Best Price In The Market
All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.
##### Uninterrupted 24/7 Support
Our customer support wing remains online 24x7 to provide you seamless assistance. Also, when you post a query or a request here, you can expect an immediate response from our side.
Only 45 characters allowed.

\$ 629.35