What is the CONFIDENCE.NORM Function?
The CONFIDENCE.NORM Function is categorized under Statistical functionsFunctionsThe CONFIDENCE.NORM Function is categorized under Statistical functions. It will use the normal distribution, calculate and return the confidence interval for a population mean. The confidence interval is the range that a population parameter is likely to fall into for a given probability. As a financial analyst, the. It will use the normal distribution, calculate and return the confidence interval for a population mean. The confidence interval is the range that a population parameter is likely to fall into for a given probability.
In financial analysisAnalysis of Financial StatementsHow to perform Analysis of Financial Statements. This guide will teach you to perform financial statement analysis of the income statement, balance sheet, and cash flow statement including margins, ratios, growth, liquiditiy, leverage, rates of return and profitability. See examples and step-by-step instruction, the CONFIDENCE.NORM function is useful in predicting and adjusting for a wide range of financial goalsFinancial ModelingThe CONFIDENCE.NORM Function is categorized under Statistical functions. It will use the normal distribution, calculate and return the confidence interval for a population mean. The confidence interval is the range that a population parameter is likely to fall into for a given probability. As a financial analyst, the by optimizing financial decision-making. It is done by applying and graphically mapping financial data into a distribution set of variables.
Analysts can make better financial decisions based on the statistical information provided by the normal distribution. For example, they can find the connection between income earnedNet IncomeNet Income is a key line item, not only in the income statement, but in all three core financial statements. While it is arrived at through the income statement, the net profit is also used in both the balance sheet and the cash flow statement. and income expended on luxury items.
The CONFIDENCE.NORM function was introduced in MS Excel 2010, replacing the CONFIDENCE function, although the latter is still available for compatibility purposes.
Formula
=CONFIDENCE.NORM(alpha,standard_dev,size)
The function uses the following argument:
- Alpha (required argument) – It is the significance level used to compute the confidence level. The significance level is equal to 1– confidence level. So, a significance level of 0.05 is equal to a 95% confidence level.
- Standard_dev (required argument) – It is the standard deviation for the data range.
- Size (required argument) – It is the sample size.
To calculate the confidence interval for a population mean, the returned confidence value must then be added to and subtracted from the sample mean. For example, for the sample mean x:
Confidence Interval = x ± CONFIDENCE
How to use the Function in Excel?
To understand the uses of the CONFIDENCE.NORM function, let us consider an example:
Example
Suppose we know that the mean salary of CEOs in our industry is $100,000. We can use the CONFIDENCE.NORM function to calculate how close the sample mean is to the actual population mean, specifically, if we wish to know what range of salaries, working at a 95% confidence level, includes the population mean. Using the data below:
- Significance level: 0.05
- Standard deviation of the population: 20,000
- Sample size: 100
The CONFIDENCE.NORM function is used to calculate the confidence interval with a significance of 0.05 (i.e. a confidence level of 95%).
To find out the confidence interval for the population mean, we will use the following formula:
We get the result below:
Therefore, the confidence interval is 100,000 ± 3919.928, which is equal to the range 96,080.072 and 103,919.928.
A few notes about the CONFIDENCE.NORM Function
- #NUM! error – Occurs if either:
- The given alpha is less than or equal to zero or is greater than or equal to zero.
- The given standard deviation is less than or equal to zero.
- The size argument given is less than one.
- #VALUE! error – Occurs when any of the arguments provided is non-numeric.
- If the size argument is not an integer, it is truncated.
Click here to download the sample Excel file
Additional resources
Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional resources:
- Excel Countif Not BlankCOUNTA FunctionThe COUNTA Function will calculate the number of cells that are not blank within a given set of values. The =counta() function is also commonly referred to as the Excel Countif Not Blank formula. As a financial analyst, the function is useful count cells that are not blank or empty in a given range.
- Advanced Excel Course
- Advanced Excel FormulasAdvanced Excel Formulas Must KnowThese advanced Excel formulas are critical to know and will take your financial analysis skills to the next level. Advanced Excel functions you must know. Learn the top 10 Excel formulas every world-class financial analyst uses on a regular basis. These skills will improve your spreadsheet work in any career
- Excel ShortcutsExcel Shortcuts PC MacExcel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Keyboard shortcuts speed up your modeling skills and save time. Learn editing, formatting, navigation, ribbon, paste special, data manipulation, formula and cell editing, and other shortucts