Car Plus Co. believes local payroll and local sales of import cars for the year can be considerably associated with Car Plus's yearly sales. The management looked into their stored data and summarized what is available in Table 4 below (the 10 years in the table are not consecutive years). Associate method (i.e., linear regression) is the forecasting method the management has decided to use. Answer the questions Q1 and Q2 below.

Q1: Given the estimated local sales of import cars, $18 million, and estimated local payroll, $3.8 billion, next year, what is the forecasted sales for Car Plus for next year? You have to show your analysis to earn points. (PLEASE PROVIDE ALL CALCULATIONS WITH EXCEL FORMULAS)

Q2: The manager, Alan, suggested the annual average interest rate (Table 5) be taken into consideration along with local payroll and local sales of import cars for the year, when forecasting Car Plus's yearly sales. Along with the information indicated in Q1, Alan predicted the average interest rate next year is 5.6%. Should the interest rate be included to forecast Car Plus's next year's sales? Provide the quantitative/statistical reasoning behind your answer (no personal perception please). (YES or NO and reasoning)

Car Plus Co. believes local payroll and local sales of import cars for Car Plus Co. believes local payroll and local sales of import cars for