Results 1 to 8 of 8

seriously stuck on a simple distribution chart but for weather temperatures!!

Threaded View

  1. #1
    Registered User
    Join Date
    12-23-2012
    Location
    tokyo
    MS-Off Ver
    Excel 2010
    Posts
    3

    Unhappy seriously stuck on a simple distribution chart but for weather temperatures!!

    HI!!
    I am not an excel person and i am really lost. I tired searching internet but cant find something like this. its supposed to be simple for those who understand excel or MATH. lol sorry i am neither one!!
    i have a column with 625 different temperature datas. one sheet for summer one for winter. i wanna make a simple distribution graph, that says how many of each temperatures i got.
    for example in this 625 points like 10 are between 14-20 and 20 are between 20-26 and so on. Or even percentages would be nice, like 20% is between 4-6C and so on. I really dont get this. and net is confusing me more...!! anyone??? I will attach one set of the data. so you can see what i mean. i have over 30 of these for 10 different locations in 3 seasons.
    I truly hope someone can help me out, cus i am writing my thesis and I am stuck. my professor out of no where wants me to make such graphs and I have over 30 sheets and only 2 weeks to go. considering I only wrote half my paper. After spending whole week I have seriously given up on learning excel. anything you say as formulas I will do at this point. LOL Or if there is Macro or Winter temps 1.xlsplugin for this that does this. I would truly appreciate it.
    Yes I am disperate.
    Last edited by xandras; 12-24-2012 at 12:03 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