1. Using Excel, find the z-score that corresponds to the following Confidence Levels:
a. 80%
b. 85%
c. 92%
d. 97%
2. 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
.25
To find the z-score and t-score using Excel, you can use the NORM.S.INV function for z-score and the T.INV function for t-score. Here's how you can do it:
1. Finding the z-score using Excel:
a. For the Confidence Level of 80%, use the formula: `=NORM.S.INV(0.8)`
b. For the Confidence Level of 85%, use the formula: `=NORM.S.INV(0.85)`
c. For the Confidence Level of 92%, use the formula: `=NORM.S.INV(0.92)`
d. For the Confidence Level of 97%, use the formula: `=NORM.S.INV(0.97)`
2. Finding the t-score using Excel:
a. For the Confidence Level of 95% with n = 25, use the formula: `=T.INV(0.95, 25-1)`
b. For the Confidence Level of 96% with n = 15, use the formula: `=T.INV(0.96, 15-1)`
c. For the Confidence Level of 97% with n = 21, use the formula: `=T.INV(0.97, 21-1)`
d. For the Confidence Level of 91% with n = 10, use the formula: `=T.INV(0.91, 10-1)`
Make sure to replace the Confidence Level and Sample Size values in the formulas to get the corresponding z-score and t-score.