[Solved] Frequency distribution - error #Value

Discuss the spreadsheet application

[Solved] Frequency distribution - error #Value

Postby DocC » Sat May 25, 2019 9:10 am

I have been struggling with a hit-up in Calc that might be of my own making (admittedly). I've been trying to do a frequency distribution, but each time that I try to use the function button, and start the process, I get an error message: #VALUE!

I engage the formula function by applying FUNCTION under the all spread and then click next. After this, I highlight the column for the data selection, then I highlight the other column of bin parameters that I created [see attachment].

I then make sure Array is checked and click Okay.

Then I get the #VALUE! error message.

Any help getting my frequency distribution up and running would be appreciated.


Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply [robleyd, Moderator].. Was asking for expertise
Bin.jpeg (37.68 KiB) Viewed 372 times
Last edited by Hagar Delest on Sun May 26, 2019 1:00 pm, edited 2 times in total.
Reason: tagged solved
D. Crohan Open Office 3.2.1 MAC 10.13.1
Posts: 2
Joined: Sat May 25, 2019 8:44 am

Re: Frequency distribution - error #Value

Postby robleyd » Sat May 25, 2019 11:24 am

You forgot to mention which function you are using that is giving you the error. You have also posted an image which tells us nothing about what you have done; this is akin to taking a picture of your car to the auto technician and telling him "Something is wrong with my car - please fix it now".

The error #Value is described in the Help - F1 thus:
No result (#VALUE is in the cell rather than Err:519!)
The formula yields a value that does not corresponds to the definition, or a cell that is referenced in the formula contains a text string instead of a number.

Perhaps you could upload a sample file showing the issue you are having. [Forum] How to attach a document here Note maximum file size is 128K. If your file is larger, use a file sharing site such as Mediafire and post the link here. The link also contains information on how to anonymise your document if it contains confidential information.
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
Posts: 3397
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Frequency distribution - error #Value

Postby FJCC » Sat May 25, 2019 3:02 pm

If you are using the FREQUENCY() function, the bins have to be single numbers. These represent the upper limit of the bin. In the attached file, the first bin is for values up to 25. The second bin is for value > 25 and <= 28.
(9.77 KiB) Downloaded 20 times
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Posts: 7680
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Frequency distribution - error #Value

Postby DocC » Sat May 25, 2019 10:03 pm

Thank you much for your directions. You were right; the way I had set up the bins was the problem.

The tutorial Had used was really off and without your help I wouldn't have realized this. I'm glad I included the pic to help you, but I cant thank you enough for the good guidance and it was really helpful. Thanks again.

Are there any books or online tutorials that you would recommend for stats work and for graphing the results?

Thanks again for all you help!
D. Crohan Open Office 3.2.1 MAC 10.13.1
Posts: 2
Joined: Sat May 25, 2019 8:44 am

Return to Calc

Who is online

Users browsing this forum: No registered users and 14 guests