Using Excel to Solve a Binomial Distribution Problem PDF

Title	Using Excel to Solve a Binomial Distribution Problem
Course	Introduction To Economic And Business Statistics
Institution	Brooklyn College
Pages	1
File Size	59.2 KB
File Type	PDF
Total Downloads	9
Total Views	145

Preview

CLICK TO PREVIEW PDF

Summary

Using Excel to Solve a Binomial Distribution Problem...

Description

Using Excel to Solve a Binomial Distribution Problem: A study indicates that 14% of teenagers drink alcoholic beverages on a regular basis. What is the probability that in a sample of 50 teenagers, you will find that exactly 2 drink? To solve this problem using BINOMDIST in Excel, you need the following:  Number_s is the number of successes in trials. For this problem = 2  Trials is the number of independent trials. For this problem = 50  Probability_s is the probability of success on each trial. For this problem = .14  Cumulative is a logical value and you indicate TRUE if you want the cumulative value or FALSE.  Since we are looking for the exact value which is not cumulative, type in FALSE Formula Result= .017231 [Try it!]...