Posted: May 3rd, 2021

Unit 2 assignment – marketing regression

 

Instructions

Now complete a secondary regression using the changed data table you can download here data-marketing-budget-12mo-version2Preview the document [Excel file]

  • Complete a multiple regression using the data “Use Sales” as the Y Range and “Social Media,” “Web” and “Print” as the X-Range.
  • Include residuals, line-fit plots, and Normal probability plots.

UNit 2 Assignment Picture.png

Read: Regression analysis in Excel

Watch Multiple Regression Interpretation in Excel. 

This video provides an example of interpreting multiple regression output in excel:

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:
$0.00