Data Analysis
snhembrey
b312c_mod_4_sample_spreadsheet.xlsxSheet1
| Monster | |||||
| (in thousands) | 2014 | 2013 | 2012 | 2011 | 2010 |
| Net sales | $ 2,464,867 | $ 2,246,428 | $ 2,060,702 | $ 1,703,230 | $ 1,303,942 |
| Coca Cola | $ 45,998 | $ 46,854 | $ 48,017 | $ 46,542 | $ 35,119 |
| (In Millions) | |||||
| Net sales | |||||
| Monster | Coca Cola | ||||
| 2014 | $ 2,464,867 | $ 45,998,000,000 | |||
| 2013 | $ 2,246,428 | $ 46,854,000,000 | |||
| 2012 | $ 2,060,702 | $ 48,017,000,000 | |||
| 2011 | $ 1,703,230 | $ 46,542,000,000 | |||
| 2010 | $ 1,303,942 | $ 35,119,000,000 | |||
| Monster | Coca Cola | ||||
| Mean | 1,828,576 | Mean | 44,133,000,000 | ||
| Standard Error | 208,054 | Standard Error | 3,021,379,017 | ||
| Median | 1,881,966 | Median | 46,698,000,000 | ||
| Mode | ERROR:#N/A | Mode | ERROR:#N/A | ||
| Standard Deviation | 416,107 | Standard Deviation | 6,042,758,035 | ||
| Sample Variance | 173,145,075,817 | Sample Variance | 36,514,924,666,666,615,000 | ||
| Kurtosis | (1) | Kurtosis | 4 | ||
| Skewness | (1) | Skewness | (2) | ||
| Range | 942,486 | Range | 12,898,000,000 | ||
| Minimum | 1,303,942 | Minimum | 35,119,000,000 | ||
| Maximum | 2,246,428 | Maximum | 48,017,000,000 | ||
| Sum | 7,314,302 | Sum | 176,532,000,000 | ||
| Count | 4 | Count | 4 |
Net Revenue
Net Revenue
Coca Cola 2014 2013 2012 2011 2010 45998000000 46854000000 48017000000 46542000000 35119000000 Monster 2014 2013 2012 2011 2010 2464867 2246428 2060702 1703230 1303942
