MATH 111 Statktics for Beckie]: Making
Week 4 Lab Name:
MATHZZI Statistical Concepts:
I Probability
I Binomial Probability Distributions Calculating Binomial Probabilities > Calculate binomial distributions for 10 trials and three different probabilities of
success Open a sprmdsheet In cell A1 type “success“ as the label Under success in column A, type 0 through 10 {in rows 2 through 12) In cell B 1, type “one fourth" Using the Excel Stat Calculator, generate the binomial distribution for p=0.25,
n: 10 6. Copy the probabilities from the calculator and paste into cells B2 through B12
using Paste Special > Values thP‘P-N" 7. In cell C1, type “one half“ ll. Using the Excel Stat Calculator, generate the binomial distribution for H.5,
n: 10 9. Copy the probabilities from the calculator and paste into cells C2 through C 12
using Paste Spera’al > Values 10 In cell D 1 type “three fourths" 11 Using the Excel Stat Calculator, generate the binomial distribution for p=O.7S,
n: 10 12. Copy the probabilities from the calculator and paste into cells D2 through D 12
using Paste Special > Values Plotting the Binomial Probabilities 1. Create a plot for the three binomial distributions above. In Exch select the data (all
values including the column In. gs in row 1), click on INSERT> CHARTS >
SCATTER. and select the chart with dots connected by sooth lines. Add an
appropriate title, axis labels and a legend hste the smtter plot in the grey area
below. (10 points) Calculating Descriptive Statistics
)> In the Files folder- > Labs, open ‘Math2217LabDataorlsx‘ to answer question 2. 2. Calculate descriptive statistics for the variable (Coin) Where each of the thirtyrfive
students flipped a coin 10 times and recorded the number of heads. Round your
answers to three decimal places Determine the mm using =ay§rage§highlight data)
and the standard deviation using =stdev.s{high|ight data). Enter your results in the
grey area below (8 points) Short Answer Writing Assignment — Both the calculated binomial probabilities and the
descriptive statistics from the class database will be used to answer the following
questions. Round all numeric answers to three dedmal places. 3. Copy and paste the probability values for the probability of success : 59, calculated at
the beginning of the lab. (Complete sentence not necessary; round your answers to
three decimal places) (4 points) may) pops)
l’(x=1) HF?)
P(x:2) P(x:8)
pops) Kyla)
l’(x=4) P(x=10) 8. Using the Excel Stat Calculator, calculate the mean and standard deviation for a
binomial distribution with the probability of a success : 5/: and n : 10. Explain in