Congratulations for being hired Director of Casino Services for the Adelphi Casino and Racetrack. On your second week of work, you received a state complaint filed by 132 patrons of the casino that the vendor WMS has sent faulty slot machines to your casino. The claim has indicated that some machines are not paying out at the claimed payout percentages. To that end, your staff has sampled over a five-hour period the number of times a bonus was initiated on the machines below:

Slot Machines - http://www.wms.com/Games/Video/IPlay/Pages/default.aspx

Slot Machines - http://www.wms.com/Games/Video/IPlay/Pages/default.aspx

Jade Palace The Princess Bride Winning Bid 2 Jackpot Block Party Airplane

1 p.m 1 2 3 3 4

2 p.m. 1 6 2 3 4

3 p.m. 3 3 3 1 5

4 p.m. 2 7 7 5 8

5 p.m. 6 4 8 6 3

6 p.m. 7 3 4 4 6

The five machines initiate bonuses at a mean of 4.15/per hour and a SD of 2.06

The average money spent was $212 per hour and an SD of $294

The judge advanced five complainants who kept meticulous records. The judge has allowed you to use the sum for each complainant for the bonuses (i.e. Add up each bonus per complainant and find the mean. Then convert the mean into a z-score and then find the area. You also must find the z-score for the money spent per complainant.)

Money Spent Jade Palace The Princess Bride Winning Bid 2 Jackpot Block Party Airplane

Complainant 1 $300 11 4 2 6 7

Complainant 2 $550 8 3 6 7 2

Complainant 3 $75 4 6 22 3 6

Complainant 4 $688 9 15 0 8 4

Complainant 5 $290 4 5 8 11 4

% Above in Money Spent% Over in Bonuses Per Hour

Complainant #1

Complainant #2

Complainant #3

Complainant #4

Complainant #5

To make the decision below, the complainant must be above 65% of their class action suit group in Money Spent and over 85% in Bonuses per hour. If they exceed both metrics, then the complainant lost their case.

1) Did complainant #1 win the case?YESNO

2) Did complainant #2 win the case?YESNO

3) Did complainant #3 win the case?YESNO

4) Did complainant #4 win the case?YESNO

5) Did complainant #5 win the case?YESN

6) You won your lawsuit if the majority of the complainants lost. Did you win your case?

What are the Excel function to calculate z-score and rest of the calculations please provide for at least 1 data set