Z-Transformation

[priyanka]

Hello members,
My question is that i have to scale my data.. Can i do Z-transformation..
Is there any inbuilt function or shall i have to write Code,

thanks
Priyanka

 

[Bill_Biggs]

Guten Tag, Priyanka, (that is all the German I know, except for hamburger),

If you enter Fisher or transformation under the Excel Help, it can get you going. They are not built in functions but the tables are easy to create. Here is the Microsoft Excel address for some more information also (I found it in Help as well).

http://office.microsoft.com/en-us/marketplace/EM102368531033.aspx

Hope this is helpful for you.

 

[MrKowz]

Priyanka, are you meaning you need to find the Z-Score of the data to fit a Normal Distribution?

 

[Cindy Ellis]

Hello priyanka,
I don't think there is an all-in-one built-in function for normalizing data to a standard normal distribution, but you can modify the following function to do what you need, since a z-score is just the difference from the mean, divided by the standard deviation.
Assuming the data is in cells A1 - A5...

=(A1-AVERAGE($A$1:$A$5))/STDEV($A$1:$A$5)

The initial "A1" is the value you are normalizing.
$A$1:$A$5 is the range with the whole set of data.

Hope this helps,
Cindy

 

[priyanka]

hello

guten tag... i too dont know german.. i am indian.. and came here for phd just a month back..

does fisher transformation mean z-transformation ??
and yes i mean to scale the data and i need z-score to fit to a normal distribution..

i will try ur code cindy....

Thanks Everyone for ur help


Priyanka

 

[Cindy Ellis]

The Fisher transformation is not a z-transformation...the input to it is a correlation coefficient, and is used for hypothesis testing of correlation coefficients.
To calculate the z-score, you subtract the sample (or population) mean from the given value, and divide by the standard deviation of the sample or population.
Cindy

 

[MrKowz]

The Fisher transformation is not a z-transformation...the input to it is a correlation coefficient, and is used for hypothesis testing of correlation coefficients.

This is exactly what I am learning in my Statistical Modeling and Statistics III class right now...

 

[Bill_Biggs]

I stand corrected, and am in awe of Guru Cindy's knowledge.

 

[Cindy Ellis]

Not a guru...but lots of time in statistics classes (I start a master's degree program in statistics in a couple of months)

 

[tusharm]

Cindy has already shared with you the x-to-z transformation. For more on how to draw a normal curve and the z-to-x transformation see
Normal curve
http://www.tushar-mehta.com/excel/charts/normal_distribution/

The section Understanding the Standard Normal distribution and how it connects all other Normal distribution functions discusses the x-to-z and the z-to-x transformations.

Hello members,
My question is that i have to scale my data.. Can i do Z-transformation..
Is there any inbuilt function or shall i have to write Code,

thanks
Priyanka