The file Salary_Data.xlsx contains the salary data for the Labour Force Survey.

The Salary data file: https://docs.google.com/spreadsheets/d/1VV8iztnJGYERcpQl4F45SN0ZeG97zXodNETTGN0WS9g/edit?usp=sharing

a) Treating this set of data as the population, use Excel to calculate the population mean and standard deviation for the Annual Salary variable.

b) Examine a boxplot and histogram of this population data and report your findings.

c) Explain if the means of all possible random samples of size 100 from this population would form a normal distribution.

d) Use Excel (Sampling function in the Analysis ToolPak) to draw twenty samples of size n = 100 from the Annual Salary population data. (HINT: This procedure must be replicated twenty times. Note that if you open the same sampling dialog box each time from the menu, then you only have to replace the last destination column with the next one). (please show how)

e) Suppose you have concluded in b) that the population data was not normally distributed, use your first sample and display its distribution using a boxplot or histogram and comment on whether the relevant assumption and conditions of the CLT are warranted for analysing the sampling distribution of the mean (state clearly the 4 assumptions and conditions).

f) Calculate the mean of each sample and thereafter the mean and standard deviation of the sample means.

g) How does the mean and the standard deviation of the population compare with the mean and standard deviation of the sample means based on your calculations? Explain.

Please answer all questions above^. For all questions please show your steps on Excel how you did it so I can replicate it.