The Excel file Accounting Professionals provides the results

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

Solution

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