Observations in the sample are assumed to come from a normal distribution with known standard deviation, sigma, and the number of observations in the sample is n. The confidence interval is a range of values that are centered at a known sample mean. The CONFIDENCE(alpha, sigma, n) function returns a value that you can use to construct a confidence interval for a population mean. The meaning of a confidence interval is frequently misinterpreted, and we try to provide an explanation of valid and invalid statements that can be made after you determine a CONFIDENCE value from your data. This article describes the CONFIDENCE function in Microsoft Office Excel 2003 and in Microsoft Office Excel 2007, illustrates how the function is used, and compares the results of the function for Excel 2003 and for Excel 2007 with the results of CONFIDENCE in earlier versions of Excel. Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 Office for business More.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |