Question: 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

 Please help make a single Excel file with each problem on

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

a separate worksheet tab Problem 4 A variable Z is normally distributed

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

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!