Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need help on these and how to do them in excel can you show the function too please The probability of success for an experiment
need help on these and how to do them in excel can you show the function too please
The probability of success for an experiment is 39.74%. If the trial size is 45, answer the following questions. Use BINOM.DIST to calculate probabilities.. What is the expected number of success? 17.883 What is the expected number of failures? 27.117 What is the probability of 20 successes? 0.09690072 What is the probability of more than 22 successes? 0.080886685 What is the probability of more than 15 but less than 25 successes? T.INV gives the t-score given area in one tail. Answer the following t-distlibution questions using these functions for a sample size of n = 38. After solving 7a, compare your result with the T-table we use. If they match, then you are on the right track. Remember - Excel gives areas from Negative Infinity. What is the t-score if the right tail area is .05? 1.68709362 What is the t-score if the left tail area is .086? 4392778305 What is the absolute value of t-score if the area around the mean is .78? If the mean score on Test 3 is 82 and standard deviation is 7.5, what will be the cut-off score for an A if the top 12% students get an A? If the mean score on Test 3 is 82 and standard deviation is 7.5, what will be the cut-off score for an F if the bottom 7% students get an F? Pioneer Bank's customers require an average of 4.7 minutes of service. Use EXPON.DI5T function to answer the follwing questions. What is the probability a customer will take more than 5.9 minutes? What is the probability a customer will take less than 3.2 minutes? What is the probability a customer will take between 3.4 and 6.9 minutesStep 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