Prepare a brief, descriptive report based on the data (Gross Square Feet of Whole Foods Market, The column D in the excel file) in the file and submit it.
You may use any computer software you wish (e.g., Excel). Include relevant worksheets or graphs in your report.
If some questions do not apply to your data set, explain why not.
(a) Find Xmin and Xmax.
(b) Make a histogram. Describe its shape.
(c) Discuss mean and median, and calculate the mean and median for the data. Are the data skewed?
(d) Calculate Geometric Mean.
(e) Discuss variance and standard deviation and calculate the SAMPLE standard deviation.
(f) Discuss empirical rule. How many outliers in the data based on empirical rule.
(g) Explain what are the quartiles. Calculate the quartiles (Q1, Q2, Q3) and make a box plot. Describe its appearance.
These questions should be answered in a plain language, executive level report that is supported with a technical level appendix that includes the original data set, all manipulations and calculations of those data in Excel®, all relevant statistical software output, and a running narrative explaining the methodology used, the assumptions made, and the interpretation of each analysis performed. Use only the information provided and your business and or common sense to complete this project; do not make things up or engage in creative writing.
Gross Square Feet of Whole Foods Market, Inc. Stores (n = 171)
Location (Store Name)
Albuquerque, NM (Academy)
Alexandria, VA (Annandale)
Ann Arbor, MI (Washtenaw)
Arlington, TX (Parkway)
Atlanta, GA (Briarcliff)
Atlanta, GA (Ponce de Leon)
Atlanta, GA (Sandy Springs)
Austin, TX (Gateway)
Austin, TX (Lamar)
Aventura, FL (Biscayne)
Baltimore, MD (Harbor East)
Baltimore, MD (Mount Washington)
Baton Rouge, LA
Beverly Hills, CA
Boca Raton, FL
Boston, MA (Symphony)
Boulder, CO (Pearl)
Cambridge, MA (Fresh Pond)
Cambridge, MA (River Street) Region
NA Sq. Ft.
40000 WHOLE FOODS MARKET, INC.
Store List as of 7/28/05
Pacific Northwest SW
PN Source: http://www.wholefoodsmarket.com/stores/
Note: Print area is truncated to save trees.