We would have a lot of empty bins on the left side of our figure (since there are no. Since we want to make a histogram to show the distribution of grades for. For a value to appear in a data set 2.5 times or 1.7 times (anything other than 0. Instructions: The following graphical tool creates a histogram based on the data you provide in the boxes below. All you have to do is type your data and also the number of bins (typically between 4 and 10). The tool will construct a histogram for you, corresponding to the data you entered.
I have a spreadsheet containing timestamps, that I want to display as a histogramI've installed the Data Analysis plugin, and I have need to visualise a spreadsheet of timestamps as a histogram, but Excel (2010) is automatically generating a bin range when I want to set it manually. The source data has times in hh:mm:ss format and the bin range I'm specifying has the same format.
I don't think you need the data analysis plugin for this. Times in Excel are just real numbers between 0 and 1. Midnight is 0, 1:00 AM is 1/24, 2:00 AM is 2/24, etc.
So let's say you have some times in cells A1:A40. Put the bins in cells E1:E24. I used 1/24, 2/24, etc., through 24/24=1. But you could use whatever you want for the bins. So if you knew the times were all between 8 AM and 5 PM the bins would be 9/24, 10/24, ... 17/24.
Then use the array formula FREQUENCY. Highlight cells F1:F24, then go up to the input box and type in =frequency(A1:A40,E1:E24)
After this you have to press CMD+SHIFT+ENTER (at least on a Mac -- Windows may have a different convention). Then the frequencies will be in cells F1:F24 and you can use the charting functions to make the bar chart. You can also format cells E1:E24 as times.
Look at the documentation for the FREQUENCY function.
posted by Pararrayos at 4:41 AM on July 17, 2014 [2 favorites]
So let's say you have some times in cells A1:A40. Put the bins in cells E1:E24. I used 1/24, 2/24, etc., through 24/24=1. But you could use whatever you want for the bins. So if you knew the times were all between 8 AM and 5 PM the bins would be 9/24, 10/24, ... 17/24.
Then use the array formula FREQUENCY. Highlight cells F1:F24, then go up to the input box and type in =frequency(A1:A40,E1:E24)
After this you have to press CMD+SHIFT+ENTER (at least on a Mac -- Windows may have a different convention). Then the frequencies will be in cells F1:F24 and you can use the charting functions to make the bar chart. You can also format cells E1:E24 as times.
Look at the documentation for the FREQUENCY function.
posted by Pararrayos at 4:41 AM on July 17, 2014 [2 favorites]
« Older Help me not live off Trader Joe's and Lean Cuisine... | Can you take too much activated charcoal? Newer »
Make me an Excel rockstar!April 11, 2014
What are the best ways to increase Excel skills?July 1, 2012
Free online graphing app that plays well with Excel?November 22, 2011
Excel Filter: Search the contents of one cell for...February 24, 2010
Get rid of one gray w/ photoshopDecember 9, 2008
What are the best ways to increase Excel skills?July 1, 2012
Free online graphing app that plays well with Excel?November 22, 2011
Excel Filter: Search the contents of one cell for...February 24, 2010
Get rid of one gray w/ photoshopDecember 9, 2008