Difference between revisions of "Manuals/calci/HISTOGRAM"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''HISTOGRAM'''(Array, BinRange, NewTableFlag) where, '''Array '''- Input range should be one block. '''B...")
 
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]

Revision as of 17:40, 7 January 2014

HISTOGRAM(Array, BinRange, NewTableFlag)

  • where, can be array of numbers to analyze using HISTOGRAM() function.
  • 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.
  • can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
  • If is TRUE, the result is displayed on new zspace sheet.

<font=blue>Need to check the functionality of NewTableFlag

Examples

Consider the following table with Columns A and B as array inputs for ANOVASINGLEFACTOR() function.

Array Bin Range
1 10
7 20
12 30
17 40
20 50
37
50 
=HISTOGRAM(A3:A9, B3:B7, TRUE) returns the following table:

Histogram
Bin Frequency
10 2
20 3
30 0
40 1
50 1
More 0

See Also

References

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/HISTOGRAM&oldid=197101"