Final Project:

You will need to prepare a short presentation using PowerPoint and Excel to show us your findings and what you have learned.

Use the job data from

https://data.bls.gov/oes/#/home

1, Decide your favorite job first. Then look for a second job that you think they will have same/close wage. (you may pick a few couple ones, and decide which ones are looking close). at the end, keep TWO jobs. And transfer all the data into one excel sheet.

In your presentation, powerpoint

tell us why you pick those two jobs (such as you are working in that field, or you want to be, etc).

and explain why you believe they are having close wage.

2, In Excel, find the Mean, Min, Quartile 1, 3, Median, Max, and Standard deviation for the Two jobs.

In your presentation, explain the which job is more dispersion (higher standard deviation).

3, In your presentation, explain the basic stats finding in #2, and tell us if the two jobs are close to each other, by comparing to their Mean, Median.

4, Use excel to find the correlation coefficient between the two jobs. And create the scatter plot between the two jobs, show to trend equation.

5, in your presentation, interpret the correlation and the equation you found.

6, Run the hypothesis for the following parts. (Main and Heavy here.)

https://www.statssolver.com/hypothesis-testing.html

Please pay attention in class to watch how I do it. it is a little tricky.

7a, test if the two jobs are of the same mean wage, with 10% significance.

7b, if Yes in 7a, then re-test it with 5% sigificance. If No in 7a, skip this part.

8a, test if the one job's wage is higher than the other, with 10% significance.

8b, if Yes in 8a, then test if one job's wage is $5000 more than the other, with 10% sigificance. If No in 8a, skip this part.

8c, If Yes in 8b, then test if one job's wage is $20000 more than the other, with 10% sigificance. If No in 8b, skip this part.

9, In your presentation, interpret your hypothesis test results.

For example, if in YES 7a, you can state that "with 10% significance, which is 90% confidence to say that the two jobs are of same wage."

If No in 7a, then the statement becomes ""with 10% significance, which is 90% confidence to say that the two jobs areNOT of same wage."

If Yes in 8b, we state that "with 10% significance, which is 90% confidence to say that job A is $1000 more than the job B."