Thus, the testing will not only expose a relationship, but may shed light into how it will continue to evolve in the future. Using Microsoft Excel, a regression test was administered for each individual independent variable as it related to the dependent variable of general unemployment in Detroit.
Data
Automotive Industry Employment rates in thousands
Year
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Annual
2002
2003
2004
2005
2006
2007
2008
96.9
2009
79.5
86.6
86.2
85.4
77.2
73.4
73.5
80.5
84.3
83.9
82.8
83.9
81.4
2010
82.7
82.7
82.6
83.3
83.8
85.0
81.2
83.3
87.6
89.4
89.8
90.2
85.1
2011
89.4
90.4
91.2
93.1
93.4
94.1
83.3
92.0
94.7
96.3
96.7
97.4
92.7
2012
97.6
98.2
99.3
97.4
98.5
99.5
95.8
96.8
97.7
97.7(P)
P: Preliminary
(United States Bureau of Labor Statistics 2012)
Year
Period
labor force employment unemployment
OUTPUT
Regression Statistics
Multiple R...
[ View Full Essay]