Manuals/calci/STANDARDIZE - Revision history

Devika at 22:14, 8 August 2018

2018-08-08T22:14:12Z

Devika: /* Description */

2018-06-12T20:39:01Z

Description

Devika at 20:38, 12 June 2018

2018-06-12T20:38:23Z

Jayaram at 07:20, 13 March 2017

2017-03-13T07:20:02Z

Jayaram at 11:33, 9 March 2017

2017-03-09T11:33:11Z

Swapna at 20:19, 30 June 2015

2015-06-30T20:19:30Z

Devika at 18:11, 11 May 2015

2015-05-11T18:11:27Z

Abin at 07:53, 5 February 2014

2014-02-05T07:53:36Z

Devika at 05:41, 3 February 2014

2014-02-03T05:41:17Z

MassBot1: Created page with "
'''STANDARDIZE'''
2013-10-25T02:44:51Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font face="Arial, sans-serif"><font size="2">'''STANDARDIZE'''</font></font><font face="Arial, sans-serif"><font siz..."

New page
<div id="6SpaceContent" class="zcontent" align="left">

<font face="Arial, sans-serif"><font size="2">'''STANDARDIZE'''</font></font><font face="Arial, sans-serif"><font size="2">(</font></font><font face="Arial, sans-serif"><font size="2">'''val'''</font></font><font face="Arial, sans-serif"><font size="2">,</font></font><font face="Arial, sans-serif"><font size="2">''' m, sd'''</font></font><font face="Arial, sans-serif"><font size="2">)</font></font>

<font face="Arial, sans-serif"><font size="2"></font></font><font face="Arial, sans-serif"><font size="2">'''Where val'''</font></font><font face="Arial, sans-serif"><font size="2"> is the value to normalize and m is the arithmetic mean and sd is the standard deviation of the distribution.</font></font>

# <font face="Arial, sans-serif"><font size="2">When sd is equal to zero , the function displays infinity. </font></font>
# <font face="Arial, sans-serif"><font size="2">The equation for calculating normalized value is: </font></font>

</div>
----
<div id="1SpaceContent" class="zcontent" align="left"><font face="Arial, sans-serif"><font size="2">It calculates a normalized value from a distribution characterized by mean and standard deviation</font></font></div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

STANDARDIZE

</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left"><font color="#7f7f7f"><font face="Arial, sans-serif"><font size="2">

<font color="#7f7f7f"><font face="Arial, sans-serif"><font size="2"> </font></font></font>

<font color="#000000"><font face="Times New Roman, serif"><font size="3">Let’s see an example in (Column1 Row 1,Column1Row2, Column1 Row 3)</font></font></font>

<font color="#000000"><font face="Times New Roman, serif"><font size="3">i.e.STANDARDIZE(val,m,sd)</font></font></font>

<font color="#000000"><font face="Times New Roman, serif"><font size="3"><nowiki>=STANDARDIZE(C1R1,C1R2,C1R3)</nowiki></font></font></font>

<font color="#000000"><font face="Times New Roman, serif"><font size="3"><nowiki>=STANDARDIZE(50,40,2.5) is 4</nowiki></font></font></font>

</font></font></font></div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
----
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
----
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
----
<div id="2SpaceContent" class="zcontent" align="left">

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class=" " |
| class=" " | Column1
| class=" " | Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class=" " | 50
| class="sshl_f" | 4
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
| class=" " | Row2
| class=" " | 40
| class=" SelectTD SelectTD" |
<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
|
|
|- class="odd"
| Row3
| class="sshl_f " | 2.5
|
|
|
|- class="even"
| Row4
| class="sshl_f" |
|
|
| class=" " |
|- class="odd"
| class=" " | Row5
| class="sshl_f" |
|
|
|
|- class="even"
| class="sshl_f" | Row6
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
| class="sshl_f " | Row7
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
| class="sshl_f" | Row8
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
| class="sshl_f" | Row9
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----

@@ Line 3: / Line 3: @@
 *<math>Mean</math> is the mean.
 *<math>StandardDeviation </math> is the standard deviation.
 ==Description==

@@ Line 12: / Line 12: @@
 *This function will give the result as error when
 . Any one of the argument is non-numeric.
-. sd<=0
+. StandardDeviation<=0
 ==Examples==

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''STANDARDIZE(x,m,sd)'''</div><br/>
+<div style="font-size:30px">'''STANDARDIZE (X,Mean,StandardDeviation)'''</div><br/>
-*<math>x </math> is the value.
+*<math>X </math> is the value.
-*<math> m </math> is the mean.
+*<math>Mean</math> is the mean.
-*<math> sd </math> is the standard deviation.
+*<math>StandardDeviation </math> is the standard deviation.
 ==Description==
 *This function gives the  normalized value of any distribution.
 *Standardize is the normalized value for a distribution characterized by a given mean and standard deviation.
-*In <math> STANDARDIZE(x,m,sd)</math>, <math>x </math> is the value to be normalized , <math> m </math> is the arithmetic mean of the distribution, and <math> sd </math> is the standard deviation of the distribution.
+*In <math> STANDARDIZE (X,Mean,StandardDeviation)</math>, <math>X</math> is the value to be normalized , <math> Mean </math> is the arithmetic mean of the distribution, and <math> StandardDeviation </math> is the standard deviation of the distribution.
 *The equation for the normalized value is:
 <math> Z= \frac{x-\mu}{\sigma}</math>, where <math> \mu </math> is the arithmetic mean and <math>\sigma </math> is the standard deviation.

← Older revision		Revision as of 07:20, 13 March 2017
Line 35:		Line 35:


−	[[Z_API_Functions \| List of Main Z Functions]]	+	*[[Z_API_Functions \| List of Main Z Functions]]

−	[[ Z3 \| Z3 home ]]	+	*[[ Z3 \| Z3 home ]]

← Older revision		Revision as of 11:33, 9 March 2017
Line 33:		Line 33:
	==References==		==References==
	*[http://en.wikipedia.org/wiki/Standard_score Standrd Score]		*[http://en.wikipedia.org/wiki/Standard_score Standrd Score]
		+
		+
		+	[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	[[ Z3 \| Z3 home ]]

@@ Line 20: / Line 20: @@
 #=STANDARDIZE(2,0,5.3) = 0.377358490566
 #=STANDARDIZE(-2,1,6.17) = -0.48622366288
 ==See Also==

← Older revision		Revision as of 18:11, 11 May 2015
Line 28:		Line 28:

	==References==		==References==
		+	*[http://en.wikipedia.org/wiki/Standard_score Standrd Score]

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left">
+<div style="font-size:30px">'''STANDARDIZE(x,m,sd)'''</div><br/>
-<font face="Arial, sans-serif"><font size="2"></font></font><font face="Arial, sans-serif"><font size="2">'''Where val'''</font></font><font face="Arial, sans-serif"><font size="2">  is the value to normalize and m is the arithmetic mean and sd is the standard deviation of the distribution.</font></font>
+==Description==
-</div>
+==Examples==
-----
+#=STANDARDIZE(25,20,10.2) = 0.490196078431
-<div id="1SpaceContent" class="zcontent" align="left"><font face="Arial, sans-serif"><font size="2">It calculates a normalized value from a distribution characterized by mean and standard deviation</font></font></div>
+#=STANDARDIZE(52.5,42,3.25) = 3.230769230769
-----
+#=STANDARDIZE(30,35,4.21) = -1.187648456057
-<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
+#=STANDARDIZE(2,0,5.3) = 0.377358490566
-</div></div>
+==See Also==
-----
+*[[Manuals/calci/NORMDIST  | NORMDIST ]]
-<div id="8SpaceContent" class="zcontent" align="left"><font color="#7f7f7f"><font face="Arial, sans-serif"><font size="2">
+*[[Manuals/calci/NORMINV  | NORMINV ]]
-<font color="#000000"><font face="Times New Roman, serif"><font size="3">i.e.STANDARDIZE(val,m,sd)</font></font></font>
+==References==