This video shows the method to find the variance and standard deviation using Excel. The variance shows the variability of the data points from the median. We find the difference of the median and the mean. We write the formula using '=' sign. The median and data points are put in it by selecting the appropriate cell. The median is made an absolute constant by pressing the F4 key. This is squared by using '^2'. This is multiplied to the frequency using '*'. The result is found for all the data points by double clicking on the bottom right corner of the cell. The sum of all the results is found by the 'sum' function. This is divided by the total number of data points. Hence, the variance is found. The standard deviation is found by finding the square root of the variance using the 'squirt' function.
 Hot
 Latest

How To: Find a PValue with Excel

How To: Create a Basic Attendance Sheet in Excel

How To: Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'

How To: Update inventory records by formula in Microsoft Excel

How To: Insert movie files into a MS Word document

How To: Create a passfail grade formula in Microsoft Excel

How To: Create an Excel inventory template with running totals

How To: Crosscheck two lists for discrepancies in MS Excel

How To: Enter formulas in Excel with a macro

How To: Use conditional formatting for a student grading report in Microsoft Excel

How To: Create a Tangent Line with Excel

How To: Average rank scores given a tie in Excel 2010

How To: Calculate interest on a loan payment in MS Excel 2007

How To: Sort and extract by cell color in Microsoft Excel 2007

How To: Use HLOOKUP across two worksheets in Microsoft Excel

How To: Extract records that meet certain criteria in Excel

How To: Clear data & cell contents in Excel using a macro

How To: Display trend arrows in a Microsoft Excel spreadsheet

How To: Graph the probability density function in an Excel file

How To: Create a percentage frequency table in Microsoft Excel

How To: Find a PValue with Excel

How To: Create a Basic Attendance Sheet in Excel

How To: Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'

How To: Update inventory records by formula in Microsoft Excel

How To: Insert movie files into a MS Word document

How To: Create a passfail grade formula in Microsoft Excel

How To: Create an Excel inventory template with running totals

How To: Crosscheck two lists for discrepancies in MS Excel

How To: Enter formulas in Excel with a macro

How To: Use conditional formatting for a student grading report in Microsoft Excel

How To: Create a Tangent Line with Excel

How To: Average rank scores given a tie in Excel 2010

How To: Calculate interest on a loan payment in MS Excel 2007

How To: Sort and extract by cell color in Microsoft Excel 2007

How To: Use HLOOKUP across two worksheets in Microsoft Excel

How To: Extract records that meet certain criteria in Excel

How To: Clear data & cell contents in Excel using a macro

How To: Display trend arrows in a Microsoft Excel spreadsheet

How To: Graph the probability density function in an Excel file

How To: Create a percentage frequency table in Microsoft Excel
Be the First to Comment
Share Your Thoughts