Suppose that the population average of (monthly) wage of young employees in Tasmania in the previous year before this survey was conducted was $900.

1. Conduct a hypothesis test that the population average wage of young employees in Tasmania during the year of survey remains the same as in the previous year.
2. Construct a 95% confidence estimate for the population average wage, and comment whether the population average wage in the year of survey remains the same as in the previous year.

Dear tutors,

I am working on a statistics project. I need some support to help me to understand this question better.

I am trying to use excel to run this question, however, I couldn't find the correct way to do it.

Could you give me some guidance, please?

Much appreciate