**ConductÂ the following descriptive statistics analysis using the data set â€“ Assignment Solution**

**ConductÂ**the following descriptive statistics analysis using the data set in attached Excel. Answer the questions in the spreadsheet or a separate Microsoft Word document.

**InsertÂ**a new column in the database that corresponds toÂ

*AnnualSales*.Â

*AnnualSalesÂ*is the result of multiplying a restaurantâ€™sÂ

*SqFtÂ*byÂ

*Sales/SqFt*.

**CalculateÂ**the following:

- mean
- standard deviation
- skew
- 5-number summary
- interquartile range (IQR) for Â Â Â Â Â each of the variables

**CreateÂ**a box-plot for theÂ

*AnnualSalesÂ*variable and answer the following questions:

- Does it look symmetric?
- Would you prefer the IQR Â Â Â Â Â instead of the standard deviation to describe this variableâ€™s dispersion? Â Â Â Â Â Why or why not?

**CreateÂ**a histogram for theÂ

*Sales/SqFt*Â variable and answer the following questions:

- Is the distribution symmetric? Â Â Â Â Â If not, what is the skew?
- Are there any outliers? If so, Â Â Â Â Â which one(s)?
- What is theÂ
*SqFtÂ*area Â Â Â Â Â of the outlier(s)? Is the outlier(s) smaller or larger than the average Â Â Â Â Â restaurant in the database? What can you conclude from this observation? - What measure of central Â Â Â Â Â tendency is more appropriate to describeÂ
*Sales/SqFt*? Why?

**CiteÂ**references to support your assignment.

**Part 2: Report**.

**Write**Â a minimum 1,000-word statistical report with 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 Part 1. Use a table and insert appropriate Â Â Â Â Â graphs.

**Section 2: Analysis**Using Microsoft 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(%)

**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?)

**Cite**Â references to support your assignment.