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]