Calculate the coefficient of variation for each group and the entire data set (standard deviation/mean). Add this as an additional row in the above table.

profileshapoo
tomdata_1.xlsx
Home>Business & Finance homework help>Marketing homework help> Calculate the coefficient of variation for each group and the entire data set (standard deviation/mean). Add this as an additional row in the above table.

Sample Data

Lemonade Analysis - Tom Dullaghan
Day Weather Price Lemons Sugar Ice # Cups # Lemons # Cups # Ice Cubes Assets after Assets after Cups # Customers Total Sales Total Expense Net Revenue
Per Cup Per Pitcher Per Pitcher Per Cup of Sugar Expenses Sales Sold
1 Overcast 78 0.25 4 4 4 100 30 20 250 7.88 15.88 32 70 8 12.12 -4.12
2 Rain 85 0.10 3 3 10 68 18 36 1000 8.16 11.66 35 65 3.5 7.72 -4.22
3 Sunny 63 0.20 4 4 7 133 19 23 500 4.37 12.75 35 85 7 7.29 -0.29
4 Coudy 89 0.15 4 4 7 98 20 21 250 9.88 15.13 35 69 5.25 2.87 2.38
5 Overcast 86 0.15 4 4 7 113 12 9 500 10.13 17.63 50 71 7.5 5.00 2.50
6 Overcast 76 0.20 3 3 3 67 12 20 500 9.05 14.17 32 61 6.4 8.58 -2.18
7 Overcast 90 0.15 4 4 4 83 33 49 500 4.89 8.49 24 61 3.6 9.28 -5.68
8 Coudy 51 0.15 4 4 4 59 25 41 500 4.64 8.54 26 78 3.9 3.85 0.05
9 Hazy 70 0.15 4 4 4 133 23 29 250 2.65 8.05 36 55 5.4 5.89 -0.49
10 Sunny 64 0.20 4 4 6 97 11 17 100 7.13 10.33 16 68 3.2 0.92 2.28
11 Sunny 51 0.20 3 4 4 81 13 17 250 6.74 13.34 33 71 6.6 3.59 3.01
12 Sunny 69 0.20 3 4 4 48 14 13 250 9.86 15.66 29 65 5.8 3.48 2.32
13 Rain 69 0.10 3 4 4 119 15 29 250 7.73 9.93 22 78 2.2 7.93 -5.73
14 Rain 72 0.10 3 4 4 97 19 21 0 9.02 9.02 0 67 0 0.91 -0.91
15 Hazy 50 0.15 3 4 4 97 16 17 250 8.18 11.93 25 69 3.75 0.84 2.91
16 Sunny 76 0.20 4 4 7 72 17 13 250 8.27 15.27 35 68 7 3.66 3.34
17 Rain 71 0.10 3 4 4 137 15 21 250 7.74 12.14 22 60 2.2 7.53 -5.33
18 Rain 78 0.10 3 4 7 115 5 9 0 10.37 10.37 0 71 0 1.77 -1.77
19 Sunny 93 0.25 4 4 7 115 15 21 250 7.74 16.30 35 73 8.75 2.63 6.12
20 Rain 66 0.10 3 4 8 80 13 17 250 13.39 15.27 21 76 2.1 2.91 -0.81
21 Sunny 71 0.20 4 4 8 60 17 29 250 10.99 17.19 31 61 6.2 4.28 1.92
22 Sunny 97 0.20 4 4 7 129 19 21 500 9.64 19.84 51 63 10.2 7.55 2.65
23 Hazy 78 0.20 3 4 7 78 23 25 250 13.93 23.13 46 60 9.2 5.91 3.29
24 Hazy 62 0.20 3 4 5 132 23 29 250 15.84 23.44 38 68 7.6 7.29 0.31
25 Rain 68 0.10 3 4 4 94 12 17 100 22.55 24.65 21 81 2.1 0.89 1.21
26 Coudy 82 0.15 3 4 7 73 16 17 250 21.00 26.25 35 67 5.25 3.65 1.60
27 Rain 57 0.10 3 4 8 63 14 1 0 24.69 24.69 0 72 0 1.56 -1.56
28 Hazy 75 0.20 4 4 8 63 14 9 250 21.80 28.00 31 79 6.2 2.89 3.31
29 Cloudy 91 0.20 4 4 5 57 16 9 250 23.75 28.95 27 72 5.4 4.25 1.15
30 Overcast 94 0.15 4 4 5 31 15 17 250 25.06 29.71 31 67 4.65 3.89 0.76
Total 854 148.95 140.93 8.02
Mean
Standard Deviation
End of Season Report
Total Income 148.95
Total Expenses 140.93
Liquidated Inventory 0.42
Net Profit/Loss 8.02