Manuals/calci/NORMAL - Revision history

Swapna at 20:09, 30 June 2015

2015-06-30T20:09:45Z

Devika at 15:34, 12 May 2015

2015-05-12T15:34:03Z

Devika: /* Examples */

2014-03-24T07:06:50Z

Examples

Devika at 07:05, 24 March 2014

2014-03-24T07:05:56Z

Devika: /* Description */

2014-03-24T07:01:22Z

Description

Devika: /* Description */

2014-03-24T07:00:16Z

Description

Devika: /* Description */

2014-03-24T06:54:51Z

Description

Devika at 06:52, 24 March 2014

2014-03-24T06:52:02Z

Devika at 06:50, 24 March 2014

2014-03-24T06:50:46Z

MassBot1: Created page with "
'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, Mean, StandardDeviation) where, ..."

2013-10-25T02:40:57Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, Mean, StandardDeviation) where, ..."

New page

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

'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, Mean, StandardDeviation)

where,

'''Number '''- represents the number of variables.

'''RandomNumber '''- represents the number of random number.

'''Distribution '''- represents the distribution method(i.e normal) to create random values.

'''NewTableFlag''' - is the TRUE or FALSE.If set as TRUE,the result in new sheet. If NewTableFlag is omitted, it assumed to be FALSE.

'''Mean '''- represents the Mean.

'''StandardDeviation '''- represents the standard deviation.

</div>
----
<div id="1SpaceContent" class="zcontent" align="left">Normal Distribution characterized by a mean and a standard deviation.</div>
----
<div id="7SpaceContent" class="zcontent" align="left">

Lets see an example in (Column3Row1)

<nowiki>=RANDOMNUMBERGENERATION(3, 4, "Normal", TRUE, 0, 4)</nowiki>

RANDOMNUMBERGENERATION returns the result in new sheet(5Space).

<nowiki>=RANDOMNUMBERGENERATION(-3, 4, "Uniform", TRUE, 3, 4)</nowiki>

RANDOMNUMBERGENERATION returns the #ERROR(Number < 0).

</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

RANDOM NUMBER GENERATION : NORMAL

</div></div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
----
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </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="8SpaceContent" class="zcontent" align="left">

If Number < 0 or RandomNumber < 0, RANDOMNUMBERGENERATION returns the #ERROR.

</div>
----
<div id="2SpaceContent" class="zcontent" align="left">

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class=" " |
| Column1
| Column2
| class=" " | Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | 5Space
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| class=" " | Row2
| class=" SelectTD1 ChangeBGColor SelectTD1" |
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div>
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
| Row3
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| Row4
| class="sshl_f" |
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
| class=" " | Row5
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| Row6
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----
<div id="5SpaceContent" class="zcontent" align="left">

{| class="SpreadSheet blue"
|+ Random Number Generation<br />Normal Distribution
|- class="even"
| -0.6469271541994427
| -1.9074080903736057
| -0.617997136104105
|- class="odd"
| -0.7646726307858795
| -0.12686814329075044
| -1.0016839542241755
|- class="even"
| 1.5847698409152808
| 0.6334613031585946
| -0.4798269568260549
|- class="odd"
| -1.6687086155351085
| 1.102906962994111
| 1.4347768240383833
|}

</div>
----

@@ Line 28: / Line 28: @@
 #=NORMALDISTRIBUTED(250,255,2.5) = 748.545737759758,417.93831835416444,-92.67846228553037,etc
 #=NORMALDISTRIBUTED(30,36,20.9) = 7.937852412035841,10.385286729354199,83.54572095198611 etc.
 ==See Also==

@@ Line 3: / Line 3: @@
 *<math>m </math> is the mean.
 *<math>sd</math> is the standard deviation.
 ==Description==
@@ Line 34: / Line 33: @@
 *[[Manuals/calci/NORMSDIST  | NORMSDIST ]]
 *[[Manuals/calci/NORMINV  | NORMINV ]]
 ==References==

@@ Line 27: / Line 27: @@
 ==Examples==
-.NORMALDISTRIBUTED(250,255,2.5) = 748.545737759758,417.93831835416444,-92.67846228553037,etc
+#=NORMALDISTRIBUTED(250,255,2.5) = 748.545737759758,417.93831835416444,-92.67846228553037,etc
-.NORMALDISTRIBUTED(30,36,20.9) = 7.937852412035841,10.385286729354199,83.54572095198611 etc.
+#=NORMALDISTRIBUTED(30,36,20.9) = 7.937852412035841,10.385286729354199,83.54572095198611 etc.
 ==See Also==

@@ Line 24: / Line 24: @@
 *A normal distribution is calculated by :
 <math>f(x,\mu,\sigma)=\frac {1}{\sigma\sqrt{2\pi}} e^{\frac{-(x-\mu)^2}{2\sigma^2}}</math>
-where <math>\mu</math> is the mean and  <math>\sigma<\math> is the standard deviaton of the distribution.
+where <math>\mu</math> is the mean and  <math>\sigma</math> is the standard deviaton of the distribution.
 ==Examples==
-'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, Mean, StandardDeviation)
+==References==

@@ Line 22: / Line 22: @@
 *In a normal distribution the mean =0 and standard deviation =1,then  the distribution is called the standard normal distribution or the unit normal distribution, and a random variable with that distribution is a standard normal deviate.
 *It is the only absolutely continuous distribution.
-*A normal distribution is calculated by
+*A normal distribution is calculated by :
-<math>f(x,\mu,\sigma)=\frac {1}{\sigma\sqrt{2\pi}} e^{\frac{-(x-\mu)^2}{2\sigma^2}}</math>,
+<math>f(x,\mu,\sigma)=\frac {1}{\sigma\sqrt{2\pi}} e^{\frac{-(x-\mu)^2}{2\sigma^2}}</math>
 where <math>\mu</math> is the mean and  <math>\sigma<\math> is the standard deviaton of the distribution.

@@ Line 23: / Line 23: @@
 *It is the only absolutely continuous distribution.
 *A normal distribution is calculated by
-<math>f(x,\mu,\sigma)=\frac {1}{\sigma\sqrt(2\pi) e^{\frac{-(x-\mu)^2}{2\sigma^2}</math>, where <math>\mu</math> is the mean and  <math>\sigma<\math> is the standard deviaton of the distribution.
+<math>f(x,\mu,\sigma)=\frac {1}{\sigma\sqrt{2\pi} e^{\frac{-(x-\mu)^2}{2\sigma^2}}</math>, where <math>\mu</math> is the mean and  <math>\sigma<\math> is the standard deviaton of the distribution.

@@ Line 1: / Line 1: @@
 <div id="6SpaceContent" class="zcontent" align="left">
@@ Line 25: / Line 53: @@
 Lets see an example in (Column3Row1)
-<nowiki>=RANDOMNUMBERGENERATION(3, 4, "Normal", TRUE, 0, 4)</nowiki>
+UNIQeebbe8a3183fa626-nowiki-00000004-QINU
 RANDOMNUMBERGENERATION returns the result in new sheet(5Space).
-<nowiki>=RANDOMNUMBERGENERATION(-3, 4, "Uniform", TRUE, 3, 4)</nowiki>
+UNIQeebbe8a3183fa626-nowiki-00000005-QINU
 RANDOMNUMBERGENERATION returns the #ERROR(Number &lt; 0).

Manuals/calci/NORMAL - Revision history

Swapna at 20:09, 30 June 2015

Devika at 15:34, 12 May 2015

Devika: /* Examples */

Devika at 07:05, 24 March 2014

Devika: /* Description */

Devika: /* Description */

Devika: /* Description */

Devika at 06:52, 24 March 2014

Devika at 06:50, 24 March 2014

MassBot1: Created page with " '''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, Mean, StandardDeviation) where, ..."

MassBot1: Created page with "
'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, Mean, StandardDeviation) where, ..."