Python for Data Science - Basics, Descriptive Statistics, Hypothesis Tes...

This video focuses on Basics of Python for Data Science. Descriptive Statistics including Measures of Central Tendency, Dispersion, Asymmetry and Relationship. Hypothesis Test covered are 2 Sample Independent Ttest, Anova Single Factor, Chi Square Test of Independence. The video also covers Label Encoding, splitting the data frames. Regression models like Multiple Linear Regression, Decision Tree and Random Forest

MODE, MODE.MULT,MODE.SNGL - Descriptive Statistics using Microsoft Excel Statistical Functions - Measures of Central Tendency

The practice sheet can be downloaded from Link. Statistics Marks Data - Download Sheet

About the Data Sheet - The data in this sheet is related to marks scored by 100 Students in a Statistical Test. 

Based on the data, we will use Microsoft Excel Statistical functions to analyse the descriptive statistics. 

In the Data Sheet, we have Data from A2:A101, A1 being the header of the Data. 

MODE

A statistical term that refers to the most frequently occurring number found in a set of numbers.

The mode is found by collecting and organizing the data in order to count the frequency of each result. The result with the highest occurrences is the mode of the set.

= MODE(number1,[number2],...])

In the Data Sheet, we have Data from A2:A101, A1 being the header of the Data. 

=MODE(A2:A101)

Result is 80

9 Students got 80 marks and since 80 is the most frequently occurring number in the data set it is identified as mode.

The MODE.SNGL and the MODE.MULT functions both find the statistical mode (the most commonly occurring value (or values) of a supplied set of numbers).

The difference between the functions occurs when the supplied data set has more than one mode. The Mode.Sngl function returns the lowest of these values, whereas the Mode.Mult function returns an array of all of the modes. 

Mean or Arithmetic Mean or Average - Descriptive Statistics using Microsoft Excel Statistical Functions - Measures of Central Tendency

The practice sheet can be downloaded from Link. Statistics Marks Data - Download Sheet

About the Data Sheet - The data in this sheet is related to marks scored by 100 Students in a Statistical Test. 

Based on the data, we will use Microsoft Excel Statistical functions to analyse the descriptive statistics. 

Mean or Arithmetic Mean or Average

The mean, also referred to by statisticians as the average, is the most common statistic used to measure the center of a numerical data set.

The mean is the sum of all the values in the data set divided by the number of values in the data set. 

The mean of the entire population is called the population mean, and the mean of a sample is called the sample mean.

The mean may not be a fair representation of the data, because the average is easily influenced by outliers (very small or large values in the data set that are not typical).

In Microsoft Excel there is no mean function, we use AVERAGE Function 

=AVERAGE(number1, [number2],...)

Returns the average (arithmetic mean) of the Data Set.

In the

Data Sheet, we have Data from A2:A101, A1 being the header of the Data. 

=AVERAGE(A2:A101)

Result is 73.99 or rounded of to 74.

  

Average in this context means on an average the Students scored 74 marks in the test.

If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the AVERAGEA function.

The practice sheet can be downloaded from Link. Statistics Marks Data - Download Sheet

MEDIAN - Descriptive Statistics using Microsoft Excel Statistical Functions - Measures of Central Tendency

The practice sheet can be downloaded from Link. Statistics Marks Data - Download Sheet

About the Data Sheet - The data in this sheet is related to marks scored by 100 Students in a Statistical Test. 

Based on the data, we will use Microsoft Excel Statistical functions to analyse the descriptive statistics. 

In the Data Sheet, we have Data from A2:A101, A1 being the header of the Data. 

MEDIAN

In a numerical data set, the median is the point at which there are an equal number of data points whose values lie above and below the median value.

The MEDIAN Function in Excel returns the median of the given numbers. The median is the number in the middle of a set of numbers.

=MEDIAN(number1,number2,...)

In case of an even number of numbers in the set, then MEDIAN calculates the average of the two numbers in the middle.

In the Data Sheet, we have Data from A2:A101, A1 being the header of the Data. 

=MEDIAN(A2:A101)

Result is 75

Median in this context is that half of the students scored above 75 marks and other half of the students scored below 75 marks.