Question
Question is based on this data: https://docs.google.com/spreadsheets/d/1AiNW4UuX1fPBzP9ocUyHc2ozzUkIrFknfmUlIkVR2i0/edit?usp=sharing Fortune magazine publishes an annual list of the 100 best companies to work for. The data is provided
Question is based on this data: https://docs.google.com/spreadsheets/d/1AiNW4UuX1fPBzP9ocUyHc2ozzUkIrFknfmUlIkVR2i0/edit?usp=sharing
Fortune magazine publishes an annual list of the 100 best companies to work for. The data is provided in the file named Fortune-Best and it shows a portion of the data for a random sample of 30 of the companies that made the top 100 list for 2020. The column labeled Salaried ($1000s) shows the average annual salary for salaried employees rounded to the nearest $1000; and the column labeled Hourly ($1000s) shows the average annual salary for hourly employees rounded to the nearest $1000. Fortune defines large companies as having more than 10,000 employees, midsize companies as having between 2500 and 10,000 employees, and small companies as having fewer than 2500 employees.
a. Use methods of descriptive statistics to summarize the Fortune-Best data and comment on your findings.
b. Based upon the results of your analysis, what estimated regression equation would you recommend to predict the average annual salary for salaried employees given the average annual salary for hourly employees and the size of the company. Provide an interpretation of the estimated regression coefficients for this equation.
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