Question

Department Survey Data Years Undergraduate Study Graduate Degree? Age Group Gender Years of Service 17 CPA? Y Age Group 1 N 2 3 4 5 Age Range 21-25 26-30 31-35 36-40 41-45 46-50 51-55 56-60 over 60 7 - 4 N. 16 21 27 7 8 23 8 4 9 N. NY 2 3 5 3 N. 2 4 4 26 N - 19 5 z 2 2 4 4 4 4 19 < z 20 14 < 31 z z 10 10 26 4 N 4 28 4 4 N.

Use AccountingProfessionals.xlsx to test the null hypothesis that mean years of service is equal to 20 using a 0.05 level of significance. What is the p-value (round to four decimal places after making all calculations)?

Answer 1

Result:

Use AccountingProfessionals.xlsx to test the null hypothesis that mean years of service is equal to 20 using a 0.05 level of significance. What is the p-value (round to four decimal places after making all calculations)?

P value = 0.0023

since p value 0.0023 is < 0.05 level of significance. Ho is rejected.

Ho: µ = 20 H₁: µ ≠ 20

$t = \frac { (\bar x - \mu)} {\frac {s} {\sqrt{n}}}$

t Test for Hypothesis of the Mean
Data
Null Hypothesis                m=	20
Level of Significance	0.05
Sample Size	27
Sample Mean	14.7037
Sample Standard Deviation	8.1326
Intermediate Calculations
Standard Error of the Mean	1.5651
Degrees of Freedom	26
t Test Statistic	-3.3839
Two-Tail Test
Lower Critical Value	-2.0555
Upper Critical Value	2.0555
p-Value	0.0023
Reject the null hypothesis