The datasetincluded with this assignmentis a randomsample of450persons fromthe population survey ofAustraliain aparticularyear (2020).The population consists of working and drawingsalaries duringthe survey year,which you canaccess from theAssessment Information pageon the unit website.Youneed to selectthe random samplesof100IDs,eachcontaining observations,where appropriate, of the eight variables,V1 to V8.The variables in the data set are as follows: V1 =Salary(dollars per hour) V2 = Occupational category (1=Management, 2=Sales, 3=Clerical, 4=Service, 5=Professional, 6=Other) V3 =Sector (0=Other, 1=Manufacturing, 2=Construction) V4 = Indicator variable forResidency Ownership(1=Homeowner, 0=Tenant) V5=Educationallevel (0= other,1= Diploma, 2=Graduate Certificate, 3=Bachelor, 4=Master, 5= Doctorate) V6 = Number of years ofwork experience V7 =Age (years) V8 = Indicator variable for sex (1=Female, 0=Male). Assessment Tasks

Answers to the Assessment 3 tasks must be based on the sample data file you created in Part I of the assignment. In addition,most tasks inassessment3 require youto obtain anExcel output before performing some analysis. There are five tasks in Assessment 3. You must meet all task requirements to receive full marks Task 3 (20 marks) a.UseExcel and your sampledata file toproduce a suitableoutput;test,at the5% level ofsignificance, the hypothesis that, forSalaries(dollar per hours) in the population with meanis $25. b.Is this a one-tailed or two-tailed test?Briefly explain the reasoning behind your answer. c.Write, in precise symbolic form, the null and alternative hypotheses.

d Define Z test and calculate the value of test statistics. e.Define critical values based on the nature of the problem. f.Finda95% confidence interval for thesalaries(dollar perhour) in the population. g.Make the decision based on the critical value. please answer step step by ention ,a,b,c,d,e,f,g