Messages
Proposals
Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.
Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support
Excel Worksheet With Correct Calculations Only
Deliverable 02–Worksheet
Instructions:The following worksheet is shown to you by a student who is asking for help. Your job is to help the student walk through the problems by showing the student how to solve each problem in detail. You are expected to explain all of the steps in your own words.
Key:
· - This problem is an incorrect.Your job is to find the errors, correct the errors, and explain what they did wrong.
·
- This problem is partially finished.You must complete the problem by showing all steps while explaining yourself.
· - This problem is blank.You must start from scratch and explain how you will approach the problem, how you solve it, and explain why you took each step.
1)
Assume that a randomly selected subject is given a bone density test. Those tests follow a standard normal distribution. Find the probability that the bone density score for this subject is between -1.93 and 2.37
Student’s answer: We first need to find the probability for each of these z-scores using Excel.
For -1.93 the probability from the left is 0.0268, and for 2.37 the probabilityfrom the left is 0.9911.
Continue the solution:
Finish the problem giving step-by-step instructions and explanations.
We need to subtract the two probabilities to get the required probability.
∴The probability that the bone density score for this subject is between -1.93 and 2.37 is 0.9911 - 0.0268 = 0.9643.
2) The U.S. Airforce requires that pilots have a height between 64 in. and 77 in. If women’s heights are normally distributed with a mean of 63.8 in. and a standard deviation of 2.6 in, find the percentage of women that meet the height requirement.
Answer and Explanation:
Enter your step-by-step answer and explanations here.
Step-1: Calculation of z-scores
Given:
Mean, µ = 63.8
Standard Deviation, σ = 2.6
Formula used for calculating z-scores is given as:
Step-2: Calculation of probabilities
Step-3: Calculation of final probability
The probability that women have a height between 64 in. and 77 in is 0.9680.
∴The percentage of women that meet the height requirement is 96.80%.
3) Women’s pulse rates are normally distributed with a mean of 69.4 beats per minute and a standard deviation of 11.3 beats per minute. What is the z-score for a woman having a pulse rate of 66 beats per minute?
Student’s answer:
Let
Corrections:
Enter your corrections and explanations here.
The z-score for a woman having a pulse rate of 66 beats per minute is -0.30.
4) What is the cumulative area from the left under the curve for a z-score of -1.645? What is the area on the right of that z-score?
Answer and Explanation:
Enter your step-by-step answer and explanations here.
We plug in “=NORMDIST (-1.645, 0, 1, 1)” into Excel and get an area of 0.04998.
∴ the cumulative area from the left under the curve for a z-score of -1.645 is 0.04998 and the cumulative area from the right under the curve for a z-score of -1.645 is 1-0.04998 = 0.95002.
5) If the area under the standard normal distribution curve is 0.8980 from the right, what is the corresponding z-score?
Student’s answer:We plug in “=NORM.INV(0.8980, 0, 1)” into Excel and get an area of 1.27.
Corrections:
Enter your corrections and explanations here.
If the area under the standard normal distribution curve is 0.8980 from the right, then the area under the standard normal distribution curve is 1- 0.8980 = 0.1020 from the left.
We plug in “=NORM.INV (0.1020, 0, 1)” into Excel and get an area of -1.27.
∴ the corresponding z-score is -1.27.
6)
Manhole covers must be a minimum of 22 in. in diameter, but can be as much as 60 in. Men have shoulder widths that are normally distributed with a mean of 18.2 and a standard deviation of 2.09 in. Assume that a manhole cover is constructed with a diameter of 22 in. What percentage of men will fit into a manhole with this diameter?
Student’s answer:We need to find the probability that men will fit into the manhole. The first step is to find the probability that the men’s shoulder is less than 22 inches.
Continue the solution:
Enter your step-by-step answer and explanations here.
We plug in “=NORMDIST(22,18.2,2.09,1)” into Excel and get an area of 0.9655.
∴ The probability that the men’s shoulder is less than 22 inches is 0.9655.
Next step is to calculate the percentage from the proportion. We do this by multiplying the probability with 100%
∴ The percentage of men will fit into a manhole with this diameter is 96.55%.
| Writer | Writer Name | Amount | Client Comments & Rating |
|---|---|---|---|
ONLINE |
Instant Homework Helper |
$36 |
She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up! |
Custom Original Solution And Get A+ Grades
Custom Original Solution And Get A+ Grades
Custom Original Solution And Get A+ Grades
| Writer | Writer Name | Offer | Chat |
|---|---|---|---|
ONLINE |
Online Assignment HelpThis project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices. |
$20 | Chat With Writer |
ONLINE |
Financial Solutions ProviderI will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points. |
$27 | Chat With Writer |
ONLINE |
Assignment GuruI find your project quite stimulating and related to my profession. I can surely contribute you with your project. |
$23 | Chat With Writer |
ONLINE |
Calculation GuruI am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You |
$18 | Chat With Writer |
ONLINE |
Top Class EngineersI find your project quite stimulating and related to my profession. I can surely contribute you with your project. |
$22 | Chat With Writer |
ONLINE |
Quality Homework HelperI am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You |
$33 | Chat With Writer |
Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.