Add missing "Histogram" function from Data Analysis Toolkit
*** Bug 82716 has been marked as a duplicate of this bug. ***
changed source and target. Make this bug the duplicate of bug 82716.
Best regards. JBF
*** This bug has been marked as a duplicate of bug 82716 ***
''Bug 82716 isn't directly related to this one. That bug is about easier creating a histogram chart so you don't have to put extra histogram related data into the sheet - a dedicated histogram chart type. This one is about calculating the histogram from data and putting the results back into the sheet.
I'll put this one back to status NEW.
For competitive comparison, MS Office 2016 is going to implement a Histogram chart type: https://blogs.office.com/2015/07/02/introducing-new-and-modern-chart-types-now-available-in-office-2016-preview/
Isn't bug 81530 (which is linked to this page as "See also") actually a duplicate?
Both bugs refer to the chart type HISTOGRAM, while this bug refers to its entry in the Data Analysis Toolkit and the other bug in the Insert -> Chart types.
No.. that are 2 exclusive features. You can make a histogram function for the data analysis toolkit without adding a histogram chart type and the other way around.
Setting Assignee back to default. Please assign it back to yourself if you're
still working on this issue
(In reply to Tomaz Vajngerl from comment #6)
> No.. that are 2 exclusive features. You can make a histogram function for
> the data analysis toolkit without adding a histogram chart type and the
> other way around.
Tomaz, what do you expect from a 'histogram' function that is not available with frequency()? https://help.libreoffice.org/Calc/Array_Functions#FREQUENCY
The common understanding of a histogram is the graphical representation of what frequency calculates.
This is not about adding a new HISTOGRAM function.
This is all about quickly preparing data to create data for a histogram which will use existing formulas (like FREQUENCY). Bin calculation is the key here, which will be created automatically depending on user input (number of bins) and other options. See how Analysis Toolkit works in Excel..
Feature is available in Excel and Gnumeric, so there isnt any reason not to also have it in Calc.
The design team talked about the request in the meeting. The requested Data > Statistics wizard is generic, so no mockup is needed. First, the bins have to be calculated equidistantly between min and max based on the user input on how many, followed by frequencies() and the histogram generation.