Find the following z-scores.=NORM.S.INV(P(Z<z))(A) There is 29%29\% chance of a z-score being below what value?z=−−−z=_{---}(B) There is a 67%67\% chance that a z-score is larger than what value?z=−−−z=_{---}

(A) z = − 0.55 z=-0.55 ; (B) z = − 0.44 z=-0.44 z = − 0.44

Find the following z-scores. =NORM.S.INV(P(Z<z)) (A) There is 29 % 29\% chance of a z-score being below what value? z = − − − z=_{---} (B) There is a 67 % 67\% chance that a z-score is larger than what value? z = − − − z=_{---}

Welcome to the practice. In this problem, we'd like to find the following z scores. And because we'll be finding z scores from probabilities, we'll be using the standard normal distribution and the equals norm dot s dot I n v function. Let's start with part a. It says there is a 29% chance of a z score being below what value. So my first step is either going to be to copy and paste in my function or type it in here. I'm gonna type it in equals norm dot s dot I n b, open parenthesis, but it's totally up to you. Now I need to put in my probability. And as a reminder, I need it to be a left hill probability, so I'm going to have to check that first. I can see that this is a 29% chance that a z score is below a certain value. Because it says below, I know that this is a left tail probability, and I can enter in this probability as is. I can either keep it as a percent, 29%, and I will need the percent symbol, or I can convert it to a decimal if that's easier for me. Either way, now that I have my input, I can click enter, and I get that z score at negative 0.55. So I could say that there is a 29% chance of a z score being below negative 0.55. Let's look at part b. It says there is a 67% chance that a z score is larger than what value. So I'm still going to be using my function here because I wanna convert a probability into a z score. And, again, I can either copy and paste it in or type it in, equals norm dot s dot I n v open parenthesis. But this time, I have here a 67% chance that the z score is larger than a certain value. So here, I've been given a right tail probability, and I need to turn it into a left tail probability so I can use it as an input for this function. As a reminder, we said in the concept video that you can take one minus a right tail probability to turn it into a left tail probability. But to do that, I am gonna have to convert my probability here into a decimal, so I'll think of it as 0.67, and I'll have my input be one minus that right tail probability of 0.67. Again, it doesn't matter that my input is an expression. That is totally fine. Now that I have my input taken care of, I can click enter, and I get a z score of negative 0.44. So I can say there is a 67% chance that the z score is larger than negative 0.44. Great job.

Find the following z-scores. =NORM.S.INV(P(Z<z)) (A) There is 29 % 29\% chance of a z-score being below what value? z = − − − z=_{---} (B) There is a 67 % 67\% chance that a z-score is larger than what value? z = − − − z=_{---}

(A) z = − 0.55 z=-0.55 ; (B) z = − 0.44 z=-0.44 z = − 0.44

(A) z = − 0.55 z=-0.55 ; (B) z = 0.44 z=0.44

(A) z = 0.55 z=0.55 ; (B) z = − 0.44 z=-0.44

(A) z = 1.9 z=1.9 ; (B) z = − 0.44 z=-0.44 z = − 0.44

Table of contents

Skip topic navigation

1. Intro to Stats and Collecting Data1h 14m

Intro to Stats
24m

Levels of Measurement
18m

Intro to Collecting Data
8m

Sampling Methods
23m

2. Describing Data with Tables and Graphs1h 56m

Visualizing Qualitative vs. Quantitative Data
4m

Frequency Distributions
35m

Histograms
14m

Bar Graphs and Pareto Charts
11m

Pie Charts
8m

Frequency Polygons
10m

Dot Plots
6m

Stemplots (Stem-and-Leaf Plots)
14m

Time-Series Graph
9m

3. Describing Data Numerically2h 5m

Mean
9m

Median
17m

Mode
7m

Standard Deviation
16m

Interpreting Standard Deviation
20m

Percentiles & Quartiles
14m

Describing Data Numerically Using a Graphing CalculatorBonus
10m

Boxplots
8m

Descriptive Statistics-ExcelBonus
11m

Boxplots-ExcelBonus
8m

4. Probability2h 16m

Basic Concepts of Probability
7m

Complements
6m

Addition Rule
17m

Multiplication Rule: Independent Events
11m

Introduction to Contingency Tables
17m

Multiplication Rule: Dependent Events
15m

Bayes' Theorem
13m

Fundamental Counting Principle
8m

Counting
37m

5. Binomial Distribution & Discrete Random Variables3h 6m

Discrete Random Variables
31m

Binomial Distribution
1h 7m

Finding Binomial Probabilities-ExcelBonus
17m

Poisson Distribution
40m

Finding Poisson Probabilities-ExcelBonus
15m

Hypergeometric Distribution
14m

6. Normal Distribution and Continuous Random Variables2h 11m

Uniform Distribution
18m

Standard Normal Distribution
39m

Probabilities & Z-Scores w/ Graphing CalculatorBonus
19m

Non-Standard Normal Distribution
21m

Finding Probabilities, Z Values, and X Values with the Normal Distribution-ExcelBonus
32m

7. Sampling Distributions & Confidence Intervals: Mean3h 23m

Sampling Distribution of the Sample Mean and Central Limit Theorem
19m

Distribution of Sample Mean - ExcelBonus
23m

Introduction to Confidence Intervals
15m

Confidence Intervals for Population Mean
1h 18m

Determining the Minimum Sample Size Required
12m

Finding Probabilities and T Critical Values - ExcelBonus
28m

Confidence Intervals for Population Means - ExcelBonus
25m

8. Sampling Distributions & Confidence Intervals: Proportion2h 10m

Sampling Distribution of Sample Proportion
29m

Confidence Intervals for Population Proportion
42m

Confidence Intervals for Population Proportion - ExcelBonus
12m

Chi Square Distribution
20m

Confidence Intervals for Population Variance
24m

9. Hypothesis Testing for One Sample5h 8m

Steps in Hypothesis Testing
1h 6m

Performing Hypothesis Tests: Means
1h 4m

Hypothesis Testing: Means - ExcelBonus
42m

Performing Hypothesis Tests: Proportions
37m

Hypothesis Testing: Proportions - ExcelBonus
27m

Performing Hypothesis Tests: Variance
12m

Critical Values and Rejection Regions
28m

Link Between Confidence Intervals and Hypothesis Testing
12m

Type I & Type II Errors
16m

10. Hypothesis Testing for Two Samples5h 37m

Two Proportions
1h 13m

Two Proportions Hypothesis Test - ExcelBonus
28m

Two Means - Unknown, Unequal Variance
1h 3m

Two Means - Unknown Variances Hypothesis Test - ExcelBonus
12m

Two Means - Unknown, Equal Variance
15m

Two Means - Unknown, Equal Variances Hypothesis Test - ExcelBonus
9m

Two Means - Known Variance
12m

Two Means - Sigma Known Hypothesis Test - ExcelBonus
21m

Two Means - Matched Pairs (Dependent Samples)
42m

Matched Pairs Hypothesis Test - ExcelBonus
12m

Two Variances and F Distribution
29m

Two Variances - Graphing CalculatorBonus
16m

11. Correlation1h 24m

Scatterplots & Intro to Correlation
26m

Correlation Coefficient
21m

Creating Scatterplots and FInding Correlation Coefficient - ExcelBonus
6m

Hypothesis Tests for Correlation Coefficient Using TI-84 Bonus
17m

Inferences for the Correlation Coefficient - ExcelBonus
11m

12. Regression3h 33m

Linear Regression & Least Squares Method
26m

Residuals
12m

Coefficient of Determination
12m

Regression Line Equation and Coefficient of Determination - ExcelBonus
8m

Finding Residuals and Creating Residual Plots - ExcelBonus
11m

Inferences for Slope
31m

Enabling Data Analysis ToolpakBonus
1m

Regression Readout of the Data Analysis Toolpak - ExcelBonus
21m

Prediction Intervals
13m

Prediction Intervals - ExcelBonus
19m

Multiple Regression - ExcelBonus
29m

Quadratic Regression
15m

Quadratic Regression - ExcelBonus
10m

13. Chi-Square Tests & Goodness of Fit2h 21m

Goodness of Fit Test
41m

Goodness of FIt Test Using TI-84Bonus
17m

Goodness of Fit Test - ExcelBonus
10m

Contingency Tables
12m

Independence Tests
14m

Homogeneity Tests
11m

Using Matrices on a TI-84Bonus
6m

Independence Test Using TI-84Bonus
12m

Independence Tests - ExcelBonus
13m

14. ANOVA2h 28m

Introduction to ANOVA
30m

One-Way ANOVA - ExcelBonus
12m

Multiple Comparisons: Tukey Test
14m

Multiple Comparisons: Tukey-Kramer Test
15m

Multiple Comparisons: Bonferoni Test
24m

Two-Way ANOVA
32m

Two-Way ANOVA - ExcelBonus
18m

6. Normal Distribution and Continuous Random Variables

Finding Probabilities, Z Values, and X Values with the Normal Distribution-Excel

Statistics

6. Normal Distribution and Continuous Random Variables

Finding Probabilities, Z Values, and X Values with the Normal Distribution-Excel

Previous problemNext problem

Struggling with Statistics?

Join thousands of students who trust us to help them ace their exams!

Multiple Choice

Find the following z-scores.
=NORM.S.INV(P(Z<z))
(A) There is $29 percent sign$ chance of a z-score being below what value?
$z =_{- - -}$
(B) There is a $67 percent sign$ chance that a z-score is larger than what value?
$z =_{- - -}$

(A) $z = - 0.55$ ; (B) $z equals 0.44$

(A) $z equals 0.55$ ; (B) $z = - 0.44$

(A) $z = - 0.55$ ; (B) $z=-0.44$

(A) $z equals 1.9$ ; (B) $z=-0.44$

0 Comments

Previous problemNext problem

Verified step by step guidance

Understand that the problem asks for z-scores corresponding to given probabilities using the standard normal distribution, where the mean is 0 and the standard deviation is 1.

For part (A), identify that the probability given is P(Z < z) = 0.29, meaning the z-score corresponds to the 29th percentile of the standard normal distribution.

Use the inverse standard normal cumulative distribution function, denoted as $\text{NORM.S.INV}(p)$, to find the z-score for a given cumulative probability $p$. For part (A), calculate $z = \text{NORM.S.INV}(0.29)$.

For part (B), note that the probability given is P(Z > z) = 0.67. Since the inverse function uses cumulative probability from the left, convert this to P(Z < z) = 1 - 0.67 = 0.33, then calculate $z = \text{NORM.S.INV}(0.33)$.

Interpret the results: the z-score found in part (A) will be negative because 0.29 is less than 0.5 (the mean), and the z-score in part (B) will also be negative since 0.33 is less than 0.5. This matches the properties of the standard normal distribution.