Results 1 to 3 of 3

Statistics in Excel HELP!

Threaded View

  1. #1
    Registered User
    Join Date
    11-06-2006
    Posts
    1

    Statistics in Excel

    Hi everyone, first thanks for the help.

    I am trying to create a histogram and let me explain some of the data.

    I have a list of data separated like so:
    3.5
    3.6
    3.8
    3.8
    3.9
    3.9
    etc...

    Now I need to calculate the frequencies of these like so:
    3.5 (up to but not including) 4.0
    4.0 (up to but not including) 4.5

    I can count out the frequencies myself but i need to create a histogram (bar graph) with the y axis as the frequency and the x axis as the IMR(infant mortality rate: ie the 3.5 (up to but not including) 4.0).

    I am having problems with calculating the frequencies because when setting the bin values because they include 4.0.

    If this is confusing I can provide some more information, but cannot find a good tutorial that would create a histogram anywhere remotely close to the histogram i drew by hand.
    Last edited by VBA Noob; 03-08-2007 at 06:28 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1