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 #CharityTotal Expenses ($)Administrative Expenses (%)Fundraising Expenses (%)Program Expenses (%)1American Red Cross33551475203.83.992.12World Vision12004109403.87.688.43Smithsonian Institution107888883923.32.673.74Food For the Poor10490699770.72.296.75American Cancer Society10066005655.822.271.56Volunteers of America9273435328.41.889.67Dana-Farber Cancer Institute87642464813.01.485.48AmeriCares8503394520.50.698.69ALSAC - St. Jude Children's Research Hospital8307365279.516.973.210City of Hope73627563313.62.883.2 Looking at the data, do there appear to be any outliers and/or influential observations?The scatter diagram doesindicate potential influential observation(s). If there are potential influentialobservations, select the corresponding numbers of charity organizations as indicated in the Excel Online file above. If thereare no potential influential observations, select "None".5.9The scatter diagram doesindicate potential outlier(s).If there are potential outliers, select the corresponding numbers of charity organizations as indicated in the Excel Online fileabove. If there are no potential outliers, select "None".3b. 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 isThus, for every 1% increase in the amount spent onfundraising the percentage spent on program expresses will decrease Vby%%. The negativeslopeand 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 yourfindings and conclusions.Observationis an outlier because it has the largest absolute value of the standardized residual.is an influential observation because it has the highest leverage.Observation

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 #CharityTotal Expenses ($)Administrative Expenses (%)Fundraising Expenses (%)Program Expenses (%)1American Red Cross33551475203.83.992.12World Vision12004109403.87.688.43Smithsonian Institution107888883923.32.673.74Food For the Poor10490699770.72.296.75American Cancer Society10066005655.822.271.56Volunteers of America9273435328.41.889.67Dana-Farber Cancer Institute87642464813.01.485.48AmeriCares8503394520.50.698.69ALSAC - St. Jude Children's Research Hospital8307365279.516.973.210City of Hope73627563313.62.883.2 Looking at the data, do there appear to be any outliers and/or influential observations?The scatter diagram doesindicate potential influential observation(s). If there are potential influentialobservations, select the corresponding numbers of charity organizations as indicated in the Excel Online file above. If thereare no potential influential observations, select &#34;None&#34;.5.9The scatter diagram doesindicate potential outlier(s).If there are potential outliers, select the corresponding numbers of charity organizations as indicated in the Excel Online fileabove. If there are no potential outliers, select &#34;None&#34;.3b. 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 isThus, for every 1% increase in the amount spent onfundraising the percentage spent on program expresses will decrease Vby%%. The negativeslopeand 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 yourfindings and conclusions.Observationis an outlier because it has the largest absolute value of the standardized residual.is an influential observation because it has the highest leverage.Observation

Accepted Answer

Given Charity Navigator is America's leading independent charity evaluator. 
We should find the…

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