Brief characterization of the methodology used by Fortune to define the list|My homework aider
Posted: February 24th, 2023
Sheet 1: Brief characterization of the methodology used by Fortune to define the list (not more than 120 words in your own words, not copying it from the website!) and at least 5 variables relevant to building the ranking (with a short description of each one). Additionally, identify yourself or the team as the author of this workbook.
Sheet 2: All the data downloaded from this website for the last available year, showing all the columns. Add:
- 2 histograms with seven bins each of any two of the variables (columns),
- a column chart of the % Women vs the rank of the company, and
- a scatter plot of the job openings in the horizontal axis vs the new graduates hired in the vertical axis.
Sheet 3: The descriptive statistics of each one of the variables reported, of the companies ranked from 1 to 20, and of the companies ranked from 81 to 100, created with the Data Analysis Toolpak, side by side. By inspection of the statistics obtained, try to draw conclusions about the similarities and differences between the top 20 companies and the lowest 20 columns.
SOLUTION
Inspection of the statistics reveals that the top 20 companies generally have higher scores on all variables compared to the bottom 20 companies. For example, the mean Trust in Leadership score for the top 20 companies is 93.85, compared to 83.80 for the bottom 20 companies. The top 20 companies also have higher means for Camaraderie, Innovation, and Work-life Balance, and a higher percentage of women in their workforce. The bottom 20 companies have a higher mean for Job Openings and New Graduates Hired. These findings suggest that the best companies to work for excel in creating a positive work culture and promoting employee well-being and diversity, while also attracting a high-quality workforce.
Expert paper writers are just a few clicks away
Place an order in 3 easy steps. Takes less than 5 mins.