Statistical

A collection of 10 posts

Statistical Tutorial How To Python VBA Functions Data Analysis Convert Spreadsheets Tools Script Generate Templates JSON Formulas Tables Format Cells PDF Workbook Tips Report Automation Charts Export Range Date & Time Range Object Document Shortcuts Worksheets Text Rows Conditional Formatting Lookup & Reference Statistical Graph Merge Cells Data Validation Print Share Worksheet Userform Loop Filter Analysis ToolPak Pivot Tables Array Formulas If Then Statement Function
How to use Weighted Average in Excel
Functions

How to use Weighted Average in Excel

To calculate a weighted average in Excel, simply use the SUMPRODUCT and the SUM function. 1. The AVERAGE function below calculates the normal average of three scores. Suppose your teacher says, “The
06 November 2020
How to use Standard Deviation In Excel
Functions

How to use Standard Deviation In Excel

This page explains how to calculate the standard deviation based on the entire population using the STDEV.P function in Excel and how to estimate the standard deviation based on a sample using
04 November 2020
How to Generate Random Numbers In Excel
Functions

How to Generate Random Numbers In Excel

Excel has two useful functions when it comes to generating random numbers. The RAND and RANDBETWEEN function. Rand The RAND function generates a random decimal number between 0 and 1. 1. Select cell
04 November 2020
How to use RANK Function In Excel
Functions

How to use RANK Function In Excel

The RANK function in Excel returns the rank of a number in a list of numbers. Use RANK.AVG to return the average rank if more than one number has the same rank.
04 November 2020
How to use FREQUENCY function in Excel
Functions

How to use FREQUENCY function in Excel

The FREQUENCY function in Excel calculates how often values occur within the ranges you specify in a bin table. You can also use the COUNTIFS function to create a frequency distribution. 1. First,
30 October 2020
How To Use AverageIf function In Excel
Functions

How To Use AverageIf function In Excel

The AVERAGEIF function in Excel calculates the average of cells that meet one criteria. AVERAGEIFS calculates the average of cells that meet multiple criteria. 1. For example, the AVERAGEIF function below (two arguments)
28 October 2020