Question

How do I find the z-score that corresponds to a cumulative probability of​ 0.975 using excel?

Expert Answer

1 Rating

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Math
Statistics

Related Statistics Q&A

Find answers to questions asked by students like you.

Q: Please show TI 84 steps. We don't use standardized table for z score

A: Introduction:According to the Central Limit Theorem, if the sampling distribution of the sample prop...

Q: Ackerman and Goldsmith (2011) found that students who studied text from printed hardcopy had better ...

A: The hypotheses to be tested are:H0: μ = 81.7, that is, the average score of entire class is 81.7;Ver...

Q: Calculate the variance and standard deviation  449,489,548,579,337,424,567,472,392,291,527,449,460,6...

A: Given,449,489,548,579,337,424,567,472,392,291,527,449,460,622Standard deviation is a measure of disp...

Q: Use the standard normal table to find the​ z-score that corresponds to the cumulative area 0.0877. I...

A: The concept of standard normal distribution is used to calculate the probability of a normally distr...

Q: 4. Suppose a new sample is chosen and you got the following estimated OLS line: predicted birthweigh...

A: Introduction:Effect of scale change of the predictor, on the regression coefficients:Suppose x denot...

Q: In a random sample of 200 people, 74% of them said that they do go to Truecar.com before they go sho...

A: It is given that 74% out of 200 people said that they do go to Truecar.com before they go shopping f...

Q: the distribution of certain test scores  is a nonstandard normal distribution with a mean of 80 and ...

A: Given:Population mean (μ) = 80Population standard deviation (σ) = 3

Q: For this problem, carry at least four digits after the decimal in your calculations. Answers may var...

A: (a) Computation of point estimate for p:Let p be the proportion of all permanent dwellings on the en...

Q: A relay microchip in a telecommunications satellite has a life expectancy that follows a normal dist...

A: A)The number of months should the satellite be insures for to be 95% secure that it will last beyond...

Q: In comparing two multiple regression models, one with variables that are a subset of the other, bigg...

A: R-squared:The coefficient of determination (R2) is defined as the proportion of variation in the obs...

Q: in a quiz competition, there are 5 competitors, each of whom makes a random choice out of 10 prizes,...

A: From the given information, there are 10 prizes. In 10 prizes, the number of wrist watches are 3 and...

Q: A manufacturer knows that their items have a normally distributed lifespan, with a mean of 14.4 year...

A: Given information:Mean, µ=14.4Standard deviation, σ=3.8Sample size, n=23

Q: How hot is the air in the top (crown) of a hot air balloon? Information from Ballooning: The Complet...

A: Sample mean = 97 oC.Standard deviation, sigma is 17 oC.The sample size, n is 58.

Q: A standard six-sided die shows a number, 1, 2, 3, 4, 5, or 6, on each of its sides. You roll the die...

A: The sample space for the given experiment is S={1,2,3,4,5,6}Define the given events as,E={2,4,6} the...

Q: 3. (a) Based on the random sample Y1 = 5.2, Y2 4.6, use the method of maximum likelihood to estimate...

A: Note:The pdf in Part (b) will be fY (y; θ1, θ2) = 1/(θ2 – θ1) if θ1 ≤ y ≤ θ2­. We have solved using ...

Q: Sociologist say that 90% of married woman have issues with their husband's mother and it is the bigg...

A: Preliminary calculations:The given scenario follows binomial distribution.The probability of success...

Q: A classic counting problem is to determine the number of different ways that the letters of "differe...

A: According to the principle, if there are n objects with r1 objects of one kind, r2 objects of anothe...

Q: Two fair dice are rolled, one blue, (abbreviated B) and one red, (abbreviated R). Each die has one o...

A: Note:Hey there! Thank you for the question. The Venn d=Diagram that you have posted is in image form...

Q: Please show TI 84 steps

A: According to the provided data, the sample size, n is 1100 with the probability of success, p is 0.8...

Q: please solve the bullet points question. please show me details for the answers and what are the for...

A: Note:Hey there! Thank you for the question. In the last line of Part (iii), nothing is displayed aft...

Q: Computers are commonly used to randomly generate digits of telephone numbers to be called when condu...

A: A nonstandard normal distribution cannot be used because the randomly generated digits themselves do...

Q: -One Sample Dichotomous Outcome- Suppose a similar study was conducted two years ago and found that ...

A: Giventhe prevalance of smoking among freshman = 27% = 0.27We assume to use 95% confidence interval t...

Q: A group conducted a survey of 13,000 brides and grooms married in the United States and found that t...

A: The minimum cost (in dollars) for a wedding to be included among the most expensive 5% of weddings i...

Q: What is a P value?

A: The p-value is also called as probability value.

Q: You wish to play a three-number lottery with your favorite data 8, 2 and 5.  After a number is drawn...

A: Given dataThere are 3 numbersRepetition is allowedWe are drawing a single number with replacement, s...

Q: Searc k for Chapter 9-3352. (1) Protected View - Saved Help View Review Mailings rences t can contai...

A: Given Data

Q: A personnel office is gathering data regarding working conditions. Employees are given a list of fiv...

A: Given situation:Data of working conditions. This list of five conditions given to employee which mig...

Q: (d) Would it be unusual for a car to spend more than 3 minutes in Wendy's drive-through? Why?

A: Consider,X be a random variable that represents the drive-through which is normally distributed with...

Q: Assume that adults have IQ scores that are normally distributed with a mean of μ=105 and a standard ...

A: It is given that IQ score of adults is normally distributed with mean 105 and standard deviation is ...

Q: Assume the random variable X has a binomial distribution with the given probability of obtaining a s...

A: Given datan = 6p= 0.5Required probability is given by

Q: Assume that a procedure yields a binomial distribution with a trial repeated n=13n=13 times. Use eit...

A: Giventotal number of trails = n = 13probability of success = p = 0.46To find the probability of 1 su...

Q: The systolic blood pressure of adults in the USA is nearly normally distributed with a mean of 120 a...

A: Hello there! there are more than three subparts in the question. According to our policies we cannot...

Q: Only question c I cannot figure it out

A: c). From the provided information, Guitar sales is the response variable (y) and YouTube Views is th...

Q: Explain the difference between a stratified sample and a cluster sample. (Select all that apply.) In...

A: Cluster sampling is a sampling method in which the researcher divides the population into clusters, ...

Q: For a normal population with a mean of m=80 and a standard deviation of 10, what is the probability ...

A: It is given that the mean and standard deviation are 80 and 10, respectively.

Q: I don't understand how to solve this

A: It is given that the proportion of all female heart transplant patients will survive for at least 3 ...

Q: According to the Center for Disease Control and Prevention (CDC), the mean life expectancy in 2015 f...

A: It is given that the mean is 71.8, the population standard deviation is 15, sample size is 100 and t...

Q: Please show TI 84 steps

A: The given data show that the surface roughness of coated interior pipes.

Q: A Poisson process has intensity of 4 events per hour. If 6 events occur in the Örst 3 hours, what is...

A: It is given that a Poisson process has an intensity of 4 events per hour.Consider that X1, X2, X3 ar...

Q: a committe of 4 is to be selected from 6 men and 5 women. 1 particular man and 1 particular woman re...

A: From the given information, there are 6 men and 5 women. That is, the total number of persons is 11(...

Q: Toby's Trucking Company determined that on an annual basis, the distance traveled per truck is norma...

A: It is given that the mean and standard deviation are 50,000 and 12,000.

Q: 72% of owned dogs in the United States are spayed or neutered. Round your answers to four decimal pl...

A: Hello! As you have posted 4 sub parts, we are answering the first 3 sub-parts.  In case you require ...

Q: Please show TI 84 steps

A: It is given that mean is 10, level of significance is 0.05 and the sample size is 14.From the altern...

Q: dult men’s weight are normally distributed with μ = 172 lb and σ = 29 lb. (a) If one male is randoml...

A: Part a)Given Mu = 172 and sigma = 29 

Q: Personnel tests are designed to test a job​ applicant's cognitive​ and/or physical abilities. A part...

A: It is given that the mean and standard deviation are 74 and 7.4, respectively.

Q: Use the sample data and confidence level given below to complete parts​ (a) through​ (d).   A drug i...

A: GivenThe total number of patients treated with drug = 4122number of patients developed adverse react...

Q: make up 2 data sets, each with 5 values, that have the same mean and median, but different standard ...

A: Let the two datasets be x and y

Q: The standard deviation of a normal distribution is 20. What is the standard error of the mean obtain...

A:  from the given information,standard deviation(σ) =20.Sample size(n) = 225.

Q: Part 1  A population of values has a normal distribution with μ=135.9 and σ=18.1. You intend to draw...

A: Note:Hey there! Thank you for the question. As have posted two different questions together- finding...

Q: The weight of a type of dog follows Normal distribution with mean of 10 pounds and standard deviatio...

A: Given Information: