Year	Manufacturing Overhead	Activity Driver 1	Activity Driver 2	Activity Driver 3
2000	4,234,155	6,174	790	48,555
2001	1,402,088	2,942	339	42,947
2002	7,567,442	2,175	781	44,462
2003	4,068,697	5,326	158	68,065
2004	5,189,409	3,195	702	34,202
2005	5,701,503	4,554	648	82,552
2006	3,439,352	3,091	225	25,170
2007	2,406,817	2,720	411	86,411
2008	3,167,239	1,723	590	38,382
2009	3,720,244	4,556	558	64,473
2010	1,731,135	2,680	169	37,526
2011	1,956,464	2,244	401	77,867
2012	6,706,160	4,294	594	26,068
2013	3,750,324	2,725	200	26,169
2014	5,202,511	6,785	359	74,815
2015	3,921,531	1,715	296	77,867

1) Use Excel to regress Manufacturing Overhead on Activity Driver 1 and Activity Driver 2. Label your new tab "Model 1".
Hint: You regress a dependent variable on an independent variable(s).
2) Use Excel to regress Manufacturing Overhead on Activity Driver 1. Label your new tab "Model 2".
3) Use Excel to regress Manufacturing Overhead on Activity Driver 2. Label your new tab "Model 3".
4) Which is the best model? Why? Make sure to write out the regression equation for the best model.

6) If Activity Driver 1 = 525 and Activity Driver 2 = 3,100, what is the expected Manufacturing Overhead?
	Expected Manufacturing Overhead =
7) Build a 90% Confidence Interval for the expected Manufacturing Overhead.
	90% Confidence Interval =		(		,		)