labtwoA Ex 03

# labtwoA Ex 03 - Oct 6 2010 LAB#2 Econ 240A-1 Binomial...

• Notes
• 5

This preview shows pages 1–3. Sign up to view the full content.

Oct. 6, 2010 LAB #2 Econ 240A- 1 L. Phillips Binomial Distribution I. Calculating the Binomial Distribution: Flips of a Fair Coin ( # of trials) 1. One flip Open Excel, In cell B3, type “Binomial 1 flip” In cell B5 type “k” for the binomial variable, and in B6 type “0” And in B7 type “1” In cell C5 type “n” for the number of trials, and in C6 type “1” and in C7 type “1” In cell D5 type “p” for probability, select cell D6, go to the formula bar and type “=”, insert function, choose function category ‘statistical” and function name “binomial”, and hit OK. In the dialog box, number s is the number of successes, select cell “B6”, Trials is the number of trials, select cell “C6”, probability s is the probability of a success, type in “0.5”, cumulative gives you an option of finding, for example, the probability of zero heads, type in “false”, or the cumulative distribution function, less than or equal zero heads, type in “true”. We will use false. Hit OK. If needed, hit the “?’ button for more info on the dialog box. For cell D6, we have p(k=0) = C 1 (k=0) (0.5) 0 (0.5) 1 = 1!/(0!1!) * 0.50 =0.50. Drag the lower right hand corner “handle” down through cell D7. For a chart of the distribution, select cells B6 and B7, hold down the “ctrl” key and select cells D6 and D7. Go to the insert menu and select “chart”, and in the dialog box select “xy scatter” as the type. Hit the “next” button. Select the “series in column” button, and hit “next”. Select the “titles” tab and for chart title type “ Binomial; One Flip”, for the x axis type “Number of Heads”, For the y axis type “Probability”. Select the legend tab and deactivate “show legend”. Select the gridlines tab and deactivate “major gridlines” for the y axis. Hit the “next” button and place the chart on a new sheet, and then the “finish” button. Select the plot area and go to the format menu and select “format plot area” and under area, hit the “none” button. Select the x axis by clicking on it and go to the format menu and select ‘format axis”. In the dialog box, select the scale tab and for maximum type in 1.0 and for major unit type

This preview has intentionally blurred sections. Sign up to view the full version.

Oct. 6, 2010 LAB #2 Econ 240A- 2 L. Phillips Binomial Distribution in 1.0 and hit OK. Go to the chart menu and select chart type “column” and sub-type in upper left hand corner. Select the left column and go to the format menu and select “format data series” Choose the “options” tab and a gap width of “10”. Select the “patterns’ tab and for borders select custom and for
This is the end of the preview. Sign up to access the rest of the document.
• Fall '08
• Staff
• Normal Distribution, Probability theory, Binomial distribution, Cumulative distribution function, L. Phillips

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern