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)

Step by Step Solution

★★★★★

3.46 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To solve the problem we will follow the steps below using the normal distribution properties and ass... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

A set of observations follow a Normal distribution with mean 40 and standard deviation 4. What proportions of observations have values? (a) Greater than 46, (b) Less than 34, (c) Between 34 and 46,...

The following data represent the number of days homes were on the market before being sold in New Castle County, Delaware, in 2014: a. Calculate the mean. b. Calculate the median. c. Determine the...

Answer the following questions using data from the Intel Corporation annual report in the appendix: Required: a. Find the discussion of depreciation methods used by Intel on page 695. Explain why the...

Hi, can you please help me? Please don't say "incomplete question, or "missing data". It's not an incomplete question and there is no missing data. Thanks. You run a gizmo factory. The following data...

Scenario You have been hired by your regional real estate company to determine if your region's housing prices and housing square footage are significantly different from those of the national...

i will make sure for good rating The BDI was also modified and shortened for use in a primary care setting (BDI-PC). The specificity of the BDI-PC is 82-95% for detecting major depression in...

1. Suppose the amount of cola dispensed by a filling machine follows a normal distribution with a mean () and a standard deviation (). Select the Calculators option in the Stat menu and then the...

The questions are in the photos below: Question 1 Not yet answered Marked out of 1.00 F Flag question If a sample of size n is drawn from a population with mean u and standard deviation 0, which of...

solve these practice problems Suppose the sediment density (g/cm) of a randomly selected specimen from a certain region is normally distributed with mean 2.65 and standard deviation .85 (suggested in...

Competency In this project, you will demonstrate your mastery of the following competency: Apply statistical techniques to address research problems Perform hypothesis testing to address an authentic...

Western Slope Bank must estimate its liquidity needs over the next 2 months. a. Using the following information given for that period, estimate the bank's liquidity surplus or deficit: Assets ?...

B. Credit Card Volume: The total credit card volume for Visa, MasterCard, American Express, and Discover has increased dramatically in recent years, as shown in the table below. (Source, CardWeb...

Two desks are setup parallel (customer may choose any of these two desks). Each desk takes 26 minutes with each customer. What is the throughput of this parallel system? Provide your answer in...

Entrepreneur and firm founder Oscar Farinetti has said that Eataly's "informal style of communication shows how direct and approachable we are, just the way people like." A focus on customer...

Bank Organizer Printers Inc, produces luxury checkbooks with three checks and stubs per page. Each checkbook is designed for an individual customer and is ordered through the customers bank. The...

PA1 LO 10.1 Artisan Metalworks has a bottleneck in their production that occurs within the engraving department. Jamal Moore, the COO is considering hiring an extra worker, whose salary will be...

Tarick Toys Company manufactures video game consoles and accounts for product costs using process costing. The following information is available regarding its June inventories. The following...

We have described several formats for presenting decisions - problem maps, payoff matrices and decision trees. But these are not the only options. What other formats are available? Find some examples...

The following table shows the number of people employed by Testel Electronics over the past 10 years. How can you present thisdata? Year 1 2 3 4 5 6 7 8 9 10 Employees 24 27 29 34 38 42 46 51 60 67

Current thinking has managers trying to eliminate their stocks. This has been assisted by just-in-time operations, e-business, efficient customer response, point-of-sales equipment, electronic fund...

Give an example of a behavior (other than behaviors in the text) that might be deemed normal in one culture but abnormal in another.

1.12 Describe the sociocultural perspective on abnormal behavior.

1.14 Identify four major objectives of science.