Pep Zone sells auto parts and supplies including a popular multi-grade motor oil. When the stock of this oil drops to 40 gallons, a replenishment order is placed. The store manager is concerned that sales are being lost due to stockouts while waiting for a replenishment order. It has been determined that demand during replenishment lead-time is normally distributed with a mean of 25 gallons and a standard deviation of 9 gallons. The manager would like to know the probability of a stockout during replenishment lead-time. In other words, what is the probability that demand during lead-time will exceed 30 gallons? PS: Compute and make a graph in excel also include the Z-table, send the screenshot.

Pep Zone sells auto parts and supplies including a popular multi-grade motor oil. When the stock of this oil drops to 40 gallons, a replenishment order is placed. The store manager is concerned that sales are being lost due to stockouts while waiting for a replenishment order. It has been determined that demand during replenishment lead-time is normally distributed with a mean of 25 gallons and a standard deviation of 9 gallons. The manager would like to know the probability of a stockout during replenishment lead-time. In other words, what is the probability that demand during lead-time will exceed 30 gallons? PS: Compute and make a graph in excel also include the Z-table, send the screenshot.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter10: Statistics

Section: Chapter Questions

Problem 25SGR

See similar textbooks

Related questions

Q: 3. An integer n : 1<n< 1000 is chosen. Compute the probability that the integer is... a) divisible…

A: Note: Hi, thank you for the question. As per our company guideline we are supposed to answer first…

Q: (b) Alice and Bob are playing a game of chance consisting of repeated rounds in which each has an…

Q: A cab drives 5 passengers to their destinations. There are 6 potential cab stops during the route.…

Q: (a) Var(X + Y ) = Var(X)+ Var(Y) (b) Ε(XY) - (EX) (EYΥ) (c) E(X + Y ) = EX+ EY

A: Since we answer up to three subparts of a problem, we'll be answering the first three sub parts…

Q: The following observations are on stopping distance (ft) of a particular truck at 20 mph under…

Q: The life (in years) of a voltage regulator of a car has an exponentia with a mean life of 7 years.…

A: It is given that the life of a voltage regulator of a car has an exponential distribution with a…

Q: If 4-digit numbers greater than 5,000 are randomly formed from the digits 0, 1, 3, 5, and 7, what is…

A: Introduction we have to find the probability of coming a number divisible by 5 when (i) the digits…

Q: Find the number of ways that 6 teachers can be assigned to 4 sections of an introductory…

Q: Fifteen percent of new residential central air conditioning units installed by a supplier need…

Q: Two dice are thrown. What are the odds in favour of rolling a sum of 4 or less

A: Two dice are thrown. What are the odds in favour of rolling a sum of 4 or less

Q: 5. Two processes A and B, were used to produce stainless steel shafts in an industrial company.…

A: Given that, Process A and Process B produce 9% and 12% nonconforming stainless steel shafts,…

Q: ous Tan dom valnable A Lion TunC 0, for x < -2, 3 1 + 4x - 32 2 for – 2 <x < 2, 3 F(x) 1, for x 2 2.…

A: Solution

Q: Let X denote the amount of time a book on two-hour reserve is actually checked out, and suppose the…

A: Let X denote the amount of time a book on two-hour reserve is actually checked out

Q: Q3) Eighty-four student (67 from moming and 17 from evening) in second stage of electronic branch…

Q: pose that X and Y are random variables with the joint density function cx2 0 2).

A: Solution

Q: Use the binomial theorem to show that for all integers n 2 1, 3" = (6) + 2 (4) + 2° (") -

Q: MUSIC FOR PLANTS To Stimulate Plant Growth 2. Use the photo on the right as your reference. a.…

Q: You simulate the following 35 random values from a distribution: 7 11 14 15 17 18 19 25 29 30 34 38…

A: For the given sample values,

Q: Consider the following subsets in the universal set U = {natural numbers from 1 to 10} X= {factors…

A: Solution-: Given: U={Natural numbers from 1 to 10} X={Factors of 16}, Y={Factors of 8}…

Q: 6) A set of data has a normal distribution with a mean of 50 and a standard deviation of 10. Find…

A: Given that mean =50 ,s.d =10

Q: a) A continuous random variable Y has density function 3-2y f(y)={3 e „y > 0 ,elsewhere Find the…

Q: Suppose that a die is rolled twice. Let X be the minimum value to appear in the two rolls. Construct…

A: " Since you have posted a question with multiple sub-parts, we will solve the first three subparts…

Q: You spin the spinner. a. In how many ways can spinning an even number occur? Spinning an even number…

Q: 2. From the given table NUMBER 1, set the probabilities defines the conditional probability…

A: set the probabilities defines the conditional probability distribution of y given that x=3

Q: The joint PDF of two continuous random variables X and y is given: S(x, v) = e,x> 0, y> 0. Let U =…

Q: In a test that measures the creativity variable in the general population of adolescents, the scores…

A: From the provided information, Population mean (µ) = 11.5 Sample size (n) = 25

Q: Based on record, the mean weight of the newborn babies is 4.8lbs with a standard deviation of…

Q: If the probability of a person winning on a scratch-off lottery ticket is 0.375, the odds of losing…

A: From the provided information, The probability of a person winning on a scratch-off lottery ticket…

Q: You flip a coin 25 times. Let X; be the Bernoulli random variable indicating if the i-th coin flip…

Q: a. What is the probability that a bulb is defective? b. Hence, what is the probability that two or…

A: here given , 1. Twelve electric bulbs are drawn independently every hour from a production line at a…

Q: high school class consists of 6 seniors, 10 juniors, 13 sophomores, and 3 freshmen. Exactly 4 of…

A: Solution

Q: 7. Hitomi and Linda are two girls that are organising a team to enter the Victorian Quoits…

A: Please find the explanation below. Thank you

Q: -1 1/6 1/6

Q: (a) Suppose that 20 % persons in a large group of people are obese. If persons are checked one by…

A: If we have a sequence of trials each having two outcomes, say Success and Failure, trials being…

Q: For a binomial experiment with n trials, let p = probability of success, q = probability of failure,…

A: Solution

Q: A test program for grade 10 can generate quadratic functions in a standard form y ax+ bx + c where…

Q: A researcher wishes to estimate the proportion of X-ray machines that malfunction. A random sample…

Q: samples there are at least three samples contain the pollutant. Solve both in detailed and…

A: here given , a sample of liquid has 12 % chance of containing a particular organic pollutant p =…

Q: 17. A number card is drawn from a deck consist of 1, 2, 5, 8, 12, 15, 16, 20, and 25. Find the…

A: a number card is drawn from a deck consist of 1,2,5,8,12,15,16,20 and 25.

Q: The following information was recorded in a toy store: Year 2016 Year 2017 Year 2018 Price Quantity…

A: Note: As per the guidelines we are supposed to solve only first three subparts. Please repost the…

Q: How many ways are there to assign 100 different diplomats to five different conti- nents if 10…

Q: (a) Suppose that 20 % persons in a large group of people are obese. If persons are checked one by…

Q: Suppose 190 geology students measure the mass of an ore sample. Due to human error and limitations…

Q: If S = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9} and A = {0, 2, 4, 6, 8}, B = {1, 3, 5, 7, 9}, C = {2, 3, 4,…

Q: If the odds of winning on a scratch-off lottery ticket are 17:2,834, what is the probability of…

A: From the provided information, The odds of winning on a scratch-off lottery ticket are 17:2834

Q: For a normal variable X~ N(u = 76, o = 5.5), find the probability P(X < 82.05) : P(X < 82.05) :…

Q: ) Let {X(t)} be a BM with parameter σ = 2 and X(0) = 0. Find P(T−1 < T2 < T−2).

A: Given that - Let {X(t)} be a BM with parameter σ = 2 and X(0) = 0.

Q: A bag has 15 red, 15 blue, and 15 yellow marbles in it, what is the probability of drawing 2 red…

Q: (a) Suppose that 20 % persons in a large group of people are obese. If persons are checked one by…

Q: using the regression equation. What is wrong with this predicted temperature? in 1 min ature (°F)…

A: Given the numbers of cricket chirps in 1 minute and the corresponding temperatures in °F.

Question

hello tutor, i hope you could help me, i have here a probability problem involving Standard normal probability distribution and it is required to be in excel. So i hope you will help me. thanksss

Pep Zone sells auto parts and supplies including a popular multi-grade motor oil.
When the stock of this oil drops to 40 gallons, a replenishment order is placed.
The store manager is concerned that sales are being lost due to stockouts while
waiting for a replenishment order. It has been determined that demand during
replenishment lead-time is normally distributed with a mean of 25 gallons and a
standard deviation of 9 gallons. The manager would like to know the probability
of a stockout during replenishment lead-time. In other words, what is the
probability that demand during lead-time will exceed 30 gallons?
PS: Compute and make a graph in excel also include the Z-table, send the
screenshot.

Features Features Normal distribution is characterized by two parameters, mean (µ) and standard deviation (σ). When graphed, the mean represents the center of the bell curve and the graph is perfectly symmetric about the center. The mean, median, and mode are all equal for a normal distribution. The standard deviation measures the data's spread from the center. The higher the standard deviation, the more the data is spread out and the flatter the bell curve looks. Variance is another commonly used measure of the spread of the distribution and is equal to the square of the standard deviation.

Expert Solution