fall2008finalexamexcel

# fall2008finalexamexcel - Excel Output BINOMDIST(X n p...

This preview shows page 1. Sign up to view the full content.

Excel Output STAT 212: Fall 2008 BINOMDIST(X, n, p, cumulative) BINOMDIST(10, 20, 18/38, TRUE) = 0.677658 BINOMDIST(10, 20, 18/38,FALSE) =0.171377 BINOMDIST(10, 20, 20/38, TRUE) = 0.493719 BINOMDIST(10, 20, 20/38, FALSE) = 0.171377 BINOMDIST(11, 15, 0.75, FALSE) = 0.225199 BINOMDIST(12, 15, 0.75, FALSE) = 0.225199 BINOMDIST(12, 15, 0.75, TRUE) = 0.763912 CHIDIST(X, deg freedom) CHIDIST(3.756, 1) = 0.052618 CHIDIST(3.756, 4) = 0.440034 CHIDIST(4.209, 1) = 0.040210 CHIDIST(4.209, 4) = 0.378459 CHIDIST(4.352, 1) = 0.036966 CHIDIST(4.352, 4) = 0.360459 CHIDIST(18.5, 24) = 0.778102 CHIDIST(18.5, 35) = 0.990044 CHIDIST(18.5, 20) = 0.554507 NORMSDIST(Z) NORMSDIST(-2) = 0.0228 NORMSDIST(1) = 0.8413 NORMSDIST(1.145) = 0.8739 NORMSDIST(-2.145) = 0.01598 NORMSDIST(1.09) = 0.8621 NORMSDIST(-1.792) = 0.0366 NORMSDIST(-2.017) = 0.0218 NORMSDIST(1.5) = 0.9332 NORMSDIST(2) = 0.9772 NORMSDIST(2.998) = 0.9986 NORMSINV(probability) NORMSINV(0.025) = -1.960 NORMSINV(0.05) = -1.645 NORMSINV(0.95) = 1.645 NORMSINV(0.975) = 1.96
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Ask a homework question - tutors are online