Question
1. [Excel Question] The number of days building a new detached home follow a normal distribution with mean of 300 days and standard deviation of
1. [Excel Question] The number of days building a new detached home follow a normal distribution with mean of 300 days and standard deviation of 25 days. If it exceeds 350 days, a late completion penalty will occur. Answer the following questions using Excel.
(a) What percent of new detached homes is built in less than 290 days? Hint: use the Excel function NORM.DIST(x, mean, std dev, true)
(b) Find Q1 and Q3. Hint: use the Excel function NORM.INV(probability, mean, std dev)
(c) What is the probability incurring a penalty? Hint: Use the complement event and the Excel function NORM.DIST
Step by Step Solution
3.46 Rating (162 Votes )
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get StartedRecommended Textbook for
Quantitative Methods For Business
Authors: Donald Waters
5th Edition
273739476, 978-0273739470
Students also viewed these Mathematics questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App