If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Normal Distribution
Have you tried using the statistical analysis tools?
Perform an analysis of variance (anova) Correlation analysis tool Covariance analysis tool Descriptive Statistics analysis tool Exponential Smoothing analysis tool Fourier Analysis tool F-Test: Two-Sample for Variances analysis tool Histogram analysis tool Moving Average analysis tool Perform a t-Test analysis Random Number Generation analysis tool Rank and Percentile analysis tool Regression analysis tool Sampling analysis tool z-Test: Two Sample for Means analysis tool -----Original Message----- Anyone know if is posssible to know, using excel, if a certain group of information (in my case, various numbers sorted in rows and columns) follow a statistical Normal distribution? Thanks in Advance --- Message posted from http://www.ExcelForum.com/ . |
#2
|
|||
|
|||
Normal Distribution
" wrote...
Have you tried using the statistical analysis tools? ... And where in this list is there any entry for the two standard test for distribution fitting: chi squared goodness of fit and Kolmogorov-Smirnov statistics? -----Original Message----- Anyone know if is posssible to know, using excel, if a certain group of information (in my case, various numbers sorted in rows and columns) follow a statistical Normal distribution? To the extent that you can use Excel to calculate chi squared goodness of fit and Kolmogorov-Smirnov statistics for the hypothetical normal distribution from the observed data, you can do this in Excel. If you don't know how to calculate these, it's an open question whether you should be trying to fit distributions. As a rough rule of thumb, if the coefficient of skewness of your sample is close to zero and the coefficient of kurtosis is close to 3, you're probably safe assuming the sample is from a normal distribution with the sample mean and sample standard deviation. -- To top-post is human, to bottom-post and snip is sublime. |
#3
|
|||
|
|||
Normal Distribution
Harlan -
As a rough rule of thumb, if the coefficient of skewness of your sample is close to zero and the coefficient of kurtosis is close to 3, you're probably safe assuming the sample is from a normal distribution with the sample mean and sample standard deviation. If you use Excel's KURT function, the online help shows an approximate "minus three" term at the end, so perhaps a value of KURT close to zero (along with SKEW = 0) indicates approximate normality. Yes? - Mike |
#4
|
|||
|
|||
Normal Distribution
"Michael R Middleton" wrote...
As a rough rule of thumb, if the coefficient of skewness of your sample is close to zero and the coefficient of kurtosis is close to 3, you're probably safe assuming the sample is from a normal distribution with the sample mean and sample standard deviation. If you use Excel's KURT function, the online help shows an approximate "minus three" term at the end, so perhaps a value of KURT close to zero (along with SKEW = 0) indicates approximate normality. Yes? Oops! You're right. Guess it shows I don't use KURT(). |
#5
|
|||
|
|||
Normal Distribution
See answer under microsoft.public.excel.programming. Please do not
separately post the same question to multiple news groups. littlecharva wrote: Hi, I need to convert a complicated Excel document that's been created by some Maths boffin into a program in C#. I've been doing really well (despite my Mathematical handicap) until I hit the Excel NORMDIST(x,mean,stdDev,cumulative) function. System.Math doesn't have any functions to help me out here, and I just can't seem to work out how to convert the formula into C# code. I need a function to work the same as the Excel Function with cumulative set to TRUE. |
Thread Tools | |
Display Modes | |
|
|