Please help with the following practice homework using Excel. Thank you.

Data Table:

RANK OUTLET RETAIL REVENUE ($MM)

1 Coles Meyer 26737

2 Woolworths 24985

3 Foodland 4905

4 Westfarmers 3100

5 David Jones 1725

6 Retravision 1290

7 Harvey Norman 1160

8 Millers Retail 972

9 Mitre 10 890

10 7-Eleven 747

a)What are the mean, median, range, variance, and standard deviation for these sample data.

b)Which of these three measures of variability (range, variance, and standard deviation) you would prefer to use as a measure of variation.

c)What is the skewness of this sample data.

d)What are the mean and median after eliminating Coles Meyer and Woolworths from the data. How are the mean and median affected by these changes?