Question: Seeking step by step and how to use excel for these functions. Question 3: The grade of statistics final exam is normally distributed, suppose the

Seeking step by step and how to use excel for these functions.

Question 3: The grade of statistics final exam is normally distributed, suppose the population mean equals to 73 and standard deviation equals to 18. Use the information to answer question 2 below.

What is the probability that a randomly selected student that has grade less than 60? Please show the steps on how you calculate the Z-score, please show me the Excel formula/syntax , then the probability calculated

2. What is the probability that a randomly selected student that has grade greater than 90? Please show the steps on how you calculate the Z-score, and the Excel formula/syntax , and the probability

3. What is the probability that FOUR randomly selected students (hint: sample mean) that have grades between 70 and 79? Please show the steps on how you calculate the Z-score, the Excel formula/syntax , then the probability.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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!

Show the steps by using Excel Formula. 15. Suppose that the scores on Midterm 2 for Principles of Statistics is normally distributed with population mean of 65 and population standard deviation of...

Question 4: a) For a normal population distribution, a score of -8 is .75 standard deviations above the mean and a score of -5 is 1.4 standard deviations above the mean. What is the mean and standard...

1. The heights of adult men in America are normally distributed, with a mean of 69.4 inches and a standard deviation of 2.62 inches. The heights of adult women in America are also normally...

2 Step-by-Step please This is a past assignment and I will have a 2016 Assignment following soon. Need within 15 days. 1) According to the record of the registrar's office at a state university, 35%...

View Help o edit. it's safer to stay in Protected View. Enable Editing International College APPLIED PROJECT - TERM 2 2024 STUDENT NAME STUDENT ID SIGNATURE UNIT NAME: Statistical Decision Making...

1. A researcher wants to assess the difficulty of test questions in an algebra class at a high school. To test it, he takes one question from each test given at the end of each week in the first...

IQuestion1 7| For a 4units class like Statistics, students should spend average of 12 hours per week studying for the class. A surveyr was done on students, and the distribution of total study hours...

Homework 6 questions: Question 1 1.25 pts A random variable is normally distributed with a mean of p = 39 and a standard deviation of o = 10.8. Calculate the Z-score for a value of 32. For all...

Apply Probability, Sampling Distributions, and Inference 8 NORTHCENTRAL UNIVERSITY Student: RodgersGBTM7104-8 Academic Integrity: As doctoral student in the field of Organizational Leadership with...

Mathematics 1670 Statistics Assignment #2 (Value: 10%) Due: June 9th@12 noon Directions: Answer all questions, show all workings. Submit your completed work via one of the approved methods (pdf...

A steam power plant operates between the pressure limit of 3.0 Mpa for the boiler and 75 kPa for the condenser. If the plant operates in an ideal Rankine cycle with superheated vapor enters the...

As a novice in global marketing, which global market entry strategy, would you be likely to start with? Why? What other alternatives are available for a global market entry?

1 Tamara shows classic withdrawal behavior and is no longer performing her work tasks effectively. Her friends know she has very little organizational commitment. Tamara is likely Multiple Choice to...

Alyeska Services Company, a division of a major oil company, provides various services to the operators of the North Slope oil field in Alaska. Data concerning the most recent year appear below:...