ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Statistics (https://www.excelbanter.com/excel-discussion-misc-queries/126619-statistics.html)

bebec20

Statistics
 
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?

Dave F

Statistics
 
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?


Jon Peltier

Statistics
 
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?





All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com