ZCubes Wiki

Changes

Manuals/calci/HISTOGRAM (view source)

Revision as of 23:40, 7 January 2014

258 bytes removed ,  23:40, 7 January 2014
no edit summary
Line 1: Line 1: −
<div id="6SpaceContent" class="zcontent" align="left">
+
=HISTOGRAM(Array, BinRange, NewTableFlag)=
   −
'''HISTOGRAM'''(Array, BinRange, NewTableFlag)
+
*where, <math>Array<math> is an array of data or reference to cells containing data to analyze
 +
*<math>BinRange<math> is the set of intervals to create an Histogram
 +
*<math>NewTableFlag<math> is a logical value that decides whether to display the output in the same worksheet or a new space cube.
   −
where,
+
HISTOGRAM() counts the number of occurrences of each data point in each of several data bins.
   −
'''Array '''- Input range should be one block.
+
== Description ==
   −
'''BinRange '''- Input range should be one block.
+
HISTOGRAM(Array, BinRange, NewTableFlag)
   −
'''NewTableFlag''' - is the TRUE or FALSE.If set as TRUE,the result in new sheet. If NewTableFlag is omitted, it assumed to be FALSE.
+
*An Histogram is a representation of tabulated frequencies over discrete bins(intervals).
 +
*HISTOGRAM() performs data analysis in an array depending on the intervals, and returns a column chart that displays frequency data.
 +
*<math>Array</math> can be array of numbers to analyze using HISTOGRAM() function.
 +
*<math>BinRange</math> is the range of intervals in which data in array is counted. A data is included in particular bin range if the number is greater than lowest range and equal to or less than largest range.
 +
*<math>NewTableFlag</math> can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
 +
*If <math>NewTableFlag</math> is TRUE, the result is displayed on new zspace sheet.
 +
<font=blue>Need to check the functionality of NewTableFlag</font>
   −
</div>
+
== Examples ==
−
----
  −
<div id="1SpaceContent" class="zcontent" align="left">Histogram counts occurences in each of several data bins.</div>
  −
----
  −
<div id="7SpaceContent" class="zcontent" align="left">
     −
Lets see an example in (Column3Row1)
+
Consider the following table with Columns A and B as array inputs for ANOVASINGLEFACTOR() function.
   −
<nowiki>=HISTOGRAM (R1C1:R6C1, R1C2:R6C2, TRUE)</nowiki>
+
<div id="2SpaceContent" class="zcontent" align="left">
   −
HISTOGRAM returns the result in new sheet(5Space).
+
{| id="TABLE3" class="SpreadSheet blue"
 +
|- class="even"
 +
| class="sshl_f" | '''Array'''
 +
| class=" " | '''Bin Range'''
 +
| class=" " |
   −
</div>
+
|- class="odd"
−
----
+
| class="sshl_f" |
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
+
| class=" " |
 +
| class=" " |
   −
HISTOGRAM
+
|- class="even"
 +
| class="sshl_f" | 1
 +
| class=" " |10
 +
| class=" " |
   −
</div></div>
+
|- class="odd"
−
----
+
| class="sshl_f" | 7
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
+
| class=" " |20
−
----
+
| class=" " |
−
<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="2SpaceContent" class="zcontent" align="left">
     −
{| id="TABLE3" class="SpreadSheet blue"
   
|- class="even"
 
|- class="even"
 +
| class="sshl_f" | 12
 +
| class=" " |30
 
| class=" " |
 
| class=" " |
−
| Column1
+
 
−
| Column2
  −
| class="  " | Column3
  −
| Column4
   
|- class="odd"
 
|- class="odd"
−
| class=" " | Row1
+
| class="sshl_f" | 17
−
| class=" " | 1
+
| class=" " |40
−
| class=" " | 3
+
| class=" " |
−
| class="sshl_f" | 5Space
+
 
−
| class="sshl_f" | 5
   
|- class="even"
 
|- class="even"
−
| class=" " | Row2
+
| class="sshl_f" | 20
−
| class=" " | 7
+
| class=" " |50
−
| class=" " | 8
+
| class=" " |
−
| 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>9
  −
| class="sshl_f" | 128
   
|- class="odd"
 
|- class="odd"
−
| Row3
+
| class="sshl_f" | 37
−
| class=" " | 12
+
| class=" " |
−
| class=" " | 8
+
| class=" " |
−
| 14
+
 
−
| class="sshl_f    " | 15
   
|- class="even"
 
|- class="even"
−
| Row4
+
| class="sshl_f" | 50
−
| class=" " | 17
+
| class=" " |
−
| class=" " | 18
+
| class=" " |
−
| class="sshl_f" | 10000
  −
| class="  " | 20
  −
|- class="odd"
  −
| class=" " | Row5
  −
| class=" " | 37
  −
| class=" " | 34
  −
| 10023
  −
| 168
  −
|- class="even"
  −
| Row6
  −
| class=" " | 6
  −
| class=" " | 5
  −
| 1.619775
  −
| 0.525322
   
|}
 
|}
   −
<div align="left">[[Image:calci1.gif]]</div></div>
+
=HISTOGRAM(A3:A9, B3:B7, TRUE) returns the following table:
−
----
+
 
 
<div id="5SpaceContent" class="zcontent" align="left">
 
<div id="5SpaceContent" class="zcontent" align="left">
   Line 97: Line 81:  
! Frequency
 
! Frequency
 
|- class="odd"
 
|- class="odd"
 +
| 10
 +
| 2
 +
|- class="even"
 +
| 20
 
| 3
 
| 3
−
| 1
  −
|- class="even"
  −
| 8
  −
| 2
   
|- class="odd"
 
|- class="odd"
−
| 8
+
| 30
 
| 0
 
| 0
 
|- class="even"
 
|- class="even"
−
| 18
+
| 40
−
| 2
+
| 1
 
|- class="odd"
 
|- class="odd"
−
| 34
+
| 50
−
| 0
+
| 1
−
|- class="even"
  −
| 5
  −
| 0
   
|- class="odd"
 
|- class="odd"
 
| More
 
| More
−
| 1
+
| 0
 
|}
 
|}
   −
</div>
+
== See Also ==
−
----
+
 
−
<div id="8SpaceContent" class="zcontent" align="left"><div class="ztipcrumbs"></div></div>
+
*[[Manuals/calci/MOVINGAVERAGE | MOVINGAVERAGE]]
−
----
+
*[[Manuals/calci/EXPONENTIALSMOOTHING | EXPONENTIALSMOOTHING]]
 +
 
 +
== References ==
 +
 
 +
*[http://en.wikipedia.org/wiki/Histogram Histogram]
Swapna
writer
2,661

edits

Retrieved from "http://wiki.zcubes.com/Special:MobileDiff/197101"