1. You have been hired by a company as a Statistical Consultant,for the purpose of determining whether there is a significantdifference in the number of units produced by workers on Mondaysand Fridays at their factory. The following table indicate thenumber of units produced by three groups of eight workers randomlysampled from each of the relevant days.

1. Using manual computation, perform the appropriate hypothesistest at ? = 0.05

Mondays	Fridays
43	24
27	16
25	33
45	28
32	26
41	17
38	32
24	23

2. You perform a simple experiment to determine whether theconsumption of two units of alcohol has a significant impact uponability to play computer games. Two samples, each of ten gameplayers, are randomly chosen for the experiment. Subjects in bothgroups are asked to play a computer game for ten minutes, and thefinal score of each game player is recorded. The first group playthe game being sober, while the second group play the gameimmediately after consuming two units of alcohol. The resultsobtained are given in the following table:

                     Score

Group 1 (No Units Of Alcohol)	Group 2 (Two Units Of Alcohol)
23	21
22	16
28	17
25	14
25	20
26	19
23	18
26	16
24	17
25	16

2. Perform an appropriate hypothesis test at the 5% significancelevel to determine whether consumption of two units of alcohol hasa significant impact upon ability to play computer games, asmeasured by the final scores obtained by game players. Show allcalculations, both manual, and using MS Excel.