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

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 710Month 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