Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-18-2012, 09:33 AM
macropod's Avatar
macropod macropod is offline Normally distributed values Windows 7 64bit Normally distributed values Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default


Quote:
Originally Posted by Jamal NUMAN View Post

Could you please elaborate more regarding the method that you have used to check whether the “marks” are normally distributed and namely the equation?

=8.74-ABS(AVERAGE(A$2:A$20)-A2)

What does 8.74 represent?
As indicated in my previous post:
Quote:
The '8.74' is just to 'normalise' the balance of the formula to a (rough) zero base
It has no other significance.

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]
Reply With Quote
  #2  
Old 08-27-2012, 11:59 AM
Jamal NUMAN Jamal NUMAN is offline Normally distributed values Windows 7 64bit Normally distributed values Office 2010 64bit
Expert
Normally distributed values
 
Join Date: Nov 2010
Posts: 615
Jamal NUMAN is on a distinguished road
Question

Quote:
Originally Posted by macropod View Post
As indicated in my previous post:

It has no other significance.

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
Many thanks Paul for the answer.

I thought there might be a simple tool that can check a set of data whether they are normally distributed or not.

I think that I have sufficient background regarding this topic. My issue is that to use the normal distribution function (attached), it is required first to check whether the data is normally distributed. I attempt to find a tool that does this sort of work but sounds that this a bit confusing.

In other words, having normally distributed data is a condition to apply the normal distribution function for further analysis! But how can we first check our raw data (whether it is normally distributed or not?!)

Best

Jamal
Attached Images
File Type: jpg Clip_22.jpg (12.8 KB, 11 views)
Reply With Quote
Reply



Similar Threads
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
Normally distributed values comparing values from a range struct Excel 1 04-01-2011 07:17 PM
Normally distributed values Using Conditions to Add Values EclipticalD Excel 1 07-08-2010 09:50 PM
Normally distributed values In vertical allignment, the dif. bettwen Justify and Distributed? Philos Hippos Excel 2 10-28-2009 10:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft