In: Statistics and Probability
Please assist with finding the mean, standard deviation and coefficient variation for the monthly profit of all the small, medium, large and very larges stores listed below.
Store Size | Monthly Profit |
VL | $9,984 |
VL | $8,387 |
VL | $9,679 |
VL | $21,591 |
VL | $8,197 |
VL | $20,930 |
M | $3,305 |
S | -$11,264 |
VL | $28,367 |
VL | $18,904 |
S | $18,934 |
VL | $11,845 |
M | $15,747 |
L | $23,107 |
VL | $18,461 |
VL | $2,035 |
L | $11,771 |
VL | $22,783 |
M | -$3,619 |
L | $13,326 |
VL | $19,157 |
VL | $16,047 |
L | $5,675 |
M | $11,720 |
L | $4,130 |
M | $8,086 |
VL | $28,319 |
VL | $9,997 |
L | $12,785 |
VL | $27,153 |
L | $6,040 |
M | $13,871 |
M | -$8,339 |
VL | $18,762 |
VL | $29,030 |
VL | $8,336 |
VL | $9,140 |
L | $10,109 |
VL | $31,273 |
VL | $21,438 |
VL | $25,395 |
VL | $24,190 |
VL | $21,085 |
VL | $24,712 |
VL | $35,222 |
M | $25,346 |
VL | $13,707 |
M | $2,104 |
S | -$3,362 |
VL | $19,557 |
VL | $28,500 |
S | -$5,787 |
VL | $10,410 |
M | -$6,766 |
VL | $22,910 |
VL | $17,351 |
M | -$4,118 |
VL | $24,758 |
M | $7,779 |
M | $6,663 |
The answers are:
Store Type | Mean | Standard deviation | Coefficient variation |
VL | 19074.62857 | 7992.41917 | 41.90% |
M | 5521.461538 | 9810.029677 | 177.67% |
S | -369.75 | 13286.83063 | -3593.46% |
L | 10867.875 | 6054.263443 | 55.71% |
We will be using excel to answer this question:
Output:
Formulas used:
Let me know in the comments if anything is not clear. I will reply ASAP! Please do upvote if satisfied!