nursing

profilecel
hworklast3.xltx

Q1

IPADs(X) F FX CF RF X-M (X-M)^2 F(X-M)^2
1 7 7 0.12 0 0
2 9 16 0.15 0 0
3 16 32 0.27 0 0
4 14 46 0.24 0 0
5 5 51 0.08 0 0
6 8 59 0.14 0 0
59 0 1.00 0
Mean ∑FX/∑F 0.00
Median 3
Mode 3
CF
RF
Variance ∑f(X-M)^2/∑f 0.00
SD 0.00

Q2

IPADs(X) F IPADs(X) CF 1. Construct a pie chart for each table
0 5 0 5 2. Cnstruct a line labeled graph for each
1 8 1 13 3. Construct a bar chart for each table
2 14 2 27
3 13 3 40
4 6 4 46
5 4 5 50

Q3

X
12 mean
13 median
15 mode
14 Variance
14 SD
14 Range
17 MIN
18 MAX
19 Q1
12 Q2
13 Q3
14 P20
14 P70
P50

Q4

Class FREQ RF
A 6 BINOMIAL
B 3 p 60% 0.6
C 6 n 3
D 13 q 0.4
E 10 x 3
F 2
40 0.00
3C3 1
P(A) P^3 0.216
P(B) q^0 1
P(AnB) 0.216
P(AnBnC)
P(BnE) Mean µ np 1.8
P(CuDuEuF) SD √npq 0.72 0.85
P(EnF)I
P(DI)

Q5

X F P(X) X*P(X)
0 10 0.00
1 13 0.00
2 18 0.00
3 13 0.00
4 8 0.00
5 14 0.00
76 0.00
Expected Value X*P(X) 0.00
sumproduct 0.00
P(X≤4)
P(X=5)
P(X<1)
P(X>3)
P(0≤X≤5)

Q6

Binomial Dist
P 0.55 Mean np
n (Trials) 8 Var npq
x (numbers) 5 Sd √npq
P(x=5)
P(x<5)
p(x<1)

Q7

POISSON
ƛ 5
x 4
e 2.718
ƛx
e-ƛ
x!
P(4) ERROR:#DIV/0!
Excel ERROR:#NAME?

Q8

Z score
Find:
P(Z>1.23)
P(Z<1.23)
P(Z<-1.23)
P(Z>-1.23)