Question

In: Statistics and Probability

you will be assessed on the use of BINOM.DIST function, and creating formula to calculate the...

you will be assessed on the use of BINOM.DIST function, and creating formula to calculate the expected value of a binomial distribution. You will also be asked to interpret a probability value.

Multiple Choice Test

Chris is sitting a multiple choice test in statistics. The test consists of 9 items and each item has 5 options. After the test, Chris told you he didn’t study for the test at all and guessed all answers.

a)

If Chris guessed each and every item in the test, describe the probability distribution for the number of correct guesses. Present the probability distribution in the form of a table using 6 decimal points in your answers. (Use BINOM.DIST function to calculate the probabilities.)

Solutions

Expert Solution

Solution

Let X = Number of correct guesses. Then, X ~ B(n, p), where

n = number of items in the test = 9 (given)

p = probability of one correct guess = 1/5 [Because, guessing with 5 options could be any one of the options, but only one option is correct and hence the probability is 1/5.]

Back-up Theory

If X ~ B(n, p). i.e., X has Binomial Distribution with parameters n and p, where n = number of trials and p = probability of one success, then

probability mass function (pmf) of X is given by

p(x) = P(X = x) = (nCx)(px)(1 - p)n – x, x = 0, 1, 2, ……. , n …………………..…………..(1)

[The above probability can also be directly obtained using Excel Function of Binomial Distribution: BINOMDIST(Number_s:Trials:Probability_s:Cumulative), what is within brackets is (x:n:p:False/True)] …………………………………………………………….(1a)

Now, to work out the solution,

Since there are 9 items in the test, X can take any value from 0 to 9, both inclusive.

The probabilities are given below:

x

p(x)

by (1)

by (1a)

0

9C0(0.2)0(0.8)9

0.134218

1

9C1(0.2)1(0.8)8

0.30199

2

9C2(0.2)2(0.8)7

0.30199

3

9C3(0.2)3(0.8)6

0.176161

4

9C4(0.2)4(0.8)5

0.06606

5

9C5(0.2)5(0.8)4

0.016515

6

9C6(0.2)6(0.8)3

0.002753

7

9C7(0.2)7(0.8)2

0.000295

8

9C8(0.2)8(0.8)1

1.84E-05

9

9C9(0.2)9(0.8)0

5.12E-07

Total

1

DONE


Related Solutions

Module and Import For these 3 problems, -You are writing a function to calculate a formula...
Module and Import For these 3 problems, -You are writing a function to calculate a formula in the module. -You are going to import the modules to the main. -Write 3 more functions in the main -Don't do any formula calculation in the main just use module functions and return your result. -Call each main function twice to test the provided values. 1. Meter to Feet and Inches One meter equals 39.37 inches and 1 foot equals 12 inches. Write...
How do you calculate Payback Period on Excel by using FAME function? What is the formula?
How do you calculate Payback Period on Excel by using FAME function? What is the formula?
Assume that the reserve ratio in a country is 2%. Use a formula to calculate the...
Assume that the reserve ratio in a country is 2%. Use a formula to calculate the simple money multiplier, show all steps involved in the calculation. Suppose that in 2019 customers deposit $200 into their banks. Based on the simple money multiplier calculated in part (i), calculate the total amount which the money supply in the banking system will eventually increase to. Show all steps involved in the calculation.    Assume the amount of funds deposited by customers in 2020...
Use the classical model to derive a formula for the electron’s kenetic energy as a function...
Use the classical model to derive a formula for the electron’s kenetic energy as a function of its orbital distance, assuming the electron is in a circular orbit. In other words, derive a formula that you could use to calculate the kinetic energy of the electron if you knew its orbital distance. What would be the formula for the electron's kinetic energy K in terms of the orbital distance d.
1. (a) Use Rydberg formula to calculate the wavelengths of the four visible lines in the...
1. (a) Use Rydberg formula to calculate the wavelengths of the four visible lines in the Balmer series of light emitted by a hydrogen gas-discharge lamp. A diffraction grating of width 1 cm has 2500 slits. It is used to measure the wavelengths of the visible spectrum of hydrogen. (b) Determine the first-order diffraction angles of the four observed lines. (c) What is the angular width of each one of them?
On this problem, you may use a computer to calculate the derivative. Consider the function f(t)...
On this problem, you may use a computer to calculate the derivative. Consider the function f(t) = (2t^2) / (3t^2 + 1) : (a) On what intervals is the function concave up, and on what invervals is it concave down? Why? (b) (5 points) On what intervals is the function increasing, and on what intervals is it decreasing? Why? (b) On what intervals is the function increasing, and on what intervals is it decreasing? Why?
Use symmetry and the region area formula under the parametric curve to calculate the area of...
Use symmetry and the region area formula under the parametric curve to calculate the area of the region enclosed by the astroid. x= a cos^3(t) y= a sin^3(t) 0 < t < 2pi a= 3
In part 2 you will be creating multiple functions to calculate the present value. You may...
In part 2 you will be creating multiple functions to calculate the present value. You may be asking what a "present value" is. Suppose you want to deposit a certain amount of money into a savings account and then leave it alone to draw interest for some amount of time, say 12 years. At the end of the 12 years you want to have $15,000 in the account. The present value is the amount of money you would have to...
can u give a formula that can be use using financial performance to calculate efficiency of...
can u give a formula that can be use using financial performance to calculate efficiency of cost of capital, capital structure, capital budgeting and mergers and acquisitions
Use the Semi Empirical Mass Formula to calculate the kinetic energy of an alpha particle (42He)...
Use the Semi Empirical Mass Formula to calculate the kinetic energy of an alpha particle (42He) emitted in the process 235U → 231Th + α.The bond energy of the α-particle is 28.3 MeV.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT