***i need the excel formats for the math please

In your own words, please describe and explain regression to someone with no financial background. Why would we need to calculate regression? Please use one of the attached data tables (based on your last name) to build the regression tables using the Data tab and Data Analysis ribbon or by using Excel formulas. Review the calculations on the worksheet of at least one other student and provide corrections if necessary. Points will be deducted for missing errors in calculations so please be careful on your review.

****When you set up your regression, be careful to select the correct dependent and independent variables. Think about what you are doing. Dependent or y variable. is the main factor you are trying to understand and predict. Independent (X) Variable, presumed cause of the dependent variable. If we have this variable, then we can estimate the dependent variable or the variable that is dependent on the independent variable.

\begin{tabular}{c|r} \hline Sales & \multicolumn{1}{|c}{ Acct } \\ Receivables \end{tabular} \begin{tabular}{c|r} \hline Sales & \multicolumn{1}{|c}{ Acct } \\ Receivables \end{tabular}