Drag the cursor over the second column of data to add the second array. Type a comma. You now in the cell. see “=ttest(A2:A10, B2:B10,” Type or for the another comma. Note that t-test refers to the “1” “2” “tail” value, then type “tail” tails on a line graph if the data were charted in a graph. You can use the value you are only “1” if interested in the data in one tail of the graph or if both tails are important. “2” Type or for the value, then type a to complete the function. Note that the “1,” “2,” “3” “type” “)” t-test to the type of t-test you want to perform. Use the value to perform a “type” refers “1” paired test. Use the to use a homoscedastic t-test with a two-sample equal variance. value “2” Type the value to use a heteroscedastic t-test with a two-sample unequal variance. “3” The function is now replaced with a value representing the result of the t-test. Press “Enter.”
Drag the cursor over the second column of data to add the second array. Type a comma. You now see “=ttest(A2:A10, B2:B10,” in the cell. Type “1” or “2” for the “tail” value, then type another comma. Note that t-test “tail” refers to the tails on a line graph if the data were charted in a graph. You can use the value “1” if you are only interested in the data in one tail of the graph or “2” if both tails are important. Type “1,” “2,” or “3” for the “type” value, then type a “)” to complete the function. Note that the t-test “type” refers to the type of t-test you want to perform. Use the value “1” to perform a paired test. Use the value “2” to use a homoscedastic t-test with a two-sample equal variance. Type the value “3” to use a heteroscedastic t-test with a two-sample unequal variance. Press “Enter.” The function is now replaced with a value representing the result of the t-test.
Excel%203%20football%20problem.docx