use of crosstabs without actually having the full data

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

use of crosstabs without actually having the full data

Moshe Marko
Hi,

What I am trying to do is to compare the % medical students in a physical
therapy school who participate in physical activity at the recommended level
to the national % of persons at the same age who do so. So I have my data
(of course) and I also have a report published by the CDC (centers for
disease control). The report by the CDC has only the number of persons who
follow the guidelines or not. Specifically, it is recommended that a healthy
adult in the US should be engaged in a vigorous physical activity a minimum
of 20 minutes for 3 days or more a week. Now, what I found was that 67%
physical therapy students report 3 or more days per week while, nationally,
the rate stands at 28%. From the national report I also have the total
number of respondents as well as the number of persons who engage in
vigorous physical activity for 3 or more days a week. Is there a way for me
to compare the populations and see if, indeed, the difference is
statistically significant? I was thinking about crosstabs and chi square but
how should I set the variables

Thanks

Moshe

Moshe Marko, PT, DPT, MHS, OCS, CSCS
Assistant Professor
Department of Physical Therapy Education
College of Health Professions
SUNY Upstate Medical University
Room 2232  Silverman Hall
750 Adams Street
Syracuse, NY 13210-1834
315 464 6577
FAX 315 464 6887
[hidden email]

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Reply | Threaded
Open this post in threaded view
|

Re: use of crosstabs without actually having the full data

Garry Gelade
Dear Moshe

Just go to his webpage and enter your data.

http://www.dimensionresearch.com/resources/calculators/ztest.html

Regards
Garry Gelade
Business Analytic Ltd.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Moshe Marko
Sent: 26 December 2010 21:28
To: [hidden email]
Subject: use of crosstabs without actually having the full data

Hi,

What I am trying to do is to compare the % medical students in a physical
therapy school who participate in physical activity at the recommended level
to the national % of persons at the same age who do so. So I have my data
(of course) and I also have a report published by the CDC (centers for
disease control). The report by the CDC has only the number of persons who
follow the guidelines or not. Specifically, it is recommended that a healthy
adult in the US should be engaged in a vigorous physical activity a minimum
of 20 minutes for 3 days or more a week. Now, what I found was that 67%
physical therapy students report 3 or more days per week while, nationally,
the rate stands at 28%. From the national report I also have the total
number of respondents as well as the number of persons who engage in
vigorous physical activity for 3 or more days a week. Is there a way for me
to compare the populations and see if, indeed, the difference is
statistically significant? I was thinking about crosstabs and chi square but
how should I set the variables

Thanks

Moshe

Moshe Marko, PT, DPT, MHS, OCS, CSCS
Assistant Professor
Department of Physical Therapy Education
College of Health Professions
SUNY Upstate Medical University
Room 2232  Silverman Hall
750 Adams Street
Syracuse, NY 13210-1834
315 464 6577
FAX 315 464 6887
[hidden email]

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Reply | Threaded
Open this post in threaded view
|

Re: use of crosstabs without actually having the full data

Ryan
In reply to this post by Moshe Marko
Moshe,

Assuming you have the values for cells {a} through {d} below, you can
run a Chi-Square Test for Independence via CROSSTABS.

                                         Factor A
                               --------------------------------
                               Level 1            Level 2
                               ---------             ---------
                Level 1       {a}                   {b}
Factor B
                Level 2       {c}                   {d}
                               --------------------------------

SPSS code follows (Remember to replacI the "{letter}" with the actual numbers):

*--------------------------------------------------------------.
DATA LIST LIST /Factor_A Factor_B weight.
BEGIN DATA
1 1 {a}
1 2 {b}
2 1 {c}
2 2 {d}
END DATA.
LIST.

WEIGHT BY weight.

CROSSTABS
  /TABLES=Factor_A  BY Factor_B
  /FORMAT= AVALUE TABLES
  /STATISTICS=CHISQ
  /CELLS= COUNT ROW COLUMN TOTAL.
*--------------------------------------------------------------.

Ryan

On Sun, Dec 26, 2010 at 4:28 PM, Moshe Marko <[hidden email]> wrote:

> Hi,
>
> What I am trying to do is to compare the % medical students in a physical
> therapy school who participate in physical activity at the recommended level
> to the national % of persons at the same age who do so. So I have my data
> (of course) and I also have a report published by the CDC (centers for
> disease control). The report by the CDC has only the number of persons who
> follow the guidelines or not. Specifically, it is recommended that a healthy
> adult in the US should be engaged in a vigorous physical activity a minimum
> of 20 minutes for 3 days or more a week. Now, what I found was that 67%
> physical therapy students report 3 or more days per week while, nationally,
> the rate stands at 28%. From the national report I also have the total
> number of respondents as well as the number of persons who engage in
> vigorous physical activity for 3 or more days a week. Is there a way for me
> to compare the populations and see if, indeed, the difference is
> statistically significant? I was thinking about crosstabs and chi square but
> how should I set the variables
>
> Thanks
>
> Moshe
>
> Moshe Marko, PT, DPT, MHS, OCS, CSCS
> Assistant Professor
> Department of Physical Therapy Education
> College of Health Professions
> SUNY Upstate Medical University
> Room 2232  Silverman Hall
> 750 Adams Street
> Syracuse, NY 13210-1834
> 315 464 6577
> FAX 315 464 6887
> [hidden email]
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD
>

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD