Help – i need a spreadsheet with statistics!
University is concerned that out of state employees may be receiving lower wages than local workers.Twoindependentrandom samples have been selected: 165 observations frompopulation 1 (Out of stateworkers) and177 frompopulation 2 (local). The samplemeans obtainedareX1(bar)=86 and X2(bar)=87.It is known fromprevious studies that the population variances are8.1 and 7.3 respectively. Using a level of significanceof.01, is there evidence that theout of state workers may be receiving lower wages?Fullyexplain your answer.
I need this as a spreadsheet!