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.
Bookmarks