Difference between revisions of "Manuals/calci/HISTOGRAM"
| (14 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =HISTOGRAM(Array, BinRange, NewTableFlag) | + | <div style="font-size:25px">'''HISTOGRAM (Array,BinRange,PareToFlag,CumulativeFlag,ShowChart,NewTableFlag)'''</div><br/> |
*where, <math>Array</math> is an array of data or reference to cells containing data to analyze | *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>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. | *<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. | |
| − | HISTOGRAM() counts the number of occurrences of each data point in each of several data bins. | ||
== Description == | == Description == | ||
| − | HISTOGRAM(Array, BinRange, NewTableFlag) | + | HISTOGRAM (Array,BinRange,PareToFlag,CumulativeFlag,ShowChart,NewTableFlag) |
*An Histogram is a representation of tabulated frequencies over discrete bins(intervals). | *An Histogram is a representation of tabulated frequencies over discrete bins(intervals). | ||
| Line 17: | Line 19: | ||
*<math>NewTableFlag</math> can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE. | *<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. | *If <math>NewTableFlag</math> is TRUE, the result is displayed on new zspace sheet. | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
== Examples == | == Examples == | ||
| Line 76: | Line 72: | ||
|} | |} | ||
| − | =HISTOGRAM(A3:A9, B3:B7, TRUE) returns the following table: | + | =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 85: | Line 82: | ||
! Bin | ! Bin | ||
! Frequency | ! Frequency | ||
| + | ! Cumulative | ||
| + | ! Bin | ||
| + | ! Frequency | ||
| + | ! Cumulative | ||
|- class="odd" | |- class="odd" | ||
| 10 | | 10 | ||
| 2 | | 2 | ||
| + | | 28.57142857142857% | ||
| + | | 20 | ||
| + | | 3 | ||
| + | | 42.857142857142854% | ||
|- class="even" | |- class="even" | ||
| 20 | | 20 | ||
| 3 | | 3 | ||
| + | | 71.42857142847143% | ||
| + | | 10 | ||
| + | | 2 | ||
| + | | 71.42857142847143% | ||
|- class="odd" | |- class="odd" | ||
| 30 | | 30 | ||
| 0 | | 0 | ||
| + | | 71.42857142847143% | ||
| + | | 40 | ||
| + | | 1 | ||
| + | | 85.71428571428571% | ||
|- class="even" | |- class="even" | ||
| 40 | | 40 | ||
| 1 | | 1 | ||
| + | | 85.71428571428571% | ||
| + | | 50 | ||
| + | | 1 | ||
| + | | 100% | ||
|- class="odd" | |- class="odd" | ||
| 50 | | 50 | ||
| 1 | | 1 | ||
| + | | 100% | ||
| + | | 30 | ||
| + | | 0 | ||
| + | | 100% | ||
|- class="odd" | |- class="odd" | ||
| More | | More | ||
| 0 | | 0 | ||
| + | | 100% | ||
| + | | More | ||
| + | | 0 | ||
| + | | 100% | ||
|} | |} | ||
| + | The Histogram chart is also displayed. | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|gSEYtAjuZ-Y|280|center|HISTOGRAM}} | ||
== See Also == | == See Also == | ||
| Line 113: | Line 143: | ||
*[http://en.wikipedia.org/wiki/Histogram Histogram] | *[http://en.wikipedia.org/wiki/Histogram Histogram] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
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.
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.
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:
| 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
See Also
References