Reference no: EM132847183

SBC is a producer of fine craft beers located in Utah. With its flagships Ale and Lager, they have enjoyed double-digit growth for more than a decade with no signs of allowing down. In 2012, SBC brewed more than 25,000 barrels of beer with sales exceeding $6.5 million. Using the below data:

Year BBLS $$$

2000 2595 521,050 
2001 3025 629,866 
2002 3465 739,153 
2003 4031 883,378 
2004 4525 1,011,409 
2005 5273 1,234,628 
2006 6268  1,481,759 
2007 7289 1,754,272 
2008 7943 2,080,795 
2009 11681 3,179,390 
2010 16026 4,376,982 
2011 21258 5,317,535 
2012 25771 6,553,145

Use descriptive statistics to summarize the SBC annual data. Discuss findings.

Include a summary of each variable (number of barrels sold and gross annual sales) in the data set. Use histograms, descriptive statistics, and Empirical rule to gain insight and detect data patterns. Your answer should refer to histograms, Empirical rule, and descriptive statistics (mean, median, mode, standard deviation, skewness, and kurtosis) to explain detected data patterns (i.e. increasing/decreasing/stable trends, whether the data is normally distributed based on Empirical rule).

Please solve above problem with EXCEL [DATA - DATA ANALYSIS tab, mostly]; and please include excel screenshots along with formula and output. Detailed responses [answers] are needed, please.