plot_rv - Plots and Random #s EXCEL Functions Obtaining a...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Plots and Random #s EXCEL Functions Obtaining a Density Function Create a column with a range of values of x containing a large portion of the density Create a column that evaluates f(x) at each value of x (Specific denities below) Repeat previous step for multiple pdfs Highlight columns with x (left-hand column) and f(x) (right hand column(s)) Chart Wizard XY (Scatter) Picture with Smooth curves/No points Families of Densities Gamma( , ): f(x)=GAMMADIST(x, , ,FALSE) Exponential ( =1 ) special case of Gamma Chi-Square ( = n/2, =2 ) special case of Gamma Normal( , 2 ): f(x)=NORMDIST(x, , , FALSE) Other densities obtained by directly typing in f(x) Example: Gamma( = 2 ,= 2 ) 0.01 0.002488 0.02 0.00495 0.03 0.007388 0.04 0.009802 0.05 0.012191 0.06 0.014557 0.07 0.016898 0.08 0.019216 0.09 0.02151 14.95 0.002119 14.96 0.00211 14.97 0.002101 14.98 0.002092 14.99 0.002083 15.00 0.002074 Cell A1 =GAMMADIST(a1,2,2,False) Cell A1500 =GAMMADIST(a1500,2,2,False) Example: Gamma( = 2 ,= 2 ) Gamma(2,2) pdf 0.02 0.04 0.06 0.08 0.1 0.12 0.14 0.16 0.18 0.2 2 4 6 8 10 12 14 16 x f(x) Cumulative Distribution Function...
View Full Document

This note was uploaded on 06/04/2011 for the course STA 4321 taught by Professor Staff during the Spring '08 term at University of Florida.

Page1 / 14

plot_rv - Plots and Random #s EXCEL Functions Obtaining a...

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

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