Hi Paul,
Thak you for the answer.
This is exactly what I’m looking for. Given a set of data (assume that they are students marks), and it is first needed to check (in principle) if they are normally distributed (or follow the normal distribution function).
I couldn’t find “direct” tool in the Excel that do this sort of work.
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?
Is this related to normalosing values by their max and min values
Xnew=Xold-Xmin/Xmax-Xmin
Or by their average and standard deviation
Xnew=Xold-avrage/standard deviation
Best
Jamal
Last edited by macropod; 08-18-2012 at 09:11 AM.
Reason: Deleted unnecessary quote of entire previous post.
|