help me please https://1drv.ms/x/s!AmpDkkHrsI33giIy11ahO8Bzmfy-

QUESTIONS 1. Find th 1. Find th1. Find th 1. Find th1. Find th 1. Find th1. Find th 1. Find th 1. Find th 1. Find the p-value for each of questions. 2. Complete the steps in hypothesis testing for each of the questions using the suitable given templates. Refer PROBLEMS in slides C1 p1 as the following title: 1 Example 8-3 (Bluman, 2015): Intelligence Tests 2 Example 8-4 (Bluman, 2015): SAT Tests 3 Example 8-5 (Bluman, 2015): Cost of Rehabilitation 4 Example 8-12 (Bluman, 2015): Hospital Infections 5 Example 8-13: Starting Nurse Salary 6 Example 8-16: Jogger's Oxygen Uptake 7 Example 8-17: Obese Young People 8 Example 8-18 (Bluman, 2015): Female Gun OwnersJ3 fx Name Box B C D E F G H I J K L M N O P Q 1 HYPOTHESIS TESTING FOR ONE POPULATION MEAN USING EXCEL 2 3 eg 4 5 HO traditional method p value method 6 H1 t test p value 8 type of test: two tailed right tailed left tailed tick answer: CV alpha 10 11 alpha comparison comparison 12 current alpha 13 decision reject HO DO NOT reject HO decision reject HO DO NOT reject HO 14 u tick answer: tick answer: 15 xbar 16 S conclusion conclusion 17 In 18 19 20 21 22 24 25 26 27 E questions z test t test + Workbook Statistics Give Feedback to Microsoft - 100% +E14 Clipboard fx A B C D E F G H I J K L M N O P Q 1 HYPOTHESIS TESTING FOR ONE POPULATION MEAN USING EXCEL 2 3 4 5 HO traditional method p value method 6 H1 t test p value Co type of test: two tailed right tailed left tailed 9 tick answer: CV alpha 10 11 alpha comparison comparison 12 current alpha 13 decision reject HO DO NOT reject HO decision reject HO DO NOT reject HO 14 u tick answer: tick answer: 15 xbar 16 S conclusion conclusion 17 In 18 degree of freedom 19 20 21 22 23 24 25 26 27 > E questions z test t test +