Frequency Distributions

J

JoLeigh

Is there an easy way to create frequency distributions in Access?
I have a field that gives response times. I would like to know in how many
instances, responses were made in less than 5 minutes, between 5 and 10
minutes, between 10 and 30 minutes, and over 30 minutes.
In the past, I've exported the data sets of interest to excel and created
histograms in excel. The data sets, however, are often more than excel can
accomodate in a single worksheet, so I've had to do this in pieces and then
put the numbers back together. As such, it would be great if I could do it
directly in Access without having to export the raw data to Excel.
As always, your expertise is greatly appreciated!
 
M

mscertified

You can do this with SQL queries:
I set up a separate query for each FD, as follows
SELECT count(*) AS FD1 FROM tblTimes WHERE intTime between 0 and 10;
SELECT count(*) AS FD2 FROM tblTimes WHERE intTime between 11 and 20;
SELECT count(*) AS FD3 FROM tblTimes WHERE intTime between 21 and 30;

Then a final query grabs the results of each of the above queries
SELECT * FROM qryFD1, qryFD2, qryFD3;

This gives a table with a separate column for each FD

- Dorian
 
J

JoLeigh

Data are whole numbers -- I'll be putting together many frequency
distributions -- however, for each one, the data will be pulled from a single
field.
Thanks for your response.
 
J

JoLeigh

I can see where you're going with this, but... I don't know how to do SQL
queries. All I know how to do is to use expressions in the design view of
queries. Would you recommend the Access Help screens to get me started on
SQL queries, or can you point me in another direction? Thanks much.
 
J

John Spencer

Details of your table structure would probably help.

Using a TOTALs query and the following calculated fields may give you the
frequency distribution you want

Field: Count5: Abs(Sum(YourMinutesField<5))

Field:Count5to10: Abs(Sum(YourMinutesfield>=5 and YourMinuteField<=10))

Field: Count11To30:Abs(Sum(YourMinutesfield>10and YourMinuteField<=30))

Use Expression as the TOTALS value in the query grid
 
Top