In 2019, the average SAT score in New York State was 1,064 with a standard deviation of 175. Solve for X using z-values obtained from Microsoft Excel and the Area Under the Curve Table. Population Mean, μ, = 1,064 Population Standard Deviation, σ, 175 X = μ + zσ What SAT score do you need to be among the top 0.5 percent? X μ z-value σ z = NORM.S.INV(0.995) 1,064 175 z w/Excel 1,064 175 Area Under the Curve Table What SAT score do you need to be among the top 2.5 percent? X μ z-value σ z = NORM.S.INV(0.975) 1,064 175 z w/Excel 1,064 175 Area Under the Curve Table What z-value is the cut-off point for the bottom 10 percent? X μ z-value σ z = NORM.S.INV(0.1) 1,064 175 z w/Excel 1,064 175 Area Under the Curve Table What z-value is the cut-off point for the bottom 1 percent? X μ z-value σ z = NORM.S.INV(0.01) 1,064 175 z w/Excel 1,064 175 Area Under the Curve Table
In 2019, the average SAT score in New York State was 1,064 with a standard deviation of 175. Solve for X using z-values obtained from Microsoft Excel and the Area Under the Curve Table.
Population Mean, μ, = 1,064 |
Population Standard Deviation, σ, 175 |
X = μ + zσ
What SAT score do you need to be among the top 0.5 percent?
X |
μ |
z-value |
σ |
z = NORM.S.INV(0.995) |
|
1,064 |
|
175 |
z w/Excel |
|
1,064 |
|
175 |
Area Under the Curve Table |
What SAT score do you need to be among the top 2.5 percent?
X |
μ |
z-value |
σ |
z = NORM.S.INV(0.975) |
|
1,064 |
|
175 |
z w/Excel |
|
1,064 |
|
175 |
Area Under the Curve Table |
What z-value is the cut-off point for the bottom 10 percent?
X |
μ |
z-value |
σ |
z = NORM.S.INV(0.1) |
|
1,064 |
|
175 |
z w/Excel |
|
1,064 |
|
175 |
Area Under the Curve Table |
What z-value is the cut-off point for the bottom 1 percent?
X |
μ |
z-value |
σ |
z = NORM.S.INV(0.01) |
|
1,064 |
|
175 |
z w/Excel |
|
1,064 |
|
175 |
Area Under the Curve Table |
Trending now
This is a popular solution!
Step by step
Solved in 2 steps