Question 6 60 pts Do the following problems using Excel. Each problem is for 20 points. Once done upload your file. Firm ABC's sales from 2010 to 2020 are $420 million, $480 million, $350 million, $250 million, $305 million, $520 million, $540 million, $600 million, $720 million, $400 million, and $563 million. ABC's accounts receivables from 2010 to 2020 are $40 million, $50 million, $32 million, $20 million, $35 million. $60 million, $65 million, $75 million, $80 million, $49 million and $65 million. It is hypothesized that ABC's accounts receivable are highly correlated with its sales and can be estimated by using sales. 1. Use Excel linear regression to estimate whether ABC's accounts receivable are linearly related to its sales. (Hint: Make sure you enter the data column wise, that means in a column, not a row in Excel.) 2. Discuss the regression output that contains R-square, regression coefficients, and t-stat of regression coefficients. 3. Estimate ABC's 2021 sales using Trend Function. 4. Estimate ABC's 2021 accounts receivable using ABC's 2021 estimated sales from 3. above and the linear regression from 2. above. Question 6 60 pts Do the following problems using Excel. Each problem is for 20 points. Once done upload your file. Firm ABC's sales from 2010 to 2020 are $420 million, $480 million, $350 million, $250 million, $305 million, $520 million, $540 million, $600 million, $720 million, $400 million, and $563 million. ABC's accounts receivables from 2010 to 2020 are $40 million, $50 million, $32 million, $20 million, $35 million. $60 million, $65 million, $75 million, $80 million, $49 million and $65 million. It is hypothesized that ABC's accounts receivable are highly correlated with its sales and can be estimated by using sales. 1. Use Excel linear regression to estimate whether ABC's accounts receivable are linearly related to its sales. (Hint: Make sure you enter the data column wise, that means in a column, not a row in Excel.) 2. Discuss the regression output that contains R-square, regression coefficients, and t-stat of regression coefficients. 3. Estimate ABC's 2021 sales using Trend Function. 4. Estimate ABC's 2021 accounts receivable using ABC's 2021 estimated sales from 3. above and the linear regression from 2. above