Predicting Charity Expenses. 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 the percentage 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 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.
Source: Charity Navigator website, (https://www.charilynavigator.org/)
- a. Develop a
scatter diagram with fundraising expenses (%) on the horizontal axis and program expenses (%) on the vertical axis. Looking at the data, do there appear to be any outliers and/or influential observations? - b. Develop an estimated regression equation that could be used to predict program expenses (%) given fundraising expenses (%).
- c. Does the value for the slope of the estimated regression equation make sense in the context of this problem situation?
- d. Use residual analysis to determine whether any outliers and/or influential observations are present. Briefly summarize your findings and conclusions.
Want to see the full answer?
Check out a sample textbook solutionChapter 14 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
- A responsibility accounting system measures the performance of each of the following centers except 16 Multiple Cholce Ask Control center. Cost center. Profit center. Investment center.arrow_forward%24 %24 T %24 3. 3. 2. 5 2. 2. 2. R %24 3. 23 316 Business & PIC Spreadsheet Assignment 2012 Value 2013 Value 2014 Value 1=North Country Region 2011 Value and South Canada 1. $16,290.00 $15,395.00 $16,863.00 $17,064.00 America $ 2,611.00 $ 2,606.00 $ 2,202.00 $ 2,875.00 2-Asia & $ 741.00 2$ $10,790.00 $ 1,108.00 $ 1,053.00 $ 833.00 zea Hong Kong East $ 8,109.00 $ 8,897.00 $ 9,310.00 3=Europe Israel $ 5,133.00 $ 4,469.00 $ 5,226.00 $ 6,367.00 $ 4,286.00 $ 2,482.00 $ 4,291.00 $ 2,520.00 China $ 4,459.00 $ 5,033.00 2. India $ 2,748.00 $ 2,026.00 2. United Arab Emirates $ 1,517.00 $ 1,636.00 $ 2,013.00 $ 1,921.00 Japan $ 2,519.00 $2,254.00 $ 2,089.00 $1,902.00 2. Netherlands $ 2,187.00 $ 1,505.00 $1,491.00 $ 1,279.00 2. Taiwan $ 1,248.00 763.00 844.00 744.00 905.00 24 761.00 846.00 Turkey 739.00 Thailand 24 502.00 467.00 517.00 Saudi Arabia 597.00 572.00 24 Australia 987.00 $ 1,017.00 2$ $ 6,498.00 932.00 Switzerland $ 5,007.00 $10,042.00 $ 8,744.00 3. United Kingdom $ 6,514.00 $ 6,549.00…arrow_forwardB and carrow_forward
- According to Zillow.com, the median sale price for homes in January for South Carolina, California, and Virginia over the last three years is given in the table below (measured in $100,000). able South Carolina California Virginia 2018 183 534 98 2019 193 555 94 2020 216 569 85 In South Carolina, realtors take 5.4% of the sale price on average as part of their commission. The average realtor commission rates in California and Virginia are 4.9% and 5.3%, respectively. Use matrix multiplication to find the total earned by realtors from their commissionsarrow_forwardPLEASE ANSWER THIS QUESTION WITHIN 30 MINUTESarrow_forwardMeet 'Em and Plead 'Em Recommendations vs. reality. Time a public defender should spend on caseload annually Felonies Misdemeanors Juvenile Appeals 0 1,000 500 Note: Recommendations based on National Advisory Council on Criminal Justice Standards and Goals, 2007 Source Bureau of Justice Statistics Average hours needed Average hours available 1,500 2,000 10. Describe the trend depicted in this chart Mother Jones 11. What does this reveal about the nation's public defender service? * ice of Gideon y Wainwright-thatarrow_forward
- Please answer ASAP. Thank you!arrow_forwardSleep Late, a large hotel chain, has been using activity-based costing to determine the cost of a night’s stay at their hotels. One of the activities, “Inspection,” occurs after a customer has checked out of a hotel room. Sleep Late inspects every 10th room and has been using “number of rooms inspected” as the cost driver for inspection costs. A significant component of inspection costs is the cost of the supplies used in each inspection Mary Adams, the chief inspector, is wondering whether inspection labor-hours might be a better cost driver for inspection costs. Mary gathers information for weekly inspection costs, rooms inspected, and inspection labor-hours as follows: Q.Plot the data and regression line for rooms inspected and inspection costs. Plot the data and regression line for inspection labor-hours and inspection costs. Which cost driver of inspection costs would you choose? Explain.arrow_forwardSwain Athletic Gear (SAG) operates six retail outlets in a large Midwest city. One is in the center of the city on Cornwall Street and the others are scattered around the perimeter of the city. Management at SAG is concerned about declining sales and profitability of the Cornwall store and believes that outlet has been a drag on profits in recent years. The most recent income statement for the Cornwall store follows. SWAIN ATHLETIC GEAR Cornwall Street Store Income Statement For the Year Ending February 28 Sales revenue $ 12,300,000 Costs Cost of goods sold $ 5,289,000 Advertising 1,421,000 Store administrative salaries 975,000 Sales commissions 1,056,000 Leases and utilities 2,100,000 Allocated corporate support 1,622,000 Total costs $ 12,463,000 Net loss before tax benefit $ (163,000) Tax benefit at 25% (40,750) Net loss $ (122,250) The CFO at SAG has asked for your advice on closing the Cornwall Street store. If the Cornwall Street store is…arrow_forward
- Complete the chase production plan, using the following information. The only costs you need to consider here are layoff, hiring, and inventory costs. If you complete the plan correctly, your hiring, layoff, and inventory costs should match those given here. Click the icon to view the costs table. Click the icon to view the forecasted sales. Fill in the production plan table below (enter your responses as whole numbers). More Info Totals Costs Cost of plan Month March Planning values Starting inventory Starting and ending workforce Hours worked per month per worker Hours per unit Hiring cost per worker Layoff cost per worker Monthly per-unit holding cost Print Forecasted sales 1,917 Sales in to meet worker sales hours average = 253 Layoff 256 $256,000 Done Hiring Inventory 256 18,000 $18,000 $1,024,000 $1,298,000 1,500 209 315 35 $4,000 $1,000 $1 Actual workers 209 Actual production Layoffs Hiring More Info Ending inventory 1,500 Month March April May June July August September October…arrow_forwardMost Expensive Colleges Listed below are the annual costs (dollars) of tuition and fees at the 10 most expensive colleges in the United States for a recent year (based on data from U.S. News & World Report). The colleges listed in order are Columbia, Vassar, Trinity, George Washington, Carnegie Mellon, Wesleyan, Tulane, Bucknell, Oberlin, and Union. What does this “top 10” list tell us about those costs for the population of all U.S. college tuitions?arrow_forwardWhy does a business cycle diagram serve as a forestcating modelarrow_forward
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman