TASK 5 See Table 1 (attached). Follow the steps below to enter the given data into a spreadsheet program.

TASK 5

See Table 1 (attached). Follow the steps below to enter the given data into a spreadsheet program.

Step 1 : Enter the number of heads, X, into Column A using a spreadsheet program (i.e., Microsoft Excel). X is the number of heads in 5 tosses of a coin.

Step 2 : Use Column B to list the number of ways that X heads can be achieved. These values are listed in Column B. Enter these values in Column B onto your spreadsheet.

Step 3 : Use Column C to list the probabilities. Enter these values in Column C onto your spreadsheet.

B1 ) Use the spreadsheet created in Task 1 to perform the following:

Consider the data you just entered into the spreadsheet program. Determine what kind of graph would best display the data.
Write an explanation of why you chose a particular type of graph to represent the data.
Use the spreadsheet program to make the graph. In making your graph, be sure to:
- Choose an appropriate scale.
- Label the horizontal and vertical axes.
- Provide a title for your graph.

TASK 6 :

Each of the following activities assumes familiarity with a 52-card deck of standard playing cards. You may use actual cards in working through the problems.

Given:
A standard deck of playing cards contains a total of 52 cards ( 26 red cards and 26 black cards). There are 4 cards of each number 2 through 10 (two red and two black). There are 12 face cards (four jacks, four queens, and four kings) and four aces. Assume the cards have been shuffled (randomized).

A ) Complete the table below based on the action described. Except in the last case, assume each card is replaced after the given action.

B) Remove the RED cards from the deck and assume that the remaining cards have been shuffled . Complete the table below based on the action described. Except in the last case, assume each card is replaced after the given action.

Action	Probability
Select a card from the partial deck. What is the probability that the card will be red?
Select a card from the partial deck. What is the probability that this card will NOT be a face card?
Select a card from the remaining deck. Place the card back in the deck. Select another card. What is the probability that both cards will be black?
Select a card from the remaining deck. Do NOT replace the card. Select another card. What is the probability that a red 3 is selected and a face card is selected?

C) Separate the 12 face cards from the rest of the deck . Assume that the remaining cards have been shuffled. Select THREE cards from the pile of face cards. For each question, show how you derive the solution. Then tell whether it is a combination or a permutation and why. (See Below)

Price: $9.63

Solution: The downloadable solution consists of 5 pages, 463 words and 2 charts.
Deliverable: Word Document