Below is a record of the number of individuals signed up by the Canadian Navy recruiting office in the Bloor West Village area of Toronto, Ontario.

Jan 8

Feb 12

Mar 15

Apr 11

May 17

June 16

July 21

Aug 7

Sep 13

Oct 16

Nov 12

Dec 11

a. Using Excel's linear regression, forecast the expected total recruits for the next two months and generate Excel's summary output.

b. Briefly explain each of the regression statistics from the summary output.

c. Demonstrate whether rounding forecast (up or down) will improve the regression forecast.