# Based on your findings above, assess which expansion      criteria seem to be more effective.Could any expansion criterion be      changed or eliminated? If so, which one and why?

Report:

Write a 750-word statistical report that includes the following sections:

• Section 1: Scope and descriptive statistics
• Section 2: Analysis
• Section 3: Recommendations and Implementation

Section 1 – Scope and descriptive statistics

### Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now
• State the report’s objective.
• Discuss the nature of the current database. What      variables were analyzed?
• Summarize your descriptive statistics findings from      Excel. Use a table and insert appropriate graphs.

Section 2 – Analysis

• Using Excel, create scatter plots and display the      regression equations for the following pairs of variables:
• “BachDeg%” versus “Sales/SqFt”
• “MedIncome” versus “Sales/SqFt”
• “MedAge” versus “Sales/SqFt”
• “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 you can conclude from these relationships.

Section 3: Recommendations and implementation

• Based on your findings above, assess which expansion      criteria seem to be more effective.Could any expansion criterion 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?)

Cite references to support your assignment.

0 replies