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 Year 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

Using Excel

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.