![]() |
#8
|
||||
|
||||
![]() Quote:
Quote:
The figures I posted were not those of an actual normal distribution curve - they were just my manual approximation of what one might look like for data spanning the number range you posted. The actual curve might be flatter or steeper than my figures suggest. In any event, for so few results, it would be unreasonable to expect a close approximation of the true normal distribution curve. You might need a few hundred results before you would have a really close approximation of the true normal distribution curve - it all depends on how variable the data are. For example, to attain 90% confidence that your sample data are within 5% of a normal distribution, you'd need a minimum sample size of 271. 95% confidence would require a minimum sample size of 385. If you need to analyse the data statistically, you'll need some understanding of the theory. You should perhaps get a copy of Freund's Modern Elementary Statisics. See also: http://en.wikipedia.org/wiki/Normal_distribution http://en.wikipedia.org/wiki/Sample_size
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
swap values | s7y | Excel Programming | 0 | 05-15-2012 01:32 PM |
Reading Values from another sheet | Raabi | Excel | 2 | 05-20-2011 02:14 AM |
![]() |
struct | Excel | 1 | 04-01-2011 07:17 PM |
![]() |
EclipticalD | Excel | 1 | 07-08-2010 09:50 PM |
![]() |
Philos Hippos | Excel | 2 | 10-28-2009 10:44 AM |