Create a new column called Average Donation that uses a formula to find how much money each
Fantastic news! We've Found the answer you've been seeking!
Question:
- Create a new column called Average Donation that uses a formula to find how much money each project backer paid on average. (I need the formula. The picture blow it’s the solution sheet but I need the formula. )
- Create two new columns, one called Parent Category and another called Sub-Category, that use formulas to split the Category and Sub-Category columns into the two new, separate columns. (I also need formula and how to do the rest)
Transcribed Image Text:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 A id ▼ 1 Odom Inc O Baldwin, Riley and Jackson 2 Melton, Robinson and Fritz 4 Larson-Little 3 Mcdonald, Gonzalez and Ross 5 Harris Group 7 Carter-Guzman 6 Ortiz, Coleman and Mitchell 8 Nunez-Richards 10 Green Ltd B name 9 Rangel, Holt and Jones. 12 Kim Ltd 11 Perez, Johnson and Gardner 13 Walker, Taylor and Coleman 14 Rodriguez, Rose and Stewart 16 Hines Inc 15 Wright, Hunt and Rowe 17 Cochran-Nguyen 18 Johnson-Gould 19 Perez-Hess 20 Reeves, Thompson and Richardson ▼ C blurb Pre-emptive tertiary standardization Managed bottom-line architecture Function-based leadingedge pricing structure core Vision-oriented fresh- thinking conglomeration Proactive foreground Open-source optimizing database Operative upward- trending algorithm Centralized cohesive challenge Exclusive attitude- oriented intranet Open-source fresh- thinking model Monitored empowering installation Grass-roots zero administration system engine Assimilated hybrid intranet Multi-tiered directional open architecture Cloned directional synergy Extended eco-centric pricing structure Cross-platform systemic adapter Seamless 4th generation methodology Exclusive needs-based adapter Down-sized cohesive archive Proactive composite alliance D goal 100 1400 108400 4200 7600 7600 5200 4500 110100 6200 5200 6300 6300 4200 28200 81200 1700 84600 9100 62500 131800 E pledged 0 14560 142523 2477 5265 13195 1090 14741 21946 3208 13838 3030 5629 10295 18829 38414 11041 134845 6089 30331 147936 F Percent Funded O failed outcome 1040 successful 131 successful 59 failed 69 failed 174 successful 21 failed 20 live 328 successful 52 failed G 266 successful 48 failed 89 failed 245 successful 67 failed 47 failed 649 successful 159 successful 67 canceled 49 failed 112 successful H backers_co Average Donat 0 158 1425 24 53 174 18 227 708 44 220 27 55 98 200 452 100 1249 135 674 1396 0 CA 92.15 US 100.02 AU 103.21 US 99.34 US 75.83 DK 60.56 GB 64.94 DK 31 DK 72.91 US 62.9 US 112.22 US 102.35 US 105.05 US 94.15 US 84.99 US 110.41 US 107.96 US 45.1 US 45 US 105.97 US country CAD USD AUD USD USD DKK GBP DKK DKK USD USD USD USD USD USD USD USD USD USD USD USD K currency L launched at 1448690400 1408424400 1384668000 1505278800 1565499600 1568955600 1439442000 1547964000 1548309600 1346130000 1347080400 1379566800 1281762000 1285045200 1571720400 1465621200 M deadline 1281330000 1281502800 1331013600 1450159200 1575957600 1408597200 1384840800 1294812000 1536382800 1505365200 1439614800 1383804000 1285909200 1285563600 1572411600 1466658000 1333342800 1390370400 1392271200 1576303200 1294898400 1537074000 1551679200 1553490000 1406523600 1406523600 N Date Created Conversion ▼ 11/28/15 8/19/14 11/17/13 8/11/19 1/20/19 8/28/12 9/13/17 8/13/15 /9/10 9/19/13 8/14/10 9/21/10 10/22/19 6/11/16 3/6/12 12/10/19 1/22/14 1/12/11 9/8/18 3/4/19 7/28/14 O Date Ended Conversion ▼ 12/15/15 8/21/14 11/19/13 9/20/19 1/24/19 9/8/12 9/14/17 8/15/15 8/11/10 11/7/13 10/1/10 9/27/10 10/30/19 6/23/16 4/2/12 12/14/19 2/13/14 1/13/11 9/16/18 3/25/19 7/28/14 P staff_pick FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE Q spotlight FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE category & sub-category food/food trucks. music/rock technology/web music/rock theater/plays theater/plays film & video/documentary theater/plays theater/plays music/electric music film & video/drama theater/plays R film & video/drama music/indie rock. music/indie rock technology/wearables publishing/nonfiction film & video/animation theater/plays theater/plays film & video/drama food music technology music theater theater Parent Category film & video theater theater music film & video theater film & video music music technology publishing film & video theater theater S film & video food trucks rock web rock plays plays documentary plays plays T Sub-Category electric music drama plays drama indie rock. indie rock wearables nonfiction animation plays plays drama 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 A id ▼ 1 Odom Inc O Baldwin, Riley and Jackson 2 Melton, Robinson and Fritz 4 Larson-Little 3 Mcdonald, Gonzalez and Ross 5 Harris Group 7 Carter-Guzman 6 Ortiz, Coleman and Mitchell 8 Nunez-Richards 10 Green Ltd B name 9 Rangel, Holt and Jones. 12 Kim Ltd 11 Perez, Johnson and Gardner 13 Walker, Taylor and Coleman 14 Rodriguez, Rose and Stewart 16 Hines Inc 15 Wright, Hunt and Rowe 17 Cochran-Nguyen 18 Johnson-Gould 19 Perez-Hess 20 Reeves, Thompson and Richardson ▼ C blurb Pre-emptive tertiary standardization Managed bottom-line architecture Function-based leadingedge pricing structure core Vision-oriented fresh- thinking conglomeration Proactive foreground Open-source optimizing database Operative upward- trending algorithm Centralized cohesive challenge Exclusive attitude- oriented intranet Open-source fresh- thinking model Monitored empowering installation Grass-roots zero administration system engine Assimilated hybrid intranet Multi-tiered directional open architecture Cloned directional synergy Extended eco-centric pricing structure Cross-platform systemic adapter Seamless 4th generation methodology Exclusive needs-based adapter Down-sized cohesive archive Proactive composite alliance D goal 100 1400 108400 4200 7600 7600 5200 4500 110100 6200 5200 6300 6300 4200 28200 81200 1700 84600 9100 62500 131800 E pledged 0 14560 142523 2477 5265 13195 1090 14741 21946 3208 13838 3030 5629 10295 18829 38414 11041 134845 6089 30331 147936 F Percent Funded O failed outcome 1040 successful 131 successful 59 failed 69 failed 174 successful 21 failed 20 live 328 successful 52 failed G 266 successful 48 failed 89 failed 245 successful 67 failed 47 failed 649 successful 159 successful 67 canceled 49 failed 112 successful H backers_co Average Donat 0 158 1425 24 53 174 18 227 708 44 220 27 55 98 200 452 100 1249 135 674 1396 0 CA 92.15 US 100.02 AU 103.21 US 99.34 US 75.83 DK 60.56 GB 64.94 DK 31 DK 72.91 US 62.9 US 112.22 US 102.35 US 105.05 US 94.15 US 84.99 US 110.41 US 107.96 US 45.1 US 45 US 105.97 US country CAD USD AUD USD USD DKK GBP DKK DKK USD USD USD USD USD USD USD USD USD USD USD USD K currency L launched at 1448690400 1408424400 1384668000 1505278800 1565499600 1568955600 1439442000 1547964000 1548309600 1346130000 1347080400 1379566800 1281762000 1285045200 1571720400 1465621200 M deadline 1281330000 1281502800 1331013600 1450159200 1575957600 1408597200 1384840800 1294812000 1536382800 1505365200 1439614800 1383804000 1285909200 1285563600 1572411600 1466658000 1333342800 1390370400 1392271200 1576303200 1294898400 1537074000 1551679200 1553490000 1406523600 1406523600 N Date Created Conversion ▼ 11/28/15 8/19/14 11/17/13 8/11/19 1/20/19 8/28/12 9/13/17 8/13/15 /9/10 9/19/13 8/14/10 9/21/10 10/22/19 6/11/16 3/6/12 12/10/19 1/22/14 1/12/11 9/8/18 3/4/19 7/28/14 O Date Ended Conversion ▼ 12/15/15 8/21/14 11/19/13 9/20/19 1/24/19 9/8/12 9/14/17 8/15/15 8/11/10 11/7/13 10/1/10 9/27/10 10/30/19 6/23/16 4/2/12 12/14/19 2/13/14 1/13/11 9/16/18 3/25/19 7/28/14 P staff_pick FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE Q spotlight FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE category & sub-category food/food trucks. music/rock technology/web music/rock theater/plays theater/plays film & video/documentary theater/plays theater/plays music/electric music film & video/drama theater/plays R film & video/drama music/indie rock. music/indie rock technology/wearables publishing/nonfiction film & video/animation theater/plays theater/plays film & video/drama food music technology music theater theater Parent Category film & video theater theater music film & video theater film & video music music technology publishing film & video theater theater S film & video food trucks rock web rock plays plays documentary plays plays T Sub-Category electric music drama plays drama indie rock. indie rock wearables nonfiction animation plays plays drama
Expert Answer:
Answer rating: 100% (QA)
Formula To calculate the Average Donation you can use the following formula in Excel Sheet for each row where you want to calculate it You can place t... View the full answer
Related Book For
Foundations of Financial Management
ISBN: 978-1259024979
10th Canadian edition
Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen, Doug Short, Michael Perretta
Posted Date:
Students also viewed these programming questions
-
Make a simpe java code that asks if you are 18+ using arrays. MAKE SURE TO USE ARRAYS the question could be " Are you 18?" type accept or decline and if they hit accept connect to this code:...
-
A manufacturer purchases a part for use at both of its plants-one at Roseville, California, the other at Akron, Ohio. The part is available in limited quantities from two suppliers. Each supplier has...
-
On April 23, 2022, Protanica Company, a florist, purchased $112,000 of merchandise, terms were 3/15, n/45 from Botail Garden Center. Protanica returned $7,500 of damaged merchandise to Botail, which...
-
In the OKR goal-setting framework, what is the difference between objectives and key results? Objectives deal with measurable aspects of a company's processes, while key results deal with...
-
What is the evidence that dark matter exists?
-
In April 2023, Brangre Saunier, editor of The Sporting News (SN), decides to reduce the price per newspaper from 0.70 in April 2023 to 0.50 starting 1 May 2023. Actual paid circulation in April is...
-
Transfer Pricing The Leviathan Steel Company has a coal-mining subsidiary in West Virginia. A substantial amount of the coal produced by the subsidiary is used by Leviathan's steel foundries located...
-
Island Novelties, Inc., of Palau makes two products, Hawaiian Fantasy and Tahitian Joy. Present revenue, cost, and sales data for the two products follow: Fixed expenses total $475,800 per year. The...
-
Can you explain this one? Question 3 AAA Corp. has a current stock price of $30 per share, is expected to pay a dividend of $1.20 in one year, and its expected price right after paying that dividend...
-
Following are the income statement and balance sheet for Medtronic PLC. Consolidated Statement of Income, 12 Months Ended ($ millions) April 26, 2019 Net Sales $30,557 Costs and expenses Cost of...
-
description of the tests and assessments currently in use? how they are used in intervention planning of Domestic violence victims? reference, citation, answer each question and explanation, please
-
1. Open your wallet and check how much money you have. (I have 2,000 pesos) Ask your Mom or Grandparents if what she/he can buy with the money today and when she was 20 years old. Give five examples....
-
1.The following information pertains to Boomerang Company's direct labor for March: Standard DL hours-21,000; Actual DL hours - 20,000; Labor rate variance - P8,400 Favorable; Standard labor rate /...
-
"Capital budgeting has the same focus as accrual accounting." Do you agree? Explain you answer.
-
What methodologies can be used to assess the conciseness of academic writing, and how can scholars balance the demands for thoroughness with the need for succinct articulation of complex concepts ?
-
What do you understand by the title of the video - "Culture Eats Strategy for Breakfast"? Discuss the relevancy of culture and strategy in Human Resources, particularly in recruitment and selection....
-
The comparative balance sheets for 2 0 2 4 and 2 0 2 3 and the statement of income for 2 0 2 4 are given below for National Intercable Company. Additional information from NIC s accounting records is...
-
For the following exercises, write the first four terms of the sequence. a n = 2 n 2
-
Why does the starting level of sales determine the degree of operating leverage (DOL) rather than the ending level of sales?
-
Why do corporate executives consider a stable dividend policy important?
-
Manpower Electric Company has 7 percent convertible bonds outstanding. Each bond has a $1,000 par value. The conversion ratio is 25, the stock price is $38, and the bonds mature in 16 years. a. What...
-
What is meant by refunding?
-
The Merton Manufacturing Co Ltd has been in business for many years making fitted furniture and chairs. During 2004 and 2005 substantial losses have been sustained on the manufacture of chairs and...
-
A company retired a bond issue early, at a loss. Is the company in an economically worse position after the retirement?
Study smarter with the SolutionInn App