Posted: March 12th, 2023

Consolidation assignment

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:

  1. 2 histograms with seven bins each of any two of the variables (columns),
  2. a column chart of the % Women vs the rank of the company, and
  3. 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. 

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price: