Question

In: Statistics and Probability

Problem 3. Plot the following binomial probability functions as a function of outcome (x) using EXCEL...

Problem 3. Plot the following binomial probability functions as a function of outcome (x) using EXCEL on the same graph, and then comment on the effect of the value of p. a. b(x;10,0.1) b. b(x;10,0.5) c. b(x;10,0.9)

Solutions

Expert Solution

x p = 0.1 p = 0.5 p = 0.9
0 0.348678 0.000977 1E-10
1 0.38742 0.009766 9E-09
2 0.19371 0.043945 3.64E-07
3 0.057396 0.117188 8.75E-06
4 0.01116 0.205078 0.000138
5 0.001488 0.246094 0.001488
6 0.000138 0.205078 0.01116
7 8.75E-06 0.117188 0.057396
8 3.65E-07 0.043945 0.19371
9 9E-09 0.009766 0.38742
10 1E-10 0.000977 0.348678


This table contains the binomial probabilities for different values of "x". The plot of the three probability functions is given below.

We see that for p = 0.1, the distribution is positively skewed. For p = 0.5, the distribution is symmetric. For p = 0.9, the distribution is negatively skewed. This tells us that as p approaches the value of 0.5, the distribution becomes symmetric and as we move away from 0.5, the distribution becomes skewed.


Related Solutions

using excel   Plot the probability mass function (PMF) and the cumulative distribution function (CDF) of 3...
using excel   Plot the probability mass function (PMF) and the cumulative distribution function (CDF) of 3 random variables following (1) binomial distribution [p,n], (2) a geometric distribution [p], and (3) Poisson distribution [?]. You have to consider two sets of parameters per distribution which can be chosen arbitrarily. The following steps can be followed: Setp1: Establish two sets of parameters of the distribution: For Geometric and Poisson distributions take two values of p (p1 and p2) and take two values...
USING EXCEL Now your task is to plot the cumulative probability density function with the information...
USING EXCEL Now your task is to plot the cumulative probability density function with the information given in number 2. First, open Worksheet #3. Then enter “=” in cell A17 of your new worksheet and then click on cell A17 of your second worksheet and hit return. Then copy cell A17 down the A column as before.               Next, you’re to compute the cumulative probabilities for x = 0, 1, 2, …. 20, beginning in cell B17 and ending in...
Using excel with formulars for binomial random variable X with n=10, p=0.3, plot its pdf and...
Using excel with formulars for binomial random variable X with n=10, p=0.3, plot its pdf and cdf; then simulate from it a sample of size N=2000, plot its histogram (relative frequency), and cumulative frequency.
Plot using RStudio Consider a binomial random variable, X. i. Plot the pmf of X ∼Bin(n...
Plot using RStudio Consider a binomial random variable, X. i. Plot the pmf of X ∼Bin(n = 10, p = 0.3). ii. Plot the pmf of X ∼Bin(n = 10, p = 0.7). iii. Plot the pmf of X ∼Bin(n = 100, p = 0.3). iv. What happens to the shape of the pmf of X ∼Bin(n, p) when p gets larger? v. What happens when n gets larger
Calculate the following binomial probability by either using one of the binomial probability tables, software, or...
Calculate the following binomial probability by either using one of the binomial probability tables, software, or a calculator using the formula below. Round your answer to 3 decimal places. P(x | n, p) = n! (n − x)! x! · px · qn − x where q = 1 − p P(x > 15, n = 20, p = 0.8) =
Calculate the following binomial probability by either using one of the binomial probability tables, software, or...
Calculate the following binomial probability by either using one of the binomial probability tables, software, or a calculator using the formula below. Round your answer to 3 decimal places. P(x | n, p) = n! (n − x)! x! · px · qn − x where q = 1 − p P(x = 11, n = 13, p = 0.80) =
Calculate the following binomial probability by either using one of the binomial probability tables, software, or...
Calculate the following binomial probability by either using one of the binomial probability tables, software, or a calculator using the formula below. Round your answer to 3 decimal places. P(x | n, p) = n! (n − x)! x! · px · qn − x    where    q = 1 − p P(x < 19, n = 20, p = 0.9) =
Excel functions to calculating binomial, Poisson, and normal distributions. Identify the functions and discuss how Excel...
Excel functions to calculating binomial, Poisson, and normal distributions. Identify the functions and discuss how Excel can be used to calculate probabilities of X, X. Apply an example to at least one business scenario.
a/Use Excel to find the discrete probability and cumulative probability of the Binomial distribution with probability...
a/Use Excel to find the discrete probability and cumulative probability of the Binomial distribution with probability of success p = 0.75 and n = 80. Find its mean and variance. b/Based upon Excel chart, what can you conclude about the binomial convergence? Hint: Use binom.dist function on Excel and sketch the curve.
Plot the following parabolic functions in Excel and then answer the discussion question below . Use...
Plot the following parabolic functions in Excel and then answer the discussion question below . Use at least 8 points for each plot: Each graph is worth 15 points and must include 8 points. 1) y=x2-6x+8 2) y=x2+4 3) y=(-1/2)(x2) 4) What is the maximum number and the minimum number of x-intercepts for a parabola? Why? (15 points) In order to obtain full credit, you will need to plot the functions in Excel or using the Open Office feature and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT