please solve in excel and show step by step

Q5. (10 points) West End Honda Acura Motors offers their customers in good standing a choice of several lease financing plans. The plan that will be the least expensive for a customer is contingent on the anticipated number of kilometers driven over the first twelve (12) months of the lease. Meghan O'Connor is trying to decide which lease plan to choose, and she therefore wishes to forecast the number of miles she will drive the car over the lease term. She has reviewed her mileage records over the past two years and found that her monthly kilometers is as follows (year 2 in the most recent year.) Year 1 2 January 1051 1398 February 1145 1366 March 1076 1425 April 1344 1286 May 1276 1342 June 1286 1451 July 1157 1486 August 1398 1385 September 1339 1468 October 1291 1536 November 1365 1422 December 1528 1449 a. Graph this time series. b. Verify statistically that this time series exhibits linear trend. c. Using a linear regression approach, forecast Meghan's kilometers over a one-year lease period