stats work

see file , i want perfect job within 3 hrs

Data

RKET, I

.

MA

MA

west

SW

NC

MA

MW

SO

SO 39000

MA

SW

SW

South SO

FL

RM

MA

MA

SW

NA

PN

NA

NC 24500

MA

SP

FL

NA

RM

NA

NA 8000

NA

NA

NA 40000

NC

SO

SO

SO

MA

MW

MW 30000

MW

RM 40000

FL

NC

SW

SW

SW

MW 39000

RM

SO

SO

NA

MW 33000

MA

RM

NA

NC

FL

MA

SP

NA

NA

RM 42000

NA

SW

SW

SW 30000

SW

SP

SP 40000

NA

NA

NA

NA 6000

NA

NA

SP

SP 30000

SP

SP

NC

MA 40000

NA

MW

NA

SO

MA

SW

NA

NC

NA 30000

MW 40000

NA

NC

NA 24000

SW

NA

NA

NA

NA

NA

SP

RM

MW 30000

NC

SP 31000

SP

NC 31000

MA

MA

MA 37000

SW

FL 30000

PN 43000

MA

NA 23000

NA 32000

SO

SP

NC

MA 25000

SW

NA

MW

MW

MA

SO

MA 33000

NC

SW

SP 28000

NC 28000

NC 30000

NC

NC 25000

NC

RM 40000

SP

NC 25000

FL

PN

NC 15000

SP

SP

MA 35000

MA 24000

MW

MW

NA

SP

SP

MW

MW 40000

SP

MW

SP

SP

MA 32000

NC

MA 35000

MA

MA 28000

NA

MA

NA

MW

PN

SP

MW 40000

NA

MW

SO 30000

FL

SP

MA

2. This exercise uses the dataset “WholeFoods.”

(a) Use Excel to construct a relative histogram for store size. Does the distribution of store size appear to be skewed? If so, does it appear to be skewed to the right or to the left? Explain.

(b) Use Excel to calculate the following four measures of central tendency for store size: mean, median, midrange, and 5% trimmed mean (using the trimmed mean definition from the textbook). Do any of these measures of central tendency appear to not be appropriate for this particular dataset? Explain.

(c) Use Excel to calculate the following four measures of dispersion for store size: variance, standard deviation, mean absolute deviation, and coefficient of variation. Please provide brief and “to-the-point” comments on your results.

(d) According to Chebyshev’s Theorem, at least what percentage of the observations within a sample is supposed to lie within 1.5 sample standard deviations of the sample mean? Next, using Excel, please take the observations for store size in the Whole Foods dataset and confirm that this prediction holds within the Whole Foods sample dataset.

(e) Use Excel to calculate the first quartile, the third quartile, the midhinge, and interquartile range for store size. Next, use Excel to create a box plot graph for store size. (Note: Excel does not have a built-in function for creating a box plot. Your group will need to “figure out” how to do it. For example, the internet has many examples of how to create a box plot in Excel using column/bar charts. You may do either a “horizontal” box plot (i.e., a box plot with the “whiskers” pointing to the right and to the left) or a “vertical” box plot (i.e., a box plot with the “whiskers” pointing to the top and to the bottom).)

(f) Use Excel to calculate both inner fences (left and right) for store size, and then both outer fences (left and right) for store size. Based on these calculated values, are there any “outlier” stores in the data? Any “extreme outlier” stores in the data? If so, which stores are they? (Note: In answering this question, please use the definition of “outlier” and “extreme outlier” provided on page 144 of the textbook; please do not use the definition of “outlier” provided on pages 135-137 of the textbook.) (g) Use Excel to calculate skewness for the variable store size. Is store size skewed right or left? Does your answer corroborate the answer you provided in part 2(a) above?