Answered step by step
Verified Expert Solution
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
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 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 hoursStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started