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

Data Analytics Help

  • From Mathematics, Data Analysis
  • Due on 22 Apr, 2021 01:41:00
  • Asked On 19 Apr, 2021 10:44:35
  • Due date has already passed, but you can still post solutions.
Question posted by
Online Tutor Profile
request

Transit Monthly Data (Excel) (Links to an external site.) contains the number of monthly transit rides on a transportation system from June 2013 up until May 2017. Our goal is to predict the ride volume for the following 12 months.

Model 1: Exponential Smoothing (12 points)

Keep the last 12 months as a holdout (validation) data set, and the remaining data as a training set.

Set the number of forecasts to 12.

a. (3 points) Create and attach the time series plot of the number of monthly transit rides. Does this time series exhibit trend and/or seasonality?

b. (9 points) Based on your answer in part a, identify the best exponential smoothing model with appropriate smoothing constant.

i. (5 points) Attach the StatTools report. Also, include a plot of the predicted volume and actual over time.

ii. (2 points) What are the RMSE and MAPE of the model based on the holdout data?

iii.(2 points) What are the predicted ride volumes for June 2017–May 2018?

Model 2: Regression Models (18 points)

Keep the last 12 months as a validation data set, and the remaining data as a training set.

a. (10 points) Build a regression model with trend and seasonality.

i. (6 points) Attach the StatTools report including regression equation. Also, insert a plot of the fitted values and the actual values over time.

ii. (2 points) Compute RMSE and MAPE of the model based on the validation data.

iii. (2 points) What are the predicted ride volumes for June 2017–May 2018?

b. (6 points) Suppose that we think weather impacts ridership. We have collected data on the highest temperature for each month in the dataset. Build a regression model with trend, seasonality and highest temperature.

i. (2 points) Attach the StatTools report including regression equation. Also, insert a plot of the fitted values and the actual values over time.

ii. (2 points) Compute RMSE and MAPE of the model based on the validation data.

iii. (2 points) Suppose the high temperature is 85 degrees in June 2017. What is your prediction for June 2017? Show how you got there.

c. (2 points) Which model is the best (your exponential smoothing model and two regression model)? Explain your answer.

Available Answers
No solution has been posted yet.Be first to post the solution!
Other Related Questions
User Image
eddie...

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