Part 2- Stats report

Sheet1

Years	Weeks SP							Weeks SP	Years
16	13
19	13						Mean	10.26	11.56
8	11						Standard Error	0.48	0.70
16	14						Median	10.5	12.5
4	3						Mode	11	13
9	10						Standard Deviation	3.41	4.93
3	4						Sample Variance	11.62	24.33
2	7		Weeks SP	Number of weeks of severance pay			Kurtosis	-0.41	-0.90
15	12						Skewness	-0.03	-0.24
15	7		Years	Number of years with the company			Range	15	18
13	8						Minimum	3	2
10	11						Maximum	18	20
5	9						Sum	513	578
13	10						Count	50	50
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	SUMMARY OUTPUT
12	14
17	12	Regression Statistics
11	10	Multiple R	0.831
14	14	R Square	0.690
17	12	Adjusted R Square	0.684
17	12	Standard Error	1.917
8	8	Observations	50
16	12
10	10	ANOVA
13	11		df	SS	MS	F	Significance F
19	15	Regression	1	393.218	393.218	106.997	0.000
6	5	Residual	48	176.402	3.675
9	8	Total	49	569.620
11	11
15	15		Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
13	11	Intercept	3.621	0.697	5.198	0.000	2.221	5.022
5	6	Years	0.574	0.056	10.344	0.000	0.463	0.686
7	6
14	13
10	9

Scatter Plot

Years

Weeks SP

Sheet2