Question
Answered step-by-step

I need help solving this lab.

sa

dsa

ddsadsaddsadsad

Image transcription text

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

... Show more

Image transcription text

£—:— 4. Determine the probability for the following based on the values in question 3 above. (Complete sentence not necxssary; round your answers to three decimal places) (12 poinIS) NYE 1) W151) P{x> 1) "754) m4<x 57) Nx<4 or x27) 5. In words, what does 1,121) mean? (4 points) 6. Using the Excel Stat Calculator, calculate the mean and standard deviation fix a binomial dis'h'ibution with the probability of success = l6 and n = 10. (4 points) 7. Using the Excel Slat Calculator, mlculate themean and standard deviation for a binomial dism'bution with the probability of a success = V4 and n = 10. Explain in detail why the mm is different from question 6. (6 points) E. Using the Excel Stat Calculator, mlculate the mean and standard deviation for a binomial disrrflmtion with the probability of a sum = 3/: and n = 10. Explain in detail why [he mean is different from qusfion 6. (6 points) 9. Using all four of the properties of a Binomial experiment, explain in a short paiagiapli why me Coin variable from the class survey IepISenls a binomial distributionfiomabinomial experiment. (6points) 10. Compare the mean and standard deviation for the Coin variable (question 2) with the mean and standard deviation for the binomial distribution calculated in question 6 with the probability of success : t5, 11:10. Do you expect the 1501's to be similar? Why or why not? (10 points)

... Show more

Answer & Explanation
Verified Solved by verified expert
Rated Helpful

ipsum dolor sit amet, consectet

sus ant

inia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam l

Unlock full access to Course Hero

Explore over 16 million step-by-step answers from our library

Subscribe to view answer
Step-by-step explanation

binomial distribution.xlsx

molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet.
1 Attachment
binomial distribution.xlsx
xlsx
Student review
100% (1 rating)

"thanks."