Category: Excel Guides

shape
shape
shape
shape
shape
shape
shape
shape
Standard

How to Calculate Standard Error in Excel: Formula and Examples

The standard error tells you how much a sample average is likely to differ from the true average of the whole population. It is one of the most useful numbers in statistics, because it shows how reliable your average is. Excel has no single function called standard error, but you can calculate it in one

Standard

How to Use the TEXT Function in Excel: Format Dates, Numbers and Percentages

The TEXT function in Excel converts a number or a date into text in the exact format that you choose. It is the tool to use when you want to join a value to a sentence and keep it looking right, for example showing a sales figure as $1,234.50 or a date as Monday, 18

Standard

How to Calculate a Confidence Interval in Excel: CONFIDENCE.T and CONFIDENCE.NORM

A confidence interval gives a range of values that is likely to contain the true value of a population figure, such as an average, based on a sample. Instead of reporting only that the average score in your sample is 70, you can say that you are 95 percent confident that the true average lies

Standard

How to Use COUNTIF in Excel: Text, Numbers, Wildcards, Dates and Blanks

COUNTIF counts the cells in a range that meet one condition. It answers questions such as how many orders are marked Paid, how many students scored above 60, how many names start with the letter A, or how many dates fall after today. It is one of the first functions worth learning, because counting is