Excel for Statistics
How to Use the F.DIST Function in Excel (with Syntax and Usage)
This article explores the syntax and usage of the F.DIST and F.DIST.RT functions in Excel with step-by-step examples.
Read article
Blog
1285 articles
Excel for Statistics
How to Do F-Test in Excel (One & Two-Tailed Tests)
This article teaches you how to do f test in Excel using Data Analysis ToolPak and the F.TEST function, along with interpretation of results.
Read article
Excel for Statistics
Descriptive Statistics: Input Range Contains Non-Numeric Data
This article teaches you several ways to fix input range contains non numeric data when obtaining Descriptive Statistics in Excel.
Read article
Excel Charts
How to Create a Legend Without a Chart in Excel (4 Methods)
Create Excel legends without charts using text boxes, shapes & formatting. Step-by-step guide for visual data representation in cells.
Read article
Excel for Statistics
How to Find T Critical Value in Excel (Left, Right & 2-Tailed Tests)
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.
Read article
Excel for Statistics
How to Get Summary Statistics in Excel (Using Analysis ToolPak)
This article teaches you to get summary statistics in Excel using Data Analysis software, along with a detailed explanation of the results.
Read article
Excel for Statistics
How to Export Tally Data in Excel (2 Suitable Ways)
This article teaches you how to export tally data in Excel using the Export option and the ODBC (Open Database Connectivity) feature.
Read article
Excel Charts
How to Add a Legend in Excel Chart (Manually & with Tools)
Learn how to add a legend in Excel charts using the Chart Elements button, Chart Design tab, or manual methods.
Read article
Excel Charts
How to Edit Legend in Excel (Format Legend Text, Order & More)
Learn how to edit a legend in Excel charts, including changing text, moving positions, customizing order, and formatting appearance.
Read article
Excel Charts
How to Create an Excel Chart from Selected Range of Cells
Learn how to create a chart from selected range of cells using ribbon features, quick analysis tool, and keyboard shortcut
Read article
Excel for Statistics
How to Tally a Column in Excel (5 Simple Ways)
This article teaches you how to tally a column in Excel using AutoSum, Table, functions, in addition to conditional tallying.
Read article
Excel Charts
How to Show Percentage in Excel Graph (2 Simple Ways)
Learn how to show percentage in excel chart (pie & clustered columns) by formatting data labels with 2 different & easy ways.
Read article