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. Charity # Charity Total Expenses ($) Administrative Expenses (%) Fundraising Expenses (%) Program Expenses (%) 1 American Red Cross 3355147520 3.8 3.9 92.1 2 World Vision 1200410940 3.8 7.6 88.4 3 Smithsonian Institution 1078888839 23.3 2.6 73.7 4 Food For the Poor 1049069977 0.7 2.2 96.7 5 American Cancer Society 1006600565 5.8 22.2 71.5 6 Volunteers of America 927343532 8.4 1.8 89.6 7 Dana-Farber Cancer Institute 876424648 13.0 1.4 85.4 8 AmeriCares 850339452 0.5 0.6 98.6 9 ALSAC - St. Jude Children's Research Hospital 830736527 9.5 16.9 73.2 10 City of Hope 736275633 13.6 2.8 83.2

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

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.

Charity # Charity Total Expenses ($) Administrative Expenses (%) Fundraising Expenses (%) Program Expenses (%)
1 American Red Cross 3355147520 3.8 3.9 92.1
2 World Vision 1200410940 3.8 7.6 88.4
3 Smithsonian Institution 1078888839 23.3 2.6 73.7
4 Food For the Poor 1049069977 0.7 2.2 96.7
5 American Cancer Society 1006600565 5.8 22.2 71.5
6 Volunteers of America 927343532 8.4 1.8 89.6
7 Dana-Farber Cancer Institute 876424648 13.0 1.4 85.4
8 AmeriCares 850339452 0.5 0.6 98.6
9 ALSAC - St. Jude Children's Research Hospital 830736527 9.5 16.9 73.2
10 City of Hope 736275633 13.6 2.8 83.2 
Looking at the data, do there appear to be any outliers and/or influential observations?
The scatter diagram does
indicate potential influential observation(s). If there are potential influential
observations, select the corresponding numbers of charity organizations as indicated in the Excel Online file above. If there
are no potential influential observations, select "None".
5.9
The scatter diagram does
indicate potential outlier(s).
If there are potential outliers, select the corresponding numbers of charity organizations as indicated in the Excel Online file
above. If there are no potential outliers, select "None".
3
b. Develop an estimated regression equation that could be used to predict program expenses (%) given fundraising expenses
(%).
Program Expenses % (pred)
]Fundraising Expenses (%) (to 2 decimals)
c. Does the value for the slope of the estimated regression equation make sense in the context of this problem situation?
The slope of the estimated regression equation is
Thus, for every 1% increase in the amount spent on
fundraising the percentage spent on program expresses will decrease V
by
%%. The negative
slope
and value seem to make sense in the context of this problem situation (to 2 decimals).
d. Use residual analysis to determine whether any outliers and/or influential observations are present. Briefly summarize your
findings and conclusions.
Observation
is an outlier because it has the largest absolute value of the standardized residual.
is an influential observation because it has the highest leverage.
Observation
Transcribed Image Text:Looking at the data, do there appear to be any outliers and/or influential observations? The scatter diagram does indicate potential influential observation(s). If there are potential influential observations, select the corresponding numbers of charity organizations as indicated in the Excel Online file above. If there are no potential influential observations, select "None". 5.9 The scatter diagram does indicate potential outlier(s). If there are potential outliers, select the corresponding numbers of charity organizations as indicated in the Excel Online file above. If there are no potential outliers, select "None". 3 b. Develop an estimated regression equation that could be used to predict program expenses (%) given fundraising expenses (%). Program Expenses % (pred) ]Fundraising Expenses (%) (to 2 decimals) c. Does the value for the slope of the estimated regression equation make sense in the context of this problem situation? The slope of the estimated regression equation is Thus, for every 1% increase in the amount spent on fundraising the percentage spent on program expresses will decrease V by %%. The negative slope and value seem to make sense in the context of this problem situation (to 2 decimals). d. Use residual analysis to determine whether any outliers and/or influential observations are present. Briefly summarize your findings and conclusions. Observation is an outlier because it has the largest absolute value of the standardized residual. is an influential observation because it has the highest leverage. Observation
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 6 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman