Unit 2 Assignment – Marketing Regression


  • In this assignment, you will perform a multiple regression analysis inside of Microsoft Excel.
  • Walk through the example regression problem.
  • Learn by Marketing. (2018). Linear regression by hand and in Excel (Links to an external site.). Retrieved from http://www.learnbymarketing.com/tutorials/linear-regression-by-hand-in-excel/

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
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)