Calculate the mean, median and standard deviation for sales, profit, EBIT and ROA for
the companies in the dataset.
Analysis
Which companies have the highest sales within each SIC categorization?
How many companies have sales of more than 100,000?
Which company has the highest sales and how much are they?
How many companies are listed on a “LBO, Subsidiary or Other” type of Exchange?
What is the Name, Industry and Sales of the company whose name is last in the list on
the LBO, Subsidiary or Other type of Exchange, when sorted alphabetically?
Which Stock Exchange has the highest total Sales? What is this amount?
How many companies are listed on the NASDAQ?
How many companies are listed in the NASDAQ and headquartered in Ohio?
How many companies in total are listed in Ohio?
What is the total Sales of all companies that are listed in the NYSE and headquartered
in Ohio?
What is the total Sales of all companies headquartered in Ohio?
Which industry (SIC) group is the largest (by number of companies in the category)?
Recommend a company to buy. Give three reasons to support your recommendatio