none
Confidence Interval calculation using CONFIDENCE function RRS feed

  • 一般討論

  • Hi,

     

    It seems to be difference in calculating 95% confidence interval using CONFIDENCE(alpha,standard deviation,size) and the descriptive function in data analysis add-on in Excel 2003 and Excel 2007. The following is the sample data.

     

    data 1, 2, 3, 4, 5, 6, 7, 8, 9, 10

    standard deviation = 3.02765

    size=10

    alpha=0.05 

     

    CONFIDENCE(0.05,3.02765,10) return 1.8765

     

    Descriptive in Data analysis add-on, confidence level (95%) return  2.1658

     

     

    Please help to explain why the difference

     

    Thanks

    2007年8月30日 上午 09:37