Histograms in a spreadsheet?
Mar. 28th, 2007 04:34 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
I want to do a histogram - that is a count of frequency of reply - in some sort of spreadsheet program. I want to be able to input each person's responses (for example, from a survey) and have it tally up the number of responses for me. As I understand it, Excel cannot do this, I'd have to tell it how many people gave each reply. Anyone know of another (free) program that can do this for me, or will I have to relearn C++ and find a compiler, or just do it by hand since there's "only" going to be 68 people?
ETA: I've been told that Access can do this, so I'm goign to play with that. And with Excel according to what
kadath says.
ETAA: In MS Excel, go to the Tools menu and Data Analysis... If yours doesn't have that menu, first click "Add-Ins..." to install it (no CD required). Use the Help dialogue to figure out how to install it and use it.
ETA: I've been told that Access can do this, so I'm goign to play with that. And with Excel according to what
![[livejournal.com profile]](https://www.dreamwidth.org/img/external/lj-userinfo.gif)
ETAA: In MS Excel, go to the Tools menu and Data Analysis... If yours doesn't have that menu, first click "Add-Ins..." to install it (no CD required). Use the Help dialogue to figure out how to install it and use it.
no subject
Date: 2007-03-28 08:43 pm (UTC)no subject
Date: 2007-03-28 08:51 pm (UTC)no subject
Date: 2007-03-28 08:54 pm (UTC)Once this is installed, you can generate a histogram with Tools -> Data Analysis. Choose "Histogram" from the options in the box.
no subject
Date: 2007-03-28 08:58 pm (UTC)no subject
Date: 2007-03-28 08:58 pm (UTC)no subject
Date: 2007-03-28 09:00 pm (UTC)no subject
Date: 2007-03-28 09:09 pm (UTC)no subject
Date: 2007-03-29 12:14 am (UTC)no subject
Date: 2007-03-29 12:49 am (UTC)