Eco Prac Excel Function

0.0(0)
Studied by 3 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/8

encourage image

There's no tags or description

Looks like no tags are added yet.

9 Terms

1
New cards

Average life span

=AVERAGE(dataset)

2
New cards

Male life span

=if(datapoint=”m”,lifespan,““)

3
New cards

Average Lifespan of Male <1950

=AVERAGEIFS(lifespan,sex,”m”,deathyear,“<1950“)

4
New cards

Dx

=COUNTIF(dataset,”>=”&O4)-COUNTIF(dataset,”>=”&O5)

5
New cards

Nx

nx-1 - dx-1

6
New cards

lx

nx/total

7
New cards

qx

dx/nx

8
New cards

%dx

dx/total * 100

9
New cards

Neg % male deaths for graph

%dx * -1