How are the Z, P tails, Z tails, DF, F, P One tail, and F critical one tail foun
ID: 3293729 • Letter: H
Question
How are the Z, P tails, Z tails, DF, F, P One tail, and F critical one tail found in excel?
Descriptive Statistics
Current
Proposed
Count
Mean
Sample Variance
Sample Standard Deviation
Minimum
Median
Mode
61.00
75.07
15.56
3.94
65.00
76.00
76.00
61.00
75.43
6.28
2.51
65.00
76.00
76.00
Z – Test: Two Sample for Means
Current
Proposed
Mean
Known Variance
Observations
Hypothesized Mean Difference
z
P(Z<=z) one-tail
z Critical one-tail
P(Z<=z) one-tail
Z Critical two-tail
75.0656
15.5623
61.0000
0.0000
-0.6027
0.2733
1.6449
0.5467
1.9600
75.4262
6.2820
61.0000
F – Test Two-Sample for Variances
Current
Proposed
Mean
Known Variance
Observations
df
F
P(F<=f) one-tail
F Critical one-tail
75.0656
15.5623
61.0000
60.0000
2.4773
0.0003
1.5343
75.4262
6.2820
61.0000
60.0000
Descriptive Statistics
Current
Proposed
Count
Mean
Sample Variance
Sample Standard Deviation
Minimum
Median
Mode
61.00
75.07
15.56
3.94
65.00
76.00
76.00
61.00
75.43
6.28
2.51
65.00
76.00
76.00
Explanation / Answer
Ans:
Normal distribution:
z critical(One tail)
z=NORMSINV(0.95)=1.645
z=NORMSINV(0.05)=-1.645
z critical two tail(for 0.05 significance level)
z=NORMSINV(0.025)=-1.96
z=NORMSINV(0.975)=1.96
Probability(P tails):
P(z<1.645)=NORMSDIST(1.645)=0.95
P(z<-1.645)=NORMSDIST(-1.645)=0.05
F distribution:
P(F<=2.4773)=FDIST(2.4773,60,60)=0.0003
F critical one tail(0.05)=FINV(0.05,60,60)=1.5343
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.