-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.

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
100%

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).
Transcribed Image Text: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).
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
▬▬▬▬
Transcribed Image Text: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 ▬▬▬▬
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 7 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