Chapter 11.5, Problem 1E

To determine

To construct: The graph of the full probability distribution for $X$ by using spreadsheet.

Answer to Problem 1E

The required graph of full probability distribution is shown in figure (3).

Explanation of Solution

Given:

The number of times a 3 is rolled from a die 25 times.

Calculation:

First, enter 0 to 3 in the spread sheet of column $A$ as shown below.

  

Figure (1)

Then, write the formula $=\text{COMBIN}\left(25,\text{A}1\right)\ast {\left(0.1666\right)}^{\text{A}1}\ast {\left(0.8334\right)}^{25-\text{A1}}$ in spreadsheet of column $\text{B1}$ , and then enter.

Finally, drag this output up to $\text{B4}$ as shown below.

  

Figure (2)

Now, select $\text{B1:B4}$ and go to insert and then select the clustered column bar graph.

  

Figure (3)

Therefore, the required graph of full probability distribution is shown in figure (3).