writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − + − + − + − − + Line 73:
Line 72: − + Line 112:
Line 111: − |- class="odd" + + + + Line 128:
Line 130: + + + + Line 137:
Line 143: + + + + + +
no edit summary
=HISTOGRAM(SomeArray,BinRange,SomePareToFlag,SomeCumulativeFlag,SomeChartFlag,NewTableFlag)=
<div style="font-size:25px">'''HISTOGRAM (Array,BinRange,PareToFlag,CumulativeFlag,ShowChart,NewTableFlag)'''</div><br/>
*where, <math>SomeArray</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>SomePareToFlag</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>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>SomeCumulativeFlag</math> is a logical value that decides whether to display cumulative percentages in addition to bin totals
*<math>CumulativeFlag</math> is a logical value that decides whether to display cumulative percentages in addition to bin totals
*<math>SomeChartFlag</math> is a logical value that decides whether to display the chart
*<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(SomeArray,BinRange,SomePareToFlag,SomeCumulativeFlag,SomeChartFlag,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).
|}
|}
=HISTOGRAM(A3:A9, B3:B7, TRUE)
=HISTOGRAM(A3:A9, B3:B7, TRUE,TRUE,TRUE,TRUE)
returns the following table:
returns the following table:
| 1
| 1
| 85.71428571428571%
| 85.71428571428571%
| 50
| 50
| 1
| 1
| 100%
| 100%
|- class="odd"
| 50
| 50
| 1
| 1
| 100%
| 30
| 0
| 100%
| 100%
|- class="odd"
|- class="odd"
|}
|}
The Histogram chart is also displayed.
The Histogram chart is also displayed.
==Related Videos==
{{#ev:youtube|gSEYtAjuZ-Y|280|center|HISTOGRAM}}
== See Also ==
== See Also ==
*[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 ]]