please I really need help to solve this question because I did not find this tab in my excel. Thanks

ork - Ch& Assignments (78quez, 171pts) (su2'20) - Google Chrome mathxl.com/Student/PlayerHomework.aspx?homeworkld=602219514&questionld=45&flushed=false&cld=6575746¢erwin=yes MATH 251 901 ONL 15A FA21 - Statistics for Science, CCP crn40776 Karima Merzak & | 11/10/21 11:51 = Homework: Ch8 Assignment8 (78quez, 171pts) {su2'20} Question 49, 8.2.21-E HW Score: 50.88%, 87 of 171 points Save Part 2 of 5 Points: 0 of 6 A 9-year-old girl did a science fair experiment in which she tested professional touch therapists to see if they could sense her energy field. She flipped a coin to select either her right hand or her left hand, and then she asked the therapists to identify the selected hand by placing their hand just under her hand without seeing it and without touching it. Among 264 trials, the touch therapists were correct 112 times Use a 0 10 significance level to test the claim that touch therapists use a method equivalent to random guesses. Do the results suggest that touch therapists are effective? identify the null and alternative hypotheses for this test. Choose the correct answer below A Ho p#05 Ho p = 05 Hy p = 0.5 H1 p $ 05 C. Ho p = 0.5 OD. Ho P= 05 Hy p 05 Identify the test statistic for this hypothesis test. The test statistic for this hypothesis test is (Round to two decimal places as needed.) Help me solve this View an example Get more help - Clear all x Type here to search O 9 w Check answer 44OF Clear ~ 49) 11/10/2021HW Score: 50.88%, 87 of 171 points Assignment8 (78quez, 171nts) (su2'201 Question 49, 8.2.21-E her left hand, a experiment in which she tested profe View an example | 4 parts remaining X to test the claim d just under her hand without seeing ggest that touch therapists are effect A 9-year-old girl did a science fair experiment in which she tested professional touch therapists to see if they could sense her energy field. She flipped a coin to select either her right hand or her left hand, and then she asked the otheses for this test. Choose the co therapists to identify the selected hand by placing their hand just under her hand without seeing it and without touching it. Among 242 trials, the touch therapists were correct 106 times Use a 0. 10 significance level to test the claim that touch therapists use a method equivalent to random guesses. Do the results suggest that touch therapists are effective? P - P pq pothesis test In particular, this solution process uses the XLSTAT add-on for Excel to perform the hypothesis test. Click on the s test is XLSTAT tab in the Ribbon and then click Parametric Tests Select Tests for one proportion from the dropdown leeded. menu. In the procedure's General menu, shown here, since the number of successes are known, select Frequency under Data Format. Identify the frequency, sample size, and claimed value for the population proportion to be entered. Frequency = 106 Sample size = 242 Test proportion = 0.5 Make sure that z test is checked, and that Continuity correction is unchecked In the procedure's Options tab, shown here, under Alternative hypothesis select Proportion - Test Proportion # D. For Hypothesized Difference, enter 0. For Significance Level (%), enter 10% Under Variance (confidence interval) select Test Proportion and under Confidence Interval select Wald Then click OK to display the result. If a window titled XLSTAT - Selections appears, click Continue. Calculator Print Continuhy View an example Get more nelp - Continue O 9