Question

The computer operations department had a business objective of reducing the amount of time to fully update each subscriber’s set of messages in a special secured email system. An experiment was conducted in which 40 subscribers were selected with four difference messaging systems and two connection media types used. The subscribers were randomly assigned so that there were five subscribers in each of the eight combinations of the two factors – messaging system and media used. The updates time are as follows.

	System 1	System 2	System 3	System 4
Cable	45.6	41.7	35.3	30.5
	49.0	42.8	37.7	31.3
	41.8	40.0	41.0	39.6
	35.6	39.6	28.7	25.4
	43.4	39.0	31.8	23.7
Fiber	44.1	37.9	43.3	43.8
	40.8	41.1	40.0	40.5
	46.9	35.8	43.1	44.2
	51.8	45.3	39.6	42.1
	48.5	40.2	33.2	35.4

Completely analyze these data and write a report to the team that indicates the importance of each of the two factors and/or the interaction between them on the update time. Hint: Use Two-Way ANOVA spreadsheets.

Answer 1