|
|
In the following, I would like the "TOTAL" column to contain weighted
data. Is that possible in Custom Tables? If so, how is it achieved?
Thanks!
Spring 2005-06
Summer 2005-06
Fall 2006-07
Spring 2006-07
Summer 2006-07
Total
Excellent
36.0%
75.0%
64.3%
60.0%
92.3%
62.3%
Above Average
20.0%
15.0%
21.4%
20.0%
7.7%
16.9%
Average
36.0%
10.0%
14.3%
20.0%
0.0%
18.2%
Below Average
8.0%
0.0%
0.0%
0.0%
0.0%
2.6%
Poor
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
Count
25
20
14
5
13
77
Mean
3.84
4.65
4.5
4.4
4.92
4.39
Median
4
5
5
5
5
5
The code I am utilizing:
CTABLES
/FORMAT EMPTY=ZERO MISSING='.' MINCOLWIDTH=60 MAXCOLWIDTH=60
UNITS=POINTS
/SMISSING VARIABLE
/VLABELS VARIABLES=Term2 Q9 DISPLAY=DEFAULT
/TABLE Q9 [COLPCT.COUNT ' ' PCT40.1, TOTALS[COUNT COMMA40.0, MEAN
COMMA40.2,
MEDIAN COMMA40.1]] BY Term2
/SLABELS POSITION=ROW
/CATEGORIES VARIABLES=Term2 ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES
POSITION=AFTER
/CATEGORIES VARIABLES=Q9 ORDER=D KEY=VALUE EMPTY=INCLUDE TOTAL=YES
POSITION=AFTER.
Sherry
Sherry Downing
Director of Institutional Assessment, Research and Planning
Good Samaritan College of Nursing and Health Science
A man who does not read good books has no advantage over the man who
can't read them. (Mark Twain)
PRIVACY/CONFIDENTIALITY NOTICE REGARDING PROTECTED HEALTH INFORMATION
This email (and accompanying documents) contains protected health information that is privileged, confidential and/or otherwise exempt from and protected from disclosure under applicable laws, including the Health Insurance Portability and Accountability Act. The information contained in this email (and any accompanying documents) is intended only for the personal and confidential use of the intended recipient. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this information in error and that any review, dissemination, distribution, copying or action taken in reliance on the contents of this communication is strictly prohibited. If you have received this communication in error, please destroy it immediately.
|
Locked
