NEED HELP WITH EXERCISES 1-4 One sample t Test we are mow going to use Excel to test a l it the average cholesterol level of patients in in cholesterol level of 20 random people from vario on one...
One sample t Test we are mow going to use Excel to test a l it the average cholesterol level of patients in in cholesterol level of 20 random people from vario on one given sample We would like to know to 200 and for shat reason we collec or patients in intens based n various intensive care units Cholesterol level 1S4, 168, 134,201,208,220.225,228,201207,168,211,203,254,268198 out our data in colurmn A. In Cells A3 A22 we type our data and in cell A1 we type Coletere, First let's input the sample size n that is how many elements in data do we have. 'n cel、B24 w type N and in cell A24 we type 20. Second, we find degrees of freedom df-N-1. in cell 825 we type af and in cell A25 we type-A24-1 Next we evaluate the mean We learned that already. In cell 826 we tvpe Mean and in cell A26 we type saveragelA3:A22) Now let's do standard deviation. In cell 827 we type SD and in cell A27 we type stidevlAd A Next let's do standard error of the mean. In cell B28 we type SEM and in c A27/sqrt(A24) ell A28 we type We will do a one sample t test and for that we need a t value. . In cell 829 we type t and in cell A29 we type -(A26-200)/A28 Now we evaluate the p value using Excel, in cell B31 we type TEST value and in cell A31 we type 200 rn cell B32 we type Mean Difference. In cell A32 we type A26-A31. n cell 833 we type Sig.(2-tailed). In cell A33 type T.DIST 2T(A29,A25). Here T.DIST.2T means we are doing 2 tailed one sample TTEST first parameter A29 means we are computing the p value based on our calculated t value and we comparing it to our threshold significance level of 005. The second variable represents degrees of freedom. Exercises Exercise 2. What does the value in cell A33 tell you about the hypothesis. Do we reject the null hypothesis? Why? Put your explanation in cell A36. Exercise 1. State the null hypothesis from this example in cell A35. Exercise 3. Instead of using Excel, we can look at the t chart. Find the critical value for the t distribution from that table. Put that value in cell A37 Exercise 4. Compare the t value in cell A29 to the table t value in cell A37. What is this comparison telling you about rejecting or not rejecting the null hypothesis. Put your explanation in cell A38.
One sample t Test we are mow going to use Excel to test a l it the average cholesterol level of patients in in cholesterol level of 20 random people from vario on one given sample We would like to know to 200 and for shat reason we collec or patients in intens based n various intensive care units Cholesterol level 1S4, 168, 134,201,208,220.225,228,201207,168,211,203,254,268198 out our data in colurmn A. In Cells A3 A22 we type our data and in cell A1 we type Coletere, First let's input the sample size n that is how many elements in data do we have. 'n cel、B24 w type N and in cell A24 we type 20. Second, we find degrees of freedom df-N-1. in cell 825 we type af and in cell A25 we type-A24-1 Next we evaluate the mean We learned that already. In cell 826 we tvpe Mean and in cell A26 we type saveragelA3:A22) Now let's do standard deviation. In cell 827 we type SD and in cell A27 we type stidevlAd A Next let's do standard error of the mean. In cell B28 we type SEM and in c A27/sqrt(A24) ell A28 we type We will do a one sample t test and for that we need a t value. . In cell 829 we type t and in cell A29 we type -(A26-200)/A28 Now we evaluate the p value using Excel, in cell B31 we type TEST value and in cell A31 we type 200 rn cell B32 we type Mean Difference. In cell A32 we type A26-A31. n cell 833 we type Sig.(2-tailed). In cell A33 type T.DIST 2T(A29,A25). Here T.DIST.2T means we are doing 2 tailed one sample TTEST first parameter A29 means we are computing the p value based on our calculated t value and we comparing it to our threshold significance level of 005. The second variable represents degrees of freedom. Exercises Exercise 2. What does the value in cell A33 tell you about the hypothesis. Do we reject the null hypothesis? Why? Put your explanation in cell A36. Exercise 1. State the null hypothesis from this example in cell A35. Exercise 3. Instead of using Excel, we can look at the t chart. Find the critical value for the t distribution from that table. Put that value in cell A37 Exercise 4. Compare the t value in cell A29 to the table t value in cell A37. What is this comparison telling you about rejecting or not rejecting the null hypothesis. Put your explanation in cell A38.