FOR THIS QUESTION, EXCEL *MUST* BE USED TO CALCULATE THE P-VALUE FOR CHI SQUARED! Some people feel that they have good intuition about when others are lying, while others do not feel they have this ability. Are the more "intuitive" people better able to detect lies? 100 people were shown a video clip of a person stating the name of his or her favorite movie (Young 2002). The person was truthful in only some of the video clips shown. Another group of 100 people who claimed to not have any "intuitive" ability were shown similar video clips. 59 of 100 "intuitive" people correctly identified whether the filmed person was lying, whereas 69 of the 100 "nonintuitive" people correctly identified if the person in the film clips was lying. Observed Frequencies Table Intuitive Nonintuitive Rows Total Detected Lie 59 69 128 41 31 72 Did Not Detect Lie Column Totals 100 100 200 Fill in the expected frequecies table (below) based on your knowledge of the observed frequencies (table above). Round answers to whole numbers. Intuitive Nonintuitive Rows Total Detected Lie 128 72 Did Not Detect Lie Column Totals 100 100 200 Calculate the odds ratio (OR) to decide if intuitive people are more or less intuitive than the non-intuitive. (Round to two decimal places if necessary) df= X 11 (round to 2 decimals) Critical value +2 0.05,1,1 = (answer 0.05 1. People in the two groups detect lies at the same frequency. 2. People in the two groups do not detect lies at the same frequency. Above are the two hypotheses. Which of the two hypotheses is the null hypothesis? Enter either 1 or 2 in the answer box Based on our statistical results, calculated above, do we (Enter either fail to reject, or reject.) the H.? Are we confident that one of the two groups is better than the other at detecting lying? (yes or no)