-10 3 15 20 Fundraising Expenses (%) 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 € ✔ 10 The scatter diagram does e 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 25 ✔ 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. Observation 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). is an influential observation because it has the highest leverage.
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.
![5,9
-10
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
Observation
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
20
Fundraising Expenses (%)
Check My Work
15
↑
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).](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fbc3ad949-79b2-4a66-83f9-922936cf2321%2F7c590c1b-f141-4a3e-93a4-7d8e90304b6c%2Fm627k1_processed.png&w=3840&q=75)
![Excel template - Saved
File
5
S10
123456789
10
11
12
13
14
15
16
17
18
19
20
21
22
4
A
Charity #
123 500
4
6
7
Home
8
9
10
Insert
Arial
B
fx
Charity
American Red Cross
World Vision
Draw Page Layout
Smithsonian Institution
Food For the Poor
American Cancer Society
Volunteers of America
Dana-Farber Cancer Institute
AmeriCares
ALSAC - St. Jude Children's
Research Hospital
City of Hope
✓10
V
с
Total
Expenses ($)
B
3355977946
1206722938
1082591716
1049106059
1006407437
927122720
875544781
853233478
829344923
734258906
Formulas
V
D
Administrative
Expenses (%)
3.7
4.0
23.7
0.7
6.0
8.7
13.2
0.5
9.6
13.4
Search (Option + Q)
Data
Review
E
Fundraising
Expenses (%)
3.9
7.3
2.5
2.2
22.4
1.7
1.6
0.8
16.7
3.1
View
F
Expenses
(%)
92.2
88.0
73.5
96.6
71.5
89.3
85.3
98.7
73.3
83.0
ab
G
Help
General
H
I
>
←.0
.00
.00
→→.0
K
▬▬▬▬](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fbc3ad949-79b2-4a66-83f9-922936cf2321%2F7c590c1b-f141-4a3e-93a4-7d8e90304b6c%2F7dk7z8_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 7 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![Elementary Statistics: Picturing the World (7th E…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
![Introduction to the Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)