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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started