+ Reply to Thread
Results 1 to 8 of 8

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

  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.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,453

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

    Sorry I don't have more time, but I suggest you have a look at the FREQUENCY function

  3. #3
    Forum Contributor Steve N.'s Avatar
    Join Date
    12-22-2011
    Location
    USA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    298

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

    Will this work for you?
    Attached Files Attached Files

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

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

    Quote Originally Posted by Pepe Le Mokko View Post
    Sorry I don't have more time, but I suggest you have a look at the FREQUENCY function
    thanks!! that helped a lot. but i dont get how to make excel find the temperatures. now i have to put in manually but all the sheets have different max and minimums. but i kinda expected excel to find the range.thanks anyways

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

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

    hey thanks. i suppose I can do this. but than i have to find the range of numbers with hand or manually. i needed excel to give me estimate. ^^ but i can really use this if i dont find the way to do it.

  6. #6
    Forum Contributor Steve N.'s Avatar
    Join Date
    12-22-2011
    Location
    USA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    298

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

    Can you post a a sample of what you would like to achieve? Perhaps if I could see better how to help...

  7. #7
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

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

    Maybe this link on How to create a Histogram in Excel will be of help.

    Here links to YouTube video demos on how to create histograms
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  8. #8
    Forum Contributor Steve N.'s Avatar
    Join Date
    12-22-2011
    Location
    USA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    298

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

    Had to take that histogram for a test ride. Runs pretty good!
    Attached Files Attached Files

+ Reply to Thread

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