If this is your data set, you are allowed to choose among the following 5 alpha levels. 0.03 0.008 0.11 0.07 0.45 Choose 1 to use in your assignment. Element EE_11879 EE_9053 EE_19468 EE_22386 EE_8786 EE_21996 EE_28489 EE_23295 EE_21757 EE_24784 EE_5265 EE_17991 EE_20184 EE_27734 EE_21107 EE_16500 EE_12321 EE_26043 EE_7000 EE_9438 EE_19301 EE_26444 EE_6601 EE_24986 EE_18570 EE_5471 EE_14878 EE_16074 EE_5218 EE_21425 EE_19488 EE_26877 EE_21508 EE_18894 EE_25044 Gender OWL 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 FOX . . 1.8 1.7 2.2 2.6 2.8 3 3.2 3.3 3.3 3.5 3.9 3.9 4.1 4.1 4.1 4.2 4.3 4.3 4.3 4.3 4.5 4.5 4.7 4.7 4.8 4.8 4.9 5.1 5.4 5.4 5.5 5.7 5.7 5.6 1.3 3.4 5 3.100 1.7 1.1 2.8 2.6 4.4 5.4 4.3 2.8 3.8 3.5 5.1 4.1 4.3 1.5 2.9 2.3 3.2 2.2 2.4 3.8 4.1 1.8 . LION 2.6 2.3 3.5 4.9 2.1 4.7 2.7 1.9 1.5 2.9 3.1 4.2 2.2 1.7 3.4 3.4 1.5 3.3 4.2 2.7 2.2 2.8 3.1 4.7 . 3.5 3 1.1 1 2.9 2.5 2.1 . 3.1 2.8 . 3.8 3.7 . 2.8 . 3.3 4 1.2 4.8 4.8 2.4 4.5 4 . 1.6 4.1 4.6 2.7 3.6 3.6 3.8 SEAL 2.7 3.4 5.2 3.4 3 2.9 3.8 MAN . . . . . 3.8 . . 4.8 . 1.6 . 2.1 . . . 1.5 . . . . . . 1.1 1.5 4.5 3.5 4.9 2.7 1.8 4.5 4.4 3.7 4.4 3.3 3.8 . . 1.3 . . . . . 1.1 . . 2.8 looking ranking 2 1 1 2 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 1 2 2 2 2 2 2 2 2 2 2 2 2 1 2 2 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 Excel attached use to answer these questions. Question 1: ( data set is in the excel attached) The confidence interval of a quantitative variable is centered on the mean and has a margin of error that is added and subtracted to determine the confidence limits for that mean. What is the margin of error for the variable OWL in your data set? Question 2: What is the test statistic you needed to use to calculate the previous value? Question 2 options: z2/ Cannot calculate because we dropped this variable or it was not in our data set. t2/,df Question 3: According to your calculations, what are the upper and lower confidence limits for the variable FOX in your data set? (Answer precision to 3 decimal places, even if those are 0s.) Provide lower limit first, then upper limit. ________________________________________________ Format should be LL - UL. Question 4: Show your calculations for 1 ( and only 1) of the these two variables: SEAL or MAN. Include the number in the centre of the range, the values used to calculate the confidence interval and the final values. Questions 5:Can you calculate a confidence interval for "LOOK"? Question 5 options: Yes No Not enough information provided. Question 6: Justify your last answer. Question 7: What is the value in the centre of the confidence interval for LOOK? Question 7 options: Cannot be calculated p y p0 x Questions 8:What values did you calculate for the confidence limits for LOOK? (Show lower limit first and upper limit second.)