All language subtitles for 11. Statistical Formulas Case Study

In this video you will learn how to use some of the common statistical functions in Excel.

Very loose a case study real estate.

There you it in the case study you will analyze the batting performance of studying Tendulkar.

Using the statistical functions in Excel this spreadsheet as setting the Lukas batting record in Test

matches the column he has runs scored by each inning.

The column B has mode of dismissal Column C has the innings first second third or fourth inning in the

Test match.

Column B has the opposition name and column he has the ground set in print.

A lot of Test matches.

So it is not surprising that his batting data has a lot of regard.

If you scroll down you can see that the batting record goes up to three hundred and thirty which means

if you take out the title role 13 played three hundred and twenty nine Test innings.

In that case study we look at data from all his three hundred and twenty nine Test innings.

Normally the performance of a batsman is analysed using his batting average but there are several other

statistical measures you can use to get more insight into a batsman its consistency and effectiveness.

In that case study the values were all batting average batting average excluding not out innings median

score.

Most frequent score highest score number of victories scored standard deviation and summary statistics

to evaluate such as performance.