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.
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.
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
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.
Transcribed Image Text:-10
5,9 î
3
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".
↑
10
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".
Observation
Observation
15
20
Fundraising Expenses (%)
Check My Work
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
decrease ♥
by
%. The negative
d. Use residual analysis to determine whether any outliers and/or influential observations are present. Briefly summarize your findings and conclusions.
is an outlier because it has the largest absolute value of the standardized residual.
is an influential observation because it has the highest leverage.
25
Reset Problem
Thus, for every 1% increase in the amount spent on fundraising the percentage spent on program expresses will
slope and value seem to make sense in the context of this problem situation (to 2 decimals).
Transcribed Image Text:Excel
08
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
File
33
34
35
A
3
Charity #
1
2
4
5
6
7
8
template - Saved
9
10
Home
V
Insert
Arial
B
Charity
American Red Cross
World Vision
fx
Smithsonian Institution
Food For the Poor
American Cancer Society
Volunteers of America
Draw
Dana-Farber Cancer Institute
AmeriCares
ALSAC - St. Jude Children's
Research Hospital
City of Hope
Page Layout
✓ 10
C
Total
Expenses ($)
3359168915
1207468361
1079407702
1050324444
1002369767
929240735
875039080
852448894
831394643
734900566
Calculation Mode: Automatic Workbook Statistics
B
Formulas
12.9
0.4
O Search (Option + Q)
9.4
13.7
✓ ✓
D
E
Administrative Fundraising
Expenses (%) Expenses (%)
3.9
3.9
3.8
7.3
23.5
2.4
0.6
2.2
6.0
22.1
8.6
1.9
Data
1.6
0.6
16.9
2.8
Review
F
Expenses
(%)
= Data Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheet8
92.3
88.1
73.5
96.8
71.6
89.7
85.3
98.8
73.5
83.3
+
=
G
View
V
ab
H
Help
General
Part a.
Use the area below to develop a scatter diagram.
←.0
.00
J
.00
→.0
K
L
M
Editing ✓
Σ✓ ATV O
Part b.
After reading these instructions delete all text in this shaded area.
Use the XLMiner Analysis ToolPak to conduct your Linear Regression analysis.
After deleting all text in this shaded area, set the output range in the ToolPak to the top left cell of this area (H21).
Your Linear Regression analysis output should include Residuals, Residual Plots, and Standardized Residuals.
Your Linear Regression analysis output should fit into this shaded area.
N
Give Feedback to Microsoft
Comments
O
I
P
90% +
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 12 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman