1. Advanced Worksheets (Use NorCalOccData.xlsx for the chart below)

a. Create bar graph that shows the number of jobs by occupation (JobTitle) in northern California metro regions. Highlight IT related jobs (Create set for IT related job titles (see examples below) and use that to color the bars in the bar graph- Hint: see 14.1 Creating Sets).

b. Allow the use to input a parameter for the minimum mean wage and filter the jobs displayed to show only those that are greater than the minim wage.

This is how the chart has to look on Tableau I have the excel needed but cannot attach it here.

Keynote File Edit Insert Slide Format Arrange View Play Share Window Help $ 77% Wed 10:23 PM Q E TM440-A2P2(1) 106% + T M O View Zoom Add Slide Play Table Chart Text Shape Media Comment Collaborate Format Animate Document Slide M4409-4392 1 Slide Layout Title Slide Data Analytics Pages lil Columns SUM(TotalEmploym. P Sheetl (Nor CalOccData) Rows Job Title Appearance Search Filters IN/OUT(IT Related Jobs Sheet 1 In Title Tables MeanWage>Min: True JobTitle F Out IT Related Jobs Software Developer Body Abc JobTitle Registered Nurses MinMeanWage Mark "TF MeanWage>Min General and Operatic. 100.000 Slide Number Computer and Infor.. We MSA_Region id Automatic Accountants and Au. We Measure Names 6) Computer Occupation. Annual Mean Wage Color Size Label Financial Managers Background Computer Systems A.. TotalEmployment Lawyers Sheet! (Count) Detail Tooltip Sales Managers Measure Values Management Analys. IN/OUT(IT R. Project Managemen Edit Slide Layout Personal Service Ma.. Marketing Managers Sales Representative Financial and Invest.. Civil Engineers Police and Sheriff's . Architectural and En.. Sales Representative. Administrative Servi.. Engineers, All Other Parameters Medical and Health .. Market Research An. . MinMeanWage Chief Executives Securities, Commodi.. Network and Compu. Personal Financial A. First-Line Supervisor. Electricians Electrical Engineers 10 nulls Ahamalelane All nehas OK 10K 20K 30K 40K 50K 60K 70K BOK 100K 110K 120K 130K 140K 150K TotalEmployment F Add a comment Send 3. Enter the course 25,104 SEP 22 S X