Top Management. The Drucker Institute ranks corporations for managerial effectiveness based on a composite score derived from the following five factors: customer satisfaction, employee engagement and development, innovation, financial strength, and social responsibility. The file Top Management contains the top 25 companies in the Institute’s ranking based on the composite score (source: The Wall Street Journal). For each company, the industry sector, the company name, and the composite score are given.
Create a treemap chart using these data with the sector being the category, company being the subcategory, and the composite score being the quantitative variable. Use “Management Top 25” for the chart title. Hint: Be sure to first sort the data by sector.
In the sector with the most companies in the top 25, which company has the highest composite score?
Biodiversity Preservation. Ecologists often measure the biodiversity of a region by the number of distinct species that exist in the region. Nature reserves are lands specifically designated by the government to help maintain biodiversity. Care must be taken when setting up a network of nature reserves so the maximum number of species can exist in the network. Geography matters as well, as putting reserves too close together might subject the entire network to risks, such as devastation from wildfires. The initial step in this type of planning usually involves mapping the number of species that exist in each region. The file Biodiversity Preservation contains the number of unique species that exist in each of the 50 states in the United States.
Create a choropleth map that displays number of species by state. Use “Number of Species per State” for the chart title. Add data labels.
Comment on the distribution of species over the United States. Which regions of the United States have relatively many species? Which regions have relatively few species?
Which two states have the most species?
Income Statement. An income statement is a summary of a company’s revenues and costs over a given period of time. The data in the file Income Statement is an example of an income statement. It contains the revenues and costs for the last year for Bellevue Bakery. Revenues include gross sales and other income. Costs include returns, cost of goods sold, advertising, salaries/wages, other operating expenses, and taxes. In the income statement, there are intermediate calculations:
Net Sales = Gross Sales − Returns
Gross Profit = Net Sales − Other Income − Cost of Goods Sold
Net Income Before Taxes = Gross Profit − Advertising – Salaries/Wages − Other Operating Expenses
Net Income = Net Income Before taxes − Taxes
Create a waterfall chart of the income statement for Bellevue Bakery. Use “Bellevue Bakery Income Statement” for the chart title. Click the column associated with each of the calculations above and select Set as Total. Edit the chart to make it easier to interpret.
Regional Gains and Losses in Population. The United States Census Bureau tracks shifts in population by each state and region in the United States. The net migration rate is an indicator of the movement of people from one area to another. A positive net migration rate means more people moved into the area than moved away, and a negative net migration rate means more people left the area than moved into the area. Mathematically, the net migration rate N is defined as follows:
Create a heat map using conditional formatting with the Blue-White-Red Color Scale.
Which regions are losing population? Which regions are gaining population?
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|