Case Study: Mortgage Approval Time Study

abby.xlsx

Sheet1

								Approval Times
Run	Credit History (X1)	Mortgage Size (X2)	Regiion (X3)	X1X2	X1X3	X2X3	X1X2X3	Sample 1	Sample 2	Sample 3	Sample 4	Sample 5	Average	Standard Deviation
1	Good (-)	<$500,000 (-)	Western (-)	+	+	+	-	59	50	64	62	47	56.4	7.50
2	Fair (+)	<$500,000 (-)	Western (-)	-	-	+	+	81	58	69	65	74	69.4	8.73
3	Good (-)	>$500,000 (+)	Western (-)	-	+	-	+	38	52	58	60	65	54.6	10.38
4	Fair (+)	>$500,000 (+)	Western (-)	+	-	-	-	146	159	133	143	129	142	11.79
5	Good (-)	<$500,000 (-)	Eastern (+)	+	-	-	+	28	26	38	41	21	30.8	8.41
6	Fair (+)	<$500,000 (-)	Eastern (+)	-	+	-	-	42	53	40	50	64	49.8	9.60
7	Good (-)	>$500,000 (+)	Eastern (+)	-	-	+	-	49	31	49	42	38	41.8	7.66
8	Fair (+)	>$500,000 (+)	Eastern (+)	+	+	+	+	106	115	126	118	138	120.6	12.07
Sum+	381.8	359	243	349.8	281.4	288.2	275.4
Sum-	183.6	206.4	322.4	215.6	284	277.2	290
Avg+	95.45	89.75	60.75	87.45	70.35	72.05	68.85
Avg-	45.9	51.6	80.6	53.9	71	69.3	72.5
Effect	49.55	38.15	-19.85	33.55	-0.65	2.75	-3.65
Regressive Coeffients
b0=	141.35
b1=	24.775
b2=	19.075
b3=	-9.925
b4=	16.775
b5=	-0.325
b6=	1.375
b7=	-1.825
Interaaction Effect Chart Example
	Chart History	Low	High
	Good(+)	30.8	56.4
	Fair(-)	49.8	142
	Mortgage Size	Low	High
	<$500,000	30.8	69.4
	>$500,000	41.8	142
	Region	Low	High
	Western	54.6	142
	Eastern	30.8	120.6

Chart History/ High Low Chart

Interaaction Effect Chart Example Good(+) Low High 30.8 56.4 Interaaction Effect Chart Example Fair(-) Low High 49.8 142

Mortgage

< $500,000 Low High 30.8 69.400000000000006 > $500,000 Low High 41.8 142

Region

Western Low High 54.6 142 Eastern Low High 30.8 120.6