8.3 Creating an Athletic Competition Starting List Part 1
8 hours 33 minutes
So in this exercise we have, ah, results off semifinals
men's 100 meter race competition.
And there were three races, three heats
and in each there were eight competitors, and the rules for qualifying into finals are
that 1st 2 in each race get qualified by position
and out off remaining
18 competitors. That's court in their races between third and eighth place
two will be selected based on best results. So, out of these 16 we have to pick two with best
results, meaning the lowest ones.
And they will also get qualified to the
do the final race. Now, um,
we have these results
expecting that they are different,
all of them within one race. So it is possible that two competitors to two athletes will have the same result. But then the photo finish will decide who is
better out of these two.
we're is going to assume that they are
all different, because if they were all the same, then the referees would correct the rink manually. So we're going to do it just like they're different
and, uh, so, so determined ranking.
We have to look a tw three groups off eight competitors. So this is the first race, second race and third race
and look a TTE
their results for that. We're going to use if and large functions combined together. So if you remember large functions, looks at the range
and returns the
value that is on the end position,
10th position and number and his second perimeter in the function definition. So let's see how it works. So you were going to say, If
so the result of this competitors
if it's equal to large
this range here.
So if three to F 10
it's all right.
And, ah, we want to find who's number one. So we say
it's the eighth position because the lowest is the better best.
And it's always,
uh, large is always
looking in the order higher, highest to lowest
because it's large.
And in that case, if that's true,
we're going to put here rank number one.
If not, we're going to continue with this and we're going to say if and then
this cell here
so again F three equals
now we're going just to do some corrections. We have to put a dollar sign here because we're going to copy this election and we want throws to remain a changed,
and then we're going to
just copy D's.
So if after e equals
large off that and now we're looking
at the Position seven
and then the result will be, too.
We're going to
If if that is not the case, were again starting with. If so, we're going to copy all off this
because it's going to stay the same.
if large and then just now the position is going to be six.
And if that's the case, is going to be number three
and then again if
and is going to be five.
I'm sorry, four.
Then again if
and it's going to be six
and again if
and it's going to be
seven and two
and now no more ifs, because if it's not 1234567 57 position,
then it's going to be sorry we made a mistake and typing. So it's 123
and we have those. We were here eight and it's 17 It's too
sixes, 35 is four, and then here he should have Bean four and five
on. Then it should be
And it should be like this and to
no, sorry if it's going to be four and then five.
it's going to be six
the last one.
if it's going to be
then it's going to be seven and then Indy and eight. So you see, this is complicated. You can make a mistake typing this, so you should put it on paper first.
It's now we just close up all the brackets and it's very nice that Excel will give us
color coding off these brackets. So we finished with the black one and re presenter, and now we got
ranking of this one
just expanded here, and we got here and to know that were correct to to check If we're correct, we'll get 12345678 So all of them will be there.
And now we're going to just copy this for
this one. It's not just not going to be 3 to 10
it's going to be 11 2
and we're going to select this
and just compete all over
everything, Gale sustained. Same.
You hear? A swell.
You're a swell
here. A swell.
So just to check every 11 18 all the way through.
So where is the stake?
this is it.
And then we're going to expand this for all these eight. Again. We have 12345678
And then Ridge is going to copy this
and corrected. So it's now going to be 19
and we just have to do some copying.
and seven occurrence of this
we expand this. And now we got rankings for each race.
So let's continue in next video.
Data Analyst Excel
The Data Analyst Excel Test is a premium Cybrary assessment created by iMocha and intended ...
Monitor a Web App
In this IT Pro challenge, participants get hands-on experience activating server logging and using Application ...
Learn On Demand