Using Tableau solve Homework Assignment #2 - Government employment and salary analysis: Which of the entities (state, local or metro) have the: Highest average employment? Pay the most average salary? Highest total wage (average) What is the year with the most salary paid out? Explain the results half credit WITHOUT a good explanation of the results.

Government employment and salary 1.xlsx

Trend analysis: analyze and determine the 13-year IPO trend (1999 2012): use the dataset provided)

Gross spread (amount)

Underpricing %

Total underwriting fees

Perform three trend analysis

For financial industry (both investment and commercial bank)

For commercial banks only

Investment bank only

Explain the results:

Is trending upward?

Downward?

Fluctuating?

Flat?

Note 1: Use Tableau for this analysis. Watch the video on how to perform trend analysis in Tableau (very simple).

Note 2: Take the screenshots of the results and past it into the either Word document or the PowerPoint deck.

Explain the results (Tell the story) half credit WITHOUT a good explanation of the results