frequencies

[Keval Khichadia]

Hi,

 

I have a data file that looks like this.

 

ID     EnrolledF09 AppliedforGrad  AcademicHold       major

 

1         'Y'                                                                                ART

2                                                                                              ART

3                                  'Y'                                                       ART

4         'Y'                                                                                BIO   

5                                                                                             BIO   

6         'Y'                                                                                BIO

7                                                                'Y'                          BIO

8                                  'Y'                                                         BIO

9         'Y'                                                                                   BIO

10       'Y'                                                                                  BIO   

 

 

 

I need to report the % of students by each major who enrolledF09 and appliedforGrad. Also, out of the people who did not enroll or apply for graduation I need to report the % who have AcademicHolds. There are about 30 different majors and I want to create an excel workbook with different tabs for different majors displaying the frequencies.

 

What I would like to do is make a copy of each dataset by major then save to excel as a separate tab for each major:

 

dataset copy ART.

select if major = 'ART'.

 

and then compute additional variables displaying the Percentages.

 

For example, for ART there would be a column created (PercentageEnrolledF09) which would be 33% using the example above. Another column would be PercenatgeAppliedforGrad which would be 33%, and the final column would be PercentageAcademicHolds which would be 0%.

 

How can I calculate these %'s so the same value appears in each column like this?

 

 

Thanks,

 

Keval

 

 

 

[Dennis Deck]

What you want can be produced much more simply. 

 

Personally I would use 0 to represent No and 1 to represent Yes.

The average of such a variable represents the proportion for whom the answer was a Yes.  

When I chart the results, I select the % format (.5 displays as 50%).

 

First create numeric variables (substitute 100 for yes if you really want a 3 digit number)
Note that (‘ ‘=0) converts the implied ‘N’:

 

RECODE EnrolledFO9  AppliedForGrad AcademicHold

      (‘Y’=1) (’ ‘=0)  

   INTO nEnrolledF09 nAppliedForGrad nAcademicHold .

 

Create a concise summary table with code like:

MEANS

   Tables= nEnrolledF09 nAppliedForGrad nAcademicHold BY Major

  /Cells= Mean .

 

You could use AGGREGATE to get means by Major and write that to a spreadsheet
but I assume the table above is all you really need.

 

I assume that the absence of a ‘Y’ implies  ‘N’ but consider whether there are cases where there is a “not applicable”.

 

Dennis Deck

RMC Research

 

---

From: Keval Khichadia [mailto:[hidden email]]
Sent: Monday, May 04, 2009 2:55 PM
Subject: frequencies

 

Hi,

 

I have a data file that looks like this.

 

ID     EnrolledF09 AppliedforGrad  AcademicHold       major

 

1         'Y'                                                                                ART

2                                                                                              ART

3                                  'Y'                                                       ART

4         'Y'                                                                                BIO   

5                                                                                             BIO   

6         'Y'                                                                                BIO

7                                                                'Y'                          BIO

8                                  'Y'                                                         BIO

9         'Y'                                                                                   BIO

10       'Y'                                                                                  BIO   

 

 

 

I need to report the % of students by each major who enrolledF09 and appliedforGrad. Also, out of the people who did not enroll or apply for graduation I need to report the % who have AcademicHolds. There are about 30 different majors and I want to create an excel workbook with different tabs for different majors displaying the frequencies.

 

What I would like to do is make a copy of each dataset by major then save to excel as a separate tab for each major:

 

dataset copy ART.

select if major = 'ART'.

 

and then compute additional variables displaying the Percentages.

 

For example, for ART there would be a column created (PercentageEnrolledF09) which would be 33% using the example above. Another column would be PercenatgeAppliedforGrad which would be 33%, and the final column would be PercentageAcademicHolds which would be 0%.

 

How can I calculate these %'s so the same value appears in each column like this?

 

 

Thanks,

 

Keval