![]() ![]() The tool gives us two p-values: one for a one-tailed t-test and the other for a two-tailed t-test. Accept Alternate Hypothesis (Class B Score > Class A Score). ![]() Step 3:Add the necessary information in the dialogue box as shown below:Īfter entering the above data, click on “OK”.Įxcel will provide a detailed result for the p-value in cells E1 to G14, as shown below: S tep 2: A “Data Analysis” dialogue box will open, from which you have to select “t-Test: Two-Sample Assuming Equal Variances”. Note: You will have to activate the Analysis ToolPak add-in before you can use it. Step 1:Click the “Data Analysis” option from the “Data” Tab. We want to calculate the p-value to check if our assumption in the null hypothesis is true or false. Null Hypothesis (H0): There is no difference in the average scores between both divisions.Īlternate Hypothesis (H1): Class B students have higher average scores. Let us compare the scores of students from Class A and Class B to investigate whether Class A students have higher scores on their exams than students from Class B.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |