750 word statistical report

by


  1. t:
    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.
    Format your citations according to APA guidelines.
    Submit your assignment.

    Resources