Using the website listed in Problem 2, create a web query that ranks firms according to revenue per employee. You might need to delete the first row (from the Home tab) and, in the Transform tab, change the data type for revenue and employees to Whole Number.

Data from in Problem 2

The website https://en.wikipedia.org/wiki/List_of_largest_companies_in_the_United_States_by_revenue contains data on the 500 largest US companies. Create a web query that includes the company name, revenue, industry, number of employees, and state where its headquarters are located.