Short Report: Case Study

CopyofCaseStudy2Dataset.xls

Sheet1

Years X	Weeks SP Y
16	13
19	13
8	11
16	14
4	3
9	10
3	4
2	7		Weeks SP	Number of weeks of severance pay
15	12
15	7		Years		Number of years with the company
13	8
10	11
5	9
13	10
19	18
20	17
11	13
19	14
2	5
15	11
14	10
6	8
16	15
6	7
8	9
12	11
13	10
14	8
7	5
4	6
12	14
17	12
11	10
14	14	SUMMARY OUTPUT
17	12
17	12	Regression Statistics
8	8	Multiple R	0.8308526018
16	12	R Square	0.6903160459
10	10	Adjusted R Square	0.6838642969
13	11	Standard Error	1.9170407637
19	15	Observations	50
6	5
9	8	ANOVA
11	11		df	SS	MS	F	Significance F
15	15	Regression	1	393.217826087	393.217826087	106.9967293117	0
13	11	Residual	48	176.402173913	3.6750452899
5	6	Total	49	569.62
7	6
14	13		Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
10	9	Intercept	3.6213768116	0.6967029291	5.1978779772	0.0000040959	2.2205616867	5.0221919365	2.2205616867	5.0221919365
		Years X	0.5742753623	0.0555181433	10.3439223369	0	0.4626486538	0.6859020709	0.4626486538	0.6859020709
		Point Estimate	9.36
			Lower	Upper
		Prediction Interval	5.47	13.26
		Confidence Interval	8.79	9.94

Page &P

Weeks SP Y