Month Year Tickets January 605 February 647 March 636 April 612 May 714 June 765 July 698 August 615 September 588 October 685 November 711 December 664 January 630 February 696 March 670 April 671 May 724 June 787 July 724 August 651 September 589 October 697 November 750 December 705 - W W W W W W W W W W W W N N N N N N NN NN NN January 664 February 704 March 691 April 672 May 753 June 787 July 751 August 695 September 643 October 724 November 803 December 705 January 720 February 757 March 707 April 692 May 4 828 June 4 827 July 4 763 August 4 710 September 673 October A 793 November A 852 December 710Chapter 12 Homework Problem 9 -- Perform a Regression Analysis. Present the following: a. Prediction equation b. Interpret each regression coefficient 0. Present the value of R-square d. Interpret the value of R-square 6. Discuss the goodness of fit for the model using the overall hypothesis test and individual coefficients test (i.e., Answer the questions -- Is the prediction model good and which variables should be used as prediction variables.) r. Predict the number of tickets sold for period 49. g. Use your prediction equation from Part A to make a prediction for periods 1 through 48 in Column E of your spreadsheet. (You should be able to enter the formula for your prediction equation to make a forecast for period 1 and then copy the formula for periods 2 through 48.) h. After you have made the predictions, calculate the absolute value of the error of your forecast in Column F. The EXCEL function for absolute value is =ABS. For example, =ABS(CZ - E2). Calculate the absolute error for periods 1 through 48. After you have calculated the errors, average the errors. This is your MAE value. Present the value of MAE (Mean Absolute Error). i. In Column G, am the value of your error calculated in Column F. For example, =F2"2 will calculate the squared error for Period 1. Calculate the squared error for periods 1 through 48. Average the 48 squared values. Then, take the square root of the average of the squared errors to obtain the value of RMSE which is the Root Mean Square Error. Present the results of RMSE. j. In Column H, take your error in Column F and divide it by the Actual Value in Column C for each period. Average these quotients and multiply by 100 to obtain MAPE which is Mean Absolute Percentage Error. Present the results of MAPE