Question

A marketing organization wishes to study the effects of four sales methods on weekly sales of a product. The organization employs a randomized block design in which three salesman use each sales method. The results obtained are given in the following table, along with the Excel output of a randomized block ANOVA of these data.

	Salesman, j
Sales Method, i	A	B	C
1	36	32	25
2	41	31	26
3	33	23	19
4	35	20	13

ANOVA: Two-Factor without Replication
SUMMARY	Count	Sum	Average	Variance
Method 1	3	93	31.0000	31.0000
Method 2	3	98	32.6667	58.3333
Method 3	3	75	25.0000	52.0000
Method 4	3	68	22.6667	126.3333
Salesman A	4	145	36.25	11.5833
Salesman B	4	106	26.50	35.0000
Salesman C	4	83	20.75	36.2500

ANOVA
Source of Variation	SS	df	MS	F	P-Value	F crit
Rows	204.3333	3	68.1111	9.25	.0114	4.7571
Columns	491.1667	2	245.5833	33.36	.0006	5.1433
Error	44.1667	6	7.36111
Total	739.6667	11

(a) Test the null hypothesis H₀ that no differences exist between the effects of the sales methods (treatments) on mean weekly sales. Set α = .05. Can we conclude that the different sales methods have different effects on mean weekly sales?

F = 9.25, p-value = .0114; (Click to select)Do not rejectReject H₀: there is (Click to select)no differencea difference in effects of the sales methods (treatments) on mean weekly sales.

(b) Test the null hypothesis H₀ that no differences exist between the effects of the salesmen (blocks) on mean weekly sales. Set α = .05. Can we conclude that the different salesmen have different effects on mean weekly sales?

F = 33.36, p-value = .0006; (Click to select)Do not rejectReject H₀: salesman (Click to select)dodo not have an effect on sales

(c) Use Tukey simultaneous 95 percent confidence intervals to make pairwise comparisons of the sales method effects on mean weekly sales. Which sales method(s) maximize mean weekly sales? (Round your answers to 2 decimal places. Negative amounts should be indicated by a minus sign.)

Method 1 – Method 2:	[, ]
Method 1 – Method 3:	[, ]
Method 1 – Method 4:	[, ]
Method 2 – Method 3:	[, ]
Method 2 – Method 4:	[, ]
Method 3 – Method 4:	[, ]

rev: 08_25_2016_QC_CS-57908

Hints

References

eBook & Resources

Answer 1

a)

F = 9.25, p-value = .0114; Reject H₀: there is a difference in effects of the sales methods (treatments) on mean weekly sales.

b)

F = 33.36, p-value = .0006; Reject H₀: salesman do have an effect on sales

c)

Level of significance	0.05
no of treatments	4
df error	6
MSE	7.3611
q-statistic value	4.8956

critical value = q*√(MSE/2*(1/ni+1/nj))=7.67

confidence interval = mean difference ± critical value

if confidence interval contans zero, then means are not different.

			confidence interval
population mean difference		critical value	lower limit	upper limit	result
µ1-µ2	-1.67	7.67	-9.34	6.00	means are not different
µ1-µ3	6.00	7.67	-1.67	13.67	means are not different
µ1-µ4	8.33	7.67	0.66	16.00	means are different
µ2-µ3	7.67	7.67	0.00	15.34	means are not different
µ2-µ4	10.00	7.67	2.33	17.67	means are different
µ3-µ4	2.33	7.67	-5.34	10.00	means are not different