Excel for Statistics

66 articles

This article teaches you several ways to fix input range contains non numeric data when obtaining Descriptive Statistics in Excel.

This article teaches you to find T critical value in Excel for left, right, and two tailed tests using the T.INV and T.INV.2T functions.

This article teaches you to get summary statistics in Excel using Data Analysis software, along with a detailed explanation of the results.

This article teaches you how to export tally data in Excel using the Export option and the ODBC (Open Database Connectivity) feature.

This article teaches you how to tally a column in Excel using AutoSum, Table, functions, in addition to conditional tallying.

This article teaches you how to tally words in a cell and range of cells using Excel functions and a VBA user defined function.