(solution) Prepare a brief, descriptive report based on the data (Gross

(solution) Prepare a brief, descriptive report based on the data (Gross

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)
Annapolis, MD
Arlington, TX (Parkway)
Arlington, VA
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
Bedford, MA
Bellevue, WA
Bellingham, MA
Berkeley, CA
Bethesda, MD
Beverly Hills, CA
Boca Raton, FL
Boston, MA (Symphony)
Boulder, CO (Pearl)
Brighton, MA
Bristol, England
Cambridge, MA
Cambridge, MA (Fresh Pond)
Cambridge, MA (River Street) Region
RM
MA
MW
MA
SW
MA
SO
SO
SO
SW
SW
FL
MA
MA
SW
NA
PN
NA
NC
MA
SP
FL
NA
RM
NA
NA
NA
NA
NA Sq. Ft.
33000
29811
51300
25132
43200
39000
27800
40000
39000
34078
78275
35000
25000
24500
50635
40175
56044
37050
24500
23780
23900
29630
17500
39313
38000
8000
12500
29000
40000 WHOLE FOODS MARKET, INC.
Store List as of 7/28/05
Region Definition:
Southwest
Northern California
North Atlantic
Midwest
Southern Pacific
Mid-Atlantic
Florida
South
Rocky Mountain
Pacific Northwest SW
NC
NA
MW
SP
MA
FL
SO
RM
PN Source: http://www.wholefoodsmarket.com/stores/
Note: Print area is truncated to save trees.