Using the Excel File Wedding apply the Excel Regression tool, business and finance homework help

Need help completing a finance assignment. Excel File provided. All answers require a formula and it needs to show the formula AND explain to the professor how these answers were obtained. EACH QUESTION REQUIRES AN INTERPRETATION AND CONCLUSION.

NOTE: I KNOW THAT THERE ARE ANSWERS ONLINE FOR THESE QUESTIONS, HOWEVER, THEY DO NOT SHOW THE FORMULAS, WHICH IS WHY I’M PAYING YOU TO FIGURE IT OUT AND ACTUALLY DO THE WORK. IF YOU CAN’T COMPLETE IT WITHOUT PLAGARIZING, DON’T WASTE MY TIME- I CAN GOOGLE, COPY AND PASTE JUST LIKE YOU.

HERE IS THE QUESTIONS. THE FILE REQUIRED ATTACHED. I AM ALSO ATTACHING THE ANSWERS FOR THIS ASSIGNMENT I FOUND ONLINE, AGAIN IT IS NOT COMPLETE, IT REQUIRES THE FORMULAS USED TO GET THE ANSWERS AND A MORE THOROUGH EXPLANATION OF THE ANSWERS. I EXPECT YOU TO COMPLETE EVERYTHING IN A SEPARATE SPREADSHEET WITH ORIGINAL WORK AND CALCULATIONS AND EXPLANATIONS.

ASSIGNMENT:

Using the Excel File Wedding apply the Excel Regression tool using the wedding cost as the dependent variable and the couple’s income as the independent variable, only for those weddings paid for by the bride and the groom.

A. Interpret all key regression results, hypothesis tests, and confidence intervals in the output.

B. Analyze the residuals to determine if the assumptions underlying the regression analysis are valid.

C. Use the standard residuals to determine if any possible outliers exist.

D. If a couple makes $70,000 together, how much would they probably budget for the wedding?