Q5. Two-sample test for means assuming equal variances, population standard deviations unknown. Use

Q5. Two-sample test for means assuming equal variances, population standard deviations unknown. Use information in the Excel file Accounting Professionals. Use the appropriate Excel Data Analysis Tool to test the following hypotheses.a. The average years of undergraduate study for males is greater than for females.b. The average years of undergraduate study does not differ between males and females.Accounting Department Survey DataEmployee Gender Years of ServiceYears Undergraduate StudGraduate Degree?CPA? Age Group1F174NY41-452F62NN26-303M84YY31-354F84YN31-355M164YY36-406F211NY51-557M274NN51-558F74YY26-309M84NN31-3510M232NY41-4511F94YY31-3512F82NN26-3013F84YN26-3014M264NY46-5015F94NY26-3016F92NN26-3017M192YY36-4018M54NN36-4019M194YN51-5520M204NN46-5021F144YY36-4022M314NN51-5523F100NN51-5524F104NY31-3525M264YY46-5026M284NN51-5527F54NY21-25