Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help make a single Excel file with each problem on a separate worksheet tab Problem 4 A variable Z is normally distributed with p

image text in transcribed

Please help make a single Excel file with each problem on a separate worksheet tab

image text in transcribed
Problem 4 A variable Z is normally distributed with p 54 and o 12.3. Find the following probabilities: a. P(40 54) d. P(Z 57.3) Problem 5 Using Excel's standard functions: a. Calculate the mean, variance and standard deviation of the students' grades presented below. b. Use the descriptive statistics tool and calculate various statistical measures. 90 93 63 55 93 85 79 95 83 61 82 95 66 51 99 50 95 63 69 90 59 57 63 77 75 54 69 67 79 52 Problem 6 The life of an electronic transistor is normally distributed with a mean of 500 hours and a standard deviation of 80 hours. Determine the probability that a. A transistor will last for more than 400 hours? b. A transistor will last for less than 350 hours? C. A transistor will last exactly 501 hours? Problem 7 The weight of bags of fertilizer is normally distributed with a mean of 50 pounds and standard deviation of 6 pounds. What is the probability that a bag of fertilizer will weigh: a. Between 45 and 55 pounds? b. At least 56 pounds? C. At most 49 pound? Problem 8 The amount of time devoted to studying each week by students who achieve grade A in the course is normally distributed with mean of 7.5 hours and standard deviation of 2.1 hours. Find the probability that an A student study time per week is between 7 and 9 hours? b. less than 5 hours? c. exactly 6 hours

Step by Step Solution

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

Fundamentals Of Number Theory

Authors: William J LeVeque

1st Edition

0486141500, 9780486141503

More Books

Students also viewed these Mathematics questions

Question

Define the following terms: syntax, arguments, and algorithm.

Answered: 1 week ago