Posted: July 27th, 2023

Multiple regression analysis in excel


This assessment addresses the following course objective(s):

· CO3 – Solve business problems with appropriate quantitative decision-making models

In this assignment you will perform a multiple regression analysis inside of Microsoft Excel.

Complete:  A secondary regression using the changed data table you just downloaded.

· Complete a multiple regression using the data. Use Sales” as the Y Range and “SocialMedia,” “Web” and “Print” as the X-Range.

· Include residuals, line-fit plots and Normal probability plots.

Analyze what you are able to determine from the regression:

·       Regression statistics

·       Equation of the line

·       Effects of variation of spend in Social Media and Web

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price: