. Using Excel, find the t-score that corresponds to the following Confidence Levels and Sample Sizes:
a. 95% with n = 25
b. 96% with n = 15
c. 97% with n = 21
d. 91% with n = 10
To find the t-score that corresponds to each confidence level and sample size using Excel, you can use the T.INV function.
a. For a 95% confidence level with n = 25:
- Open Excel and in a cell, enter the formula: =T.INV(1-(1-0.95)/2, 25-1)
- Press Enter and Excel will return the t-score that corresponds to a 95% confidence level with n = 25.
b. For a 96% confidence level with n = 15:
- In another cell, enter the formula: =T.INV(1-(1-0.96)/2, 15-1)
- Press Enter to get the t-score for a 96% confidence level with n = 15.
c. For a 97% confidence level with n = 21:
- Again, in a different cell, enter the formula: =T.INV(1-(1-0.97)/2, 21-1)
- Press Enter to find the t-score for a 97% confidence level with n = 21.
d. For a 91% confidence level with n = 10:
- Once more, in a new cell, enter the formula: =T.INV(1-(1-0.91)/2, 10-1)
- Press Enter, and Excel will return the t-score corresponding to a 91% confidence level with n = 10.
By using the T.INV function in Excel and plugging in the appropriate values for the confidence level and sample size, you can easily find the corresponding t-scores.