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

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