Create a new column called Average Donation that uses a formula to find how much money each project backer paid

Create a new column called Average Donation that uses a formula to find how much money each project backer paid

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

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