I'm trying to make a histogram with excel
This is what I get
It's supposed to look more like this
I'm having trouble importing the data into excel
from textedit...
=/
that's ok :)
That's a bar graph, not a histogram.
What do those data represent? Are they all from one sample? If you're having trouble importing, sometimes copying the data to Word, or Notepad or something first helps - put all the numbers in a single row. If you still have trouble, go back and put commas between all the numbers (Excel should recognize the spaces and put the numbers in different cells, though.
they're all from one sample. I'll try putting in commas
I was able to transfer the data over. The boundaries are in the attachment. How do I calculate the frequencies using excel?
@CliffSedge
I forget the particular function. With a data set that small, I would just count them myself.
Join our real-time social learning platform and learn together with your friends!