High Unemployment Rate in Detroit Research Paper

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

0.872748

R Square

0.761689

Adjusted R. Square

0.7319

Standard Error

1.573775

Observations

10

ANOVA

df

SS

MS

F

Significance F

Regression

1

63.32986

63.32986

25.56956

0.000981

Residual

8

19.81414

2.476768

Total

9

83.144

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Lower 95.0%

Upper 95.0%

Intercept

18.60066

1.703969

10.91608

4.4E-06

14.6713

22.53002

14.6713

22.53002

X Variable 1

-0.14215

0.028112.....