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!