>Hi Doug,
>A couple of weeks ago you replied to a request on Museum-L and suggested the
>asker use an Excel pivot table to get what that person wanted from
>crosstabs.
>
>I use Excel to enter data but then export it into Systat to do statistics
>and crosstabs.  I've been unable to figure out how to get frequencies from
>an Excel table.  I know I can put in a formula and get a sum or an average,
>but not anything like frequencies.
>
>Can you give me an idea of what I need to do?

I can think of two ways to get the information. If you go to the Menu Bar

tools > data analysis > (take Histograms from the pop up window)

The data analysis functions need to be "added" to Excel. The exact method
varies with the version of Excel. It's possible you may have left them
out and therefore missed them. There are a number of statistical functions
available under the data analysis.

Another approach would be to:

        sort the data
        Select the column of interest
        Select Subtotals from the Menu
        there are two pop up options the bottom one offers SUM
                instead chose COUNT

Good luck.

>
>Thanks
>Linda Wilson
>Visitor Studies and Evaluation
>Shedd Aquarium, Chicago IL 60605
>[log in to unmask]

END
end
**************************************************
Douglas W. St.Clair
Tir Na Nog
400 Burton Highway
Wilton. NH 03086-5022
PH: 603-654-9321
FAX: 603-654-5440
EMAIL: [log in to unmask]
WebSite: http://www.tellink.net/~dwstclair
**************************************************