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 [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.

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

What our clients say
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
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
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