Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed
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 minutes

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

Recent Developments Of Mathematical Fluid Mechanics

Authors: Herbert Amann, Yoshikazu Giga, Hideo Kozono, Hisashi Okamoto, Masao Yamazaki

1st Edition

3034809395, 9783034809399

More Books

Students also viewed these Mathematics questions

Question

=+c) What might you do instead?

Answered: 1 week ago