Business Statistics

Case_study2_calculation

Run	Heading (x1)	Email Open(x2)	Body(x3)	x1 x2	x1x3	x2x3	x1x2x3	Repeat Rate 1	Repeat Rate 2	Average RR	SD RR
1	Generic(-)	No(-)	Text(-)	+	+	+	-	46	38	42	5.6568542495
2	Detailed(+)	No(-)	Text(-)	-	-	+	+	34	38	36	2.8284271247
3	Generic(-)	Yes(+)	Text(-)	-	+	-	+	56	59	57.5	2.1213203436
4	Detailed(+)	Yes(+)	Text(-)	+	-	-	-	68	80	74	8.4852813742
5	Generic (-)	No(-)	HTML(+)	+	-	-	+	25	27	26	1.4142135624
6	Detailed(+)	No(-)	HTML(+)	-	+	-	-	22	32	27	7.0710678119
7	Generic(-)	Yes(+)	HTML(+)	-	-	+	-	21	23	22	1.4142135624
8	Detailed(+)	Yes(+)	HTML(+)	+	+	+	+	19	33	26	9.8994949366
sum+	163	179.5	101	168	152.5	126	145.5
sum-	147.5	131	209.5	142.5	158	184.5	165
ave +	40.75	44.875	25.25	42	38.125	31.5	36.375
ave-	36.875	32.75	52.375	35.625	39.5	46.125	41.25
effect	3.875	12.125	-27.125	6.375	-1.375	-14.625	-4.875
Regression Coefficients
b0 =	77.625	1	77.625		Run	Regression
b1=	1.9375	1	1.9375		1	80.8
b2=	6.0625	1	6.0625		2	74.8
b3=	-13.5625	1	-13.5625		3	96.3
b4=	3.1875	1	3.1875		4	112.8
b5 =	-0.6875	1	-0.6875		5	64.8
b6=	-7.3125	1	-7.3125		6	65.8
b7=	-2.4375	1	-2.4375		7	60.8
			64.8125		8	64.8
Regression Model
y = 77.625 + 1.9375 x1 + 6.0625 X2 -13.5625 x3 + 3.1875 x1 x2 -0.6875 x1 x3 -7.3125 x2 x3 - 2.4375 x1 x2 x3
Interaction Effect Chart Example
		Generic(-)	42	57.5
		Detailed(+)	36	74
		Format of email heading has small effect
		Using detailed Email heading attracts
		much higher response rate when email is open

Heading & Email open

Generic(-) Detailed(+) 42 36 57.5 74

response rate

Sheet2

Sheet3