Frequency Polygons what are they?

**johnmw1** · 02-26-2010, 02:44 AM

Hi,

Could someone help me with some charts which I have to create for an exercise for school please.

As you can see from my attempt at the histogram, that is about the only information that I actually understand. I for the life of me cannot see any of the other stats and their correlation together, and I definitely don't know how to create a Frequency polygon etc.

In a word document I also have to analyse the graphs and information which I have created to give an understanding of the spending pattern of the delegates.

Sorry for having to ask but we are being taught by someone who does not understand the subject themselves and even less on chart creation, so all in all I'm scratching myself.

Cheers
John

**rwgrietveld** · 02-26-2010, 03:20 AM

Are you sure that this should be done with EXCEL. Seems to me that it is a specific statistical task for SPSS, SAS, etc.

**johnmw1** · 02-26-2010, 05:26 PM

Originally Posted by rwg rietveld

Are you sure that this should be done with EXCEL. Seems to me that it is a specific statistical task for SPSS, SAS, etc.

Hi Ricardo,

No, Excel is all we have access to. They just want us to be able to start identifying relative stats and being able to put them into meaningful charts. But as I said previously I'm none the wiser, and apart from the histogram I don't know what or how to create the other charts into any sort of correlation.

Cheers
John

**Andy Pope** · 03-01-2010, 05:25 AM

This looked quite informative.
http://cnx.org/content/m10214/latest/
http://cnx.org/content/m16012/latest/

http://www.ozgrid.com/News/excel-histogram.htm
http://www.google.co.uk/url?sa=t&sou...n68330LwVsuxNQ
http://www.compmat.wcape.school.za/P...istr/index.htm
http://video.google.co.uk/videosearc...ed=0CA0QqwQwAA

**johnmw1** · 03-01-2010, 04:42 PM

Hi Andy,

Many thanks for that. I will have lots of reading, and from what I have read so far, it makes much more sense than what is currently being taught to us.

Cheers
John

**Paul** · 03-01-2010, 07:21 PM

John, glad you have found some assistance. In the future, though, please create threads with appropriate titles per the forum rules.

Your post title should accurately and concisely describe your problem. Use terms appropriate to a Google search. Examples of poor thread titles are: Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice.

To change a Title on your post, click EDIT, then click Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Thanks!

**johnmw1** · 03-02-2010, 03:44 AM

Hi Paul,

I'm sorry about the "Charting" title but it certainly was not mine, someone else I assume has had a go and changed it for me.

If you look at message #2 that is what I had as a message title, which now I see is also inappropriate, so apologies for that.

Cheers,
John