Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

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

How to find the z score in excel

11/11/2021 Client: muhammad11 Deadline: 2 Day

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%.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

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!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Phd Writer
Top Grade Tutor
Engineering Guru
A+GRADE HELPER
Financial Solutions Provider
Coursework Helper
Writer Writer Name Offer Chat
Phd Writer

ONLINE

Phd Writer

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$45 Chat With Writer
Top Grade Tutor

ONLINE

Top Grade Tutor

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$19 Chat With Writer
Engineering Guru

ONLINE

Engineering Guru

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$38 Chat With Writer
A+GRADE HELPER

ONLINE

A+GRADE HELPER

This 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.

$43 Chat With Writer
Financial Solutions Provider

ONLINE

Financial Solutions Provider

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$37 Chat With Writer
Coursework Helper

ONLINE

Coursework Helper

This 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.

$33 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

John c maxwell five levels of leadership - 11:59 mountain time - Gai waterhouse tip sheet - The little seagull handbook inquizitive - Roland characteristics in the song of roland - Stakeholders - Research paper on community policing - A _____ person achieves a balance between risk and payoff. - Research paper - Describe the departmentalization approach to organizational structure - Park management and conservation - General hydroponics ph up ingredients - Managerial economics - Language processing test 3 - In the normal model n 100 - West midlands south deanery - Islamic proverbs in english - Backtrack 5 tutorial for beginners - Bobsville - I have small assignment - Paypal in 2015 reshaping the financial services landscape - Example of a very poorly implemented database - Domestic building contracts act 1995 pdf - Write a few sentences explaining what you think makes someone a hero. - At december 31 folgeys coffee company reports - Deflection gauge dial indicator - Proton saga 2011 market value - How to open docx file in oneplus 6 - Rhetorical analysis on cdc adhd - Six different images of managing change - Dehydration of 2 methylcyclohexanol major product - Ken is 63 years old and unmarried - Marketing - Discussion 2 - Lambda air fuel ratio chart - Write a 2500 words essay - Firewall change request form template - CHAPTER READING REFLECTIONS JOURNAL CHAPTERS 7-9 - Https xlitemprod pearsoncmg com api v1 print math - Overcoming challenges - Limiting reactant activity with food - Fluorine electron dot diagram - Individual Project unit 4 - Lakes Automotive - What does oracle dba do - What is an emblement in real estate - Litcharts the spy who came in from the cold - Main thesis - How to calculate ksp value - Food culture - Harvard business publishing simulation answers - Ward 1c whiston hospital - In this Professional Reflectionyou will build on what you have learned and experienced to create a set of guiding principles to use as a manager. guiding principles will enable you to employ the appropriate management style for each situation at hand. - Todos los turistas llegan a machu picchu en autobús - Vornado 733 harvey norman - Descriptive Memoir Essay - Secret life of bees chapter 3 questions and answers - Paper - Discussion 175 words minimum - Health education philosophy examples - What are chemical symbols and chemical formulas - Apple case analysis recommendations - Argumentative essay peer review pdf - Mclaren flat primary school - Confessions of a heartbreaker epub - Earned value worksheet - Read the Mission, Vision, and Value Statements . Required: Write two (2) Forum posts - What is a conflicting viewpoint - Happy endings by margaret atwood pdf - 1 Page Book Response to book "Angela's Ashes" - How to add repeating decimals - Questions answers of lines written in early spring - An agronomist examines the cellulose content - APA 7TH EDITION (9) - Ochre restaurant cairns menu - Harley cruise control screw - Revive to survive chirnside park - In the northern hemisphere, the coriolis effect shifts objects ________ their straight-line paths. - Budgeting - Why does the author use only victor’s information in this passage? - How to find kinetic energy with height and mass - Blood donation speech for students - Values of plate element slenderness limits - Examples of specific purpose statements for persuasive speech - Duke cannon illegally cut pine soap - Donate bras uk freepost - Happiness now robert holden pdf - 5 letter words ending in ies - University of leeds redundancy - 18b smarts crescent burraneer - France physical features map - Schools interested in proposing a curriculum consistent with a nation at risk would probably offer - An item found in an old man's wallet family feud - Nrc ballymena farm lodge - An insurance company offers four different deductible levels - Importance of consumer behaviour ppt - Thesis statement ashford university - Sticks and stones and other student essays 9th edition - Devry econ 312 week 3 quiz - EXPLAIN NOLA PENDER'S MODEL AND HOW CAN YOU APPLY IT TO YOUR NURSING PRACTICE. EXPLAIN IN 150 WORDS