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...")
 
 
(18 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:25px">'''HISTOGRAM (Array,BinRange,PareToFlag,CumulativeFlag,ShowChart,NewTableFlag)'''</div><br/>
  
−
'''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>PareToFlag</math> is a logical value that decides whether to make a Pareto chart, a special histogram that sorts the columns from tallest to smallest
 +
*<math>CumulativeFlag</math> is a logical value that decides whether to display cumulative percentages in addition to bin totals
 +
*<math>SomeChart</math> is a logical value that decides whether to display the chart
 +
*<math>NewTableFlag</math> is a logical value that decides whether to display the output in the same worksheet or a new space cube.
 +
**HISTOGRAM(), counts the number of occurrences of each data point in each of several data bins.
  
−
where,
+
== Description ==
  
−
'''Array '''- Input range should be one block.
+
HISTOGRAM (Array,BinRange,PareToFlag,CumulativeFlag,ShowChart,NewTableFlag)
  
−
'''BinRange '''- Input range should be one block.
+
*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.
  
−
'''NewTableFlag''' - is the TRUE or FALSE.If set as TRUE,the result in new sheet. If NewTableFlag is omitted, it assumed to be FALSE.
+
== Examples ==
  
−
</div>
+
Consider the following table in Calci, with Columns A and B as array inputs for HISTOGRAM() function.
−
----
 
−
<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)
+
<div id="2SpaceContent" class="zcontent" align="left">
  
−
<nowiki>=HISTOGRAM (R1C1:R6C1, R1C2:R6C2, TRUE)</nowiki>
+
{| id="TABLE3" class="SpreadSheet blue"
 +
|- class="even"
 +
| class="sshl_f" | '''Array'''
 +
| class=" " | '''Bin Range'''
 +
| class=" " |
  
−
HISTOGRAM returns the result in new sheet(5Space).
+
|- class="odd"
 +
| class="sshl_f" |
 +
| class=" " |
 +
| class=" " |
  
−
</div>
+
|- class="even"
−
----
+
| class="sshl_f" | 1
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
+
| class=" " |10
 +
| class=" " |
  
−
HISTOGRAM
+
|- class="odd"
−
 
+
| class="sshl_f" | 7
−
</div></div>
+
| class=" " |20
−
----
+
| class=" " |
−
<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="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,TRUE,TRUE,TRUE)
−
----
+
returns the following table:
 +
 
 
<div id="5SpaceContent" class="zcontent" align="left">
 
<div id="5SpaceContent" class="zcontent" align="left">
  
Line 96: Line 82:
 
! Bin
 
! Bin
 
! Frequency
 
! Frequency
 +
! Cumulative
 +
! Bin
 +
! Frequency
 +
! Cumulative
 
|- class="odd"
 
|- class="odd"
 +
| 10
 +
| 2
 +
| 28.57142857142857%
 +
| 20
 
| 3
 
| 3
−
| 1
+
| 42.857142857142854%
 
|- class="even"
 
|- class="even"
−
| 8
+
| 20
 +
| 3
 +
| 71.42857142847143%
 +
| 10
 
| 2
 
| 2
 +
| 71.42857142847143%
 
|- class="odd"
 
|- class="odd"
−
| 8
+
| 30
 
| 0
 
| 0
 +
| 71.42857142847143%
 +
| 40
 +
| 1
 +
| 85.71428571428571%
 
|- class="even"
 
|- class="even"
−
| 18
+
| 40
−
| 2
+
| 1
 +
| 85.71428571428571%
 +
| 50
 +
| 1
 +
| 100%
 
|- class="odd"
 
|- class="odd"
−
| 34
+
| 50
 +
| 1
 +
| 100%
 +
| 30
 
| 0
 
| 0
−
|- class="even"
+
| 100%
−
| 5
+
|- class="odd"
 +
| More
 
| 0
 
| 0
−
|- class="odd"
+
| 100%
 
| More
 
| More
−
| 1
+
| 0
 +
| 100%
 
|}
 
|}
 +
The Histogram chart is also displayed.
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|gSEYtAjuZ-Y|280|center|HISTOGRAM}}
 +
 +
== See Also ==
 +
 +
*[[Manuals/calci/MOVINGAVERAGE | MOVINGAVERAGE]]
 +
*[[Manuals/calci/EXPONENTIALSMOOTHING | EXPONENTIALSMOOTHING]]
 +
 +
== References ==
 +
 +
*[http://en.wikipedia.org/wiki/Histogram Histogram]
 +
 +
 +
 +
*[[Z_API_Functions | List of Main Z Functions]]
  
−
</div>
+
*[[ Z3 |  Z3 home ]]
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left"><div class="ztipcrumbs"></div></div>
 
−
----
 

Latest revision as of 17:09, 10 August 2018

HISTOGRAM (Array,BinRange,PareToFlag,CumulativeFlag,ShowChart,NewTableFlag)


  • where, is an array of data or reference to cells containing data to analyze
  • is the set of intervals to create an Histogram
  • is a logical value that decides whether to make a Pareto chart, a special histogram that sorts the columns from tallest to smallest
  • is a logical value that decides whether to display cumulative percentages in addition to bin totals
  • is a logical value that decides whether to display the chart
  • is a logical value that decides whether to display the output in the same worksheet or a new space cube.
    • HISTOGRAM(), counts the number of occurrences of each data point in each of several data bins.

Description

HISTOGRAM (Array,BinRange,PareToFlag,CumulativeFlag,ShowChart,NewTableFlag)

  • 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.
  • 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.

Examples

Consider the following table in Calci, with Columns A and B as array inputs for HISTOGRAM() function.

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

returns the following table:


Histogram
Bin Frequency Cumulative Bin Frequency Cumulative
10 2 28.57142857142857% 20 3 42.857142857142854%
20 3 71.42857142847143% 10 2 71.42857142847143%
30 0 71.42857142847143% 40 1 85.71428571428571%
40 1 85.71428571428571% 50 1 100%
50 1 100% 30 0 100%
More 0 100% More 0 100%

The Histogram chart is also displayed.

Related Videos

HISTOGRAM

See Also

References


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