Question

2. 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. Use Excel to indicate the importance of each of the two factors and the interaction between them on the update time.

	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

Answer 1