Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Methods For Business

Authors: Donald Waters

5th Edition

273739476, 978-0273739470

More Books

Students also viewed these Mathematics questions

Question

1.12 Describe the sociocultural perspective on abnormal behavior.

Answered: 1 week ago

Question

1.14 Identify four major objectives of science.

Answered: 1 week ago