Please solve using excel functions

The following table shows the average hourly wage rates for day-care centers from two locations based on two random samples. Use the table to complete pans a through c Location 1 Location 2 Sample mean $9.6? $8.5l Sample standard deviation $1 25 $1 19 Sample size 2? 32 a. Perform a hypothesis test, usmg oc=0.05' to determine ifthe average hourly wage for day-care workers in Location 1 is $0.50 per hour higherthan the average hourly wage for day-care workers in Location 2 Assume the population variances forwage rates in each location are equal. Determine the null and alternative hypotheses forthe test Hg: [.14 |,L2 S $0.50 H1: H4 7p; > $0.50 Calculate the appropriate test statistic and interpret the result. The test statistic is 20?. (Round to two decimal places as needed) The critical value(s) is(are) 1 E?' (Round to two decimal places as needed. Use a comma to separate answers as needed.) Because the test statistic is greaterthan the critical value. reject the null hypothesis. h. Identify the p-yalue from part a and interpret the result. The p-yalue is o.o21'. (Round to three decimal places as needed) Interpret the result. Choose the correct answer below. V Since the p-yalue is less than the signicance level. reject the null hypothesis. Since the p-yalue is less than the signicance level. do not reject the null hypothesis. Since the p-yalue is not less than the signicance level, reject the null hypothesis. Since the p-yalue is not less than the signicance level, do not reject the null hypothesis. c. What assumptions need to be made in orderto perform this procedure? Although the sample size in the second sample is large enough, it must be assumed that the distribution forthe rst sample is normally distributed, and that the samples are independent. x Since the sample sizes are large enough. no assumptions are needed. Although the sample size in the rst sample is large enough. it must be assumed that the distribution forthe second population is normally distributed. and that the samples are independent. * lt must be assumed that the distribution for both populations are normally distributed, and that the samples are independent