Required information Not-For-Profit Data Analytics Project Skip to question [The following information applies to the questions displayed below.] Purpose: The purpose of this project is to analyze a large set of financial data for the not-for-profit sector. The data comprises the Form 990s filed with the IRS. The link to the raw data file is: https://www.irs.gov/statistics/soi-tax-stats-annual-extract-of-tax-exempt-organization-financial-data Obtain the most recent dataset year via the link above. This exercise is based on the Form 990 Extract file. You will also need to obtain the Extraction Documentation which provides a basic description of the variables in the dataset. Please note that it may take a few minutes to download the dataset. Click here for a brief tutorial on Pivot Tables in Excel. Click here for a brief tutorial on Pivot Table Filters and Charts in Excel.

Part 1: Understand the Sector The first part of the project is to better understand the not-for-profit sector. Required: Utilizing the acquired data, answer the following questions:

1. What percentage of not-for-profit organizations report unrelated business income? (Round your answer to 1 decimal place.)

2. How many 501(c)(3) organizations are in the dataset?

3. Among the non 501(c)(3) organizations, which subsection has the most not-for-profit organizations?

4. What is the total number of employees in the not-for-profit sector?