Question

Ska Brewing Company is a producer of fine craft beers located in Durango, Colorado. With its flagships Ale and Lager, they have enjoyed double-digit growth for more than a decade with no signs of allowing down.

Ska was founded in 1995, and through hard work and laser-like focus on brewing great beer continued to grow. In 2012, Ska brewed more than 25,000 barrels of beer (1 barrel = 2 standard kegs = 4,032 ounces) with sales exceeding $6.5 million.

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

1. Include a summary of each variable in the data set. Make comments and interpretation based on maximum, minimum, as well as the appropriate means and proportions. What new insights do these descriptive statistics provide concerning Ska annual data?
2. Do you see any obvious trends? Is there any change in data distribution?

Answer 1

1. Finding summary statistics in Excel.

Step 1 : Put the data in excel as shown

Step 2 : Go to Data -> Data Analysis->Descriptive statistics.

Step 3 : INput the value as shown.

Step 4 : The results will be displayed as follows.

We also plot the annual production and revenue as shown below.

As we see in the graph, annual sales have a very clear upward trend.

Till about mid-2008 the growth was steady growth. But then from 2009, the growth has shot up at the very steep pace.

From 2000 to 2008, the average year on year growth was about 19% .
But in 2009, it shot up to 53%.
The average growth from 2009 to 2012 is about 34%.

Hence there is a very clear growth pattern with berwing company, with complete step-change happening in 2009. Also, there is a change in the data distribution from 2009.