PART D TO BE ANSWERED!Thank you! Charity Navigator is America's leading independent charity evaluator. The following data show the total expenses ($), the percentage of the total budget spent on administrative expenses, the percentage spent on fundraising, and thepercentage spent on program expenses for 10 supersized charities (Charity Navigator website). Administrative expenses include overhead, administrative staff and associated costs, and organizational meetings. Fundraising expenses arewhat 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. Do not round yourintermediate calculations.TotalAdministrative Fundraising ProgramExpensesExpensesExpenses ExpensesCharity(millions of $)(%)(%)(%)1 American Red Cross33523.93.992.22 World Vision12103.87.888.63 Smithsonian Institution108223.52.673.64 Food For The Poor10490.82.296.55 American Cancer Society10045.922.271.96 Volunteers of America9328.41.889.37 Dana-Farber Cancer Institute87512.91.785.38 AmeriCares8530.40.598.99 ALSAC-St. Jude Children's8319.516.773.5Research Hospital10 City of Hope73513.72.983.2a. Select a scatter diagram with fundraising expenses (%) on the horizontal axis and program expenses (%) on the vertical axis.A.В.Program expenses(%)Program expenses(%)120-120-100-10080-806060-60-60-40-40-20-20-1520Fundraising expenses (%)1020Fundraising expenses (%)15251025C.D.Program expenses(%)Program expenses(%)120-120-100100-80-8060-6040-40+20-20-20Fundraising expenses (%)10152510152025Fundraising expenses (%) Looking at the data, do there appear to be any outliers and/or influential observations?The scatter diagram doesv indicate potential influential observation(s). If there are potential influential observations enter the number of charity organizations as indicated in the table above separated by commas as needed. If there are no potentialinfluential observations leave the input box blank. For example if you think that the answer is American Red Cross enter 1.5,9The scatter diagram doesv indicate potential outlier(s). If there are potential outliers enter the number of charity organizations as indicated in the table above separated by commas as needed. If there are no outliers leave the input box blank. Forexample if you think that the answer is American Red Cross enter 1.b. Develop an estimated regression equation that could be used to predict program expenses (%) given fundraising expenses (%).Program Expenses (%) =90.940.90 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? Enter negative values as negative numbers.The slope of the estimtaed regression equation is-0.90Thus, for every 1% increase in the amount spent on fundraising the percentage spent on program expenses will decreasev by-0.90 %; in other words, just a little under 1%. Thenegativev 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. Round to 3 decimals and enter negative value as negative numbers, if necessary.# CharityStandard ResidualsLeverage1 American Red Cross2 World Vision3 Smithsonian Institution4 Food For The Poor5 American Cancer Society6 Volunteers of America7 Dana-Farber Cancer Institute8 AmeriCaresALSAC-St. Jude Children's9 Research Hospital10 City of HopeObservationis an outlier because it has a large standardized residual.Observationis an influential observation because it has high leverage.

Question

Accepted Answer

d)  The step by step procedure to calculate the standardized residuals using Excel is given…