| Line 1: |
Line 1: |
| − | =HISTOGRAM(SomeArray,BinRange,SomePareToFlag,SomeCumulativeFlag,SomeChartFlag,NewTableFlag)= | + | =HISTOGRAM (Array,BinRange,PareToFlag,CumulativeFlag,ShowChart,NewTableFlag)= |
| | | | |
| − | *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. |
| | | | |
| Line 12: |
Line 13: |
| | == 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). |