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
$ 15.00

NEED HELP ASAP -2 Data

  • From Mathematics, Data Analysis
  • Due on 02 May, 2021 10:58:00
  • Asked On 02 May, 2021 02:59:34
  • Due date has already passed, but you can still post solutions.
Question posted by
Online Tutor Profile
request
  • Submit one Excel file with your answers for the following questions ((a)-(e)).
  • In your Excel file create three worksheets:
    • P4-(b): regression report for part (b)
    • P4-(d): regression report for part (d)
    • Answers: all answers for part (a) - (e)

  The following data contains the monthly number of airlines tickets sold by a travel agency for four years

Our goal is to build a regression model to predict the demand for the following 12 months.

a) Does a linear trend appear to fit these data well? Explain why or why not. Reference any tables/figures that you need to make your point.

b) Build a linear trend model or nonlinear trend regression model (depending on your answer in part a). Do not add a seasonality factor to this model. To validate your model, use the last 12 months as a validation data set.

    1. Display the regression output as 'P4 (b)' in your Excel file. Attach the plot of the fitted values and the actual values over time in worksheet ‘Answer’ in your Excel file.
    2. Fill in the table below with your predictions and errors. What are the RMSE and MAPE of the trend model based on the validation data? Display the results in the worksheet ‘Answer’.

c) Is there evidence of some seasonal pattern in the sales data? If so, characterize the seasonal pattern (monthly, quarterly, or yearly) with the number of seasons.

d) Build a regression model with trend and seasonality. To validate your model, use the last 12 months as a validation data set.

    1. Display the regression output as 'P4-(d)' in your Excel file. Attach the plot of the fitted values and the actual values over time in worksheet ‘Answer’ in your Excel file.
    2. Fill in the table below with your predictions and errors. What are the RMSE and MAPE of the trend model based on the validation data? Display the results in the worksheet ‘Answer’.

 

 

 

Available Answers
No solution has been posted yet.Be first to post the 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.
closebutton
Only 45 characters allowed.
closebutton

$ 629.35