ABC Company reports their earnings and expenses data from the years 2004 to 2018 as shown in the table. Use Linear Forecasting and regression to calculate the expense value in the year 2021. 8 9 Years 2004 2006 2008 2010 2012 2014 2016 2018 2021 Earnings Expenses $12,340.00 $13,005.00 $11,010.00 $9,257.50 $14,680.00 $11,010.00 $18,350.00 $14,762.50 $22,020.00 $16,515.00 $25,690.00 $19,267.50 $29,360.00 $22,020.00 $33,080.00 $29,810.00 $25,000.00 ?????? 3 4 5 6 Required: 7 Calculate the correlation between the known Earnings and Expenses Calculate the R-Squared between the known Earnings and Expenses 0 1 Calculate the slope of the linear regression line between known Earnings and Expenses 2 3 Calculate the intercept of the linear regression line between known Earnings and Expenses 5 The full regression equation is: 26 Expenses = 2.7 28 29 Forecasted Expense in 2021 (Earnings) 0.9574 0.9166

ABC Company reports their earnings and expenses data from the years 2004 to 2018 as shown in the table. Use Linear forecasting and regression to calculate the expense value in the year 2021. \begin{tabular}{|c|c|r|} \hline Years & Earnings & \multicolumn{1}{|c|}{ Expenses } \\ \hline 2004 & $12,340.00 & $13,005.00 \\ \hline 2006 & $11,010.00 & $9,257.50 \\ \hline 2008 & $14,680.00 & $11,010.00 \\ \hline 2010 & $18,350.00 & $14,762.50 \\ \hline 2012 & $22,020.00 & $16,515.00 \\ \hline 2014 & $25,690.00 & $19,267.50 \\ \hline 2016 & $29,360.00 & $22,020.00 \\ \hline 2018 & $33,080.00 & $29,810.00 \\ \hline 2021 & $25,000.00 & ?????? \\ \hline \end{tabular} Required: Calculate the correlation between the known Earnings and Expenses 0.9574 Calculate the R-Squared between the known Earnings and Expenses 0.9166 Calculate the slope of the linear regression line between known Earnings and Expenses Calculate the intercept of the linear regression line between known Earnings and Expenses The full regression equation is: \begin{tabular}{|l|l|l|l|} \hline Expenses = & (Earnings) & + & + \\ \hline \end{tabular} Forecasted Expense in 2021