14.2 Excel Activity 2a - Scatter Diagram, Regression Equation, and Residual Analysis (Structured)

Charity Navigator is America's leading independent charity evaluator. The data in the Excel Online file below show the total expenses ($), the percentage of the total budget spent on administrative expenses, the percentage spent on fundraising, and the percentage spent on program expenses for 10 supersized charities. Administrative expenses include overhead, administrative staff and associated costs, and organizational meetings.

Fundraising expenses are what a charity spends to raise money, and program expenses are what the charity spends on the programs and services it exists to deliver.

The sum of the three percentages does not add to 100% because of rounding. Construct a spreadsheet to answer the following questions.

PLEASE SEE THE DATA IN GOOGLE DRIVE, THE LINK IS BELOW

https://docs.google.com/document/d/e/2PACX-1vTkFMBWXke_hY2JCoYDM-mFU1mj6Q4IdFuLN6RRDJrA_koDRrhwpJI3XGIaGyyPpXktemTdirSRDTYf/pub

PLEASE SEE THE DATA IN GOOGLE DRIVE, THE LINK IS BELOW