Hi, I don't know why they are showing a solution that uses Excel.... you certainly won't be using Excel on the exam (at least not this year)! To solve this you need to calculate the Z-stat: Z = (4 - 7) / 13 = -0.2308 Next you need to use the Z table (which I would expect to be provided during the exam... most likely right in the body of the question) to look up the area: Look up Z = -0.23 on the table, which gives you 0.4090... this is the area up to 4%... so this is interpreted as 40.9%. Thus there is a 40.9% chance that the return will be lower than 4%. Choice B is the best answer. I hope this helps.... if not, let me know and I'll make up a quick teaching video showing you exactly what you need to do. Prof. Brian Gordon, CFA, CFP, CIM, MBA, FCSI Director of Learning Exam Success examsuccess.ca Answer from ProfBrianYGordonCFA on reddit.com
University of Washington
faculty.washington.edu › gloftus › P317-318 › Useful examples › ExcelNormalDist.html
Excel Basics Finding areas under the normal distribution
Excel has some very useful functions for finding areas under the normal distribution. ... Z is the value for which you want the distribution. Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in place of a table of standard normal curve areas. a) Pick a cell and enter a z score into it (for example 2), dont forget to add a label so youll know what you put in this cell.
Statistics LibreTexts
stats.libretexts.org › campus bookshelves › fresno city college › book: business statistics customized (openstax) › using excel spreadsheets in statistics › 4 continuous probability
4.3 Normal probability using Excel Spreadsheet provided and Excel only - Statistics LibreTexts
December 22, 2022 - ... Suppose a random variable X is Distributed Normal with a mean of 120 and a standard deviation of 13, X~N(120, 13). Compute the following values. Round the probabilities to 4 decimal places. Round the X values and Z scores to 2 decimal places.
Common Probability Distribution Question, how to solve without excel? Z table or T table?
Hi, I don't know why they are showing a solution that uses Excel.... you certainly won't be using Excel on the exam (at least not this year)! To solve this you need to calculate the Z-stat: Z = (4 - 7) / 13 = -0.2308 Next you need to use the Z table (which I would expect to be provided during the exam... most likely right in the body of the question) to look up the area: Look up Z = -0.23 on the table, which gives you 0.4090... this is the area up to 4%... so this is interpreted as 40.9%. Thus there is a 40.9% chance that the return will be lower than 4%. Choice B is the best answer. I hope this helps.... if not, let me know and I'll make up a quick teaching video showing you exactly what you need to do. Prof. Brian Gordon, CFA, CFP, CIM, MBA, FCSI Director of Learning Exam Success examsuccess.ca More on reddit.com
9
10
December 15, 2022Excel function for finding the z score
=NORM.S.INV(0.4962 + 0.5) gives 2.669342... That you need the 0.5 is clear from the diagram on the image you link More on reddit.com
2
3
December 8, 2022Finding a z Value for a Given Probability Use Excel's function options to find the following z values for the standard normal variable Z. Complete the following problems. P(Z = z) = 0.1020 -1.2702 Determine the z score that will produce the probability in the statement. Plz SZSO) = 0.1772 Determine the z score that will produce the probability in the
Finding a z Value for a Given Probability Use Excel's function options to find the following z values for the standard normal variable Z. Complete the following problems. P(Z = z) = 0.1020 -1.2702 Determine the z score that will produce the probability in the statement. More on chegg.com
1
calculate p value from z score (two tailed) in excel
Slightly simpler is to use normsdist for the abs value of z. More on reddit.com
3
1
June 11, 2020How can you find a z score from a given cumulative probability using Excel?
To find a z score corresponding to a cumulative probability in the standard normal distribution, use Excel's =NORM.S.INV(probability) function. The input probability must be a left-tail probability (the area under the curve to the left of the z score). For example, if you want the z score where 58% of values lie below it, enter =NORM.S.INV(0.58), and Excel returns approximately 0.202. This means there's a 58% chance a z score is less than 0.202. If you have a right-tail probability, convert it to left-tail by subtracting from 1 before using this function.
pearson.com
pearson.com › channels › business-statistics › learn › patrick › 6-normal-distribution-and-continuous-random-variables › finding-probabilities-z-scores-and-x-values-excel
Finding Probabilities from Z-Scores and X Values-Excel
How do you find the probability of a z score using Excel's normal distribution functions?
To find the probability of a z score in Excel, use the function =NORM.S.DIST(z, TRUE), where z is your z score. This function calculates the cumulative probability from the left tail up to that z score in the standard normal distribution (mean 0, standard deviation 1). For example, if you want the probability of a z score less than -1.5, enter =NORM.S.DIST(-1.5, TRUE), and Excel will return approximately 0.07, meaning a 7% chance. This method is useful when you have standardized data and want to find the likelihood of observing a value below a certain z score.
pearson.com
pearson.com › channels › business-statistics › learn › patrick › 6-normal-distribution-and-continuous-random-variables › finding-probabilities-z-scores-and-x-values-excel
Finding Probabilities from Z-Scores and X Values-Excel
How do you find the probability of a value being greater than a certain x in Excel using the normal distribution?
Excel's NORM.DIST function calculates cumulative probabilities for values less than or equal to x, so to find the probability of a value greater than x, use the complement rule: . For example, if you want the probability that baking time is longer than 12.5 minutes with mean 11 and standard deviation 0.76, calculate =1 - NORM.DIST(12.5, 11, 0.76, TRUE). This returns the right-tail probability, about 0.02 or 2% chance.
pearson.com
pearson.com › channels › business-statistics › learn › patrick › 6-normal-distribution-and-continuous-random-variables › finding-probabilities-z-scores-and-x-values-excel
Finding Probabilities from Z-Scores and X Values-Excel
Videos
Statology
statology.org › home › how to convert between z-scores and percentiles in excel
How to Convert Between Z-Scores and Percentiles in Excel
March 30, 2020 - A z-score of 0 corresponds to a percentile of exactly 0.50. Thus, any z-score greater than 0 corresponds to a percentile greater than 0.50 and any z-score less than 0 corresponds to a percentile less than 0.50.
The Bricks
thebricks.com › resources › guide-how-to-get-probability-from-z-score-in-excel
How to Get Probability from Z Score in Excel
February 20, 2025 - This area corresponds to the probability that a randomly chosen value from the population will be less than the value associated with that Z-score. For example, if we're analyzing exam scores and a score of 85 has a Z-score of 1.2, finding the probability will tell us the percentage of students who scored less than 85. Excel's hero for this task is the NORM.S.DIST function.
Microsoft Support
support.microsoft.com › en-us › office › norm-s-dist-function-1e787282-3832-4520-a9ae-bd2a8d99ba88
NORM.S.DIST function - Microsoft Support
If z is nonnumeric, NORM.S.DIST returns the #VALUE! error. The standard normal density function is determined with this equation: Copy the following entire table. Paste it into cell A1 (and adjacent cells) in a new Excel worksheet. If you do not automatically see results, select the formula, press F2 and press Enter. Adjust column widths if needed to see everything.
Microsoft Support
support.microsoft.com › en-us › office › z-test-function-d633d5a3-2031-4614-a016-92180ad82bee
Z.TEST function - Microsoft Support
From the symmetry of the Normal distribution, if AVERAGE(array) < x, Z.TEST will return a value greater than 0.5. The following Excel formula can be used to calculate the two-tailed probability that the sample mean would be further from x (in either direction) than AVERAGE(array), when the underlying population mean is x:
Reddit
reddit.com › r/cfa › common probability distribution question, how to solve without excel? z table or t table?
r/CFA on Reddit: Common Probability Distribution Question, how to solve without excel? Z table or T table?
December 15, 2022 - I’m slightly surprised they would ask this. I don’t recall needing to use any statistical distribution tables when I took L1. But I guess they could provide one for you. You’d compute the Z-score as (4-7)/13 = -0.23, and then you’d need to look that up.
Pearson
pearson.com › channels › business-statistics › learn › patrick › 6-normal-distribution-and-continuous-random-variables › finding-probabilities-z-scores-and-x-values-excel
Finding Probabilities from Z-Scores and X Values-Excel
October 9, 2025 - This function applies to the standard normal distribution, which has a mean (μ) of 0 and a standard deviation (σ) of 1. When given a z score, =NORM.S.DIST(z, TRUE) returns the cumulative probability, representing the area under the curve to ...
Coefficient
coefficient.io › home › how to calculate z-scores in excel: tips and tutorial
How to Calculate Z-Scores in Excel: Tips and Tutorial
October 17, 2024 - Open a new Excel worksheet. Enter your raw data in column A, starting from cell A2. Label cell A1 as “Raw Data” to identify the column. To calculate z-scores, you need to know the mean and standard deviation of your dataset.
ExcelDemy
exceldemy.com › home › excel formulas › how to calculate probability from z-score in excel (with quick steps)
How to Calculate Probability from Z-Score in Excel (with Quick Steps) - ExcelDemy
July 5, 2024 - You will get all the values of Z-Scores for the datasheet. Insert a Column between columns D and E. Rename the column as Probability. Select cell E5 and insert the following formula for the cell: ... Press Enter. Double-click on the Fill Handle icon to copy the formula down to cell E14.
YouTube
youtube.com › watch
Calculating a Z-score Probabiliy in Excel - YouTube
How to calculate a z-score probability in Excel
Published August 7, 2017
Wisc
online210.psych.wisc.edu › wp-content › uploads › PSY-210_Unit_Materials › PSY-210_Unit09_Materials › PSY-210_Andrews_HowTo_Z-scores.pdf pdf
How To Calculate z-scores in Microsoft Excel, Google ...
The formula for computing a z-score is =(DataValue-Mean)/StDev.
Reddit
reddit.com › r/askstatistics › excel function for finding the z score
r/AskStatistics on Reddit: Excel function for finding the z score
December 8, 2022 -
Hello,
Can anyone please help me to find the excel function for finding the z value for the area under the curve between the mean and z standard deviations above the mean. See this for reference: https://qph.cf2.quoracdn.net/main-qimg-acde2a1e5b94097e5eefc6466047ec13-pjlq
For example, if the input for the function is 0.4962 (i.e., 99.24% confidence level), the output should be 2.67
Interestingly I could not find any answer on the internet. Maybe I am using the wrong keywords!
Note: NORM.S.INV(probability) is not the function I am looking for (unless I am missing something).
Statistics How To
statisticshowto.com › home › probability and statistics topics index › z-score: definition, formula and calculation
Z-Score: Definition, Formula and Calculation - Statistics How To
June 26, 2025 - Example question: You take the GRE and scored 650 in the verbal section of the test. Calculate a z-score in Excel to determine how good your score is compared to the general population of test takers.
Pressbooks
pressbooks.pub › quantgeog › chapter › 7-2-calculating-the-z-score-with-excel
7.2 Calculating the Z-score with Excel – Quantitative Methods in Geography: A Lab Manual
We’ll need to compute the mean and standard deviation and then will be able to calculate the Z-score. First, in cell G2, type: Mean. In cell G3, type: Standard Deviation. It’s always best practice when working with Excel to label your formulas.
The Bricks
thebricks.com › resources › guide-how-to-get-probability-from-z-score-in-excel-using-chatgpt
How to Get Probability from Z Score in Excel using ChatGPT
The CDF gives you the probability that a random variable takes on a value less than or equal to a specific number. In simpler terms, if you have a Z score, the CDF allows you to calculate the probability of observing a value less than that score in a standard normal distribution. Excel can calculate this probability for you, which is where things get exciting.
Home and Learn
homeandlearn.co.uk › excel2007 › z-scores.html
z-scores, percentiles and Excel
Learn statistics with Excel. In this lesson, you'll get some hands-on experience calculating z-scores. You'll also convert those z-scores to percentiles.
Chegg
chegg.com › math › statistics and probability › statistics and probability questions and answers › finding a z value for a given probability use excel's function options to find the following z values for the standard normal variable z. complete the following problems. p(z = z) = 0.1020 -1.2702 determine the z score that will produce the probability in the statement. plz szso) = 0.1772 determine the z score that will produce the probability in the
Solved Finding a z Value for a Given Probability Use Excel's | Chegg.com
September 9, 2020 - To determine the z-score for which , use the NORM.S.INV function in Excel, specifying 0.1020 as the probability.
Quora
quora.com › How-do-I-calculate-the-Z-score-in-Excel
How to calculate the Z score in Excel - Quora
For Example, you have data in your column A, then in column B, you can calculate z-score against each value with formula as follows: =(A1-AVERAGE($A$1:$A$10))/STDEV.P($A$1:$A$10) Note that STDEV.P returns standard deviation of population.