labtwoA Ex 03

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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/09/2010 for the course ECON 240a taught by Professor Staff during the Spring '08 term at UCSB.

Page1 / 5

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

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online