For this assignment, the data used is from 2019 data analytics job postings. Please respond to the following inquiries. Show your work.

What is the number of data analytics positions that were successfully filled in 2019?

How many job postings were in Dallas, Texas?

Create a pivot table with job titles as rows and hiring status as columns, displaying the count of positions for each (job title, hiring status) combination (your table should be the similar to table below).

Note:

The data is contained in an attached EXCEL file. If you prefer to use Google Sheets, you can access the file by navigating to

Course 2 Week 3 Functions in spreadsheets Hands-On Activity: Create a Custom Data Table.

The link to the spreadsheet is available in this webpage.

Once you completed the assignment, attach your Excel file or copy the link of your google sheet in the submission folder.