Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am having alot of trouble entering info for class. I have to do frequency
dist, and histogram, percent polys, etc. I don't know how to enter the info correct, it asks for abin range, I don't know what that is? How do you know the midpoint? Is it really this difficult or am I missing something? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Bin ranges are the groups into which the frequency distribution is divided.
Perhaps this is a good place to start your research: http://en.wikipedia.org/wiki/Frequency_%28statistics%29 Dave -- Brevity is the soul of wit. "bebec20" wrote: I am having alot of trouble entering info for class. I have to do frequency dist, and histogram, percent polys, etc. I don't know how to enter the info correct, it asks for abin range, I don't know what that is? How do you know the midpoint? Is it really this difficult or am I missing something? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Enter the data in a column. Enter the bins in another column.
This page tells a bit about Excel's histograms: http://peltiertech.com/Excel/Charts/Histograms.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Dave F" wrote in message ... Bin ranges are the groups into which the frequency distribution is divided. Perhaps this is a good place to start your research: http://en.wikipedia.org/wiki/Frequency_%28statistics%29 Dave -- Brevity is the soul of wit. "bebec20" wrote: I am having alot of trouble entering info for class. I have to do frequency dist, and histogram, percent polys, etc. I don't know how to enter the info correct, it asks for abin range, I don't know what that is? How do you know the midpoint? Is it really this difficult or am I missing something? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
statistics problem | New Users to Excel | |||
Combining Statistics | New Users to Excel | |||
Summary statistics for a golf scores spreadsheet | Excel Worksheet Functions | |||
Doing Statistics on Time Values | Excel Discussion (Misc queries) | |||
Regression Statistics are returned as Rounded to 1 vs. several dec | Excel Worksheet Functions |