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...
-
Determine the force in members JE and GF of the truss and state if these members are in tension or compression. Also, indicate all zero-force members. Units Used: kN = 103 N Given: F1 = 6kN F2 = 6kN...
-
Let's suppose that Lionel Messi had the chance to kick a soccer ball on the surface of Jupiter. Jupiter's gravity is about 2 5 m / s and Messi can kick a ball with a max speed of 3 5 m / s . If Messi...
-
During the inspection of a rejected integrated circuit (IC), it was observed that the rejected IC could have an incorrect circuit, it could be bent, or it could have both defects. The probability of...
-
On August 1, 2013, Sietens Corporation had the following account balances: Raw Material Inventory (both direct and indirect) ..... $ 72,000 Work in Process Inventory .............. 108,000 Finished...
-
Requirement 2. Compute the total costs of the units (gallons) (a) completed and transferred out to the Packaging Department, and (b) in the Blending Department ending Work-in-Process Inventory....
-
1. If MII sues CP in a state trial court for the losses it incurred, what would CPs likely defense be? 2. Discuss the significance of the fact that the original lease did not have an arbitration...
-
Find the Fourier approximation of the specified order of the function on the interval [0, 2n]. f(x) = 3n - 3x, third order g(x) = Need Help? Read It
-
A softball player slides into second base. Use the particle model to draw a motion diagram of the player from the time he begins to slide until he reaches the base. Number the dots in order, starting...
-
Determine closed-form expressions for the Levinson-Durbin reflection coefficients \(k_{1}, k_{2}\), and \(k_{3}\) as functions of \(R_{Y}(v)\).
-
Design the filter satisfying the following specifications using the minimax approach and show its submatrices of overlapped blocking filtering, for \(M=L=4\) and \(N=2\) :...
-
Find an \(N\) th-order AR approximation for the ARMA system \[H(z)=\frac{\left(1-0.8 z^{-1} ight)\left(1-0.9 z^{-1} ight)}{\left(1-0.5 z^{-1} ight)\left(1+0.5 z^{-1} ight)}\] and compare the...
-
Design the filter of Exercise 8.26 with the minimax approach and show its submatrices of overlapped blocking filtering for \(M=N=4\) and for \(L=2\). Exercise 8.26 Design the filter satisfying the...
-
1. A brake commonly used in railway trains is (a) shoe brake (c) band and block brake 2. A brake commonly used in motor cars is (a) shoe brake (c) band and block brake 3. The material used for brake...
-
The following selected accounts and normal balances existed at year-end. Notice that expenses exceed revenue in this period. Make the four journal entries required to close the books: Accounts...
-
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...
-
See the option quote on IBM from the CBOE Web site on the next page showing options expiring in March and April 2022. a. Which option contract had the most trades that day? b. Which option contract...
-
Two European call options with a strike price of \($50\) are written on two different stocks. Suppose that tomorrow, the low-volatility stock will have a price of \($50\) for certain. The...
-
It is February 21, 2022, and you have decided to purchase 10 June call contracts on eBays stock with an exercise price of \($57.50.\) Because you are buying, you must pay the ask price. How much...
Study smarter with the SolutionInn App