Question

• For the next part of the lab, open the Week 3 Excel worksheet. This will be used for the next few questions, rather than the data file used for the first question.

1. Click on the “binomial tables” workbook
2. Type in n=10 and p=0.5; this simulates ten flips of a coin where x is counting the number of heads that occur throughout the ten flips
3. Create a scatter plot, either directly in this spreadsheet (if you are comfortable with those steps), or by using the week 1 spreadsheet and copying the data from here onto that sheet (x would be the x variable, and P(X=x) would be the y variable.

1. List the probability value for each possibility in the binomial experiment calculated at the beginning of this lab, which was calculated with the probability of a success being ½. (Complete sentence not necessary; round your answers to three decimal places)

P(x=0)	.0010		P(x=6)	.2051
P(x=1)	.0098		P(x=7)	.1172
P(x=2)	.0439		P(x=8)	..0439
P(x=3)	.1172		P(x=9)	.0098
P(x=4)	.2051		P(x=10)	.0010
P(x=5)	.2461

2. Give the probability for the following based on the calculations in question 3 above, with the probability of a success being ½. (Complete sentence not necessary; round your answers to three decimal places)

P(x≥2)	.054688		P(x<0)	.999023
P(x>2)	.010742		P(x≤5)	.623047
P(5<x ≤7)	.		P(x<5 or x≥7)

I need help with the last two as well as how its done. I think everything else is correct.

Answer 1