The Excel file Accounting Professionals provides the results of a survey of 27 e

Question

The Excel file Accounting Professionals provides the results of a survey of 27 employees in a tax division of a fourtune 100 company. A. Test the null hypothesis that the average number of years of service is the same for males or females. B. Test the null hypothesis that the average years of undergraduate study is the same for males and females. Using Excel

Accounting Department Survey Data Employee Gender Years of Service Years Undergraduate Study Graduate Degree? CPA? Age Group 1 F 17 4 N Y 41-45 2 F 6 2 N N 26-30 3 M 8 4 Y Y 31-35 4 F 8 4 Y N 31-35 5 M 16 4 Y Y 36-40 6 F 21 1 N Y 51-55 7 M 27 4 N N 51-55 8 F 7 4 Y Y 26-30 9 M 8 4 N N 31-35 10 M 23 2 N Y 41-45 11 F 9 4 Y Y 31-35 12 F 8 2 N N 26-30 13 F 8 4 Y N 26-30 14 M 26 4 N Y 46-50 15 F 9 4 N Y 26-30 16 F 9 2 N N 26-30 17 M 19 2 Y Y 36-40 18 M 5 4 N N 36-40 19 M 19 4 Y N 51-55 20 M 20 4 N N 46-50 21 F 14 4 Y Y 36-40 22 M 31 4 N N 51-55 23 F 10 0 N N 51-55 24 F 10 4 N Y 31-35 25 M 26 4 Y Y 46-50 26 M 28 4 N N 51-55 27 F 5 4 N Y 21-25

Explanation / Answer

The Excel file Accounting Professionals provides the results of a survey of 27 employees in a tax division of a fourtune 100 company.

The calculated t=-3.773 falls in the rejection region.

The null hypothesis is rejected. We conclude that the average number of years of service is the different for males or females.

Pooled-Variance t Test for the Difference Between Two Means

(assumes equal population variances)

Data

Hypothesized Difference

0

Level of Significance

0.05

Female 1 Sample

Sample Size

14

Sample Mean

10.0714

Sample Standard Deviation

4.3934

Male 2 Sample

Sample Size

13

Sample Mean

19.6923

Sample Standard Deviation

8.3903

Intermediate Calculations

Female 1 Sample Degrees of Freedom

13

Male 2 Sample Degrees of Freedom

12

Total Degrees of Freedom

25

Pooled Variance

43.8279

Standard Error

2.5499

Difference in Sample Means

-9.6209

t Test Statistic

-3.7731

Two-Tail Test

Lower Critical Value

-2.0595

Upper Critical Value

2.0595

p-Value

0.0009

Reject the null hypothesis

The calculated t=-1.4316 not falls in the rejection region.

The null hypothesis is not rejected. We conclude that the average years of undergraduate study is the same for males and females.

Pooled-Variance t Test for the Difference Between Two Means

(assumes equal population variances)

Data

Hypothesized Difference

0

Level of Significance

0.05

Female 1 Sample

Sample Size

14

Sample Mean

3.0714

Sample Standard Deviation

1.3848

Male 2 Sample

Sample Size

13

Sample Mean

3.6923

Sample Standard Deviation

0.7511

Intermediate Calculations

Female Sample Degrees of Freedom

13

Male Sample Degrees of Freedom

12

Total Degrees of Freedom

25

Pooled Variance

1.2679

Standard Error

0.4337

Difference in Sample Means

-0.6209

t Test Statistic

-1.4316

Two-Tail Test

Lower Critical Value

-2.0595

Upper Critical Value

2.0595

p-Value

0.1646

Do not reject the null hypothesis

Pooled-Variance t Test for the Difference Between Two Means

(assumes equal population variances)

Data

Hypothesized Difference

0

Level of Significance

0.05

Female 1 Sample

Sample Size

14

Sample Mean

10.0714

Sample Standard Deviation

4.3934

Male 2 Sample

Sample Size

13

Sample Mean

19.6923

Sample Standard Deviation

8.3903

Intermediate Calculations

Female 1 Sample Degrees of Freedom

13

Male 2 Sample Degrees of Freedom

12

Total Degrees of Freedom

25

Pooled Variance

43.8279

Standard Error

2.5499

Difference in Sample Means

-9.6209

t Test Statistic

-3.7731

Two-Tail Test

Lower Critical Value

-2.0595

Upper Critical Value

2.0595

p-Value

0.0009

Reject the null hypothesis

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.