41. An investigation of the effectiveness of an antibacterial soap in reducing operating

room contamination resulted in the accompanying table. The new soap was tested in a

sample of eight operating rooms in the greater Seattle area during the last year. The

following table reports the contamination levels before and after the use of the soap for

each operating room.

Operating Room

A B C D E F G H

Before 6.6 6.5 9.0 10.3 11.2 8.1 6.3 11.6

After 6.8 2.4 7.4 8.5 8.1 6.1 3.4 2.0

At the .05 significance level, can we conclude the contamination measurements are

lower after use of the new soap?

please explain step by step to use in Excel.