MSU Programming Median of Page Wage & Job Title Relationship Project

General Steps

Download

Salary_data.xlsx

Excel file from Canvas>Files>Datafiles>Tableau Data Files folder

Connect and open Salary_data.xlsx Excel file on Tableau. In the opening page on Tableau scan the header to see if there are any variables that are incorrectly classified as text or date or number or vice versa and change them to the correct variable type by cross-checking with the Excel file (Do this for any dataset that you open in Tableau). When all variables have been checked for appropriate classification, click on the ‘Update now’ button (might take a couple of minutes to update) .

Open Sheet 1 and scan all dimensions and measure variables.

Convert Paid Wage Per Year and Prevailing Wage per Yearfrom Dimensions to Measures.

Now you are ready to do some data visualization and analysis tasks.

Deliverable

For this exercise, you will use Paid Wage Per Yearas your Dependent variable. The Job Title Sub-group will be your Independent variable.

Create a column chart showing the relationship between the above variables and sort them from highest to lowest wages. Note: use the Median value for Paid Wage Per Yearwhile creating the graph.

From the File tab, “Print to PDF” the active worksheet and to submit, upload the PDF onto this Canvas assignment page.