Question

In: Statistics and Probability

If a fair coin is tossed 25 times, the probability distribution for the number of heads,...

If a fair coin is tossed 25 times, the probability distribution for the number of heads, X, is given below. Find the mean and the standard deviation of the probability distribution using Excel

  • Enter the mean and round the standard deviation to two decimal places.

x   P(x)
0   0
1   0
2   0
3   0.0001
4   0.0004
5   0.0016
6   0.0053
7   0.0143
8   0.0322
9   0.0609
10   0.0974
11   0.1328
12   0.155
13   0.155
14   0.1328
15   0.0974
16   0.0609
17   0.0322
18   0.0143
19   0.0053
20   0.0016
21   0.0004
22   0.0001
23   0
24   0
25   0

Solutions

Expert Solution

Given that a fair coin is tossed 25 times, the probability distribution for the number of heads X is given.

Here we need to find the mean and the standard deviation using Excel.

Now before we go on to solve the problem using Excel let us know a bit about mean and standard deviation of a discrete probability distribution.

If p(x) be the probability distribution of a random variable X.

Mean

where x are the values taken by the random variable X and 'E' is expectation.

Variance

Now,

and,

Standard Deviation

Coming back to our problem,

First of all enter the data in the Excel datasheet,

Under column C in cell C1 name it "x.P(x)" and in cell C2 write "=A2*B2"

Then press Enter.

Now to calculate all the other values in the Column C we use a very useful feature called the "Auto Complete" feature of Excel. To do that select the cell C2 and bring the mouse pointer to the bottom right corner of the cell the mouse pointer changes to a "+" sign now click and drag the your mouse to cell C27 you will see all the other values calculated automatically.

Now under column D in cell D1 name it "x2.P(x)" and in cell D2 write "=(A2^2)*B2"

Then press Enter.

Similarly like in column C use the auto complete feature in column D.

Now write "Total" in cell A28. In row 28 we are going to calculate the sum of the columns C and D. To do that write in cell C28 "=SUM(C2:C27)"

Then press Enter.

Now we calculate the sum of column D. To do that we again use the auto complete feature. Select cell C28 and bring the mouse pointer to the bottom right corner of the cell the mouse pointer changes to a "+" sign now click and drag the your mouse horizantally towards column D. You will see sum of the column D calculated.

Therefore from the table its clear that,

Now its time for us to calculate variance and standard deviation.

Now in anywhere in the worksheet write mean, variance, standard deviation.

as we know that Mean=E(X)=12.5. We write 12.5 in cell G5.

Now we know that,

Now we know that cell D28 is E(X2)=162.5076. Therefore in cell G6 we write "=D28-(G5^2)"

Then press Enter.

Now we know that,

To do that we write in cell G7 "=SQRT(G6)"

Then press Enter.

Hence,

To Round of to two decimal places in Excel the standard deviation we write in cell G7 "=ROUND(SQRT(G6),2)"

Then press Enter.


Related Solutions

A fair coin is tossed r times. Let Y be the number of heads in these...
A fair coin is tossed r times. Let Y be the number of heads in these r tosses. Assuming Y=y, we generate a Poisson random variable X with mean y. Find the variance of X. (Answer should be based on r).
A coin is tossed 400 times, landing heads up 219 times. Is the coin fair?
A coin is tossed 400 times, landing heads up 219 times. Is the coin fair?
A fair coin is tossed four times. Let X denote the number of heads occurring and...
A fair coin is tossed four times. Let X denote the number of heads occurring and let Y denote the longest string of heads occurring. (i) determine the joint distribution of X and Y (ii) Find Cov(X,Y) and ρ(X,Y).
Q7 A fair coin is tossed three times independently: let X denote the number of heads...
Q7 A fair coin is tossed three times independently: let X denote the number of heads on the first toss (i.e., X = 1 if the first toss is a head; otherwise X = 0) and Y denote the total number of heads. Hint: first figure out the possible values of X and Y , then complete the table cell by cell. Marginalize the joint probability mass function of X and Y in the previous qusetion to get marginal PMF’s.
a) A coin is tossed 4 times. Let X be the number of Heads on the...
a) A coin is tossed 4 times. Let X be the number of Heads on the first 3 tosses and Y be the number of Heads on the last three tossed. Find the joint probabilities pij = P(X = i, Y = j) for all relevant i and j. Find the marginal probabilities pi+ and p+j for all relevant i and j. b) Find the value of A that would make the function Af(x, y) a PDF. Where f(x, y)...
A coin that lands on heads with a probability of p is tossed multiple times. Each...
A coin that lands on heads with a probability of p is tossed multiple times. Each toss is independent. X is the number of heads in the first m tosses and Y is the number of heads in the first n tosses. m and n are fixed integers where 0 < m < n. Find the joint distribution of X and Y.
A coin is tossed 6 times. Let X be the number of Heads in the resulting...
A coin is tossed 6 times. Let X be the number of Heads in the resulting combination. Calculate the second moment of X. (A).Calculate the second moment of X (B). Find Var(X)
A coin is tossed three times. X is the random variable for the number of heads...
A coin is tossed three times. X is the random variable for the number of heads occurring. a) Construct the probability distribution for the random variable X, the number of head occurring. b) Find P(x2). c) Find P(x1). d) Find the mean and the standard deviation of the probability distribution for the random variable X, the number of heads occurring.
Suppose a coin is tossed 100 times and the number of heads are recorded. We want...
Suppose a coin is tossed 100 times and the number of heads are recorded. We want to test whether the coin is fair. Again, a coin is called fair if there is a fifty-fifty chance that the outcome is a head or a tail. We reject the null hypothesis if the number of heads is larger than 55 or smaller than 45. Write your H_0 and H_A in terms of the probability of heads, say p. Find the Type I...
A fair coin is tossed 100 times. What is the probability of observing at least 55...
A fair coin is tossed 100 times. What is the probability of observing at least 55 heads P(x≥55)? (Approximate the binomial distribution with a normal distribution
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT