BU 407 Herzing University Week 2 Marketing Regression Analysis Worksheet

BU 407 Herzing University Week 2 Marketing Regression Analysis Worksheet

Unit 2 Assignment – Marketing Regression

  • Due Sunday by 11:59pm
  • Points 70
  • Submitting a text entry box or a file upload

Instructions

Estimated time to complete: 10 Hours

  • In this assignment, you will perform a multiple regression analysis inside of Microsoft Excel.
  • Walk through the example regression problem.

Now complete a secondary regression using the changed data table you can download here data-marketing-budget-12mo-version2 [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

Include a copy of your Excel file with the regression output in a separate sheet

Rubric

BU407 Unit 2 Assignment – Marketing Regression (1)

BU407 Unit 2 Assignment – Marketing Regression (1)
Criteria Ratings Pts

This criterion is linked to a Learning OutcomeContentBU407-CO3
21.0 pts

Level

Demonstrates the ability to construct a clear and insightful problem statement/thesis statement/topic statement with evidence of all relevant contextual factors.

 18.9 pts

Level 4

Demonstrates the ability to construct a problem statement, thesis statement/topic statement with evidence of most relevant contextual factors, and problem statement is adequately detailed.

 16.8 pts

Level 3

Begins to demonstrate the ability to construct a problem statement/thesis statement/topic statement with evidence of most relevant contextual factors, but problem statement is superficial.

 14.7 pts

Level 2

Demonstrates a limited ability in identifying a problem statement/thesis statement/topic statement or related contextual factors.

 12.6 pts

Level 1

Demonstrates the ability to explain contextual factors but does not provide a defined statement.

 0.0 pts

No Marks

There is no evidence of a defined statement.

21.0 pts

This criterion is linked to a Learning OutcomeAnalysisPRICE-P
21.0 pts

Level

Organizes and compares evidence to reveal insightful patterns, differences, or similarities related to focus.

 18.9 pts

Level 4

Organizes and interprets evidence to reveal patterns, differences, or similarities related to focus.

 16.8 pts

Level 3

Organizes and describes evidence according to patterns, differences, or similarities related to focus.

 14.7 pts

Level 2

Organizes evidence, but the organization is not effective in revealing patterns, differences, or similarities.

 12.6 pts

Level 1

Describes evidence, but it is not organized and/or is unrelated to focus.

 0.0 pts

No Marks

Lists evidence, but it is not organized and/or is unrelated to focus.

21.0 pts

This criterion is linked to a Learning OutcomeWriting
18.0 pts

Level

The paper exhibits an excellent command of written English language conventions. The paper has no errors in mechanics, grammar, or spelling.

 16.2 pts

Level 4

The paper exhibits a good command of written English language conventions. The paper has no errors in mechanics or spelling with minor grammatical errors that impair the flow of communication.

 14.4 pts

Level 3

The paper exhibits a basic command of written English language conventions. The paper has minor errors in mechanics, grammar, or spelling that impact the flow of communication.

 12.6 pts

Level 2

e paper exhibits a limited command of written English language conventions. The paper has frequent errors in mechanics, grammar, or spelling that impede the flow of communication.

 10.8 pts

Level 1

The paper exhibits little command of written English language conventions. The paper has errors in mechanics, grammar, or spelling that cause the reader to stop and reread parts of the writing to discern meaning.

 0.0 pts

No Marks

The paper does not demonstrate command of written English language conventions. The paper has multiple errors in mechanics, grammar, or spelling that cause the reader difficulty in discerning the meaning.

18.0 pts

This criterion is linked to a Learning OutcomeAPAPRICE-I
10.0 pts

Level

The required APA elements are all included with correct formatting, including in-text citations and references.

 9.0 pts

Level 4

The required APA elements are all included with minor formatting errors, including in-text citations and references.

 8.0 pts

Level 3

The required APA elements are all included with multiple formatting errors, including in-text citations and references.

 7.0 pts

Level 2

The required APA elements are not all included and/or there are major formatting errors, including in-text citations and references.

 6.0 pts

Level 1

Several APA elements are missing. The errors in formatting demonstrate a limited understanding of APA guidelines, in-text-citations, and references.

 0.0 pts

No Marks

There is little to no evidence of APA formatting and/or there are no in-text citations and/or references.

10.0 pts

Total Points: 70.0

PreviousNext

Tagged
>>
<<
What our clients say
Daphne Whitby
Daphne Whitby
My homework required that I use Java to produce a programming assignment. I’ve been running up and down with friends and workThank you for  your help 
Arnold M
Arnold M
This site did honor their end of the bargain. I have been searching for a college essay help services for a while, and finally, I found the best of the best.
Regina Smith
Regina Smith
I received my essay early this morning after I had placed an order last night. I was so amazed at how quickly they did my work. The most surprising thing is that I was not asked to pay for extra due to the short notice!! I am a happy student
prevnext