Question: The data you will use for this question are from the Bureau of Labor Statistics Job Openings and Labor Turnover Survey(Links to an external site.)

The data you will use for this question are from the Bureau of Labor Statistics Job Openings and Labor Turnover Survey(Links to an external site.).Get the data here (jlt_firmsize_sa.xlsx).

On the second sheet (aka tab) which is titled "Hires" you willfind the monthly hires (how many people companies hired in the US) reported by the BLS. Use all the data for 2001-2016 in the "All Firm Sizes" column. WARNING this does not include the December2000 entry. WARNING you should have a total of 192 observations.

Calculate thelower boundfor a 90% confidence interval for the mean hires. WARNING in this problem you are using EXCEL soget the exact t value using excel, do not approximate using the t table.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!