STATISTICAL ANALYSIS

]

Statistical Analysis

Statistical Analysis

7.84

Solution

P (X = 3)

= BINOMDIST (3,10,0.3,FALSE) = 0.266827932

P (X = 5)

= BINOMDIST (5,10,0.3,FALSE) = 0.102919345

P (X = 8)

= BINOMDIST (8,10,0.3,FALSE) = 0.001446701

7.97

Solution

Using Excel:

=BINOMDIST (0, 25,0.1, FALSE) = 0.071789799

Using Excel:

=BINOMDIST (4, 25,0.1, TRUE) = 0.902006379

Using Excel:

= 1 - BINOMDIST (2, 25,0.1, TRUE) = 0.46290595

8.35

Solution

Z-table, p= .85 indicates the z score of 1.04

x = µ + (z * s)

x = 250 + (1.04 * 40)

x = 250 + 41.44

x = 291.44

8.42

Solution

z = (x - µ) / s

z = (12000-10000) / 2400

z = 2000/ 2400

z = 0.83

Using Excel function of NORMSDIST, p = ...