# Manuals/calci/HISTOGRAM

Jump to navigation
Jump to search

**HISTOGRAM**(Array, BinRange, NewTableFlag)

where,

**Array **- Input range should be one block.

**BinRange **- Input range should be one block.

**NewTableFlag** - is the TRUE or FALSE.If set as TRUE,the result in new sheet. If NewTableFlag is omitted, it assumed to be FALSE.

Histogram counts occurences in each of several data bins.

Lets see an example in (Column3Row1)

=HISTOGRAM (R1C1:R6C1, R1C2:R6C2, TRUE)

HISTOGRAM returns the result in new sheet(5Space).

HISTOGRAM

Syntax

Remarks

Examples

Description

Column1 | Column2 | Column3 | Column4 | |

Row1 | 1 | 3 | 5Space | 5 |

Row2 | 7 | 8 | 9 | 128 |

Row3 | 12 | 8 | 14 | 15 |

Row4 | 17 | 18 | 10000 | 20 |

Row5 | 37 | 34 | 10023 | 168 |

Row6 | 6 | 5 | 1.619775 | 0.525322 |

Bin | Frequency |
---|---|

3 | 1 |

8 | 2 |

8 | 0 |

18 | 2 |

34 | 0 |

5 | 0 |

More | 1 |