Problem $3-27($Algo$)$

Tucson Machinery, Incorporated, manufactures numerically controlled machines, which sell for an average price of $$13\mathrm{.}0$ million each. Sales for these NCMs for the past two years were as follows: Use Exhibit $3,10.$

$\backslash$table$[[\backslash$table$[[$QUARTER LAST$],[$YEAR$]],\backslash$table$[[$QUANTITY$],[($UNITS$)]],\backslash$table$[[$QUARTER THIS$],[$YUANTITY$]],],[($UNITS$),,,],[1,13,1,17],[2,15,2,21],[3,23,3,25],[4,13,4,19]]$

a$.$ Find the equation of a simple linear regression line using Excel.

Note: Round your answers to $3$ decimal places.

b$.$ Compute trend and seasonal factor from a linear regression line obtained with Excel.

Note: Do not round intermediate calculations. Round your answers to $3$ decimal places.

$\backslash$table$[[$Period$,$Trend Forecast,$\backslash$table$[[$Seasonal$],[$Factors$]]]]$

Prev

$10$ of $16$

Next

$\backslash$table$[[,$Period,Trend Forecast,$\backslash$table$[[$Seasonal$],[$Factors$]]],[$Last Year,$1,,],[2,,],[3,,],[4,,],[$This Year,$1,,],[2,,],[3,,],[4,,]]$

c$.$ Forecast sales for next year using the above seasonal factors. Note: Do not round intermediate calculations. Round your answers to $2$ decimal places.

$\backslash$table$[[,$Period,Forecast $($Units$)],[$Next Year,$1,],[2,],[3,]]$

solve the questions for me on excel please!