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'.

e) Between Model P4 (b) and Model P4 (d), which model will you use? Explain your answer

Month Year Tickets Prediction Error January 4 720 February 4 757 March 4 707 April 4 692 May 4 828 June 4 827 July 4 763 August 4 710 September 4 673 October 4 793 November 4 852 December 4 710