Create an excel sheet that explains the following

The topic is Salary Wage difference between Men and Women

The reference link: Barroso, A., & Brown, A. (2021, May 25). Gender pay gap in U.S. held steady in 2020. Pew Research Center.https://www.pewresearch.org/fact-tank/2021/05/25/gender-pay-gap-facts/

You may choose to do a one or two-sample test. For example: "Women get fewer hours of sleep on average than men." This is a two-sample hypothesis. Or "Individuals in this study get fewer hours of sleep on average than the general population." This would be a one-sample hypothesis. State why you think your hypothesis is true. Write your formal null and alternative hypothesis.

Calculate summary statistics for your data.

If your response variable is categorical, ordinal, or dichtomous, create a frequency distribution table for your sample(s) in Excel.

If your response variable is continuous, calculate sample mean, median, mode and standard deviation for your sample(s) in Excel.

Create a confidence interval for your sample(s).

Test your hypothesis.

Formulate a conclusion based on your results. State formally and informally.