Section $2$: Analysis

$$ Using Microsoft Excel, create scatter plots and display the regression equations for the following pairs of variables:

o BachDeg$\%$ versus Sales$/$SqFt

o MedIncome versus Sales$/$SqFt

o MedAge versus Sales$/$SqFt

o LoyaltyCard$(\%)$ versus SalesGrowth$(\%)$

$$ In your report, include the scatter plots. For each scatter plot, designate the type of relationship observed $($increasing$/$positive$,$ decreasing$/$negative$,$ or no

relationship$)$ and determine what can be concluded from these relationships.

DATCB$/565$ Competency $1$ Assessment and Rubric Page $3$ of $5$

Copyright $2021$ by University of Phoenix. All rights reserved.

Section $3$: Recommendations and Implementation

$$ Based on your findings above, assess which expansion criteria seem to be more effective. Is there any expansion criterion that could be changed or

eliminated? If so$,$ which one and why?

$$ Based on your findings above, does it appear as if the loyalty card is positively correlated with sales growth? Would you recommend changing this marketing

strategy?

$$ Based on your previous findings, recommend marketing positioning that targets a specific demographic. $($Hint: Are younger people patronizing the restaurants

more than older people?$)$

$$ Indicate what information should be collected to track and evaluate the effectiveness of your recommendations. How can this data be collected? $($Hint: would

you use survey$/$samples or census data?$)$