#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,574
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
statistics problem driller New Users to Excel 1 November 18th 06 04:55 PM
Combining Statistics Mark New Users to Excel 1 June 2nd 06 09:03 PM
Summary statistics for a golf scores spreadsheet Neuman Excel Worksheet Functions 3 May 9th 06 06:53 AM
Doing Statistics on Time Values Peter_G Excel Discussion (Misc queries) 2 October 13th 05 11:59 AM
Regression Statistics are returned as Rounded to 1 vs. several dec DWright Excel Worksheet Functions 2 September 9th 05 04:38 PM


All times are GMT +1. The time now is 03:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"