Hello everyone I'm new here and request help on my assignment that requires excel.

[Nihara]

Based on the above table:
(a) Use Excel to calculate the mean, median, standard deviation, coefficient of variation, lower
quartile, upper quartile, and interquartile range using Excel formulas.
(b) What do the values of the mean and median tell you about the shape of the distribution of
data?
(c) Which month has the greatest spread of data?

Sales Person	August	September
1​	21900​	12600​
2​	12400​	13500​
3​	9800​	22000​
4​	6800​	34000​
5​	13050​	12500​
6​	14900​	25540​
7​	15250​	21700​
8​	8900​	67800​
9​	16451​	18970​
10​	13230​	16450​
11​	16450​	23220​
12​	12890​	21670​
13​	13670​	17600​
14​	14700​	32420​
15​	10430​	23570​
16​	11670​	14700​
17​	13200​	22400​
18​	11100​	21600​
19​	19800​	26400​
20​	15700​	19700​

 

[Cubist]

All of the functions you listed in part (a) are available in excel. What do you need help with exactly?

 

[Micron]

What do you need help with exactly?

I'd say homework. Is it kosher to do that here?

 

[Cubist]

I'd say homework. Is it kosher to do that here?

I have no intention of assisting in anything more than Excel strictly related questions. e.g. "which function returns the mean?"