A	B	C	D	E	F	G	H	I
1	Empl ID	Division	Region	Position	M/F	Age	Yrs Exp	Manhrs	Overtime?
2	100001	Operations	Central	Operator	F	33	0	727
3	100002	Engineering	East	Labourer	F	29	10	2000
4	100003	Mechanical	West	Electrician	F	34	10	1963
5	100004	Mechanical	Central	Mechanic	M	41	15	2000
6	100005	Contractor	Central	Operator	F	25	0	1952
7	100006	Engineering	East	Pipefitter	F	39	8	2029
8	100007	Engineering	West	Labourer	M	46	6	2000
9	100008	Operations	East	Operator	M	33	0	1182
10	100009	Operations	East	Maintenance	F	39	1	2000

Part B:

Which of the following functions could beused in cell I2 then dragged down column I to display "OVERTIME" if an employee works more than 2000 hours, and display a blank cell if the employee works 2000 hours or less?Select all that apply.

		=IF(H:H<=2000,"OVERTIME","")
		=IF(H:H>2000,"OVERTIME","")
		=IF(H2>2000,"","OVERTIME")
		=IF(H2<=2000,"","OVERTIME")
		=IF(H:H>2000,"","OVERTIME")
		=IF(H:H<=2000,"","OVERTIME")
		=IF(H2<=2000,"OVERTIME","")
		=IF(H2>2000,"OVERTIME","")

Part C:

The RAND() function generates numbers between:

		-1 and 1
		0 and 100
		-100 and 100
		0 and 1

Part D:

Using your Classical worksheet, what injury rate(as a percentage) will result in P(at least one injury)=0.500 for 100 employees. Round to two decimal places. Do not include the % symbol in your answer.

%

Hint: Try different injury rates in cell B1 and observe the row with n=100.