Read Help for the CONFIDENCE function. Does the the equation it specifies
give you any clues?

Most respondants in these newsgroups will not do your assignment for you,
but will try to help you figure it out for yourself.

Jerry

"sjvicker" wrote:


I was recently marked down on a lab project for using the excel function
to find the confidence interval for 95% certainty. I properly used the
function but retrieved a different answer than my professor who used
Descriptitive Statistics under the Data Analysis-Tools feature.

The only way I can recover the points is to figure out why the answers
were different.

The sample size is 20, Mean 25.87, Max Value 28, Min Value 24.2,
Standard Deviation 1.01, Range 3.80, Mode 26 and Median 25.75

Any ideas why our values were different? did excel possibly use
different tables?

-Spencer


--
sjvicker
------------------------------------------------------------------------
sjvicker's Profile: http://www.excelforum.com/member.php...o&userid=31598
View this thread: http://www.excelforum.com/showthread...hreadid=512889