All language subtitles for 8. Information Formulas Case Study - Solution

In this way do they really use information formulas to calculate more information about sat disbanding.

The first thing we calculate is the number of banks that invested in first and third innings.

Very loose columns to store this information for each innings that in batting Column C indicates the

innings number where they do us first inning second innings third innings or fourth innings values Column

F to store information whether dining was first our third eye to our second or fourth values is odd

function to determine if dining was ordered even if their score corresponds to constant third innings.

It would be an odd inning if this cork responds to a second or fourth innings it's an evening.

For example the first rule here is scored for second innings of a test.

So this is an even innings when we use the exact function for this role.

It should be done.

For second row the ending number is 1.

So it's an odd innings when a youth is our function for second row.

It should be done through select left to and and done is on and we are going to test the column see

to select C2 which corresponds to this row close record and press center.

You can see if now says false because it's empty even innings.

Let us know copy Sal F2 and pasted the rest of the rows for each inning so we pasted Dale F three hundred

thirty.

Now we have information about each inning in terms of true or false in column F if dining is out.

The column reads through if dining is even it reads false.

Next we'll calculate the number of our innings that set in Baghdad in Dart innings on first and third

innings.

Select sell i.e. it.

We will use that counting function to count the number of rows in column F which are true.

So enter Countess

in the end.

We enter F2 to F three thirty and that criteria we are trying to test for is true.

So counting function will return the count of rows in column F where the value is equal to true so you

can see that that didn't back it in.

Hundred and sixty three innings which are already innings let us use the same formula to calculate how

many times that in batted in second or fourth innings.

So we'll again use that bounty dysfunction

the rent is again F to do f TTP and that basic idea this time is false because we are testing for U

N innings

they can see that in Baghdad 166 times in even innings next really calculate the number of runs something

is scored when batting in either first or third innings to do that they will use that sum function so

let us use some if

we need to first test whether dining was ordered even and then I up this call for that.

If it matches that criteria.

First let us test if the inning he batted in while the ordaining and this information is stored in then

F2 through F 330 that idea we are looking for is true.

If this cell is blue then it means it's a ordaining in a faster third innings.

And the range we want to add up is in a two to a T today which as it is batting scores press enter.

Now you can see that Serkis scored eight thousand six and earned four runs batting either in first or

third innings let us use the same formula to calculate runs scored in second and fourth innings then

once again is F2 through F 330 and this time that this great data is false because we are looking for

an even innings

and the summit end is a two to three thirty.

Now you can see that I scored seven thousand three hundred seventeen runs batting any second or fourth

innings which is considerably less than what you scored batting in first or third innings.

Finally let us calculate average of settings batting in first and third innings to do that will simply

divide the number of runs they scored in first and third innings by the number of times he battled in

first or third innings.

You can see as I read fifty two point seven eight.

Now let us calculate his batting average on batting second and fourth innings.

Select sell I 18 and enter the formula which will be the number of runs he scored in second and fourth

innings divided by the number of cases about it in second and fourth innings and this average is forty

before.

You can see that settings batting average was considerably lower when embedded in second or fourth innings.