Exploring WinCross - The Analytical Group
Contents
1. The majority of your tables will be based to total respondents this means that all No answer responses from the questionnaire will be included in your tables but they will not show a percent select Help within this dialog box for more information about Profile Settings Filter options LI Confirm the Filter type of Total is selected LI Select the Show percent sign on filter row option The other selected Filter options Show filter title on filter row Show frequency on filter row and Show vertical percent on filter row will also be desirable Again we suggest referencing the online Help within any dialog box any time you would like more information about one or more options Let s save this profile with a descriptive name so we can use it in the future for other jobs that require similar settings LI Select Save Profile As to save the profile as a new name Save Profile As Enter a name for the new profile LJ Enter Display Percent Sign Profile as the new profile name Q Select OK to close the Save Profile As dialog box The Analytical Group Inc Exploring WinCross 10 Congratulations Display Percent Sign Profile has been saved as a new profile and contains the settings for the tables you will create for your new job Later you will learn how to override these settings for an individual table s LI Select OK to close the Profile Settings dialog page The Analytical Group Inc Exploring W2. Numeric T Create One Table Numeric l with Many Rows Numeric Numeric Numeric Numeric Summary of Means Create One Table Using Net Logic Summary of Frequencies m V Compute and display the frequency report automaticall E sin a y i Up 123 Renumber l Duplicate Select All Scan 1000 Scan all cases cases Name Q2_10 4 Down 123 Reindex 8 Edit Eormat x Delete Type Numeric S Job file definition Q 2 Agreement with the following statement I hope that more parks are built as the population of Arizona grows TGENDER 1 OW CR OV S2 P1 V2 SA SP Gender Total TN 0 Male GENDER 1 Female GENDER 2 gt fa Save Changes Apply Changes and Run Tables OK Cancel Help Q Select the next variable Q1 in the Variables list box Scroll down to variable Q2 10 With the Shift key selected click on variable Q2 10 This will select all variables from Q1 through 02 10 7 The Analytical Group Inc Exploring WinCross 18 When multiple variables are selected the frequency report will display the frequency information for the last variable selected G e H 55 Variables 11 selected 100 Cases 12 Tables 11 selected Find a table Find Next Find a variable Find Next seven vecsesseaseascpeseauabesesveesunnnesieee seasnssceancastaseses sa necocasasasasnsuaseanerenanqavesspecsey
3. v Compute and display the frequency report automatically av Beane Select All Up 1 3 Renumber 2 Duplicate Scan all cases Scan 1000 cases Name INCOME Down 123 Reindex Z Edit Format X Delete Type Numeric ote Job file definition Q 12 Which of the following best describes your annual household income T91 2 OW OR OV S2 P1 V2 SA SP E Q 1 On average how many hours per week do you spend participating in outdoor activi Total TN 0 Value Label Frequency Percent Less than 1 hour per week 1 Under 30 000 31 31 1 3 hours per week 2 Between 30 000 18 18 4 6 hours per week 3 Between 40 000 10 10 7 9 hours per week 4 Between 50 000 14 14 10 15 hours per week 5 16 20 hours per week 6 r OK Cancel Help A Q Select variable Q3 1 in the Variables list box Scroll down to variable INCOME With the Shift key selected click on variable INCOME The Analytical Group Inc Exploring WinCross 19 Q With variables Q3 1 through INCOME still selected choose Create 41 Tables to create tables for variables Q3 1 through INCOME LI Select OK to close the SPSS Express Table Setup dialog box Now that you ve created some basic tables using Setup Express Tables for SPSS Data we will use Setup Tables to make changes to these tables When you become more familiar with the WinCross job file and WinCro
4. Longer hours at Parks and Recreation after school programs 1 2 3 4 Q4 2 28 Well maintained playgrounds 1 2 3 4 Q4_3 29 Well maintained baseball diamonds 1 2 3 4 Q4_4 30 Being able to participate in organized hikes l 2 3 4 Q4 5 31 Educational classes held at Parks and Recreation visitor s centers 1 2 3 4 Q4_6 32 Volunteering as a park steward 1 2 3 4 Q4_7 33 Maintained the natural beauty of Arizona in the parks 1 2 3 4 Q4 8 34 Silent Sundays no cars allowed 1 2 3 4 Q4_9 35 Clean bathroom facilities 1 2 3 4 Q4 _10 36 The Analytical Group Inc Exploring WinCross _ 40 Q 5 Choose the statement below that best describes your opinion of Arizona parks Q5 37 Well maintained 1 Reflects the beauty of Arizona 2 Quiet and peaceful 3 Q 6 Agreement with the following statements I do not know much about or have never heard of Strongly Disagree Mountain Park 1 South Mountain Park 1 Piestewa Park 1 McDowell Mountain Park 1 Sabino Canyon Park 1 Squaw Peak Park 1 Grand Canyon National Park 1 Don t have much interest in Noisy and unorganized Not well supervised Somewhat Disagree 2 NONNYNWN WY Q 6A Of the last 10 visits to Arizona parks how many visits were to North Mountain Park South Mountain Park Piestewa Park McDowell Mountain Park Sabino Canyon Park Squaw Peak Park Grand Canyon National Park 0 10 0 10 0 10 0 10 0 10 0 10 0 10 Q6A_1 45 46 Q6A_2
5. Q 2 Agreement with the following statement I consider myself an outdoors person Table GENDER Page 1 GENDER Line 1 Column 1 INS You also have the option to view your tables in an Enhanced text report viewing format that can be customized by using the Enhanced Text Report Fonts and Colors option from the Setup menu LI Choose Run Tables again Q Verify that all tables have been selected or choose the Select All option adjacent to the Select tables list box Q Deselect the Plain text report option of Report viewing format L Select the Enhanced text report option of Report viewing format LI Choose Run to run your tables again Your tables should appear momentarily and have been formatted in an Enhanced text report viewing format TABLE OF CONTENTS Banner 1 Table GENDER Page 1 Gender Table Q1 Page 2 Q 1 On average how many hours per week do you spend participating in outdoor activities at Arizona parks Table Q2 1 Page B Q 2 Agreement with the following statement I consider myself an outdoors person Table GENDER Page Gender GENDER TOTAL FEMALE 400 140 260 100 0 100 0 100 0 Male 140 140 35 0 100 0 Line 1 Column INS Tables completed 3 Elapsed time The Analytical Group Inc Exploring WinCross __ 32 13 Formatting Reports WinCross enables you to customize your table report by using the Setup Enhanced Text Report Fonts and Co
6. scroll to the Row logic heading and select the blue Logic syntax link LI Once you have acquainted yourself with overall logic syntax select the blue Logic examples link Q Close the Help dialog box for now keeping in mind that the online Help provides answers to many of your WinCross questions Referring once again to the sample questionnaire note that Less than 1 hour per week entered a few moments ago is the first answer choice or value in Q1 Logically represented it becomes denoted as variable Q1 value 1 There are several rows to add each representing a different range of hours To reduce repetitive entries it will be useful to engage the Show previous option for Row logic LJ With the cursor in the Row logic field enter Q1 1 LI Engage the Show previous option for Row logic A check mark will appear in the Show previous check box Q Select the Add button or press Enter to add the row The Analytical Group Inc Exploring WinCross 15 Your cursor should have returned to the Row name field The contents of the Row logic field should remain as illustrated below You are ready to enter the remaining answers inthe Q 1 Hours per week spent participating in outdoor activities at Arizona parks question Q Enter 1 3 hours per week in the Row name field then press Tab The cursor moves to the right within the Row logic field 1 3 hours per week is still variable Q1 but its value is 2 Entering the answers becomes a very qu
7. with 2 Rows J G Voumeric a Create One Table 2ra Numeric 2 k Q2_ Using Net Logic Q2_2 Numeric Q2_3 Numeric Summary of Means Q2_4 Numeric Nnn E N mari Pm V Compute and display the frequency report automaticall P Pay a EP Y 4 Up 123 Renumber Duplicate Select All Scan 1000 Scan all cases cases Name GENDER 4 Down 8 Edit Eormat x Delete Type Numeric Summary of Frequencies aoe _____ _ ______ lt m Gender Value Label Frequency Percent Male SEY 37 0 Female 63 63 0 Total 100 100 0 Mean 1 63 H Save Changes Apply Changes and Run Tables OK Cancel Help LJ With the variable GENDER still selected choose Create 1 Table to create a table for GENDER The variable Name becomes the table Name and the variable Label becomes the table Title The variable Value Label and Codes become rows on the table The Job file definition window displays how the table will look in the WinCross job file Now that one table has been created let s create more tables by selecting more than one variable i aay SS Lo ame Ei Express Tables for SPSS Data C tag wcl 3eval example example say a 55 Variables 11 selected 100 Cases 1 Table 1 selected Find a table Find Next Find a variable Find Next Name Title V Scan data when creating tables GEN Gender a Create 11 Tables pe L
8. 1 Pos 4 10 10 10 10 10 Mean 4 50 10 0 10 0 10 0 10 0 Rec 1 Pos 5 63 Mean 1 63 63 0 Rec 1 Pos 6 2 12 Mean 4 37 17 0 12 0 Rec 1 Pos 7 16 48 Mean 3 22 Rec 1 Pos 8 32 Mean 2 81 32 0 Rec 1 Pos 9 27 Mean 3 46 27 0 Rec 1 Pos 10 16 The Analytical Group Inc Exploring WinCross _37 17 Running Frequencies A frequency provides a distribution count of the values in a field variable alpha characters can be included If the data is ASCII or column binary fields are entered as locations separated by columns If the data is not ASCII or column binary variables are listed by variable name and label To select variables that are non contiguous keep the Ctrl key depressed while individually selecting each desired field LI Choose Run Frequency I Run Freque Select the variables for frequency analysis from the list below Selected variables 3 Maximum 1000 Variable Name Variable Label 1 RESP Respondent Id La 2 GENDER Gender 3 Qi Q 1 On average how many hours per week do you spend participating in Recreation staff are well trained Q 2 Agreement with the following statement I usually visit an Arizona park at least once a week Q 2 Agreement with the following statement I wish all hiking paths in Arizona parks were paved Q 2 Agreement with the following statement I enjoy visiting the Arizona Parks and Recreation visitor centers Q 2 Agreement with the following statement I
9. 47 48 Q6A_3 49 50 Q6A_4 51 52 Q6A_5 53 54 Q6A_6 55 56 Q6A_7 57 58 Somewhat Agree 3 Go GW GW GW LWW UW 4 5 6 Strongly Agree 4 HHH AHA Don t Know aA ann anam Q 7 Would you say you are visiting Arizona parks more less or the same as you were a year ago Q7 59 More 1 The same 2 Less 3 Q 8 How likely are you to visit an Arizona park in the future Q8 60 Very likely l Somewhat likely 2 Somewhat unlikely 3 Not at all likely 4 The following questions are for classification purposes only Q 9 What is your current marital status Q9 61 Single never married 1 Living with partner 2 Married 3 Separated 4 Divorced 5 Widowed 6 Question 10 Do you have any children under the age of 18 living with you Q10 62 Yes 1 No Q 11 Which of the following best represents the highest level of education you have completed Education 63 Some high school or less l High school diploma or G E D Some college Associate s degree Bachelor s degree Graduate or professional degree Nm BW WN North Q6_1 38 Q6_2 39 Q6_3 40 Q6_4 41 Q6_5 42 Q6_6 43 Q6_7 44 The Analytical Group Inc Exploring WinCross _41 Q 12 Which of the following best describes your annual household income Income 64 65 Under 30 000 Between 30 000 and 39 000 Between 40 000 and 49 000 Between 50 000 and 59 000 Between 60 000 and 74 000 Between 75 0
10. RUNNING IANO RANG serseri cerns eases ceive ace eect EE A EE essences 36 17 RunNNO TN VSS tts ett pesca deiner asa Saipan ten Aon resanenapratl 37 More About WinCross and The Analytical Group Inc 38 Sample Questionnaire ooo ccc cece ce ctecscsecscsecsesecsesecsesecsesecsecacsecaesecaesecaesacaeecaeseeas 39 3 The Analytical Group Inc Exploring WinCross 4 Introducing WinCross WinCross is the most powerful cross tabulation software available today It is designed to be used by inexperienced analysts who simply want to identify various data relationships and experienced tab spec writers who need flexibility coupled with advanced features WinCross is powerful Here are just a few of its features KO ON KS NON NM RNR eN NR RRR NN RNR EN SS Wide array of statistical testing including T Test Z Test ANOVA and Chi Square Import data from SPSS Excel CSV ASCII Column binary and more Quick and easy table creation from a labeled SPSS sav file Use job and data files to create a labeled SPSS sav file Publish charts to Microsoft Excel PowerPoint and or Word Write tables to Excel with multiple formatting options Advanced Enhanced Text Report formatting options for tables frequencies marginals sample balancing and factor analysis reports Export reports in multiple formats ASCII Web browser Microsoft Word RTF Microsoft Excel Adobe PDF format Small sample size suppression and denotation Un
11. Type Create 11 Tables Numeric l Create One Table Numeric with Many Rows Numeric ETE Create One Table Using Net Logic i Numeric j Numeric Summary of Means Numeric N es Summary of Frequencies V Compute and display the frequency report automaticall P Pay a ELR y 4 Up 3 Renumber 2 Duplicate Select All Scan all cases Scan 1000 cases Name Q2_ 10 Down 123 Reindex Z Edit Eormat X Delete Type Numeric oe gt Job file definition Q 2 Agreement with the following statement I hope that more parks are built as the population of Arizona grows W 4 4 Value Label Frequency Percent Strongly Disagree 13 13 0 Somewhat Disagree 18 18 0 S Somewhat Agree 37 37 0 Strongly Agree 32 32 90 am Rae fd Save Changes Apply Changes and Run Tables Help x Oe _ __ j Q With variables Q1 through Q2 _10 still selected choose Create 11 Tables to create tables for variables Q1 through Q2_10 The variable Name becomes the table Name and the variable Label becomes the table Title The variable Value Label and Codes become rows on the table The Job file definition window displays how the tables will look in the WinCross job file You can select multiple variables and use the Create One Table with Many Rows Create One Table Using Net Logic Summary of Means or Summary of Frequencies options to combine rows from multiple tables This can be es
12. or Internet browser viewing You may want to experiment with some of the Setup Enhanced Text Report Fonts and Colors formatting options available for use with Enhanced Text reports Line 35 Column INS Tables completed 1 Modified The Analytical Group Inc Exploring WinCross _35 14 Saving Reports in XML Format Once tables have been run Enhanced Text reports are ready for immediate display and printing from within WinCross or using Internet Explorer WinCross allows you to save crosstabs in Enhanced Text reports xml format If you choose to save your Enhanced Text report files can be saved anywhere on your PC on your company intranet or can be uploaded to the Internet using file transfer protocol FTP Reports can be saved in Enhanced Text reports xml format by selecting File Save Report or File Save Report As Ez Save Report File WwIky F tag wel3Eval Example hd 4 Organize New folder I w Name Date modified Typ z Libraries W i paama No tems match your search a Music fe Pictures i Videos JE Computer g Local Disk C vol01 tag_corp F ee ee ee Sn Be mae Ne e TT File name Save as type xt Reports xml Hide Folders Microsoft Excel 1997 2003 xls Microsoft Excel 2007 2010 xIsx Adobe PDF pdf All files LI Verify that the Tables report that you just formatted using Setup Enhanced Text Report Fonts and Co
13. reports in RTF Microsoft Word XLS Microsoft Excel 1997 2003 XLSX Microsoft Excel 2007 2010 or PDF portable document format Optionally you can save WinCross reports in highly stylized Enhanced Text reports XML for displaying and printing from within WinCross and your Internet browser WinCross saves the custom formatting in a cascading style sheet CSS file having the same prefix as its parent XML file When saving XML reports six other files are also automatically created by WinCross They are filename css filename _run htm filename _content htm e filename _menu htm e WCCNTENT xsI e WCMENU xsl A log file has the extension LG Such a file contains information about the run such as the data file used the number of cases and so on Data files are created during a marketing research field study Most often they are generated using an Internet survey CATI computer assisted telephone interviewing CAPI computer assisted personal interviewing software applications such as QueryWeb and WinQuery also from The Analytical Group Inc WinCross does not alter your original data files in any way and accepts many file formats We have provided EXAMPLE SAV for this evaluation Optionally an ASCII data file EXAMPLE DAT is also provided and can be used for this hands on evaluation The marketing research questionnaire from which these data files were created is found on page 39 The Analytical Group Inc Expl
14. the cursor in the row of column 2 and enter GENDER LI Select the Enter key after typing GENDER and enter dashes across the merged row under GENDER Q Highlight GENDER and select Cells Center Justify to center the GENDER heading Now you are ready to enter logic for each of the three banner columns 2 7 The Analytical Group Inc Exploring WinCross 28 Edit Rows Columns Cells Layout Help Banner title Filter title Filter Column to use for ranking 1 2 3 TOTAL MALE FEMALE oo o Width and Spacing Options Horizontal Constant Percents Weights Comparison Groups _ 2 Banner logic for selected column LI Confirm the Logic tab is the currently selected tab on the Banner Editor dialog box If it is not the currently selected tab select the Logic tab LI Select 1 in the Column list box then enter TN in the adjacent Banner logic for selected column field LJ Press Enter or select 2 in the Columns list box LJ Enter GENDER 1 in the Banner logic for selected column field LJ Press Enter or select 3 in the Columns list box LJ Enter GENDER 2 in the Banner logic for selected column field You can preview how your banner will look by selecting the Preview Banner button at the bottom of the Banner Editor dialog box LJ Select Preview Banner Banner Editor Preview Banner as aa E m heal lt Table Title gt GENDER lt Table Filter Title gt Copy to Clipboard J Show hi
15. 00 and 99 000 Between 100 000 and 149 000 Between 150 000 and 199 000 Between 200 000 and 249 000 250 000 or above OOoOnNA NA BWN KR
16. G 1 R 421 542 2 371 4 Note By specifying R7 in the RECODE statement you can recode the entire Question 6 series Q6_1 through Q6_7 in one RECODE instruction R is the REPEAT feature in WinCross R7 means to repeat this RECODE statement 7 times beginning with variable Q6_1 and ending with variable Q6_7 LI Select OK to close the Setup Glossary Variables dialog box 11 Saving Your Work LI Choose File Save Save job LJ Enter WCEVAL then press Enter or select Save WinCross automatically appends the JOB file extension to your designated filename with the entire filename now being displayed in the WinCross title bar The Analytical Group Inc Exploring WinCross _30 12 Running Tables Once you have created a table you can run a crosstab If you did not create a banner in a previous portion of this evaluation WinCross uses a default banner having a single column TOTAL Note For testing purposes it is possible to run tables without opening any data by selecting No Data within the Run dialog box LJ Select Run Tables from the WinCross main menu Run Tables Override Select banners oO Table Numbering anner 1 C Page Numbering Deselect All Use glossary transformations _ Interweave banners Find a banner Find Next Banner C Excel Options Run Filter Report viewing format Select tables 53 tables 3 selected J Plain text report GENDER Gender a Q1 Q 1 On average how many hour
17. Help LI Select SPSS sav from the dropdown list of file types Q Select EXAMPLE SAV within the C TAG WC13EVAL EXAMPLE subfolder LI Select OK on the Open Data dialog box to open the data file selected The Analytical Group Inc Exploring WinCross 13 4 Adding a Table with Rows If you are using a non labeled SPSS file or an ASCII data file you are ready to add a new table Please refer to the sample questionnaire on page 39 of this WinCross Exploring Guide for this Adding a Table with Rows section If you are using a labeled SPSS data file you can skip to the next section of this evaluation Creating Tables from a Labeled SPSS File Setup Tables w a Aa GA E i 3 A EN Table title 0 480 Tables Rows Table no Table title Row name Add Table Table number 1 Table Numbe Number of tables to add 1 Renumber F Automatically renumber Cox cancel Ca nee a Edit as Text Filter Table Options Sta istics j statistics Row logic Comments 0 tables Find a table LJ Select Setup Tables LI Select Add Table Q Select OK to accept the default Table number and Number of tables to add Referring to the sample questionnaire the first table to create is entitled Q 1 Hours per week spent participating in outdoor activities at Arizona parks This will become the title of your first table You will then start adding rows representing the answ
18. Profile Settings if it is not already the currently selected tab Profile Settings Show blank tables Center tables Show frequency Decimal places V Show vertical percent Show horizontal percent Show constant percent Show comma Show footnote Show table of contents E Show date of run L Show time of run LI Select the Show percent sign option in the Tables box on the Table Presentation tab of Profile Settings The Analytical Group Inc Exploring WinCross 9 LI Now select the Filters tab on the Profile Settings dialog page Profile Settings Table Presentation Enhanced Text Layout ls Chart Style P Summary Rows Statistics Rows Wording for Rows Statistics Rounding Job File Font and Colors Small Sample Size Filter type 2 Total answering J Sigma Filter options V Show filter row Show filter title on filter row Show filter title below table title Center table filter title V Show frequency on filter row V Show vertical percent on filter row E Show horizontal percent on filter row F Show constant percent on filter row V Show percent sign on filter row Note the Filter Options above also appear on the Table Presentation tab Changing these settings in either location automatically changes them in the other location Active profile Default fa Save Profile As l Import Settings from Active Job
19. SS File You may not be interested in using all of the variables from your labeled SPSS data file as tables and or you may wish to change row text row logic table titles or add new tables to your job file The WinCross Setup Express Tables for SPSS Data menu option lets you create tables for selected variables and make changes to those tables LI Select Setup Express Tables for SPSS Data to display the Express Tables for SPSS Data dialog box e D F Ss 58 variables 0 selected 100 Cases o Tables 0 selected Ey Express Tables for SPSS Data C tag wcl 3eval example example sav gt a Find a table Find a variable Find Next Name Title V Scan data when creating tables Create 1 Table Create One Table with 0 Rows Create One Table Using Net Logic Summary of Means Summary of Frequencies ue V Compute and display the frequency report automatically Renumbper Scan all cases 5 Scan 1000 cases Remdex Job file definition Code Value Label Frequency Percent Duplicate Edit OK Cancel Help In the example above the variable RESP from your SPSS data file is the first variable in the list This would normally not be a useful table so you probably would not select this variable to use for creating a table r m Ef Express Tables for SPSS Data c tag wc13eval example example sav a f 55 Vari
20. WINCROSS Version 13 CS The Analytical Group Inc Exploring WinCross 2 Version 13 Copyright 1994 2013 The Analytical Group Inc Editor Coco Lauerman All rights reserved No part of this book may be reproduced in any form or by any electronic means electronic or mechanical including photocopying scanning recording or any information storage and retrieval system without the express permission of The Analytical Group Inc T he Analytical Group Inc Exploring WinCross Table of Contents Introducing WinGross ooo ccccccsessessseessessseeaneesneeseesesssessneesneeseeseeseeen 4 Exploring Win ross oon ccccsssssssssssesseestessteestecsteeasecssseseeesseseeesseeateeatees 5 About WinCross Filetypes ccctcatcscanesendastandendens sand sokenitedennsees stheiced geniesdastanadedensuendatiahtondantiesdads 5 Conventions Used in This Evaluation cccccccccccccccececeeesseeceeeeeeeeeeeeseeeeeeesesaeeeeeeeeeeessaaaaeees 6 QUICK Try Evaluation oo ccccccsececscscscscsesesesecacscscseserssecacsessssseseececsesesenens 7 1 Creating a New Profile cc ceeccccccssssecceeceeeeeceeeceeuseceeseeaseeceesesaeeeeessseaaeceeessaaeeeessssaseeees 8 2 Creating a New JOD nnnnnnannnnnnnnnnnnesennnressrnrnrnsrnrrresnnrrrensrnrrresrnrrressnntrrrnnrerenrnrrrensnnrrernnne 11 3 Opening Your Data File ind wectscoaccenseasincd oandeuiwiesteduextanedceevairea sand onadecevacsduanmanoenesuisateananlonsdedevecs 12 4 Adding a Table wit
21. ables 1 selected 100 Cases 0 Tables 0 selected Find a table Find a variable nd Next f Name Title V Scan data when creating tables Create 1 Table Name able Q Q2_1 Numeric Q2_2 Numeric Q2_3 Numeric Summary of Means Q2_4 Numeric Create One Table Using Net Logic Summary of Frequencies ur oy MN umar Cmd V Compute and display the frequency report automatically Scan all cases Scan 1000 cases Name GENDER Type Numeric Reindex Job file definition Gender LI Select the next variable GENDER in the Variables list box Duplicate Edit OK Cancel Help T he Analytical Group Inc Exploring WinCross 1 When the variable GENDER is selected notice the frequency report for that variable below the Variables list box This frequency information can be helpful in determining if you want to create a table for the selected variable If you are not interested in viewing the frequency report for variables selected you can uncheck the Compute and display the frequency report automatically checkbox C Lo x Bs a ee E A a aO p A mo am Py x 55 Variables 1 selected 100 Cases 1 Table 1 selected Find a table Find Next Find a variable 5 find Next Name Title V Scan data when creating tables GEN Gender ee Type a Create 1 Table j E D O Qo i D ALOI Create One Table GENDER Numeric
22. anner 1 Table GENDER Page 1 Gender Table Q1 Page 2 Q 1 On average how many hours per week do you spend participating in outdoor activities at Arizona parks Table Q2 1 Page B Q 2 Agreement with the following statement I consider myself an outdoors person Table GENDER Page Gender 400 10 260 100 0 100 0 100 0 B E ET ee E 35 0 100 0 INS Tables completed 3 Elapsed time The Analytical Group Inc Exploring WinCross _34 Q Select File Save Save Job to save your report format settings LI Select OK in the Warning dialog box You will be overwriting the job file that was saved previously in this evaluation with your new report format settings You can select any component of your job listed within the Table Elements field then apply a variety of custom formatting options There are options available within Setup Enhanced Text Report Fonts and Colors to format most of the Table elements These options include the ability to add borders and company logo s to table reports adjust alignment or customize table titles job titles banner headings etc WinCross now provides the ability to edit table reports within your reports dialog box Your Setup Enhanced Text Report Fonts and Colors settings are saved when you save your job From the example below you can see that the Setup Enhanced Text Report Fonts and Colors option of WinCross allows you to format your report for WinCross
23. dden columns The Banner Editor Preview Banner window will display how your banner will look when tables are processed and contains place holders for table elements such as Table Title Table Filter Title etc LJ Select OK to close the Banner Editor Preview Banner window LI Select OK to close the Banner Editor dialog box then OK within the Setup Banners dialog box to close it The Analytical Group Inc Exploring WinCross 29 10 Glossary Variables The WinCross glossary allows you to write statements to manipulate your data You can Y Save the modifications to a new data file v Use the modifications as is without permanently changing your data Glossary statements are evaluated from top to bottom and can have 480 characters per line For more information select Help within the Setup Glossary Variables dialog box Referring to the Q 6 series variables Q6_1 through Q6_7 in the sample questionnaire note the scale reads 1 4 with 1 representing Strongly Disagree This is also how your data was recorded in the field The client however has requested you to run their tables with the scale reading 4 1 4 being Strongly Disagree Fortunately it is very easy to honor your client s request using WinCross glossary variables 7 PTT eee Sa RECODE G6 1 R7 4 1 3 2 2 3 1 4 H Save Data As Check Syntax Line 1 Column 33 INS LI Choose Setup Glossary Variables LJ Enter RECODE O
24. er choices for each question in the sample questionnaire LJ Enter Q 1 Hours per week spent participating in outdoor activities at Arizona parks in the Table title field of the Setup Tables dialog box LJ Select Add Row The Analytical Group Inc Exploring WinCross 14 Setup Tables Table title 77 480 Q 1 Hours per week spent participating in outdoor activities at Arizona parks Tables Row name Characters 25 Show previous e a 0 1 Hours per week sper di Add Row ow logi Characters 6 C af Add Frequency Row Edit Row m Cut Copy Paste Row Options 1 table no tables selected Find a table Cancel E Help Since the first answer choice listed under Q 1 on the questionnaire is Less than 1 hour per week this will be a suitable description for the first row LJ Enter Less than 1 hour per week in the Row name field on the Add Row dialog box LI To advance to the next field either click in the Row logic field or press the Tab key To facilitate making additional row entries it may be useful to engage certain options within the Add Row dialog box But which options For that matter how should you enter crosstab logic in the Row logic field Q Select Help within the Add Row dialog box Keeping the Help Adding Rows dialog box open familiarize yourself with its contents paying particular attention to the two Show previous options Q Still within the Help Add Row dialog box
25. ert at Current Row Insert Below Selected Row F4 Delete Selected Rows Columns 2 3 Width and Spacing Options Horizc Banner logic for selected column LJ Position the cursor in any column of the new banner and select Rows Insert at Current Row from the Banner Editor tools menu This new row will be used to enter the dashed line and title GENDER above the MALE and FEMALE columns T he Analytical Group Inc Exploring WinCross Edit Rows Columns Cells Layout Help Banner title m i Merge Selected Cells Ctrl M Unmerge Selected Cell Ctrl U ee Filter title Filter logic Select All Ctri A Column to use for Number of columns 3 Left Justify Ctrl L Center Justify Ctrl E Right Justify Ctrl R Lowercase Shift Ctrl L Uppercase Shift Ctrl U Title Case Shift Ctrl T Columns Horizontal Constant Percents Comparison Groups 1 Trim Spaces E Auto Size Underlines Current column 2 3 Current row 1 Cell width 10 characters Cell height 1 line Total width 33 Q Position the cursor in the first top row of column 2 While holding the left mouse key down drag the mouse to column 3 Both columns 2 and 3 should now be highlighted LJ From the Banner Editor tools menu select Cells Merge Selected Cells Banner title Filter title Column to use for ranking 1 TOTAL MALE FEMALE A B ee LJ Position
26. h ROWS ccccccccccssseeceeeceeeeeeeeeeeeeeeeeeseeeseeeeeseeeeeeeeseeaeeeesssaaeeeeessaaees 13 5 Creating Tables from a Labeled SPSS File eeeccecccececeaeeseeeceeeeessaeeeeseeeeeeessaeaaeees 16 6 Making Changes to Tables Created from a Labeled SPSS File cecceeesseeeeeeeeeeeeees 20 7 Adjusting Table Options amp Table Filters cccccccccsseesceccceeeeeeeeeeeeeeeeeessseaeeseeeeeeessaeaaeees 21 8 Working Wiin SUAS NCS casisesaayrctnsaiederarccstweteaurdsssleiatorrsdiusierourcassuletomaaiiundeunisabietnncduniananleabiesqeediinaeedeaiitesuesans 23 9 Adding AMICUS sated enn seedaetctceedsnasceccatshacetenseseeseheeierenaseue EAR AEE NE AETR iN RAE EROARE 24 10 Glossary Variables cccccccsecccccceesseceeeceeeeceeecseaseeeeeeseaeeeeeseeaeseeeessaaaecesessaaeeeesessageeeees 29 11 Saving Your WOrK foeanecd aazctanedenaseacashenacntensteagaetantec anstoresunaeieetesaiacsaeietieedongiensanisioendgnatencans 29 12 Running Tables gees sasiecesecrecendaroteasnetssascudesiesertucetecdonatencnoscardetaniaeecineeteed east occaedeaccesteaietead 30 13 Formatting ROOT Scan eases eaten cerca wetnart cav cnet aiesad te aedte na cmv Ns treme ciate exe vay Camas 32 14 Saving Reports in XML Format as scsiesiececienees vksiset dine snseeseeaktceeswasiesveensecectiesecevarsaeideeeexncs vex 35 15 Viewing Browser Reports dics actiten cua mesnaiesett canta mast anead sy setts ney cin ahs ote mas bates ocke uae cena 35 16
27. how date of run Show time of run Table titles W Center table title Table title width 120 in characters F Show subtitle Show significance indicators in banner Show statistical footnote below table Table rows IV Show blank rows Indent levels under nets sub nets Row text width 25 in characters Blank cells V Show blank cell characters Blank cell characters Show blank cell characters for frequency cells only Show blank cell characters for all types of cells Job title top of page Left justify Center justify Right justify Job title bottom of page Left justify Center justify Right justify Table numbering V Show table number at top of page Left Right Table number position Center Filter options v Show filter row Show filter title on filter row 5 Show filter title below table title Center table filter title Show frequency on filter row Show vertical percent on filter row Show horizontal percent on filter row F Show constant percent on filter row F Show percent sign on filter row Import Settings from Active Job Remove Profile a Ceara Caniee Notice that Default is the Active profile on the Profile Settings dialog page The Profile Settings tabs currently contain the settings of the Default profile Q Select the Table Presentation tab of
28. ick task if you carefully follow these subsequent instructions Q Press the left cursor key once to place the cursor within the parentheses shown below Row name Characters 18 Show previous 1 3 hours per week ic gt Characters 6 iw Show previous A Q Press the Backspace key once to erase the 1 the Less than 1 hour per week value LJ Enter 2 the value for 1 3 hours per week L Press Enter Since the Add button has the focus 1 e it is surrounded by a dark black border pressing Enter is the equivalent of using the mouse to select Add The advantage to pressing Enter is that you do not have to remove your hands from the keyboard thereby speeding up this process The cursor has returned to the Row name field LJ Enter 4 6 hours per week in the Row name field then press Tab Note the cursor not only moved within the Row logic field but is now positioned just inside the right parenthesis LI Press the Backspace key to erase the 2 the 1 3 hours per week value LJ Enter 3 the value for 4 6 hours per week then press Enter LJ Enter 7 9 hours per week in the Row name field then press Tab LJ Press the Backspace key to erase the 3 LJ Enter 4 then press Enter Enter the remaining answers listed on the sample questionnaire LJ When you are done entering the answers for Q 1 select OK to close the Add Row dialog box The Analytical Group Inc Exploring WinCross 16 5 Creating Tables from a Labeled SP
29. in WinCross you will be asked to select a profile This is true even when you are using your SPSS data file to create a new job Once a new job has been started you would NOT make changes to your job using Setup Profile Settings Changes to the job file from that point on would be made using Setup Job Settings Setup Tables or Setup Globally Modify Tables The Analytical Group Inc Exploring WinCross 8 1 Creating a New Profile To begin a new job in WinCross you must select a profile Since Default is the only profile available to you as a new user let s create a new profile for use with this evaluation LI Select Setup Profile Settings to display the Profile Settings dialog page Profile Settings Wording for Rows Table Presentation Statistics Enhanced Text Reports Filters Page Layout Rounding Chart Style Summary Rows Job File Font and Colors Small Sample Size Statistics Rows Tables Show blank tables Center tables Seg Show frequency Decimal places Show vertical percent E Banners V Show banner title Above table title Below table title V Center banner title A W Center banner filter title Show horizontal percent F Show constant percent Show underlines in banner Decimal places for V H C percents Show percent sign E Show dollar sign Show comma E Show footnote I Show table of contents S
30. inCross 11 2 Creating a New Job To begin a new job in WinCross you must select File New Job LJ Select File New Job Settings Use settings from the active profile Duce Q Click on the dropdown arrow on the New Job dialog box to select the profile you just saved Dasplay Percent sign Profile Q Select OK to use Display Percent Sign Profile asthe profile for your new job The title bar on the WinCross main menu now displays WinCross New Job If your data file is a labeled SPSS file you can easily create tables from the SPSS variables using Setup Express Tables for SPSS Data For purposes of this evaluation we will use Setup Express Tables for SPSS Data to create our tables The Analytical Group Inc Exploring WinCross 12 3 Opening Your Data File An SPSS data file must be open to create tables using Setup Express Tables for SPSS Data File type Data viewing options v SPSS sav X Files All z E Records amp c Example sav Partial tag None wc13Eval to view Read only View data in grid Variables J Use first row as variable labels Record length Data file o Gen nes Q Select File Open Open data to open your data file Data viewing options All Partial pecora to view A None Read only View data in grid Variables v Use first row as variable labels Record length P Example sav cance
31. like being able to reserve ramadas at Arizona parks for family gatherings Abbreviated variable name Word wrap Find a variable Find Next Or Enter variables using name or card col format separated by commas Sort options Code value format Options Primary sort column Code Value Numeric Records per case Lines per page 64 Primary sort order Ascending X Alphanumeric L Show value labels Use glossary transformations Secondary sort order Ascending Show field on report Baum Oe Q Select variables Q2 1 02 2 and Q2_ 3 from the list of variables on the Run Frequency dialog box 0 Select Run Saving reports from Run options If desired you can save the reports from Run Tables Run Marginal and or Run Frequency by choosing File Save Save Report As The default file extension used for your report file is RPT Congratulations you successfully completed the Quick Try Evaluation The Analytical Group Inc Exploring WinCross _38 More About WinCross and The Analytical Group Inc We hope you have enjoyed this brief overview of the countless features offered in WinCross Since this introduction cannot begin to showcase all of its powerful features we encourage you to take a look at other related information we have posted on our Website such as the WinCross Frequently Asked Questions page It has been a pleasure to take you on this WinCross tour We look forward to the opportuni
32. limited number of tables and respondents Glossary logic looping and color coded editor Edit clean and recode data Up to 6000 rows per table Up to 255 banner columns per banner Memorized reports queue for running tables frequencies and marginals Create marginal and frequency reports Sample balancing feature for weighting Factor analysis Segmentation Save job settings as client profiles for creating new jobs Automatically generated frequency tables with actual values as row text Job file color coding of specific job file elements for easier identification Data entry and data verification module Sort Merge module WinCross Runtime a separate module allowing clients limited runtime access to linked data and job specification files Multi threaded processing for machines with multiple processors Automatic online software updates T he Analytical Group Inc Exploring WinCross 5 Exploring WinCross You can use this WinCross Evaluation for 30 days The WinCross Evaluation copy is limited to processing 100 respondents and 25 tables however most of the commonly used features are available and let you experience the look and feel of the fully featured version of WinCross An abridged version of the user manual this guide serves as your personal invitation to explore WinCross powerful features Included is a step by step evaluation with which you can interactively try the innovative crosstabulation capabilities of WinCross fi
33. lity Q Select Statistics within the Setup Tables dialog box Q Your report should include the Mean Standard deviation and Standard error in relation to the responses for Question 6 so engage these three respective options in the Table Statistics dialog box Row 5 Don t Know should not be included in the readership statistics for it is the response chosen by those respondents who answered Don t Know to Q 6 Agreement with the following statement do not know much about or have never heard of North Mountain Park LI Select Don t Know in the field entitled Select rows if any to exclude from statistics LI Select OK to close the Table Statistics dialog box Q Select OK to close the Setup Tables dialog box The Analytical Group Inc Exploring WinCross__ 24 9 Adding Banners A banner consists of banner columns each defined as a group of respondents within your data For this evaluation you will use the variables Total and Gender for creating banner columns LI Choose Setup Banners LI Select New E Setup Banners ES i Edit Banner Create Banners from Tableg Number of columns 1 Banner preview window rr ee ae i Ql Enter Banner 1 as the Banner name then select OK LJ Select Edit Banner T he Analytical Group Inc Exploring WinCross 25 Banner Editor Banner 1 Edit Rows Columns Cells Layout Help Banner title Filter title i Filter logic Co
34. lors is the active dialog box or click on the report entitled Enhanced Text Report Tables to make your enhanced text format table report the active dialog box LI Select File Save Report As LI Select the dropdown adjacent to the Save as type field LJ Select Enhanced Text Reports xml LI Name your file WCEVAL Report then select Save WinCross automatically appends the XML file extension 15 Viewing Browser Reports Once you have successfully created your report in Enhanced text report format it is immediately available for viewing using Internet Explorer LI Choose View Report in Browser from the WinCross menu alternatively you can use the globe button on the right WinCross toolbar The Analytical Group Inc Exploring WinCross _36 16 Running Marginals A marginal provides a count of every position column within the data It can be used to check tables statistics and reports or to verify assumptions about the data LI Choose Run Marginal Cases Records per case 1 Percent gt Cases to run 400 Total answering base Suppress blank positions Output V Show blank cells with dashes V Use glossary transformations Show output for columns Po Lines per page 64 Pagel Arizona Parks and Recreation Study FILE c tag wci3eval example example sav Tue Oct 02 13 26 25 2012 Cases Ci 2 Rec 1 Pos 2 100 1 Mean 1 00 1 0 Rec 1 Pos 3 10 10 10 10 10 Mean 4 95 10 0 10 0 10 0 10 0 10 0 Rec
35. lors menu option LI Choose Setup Enhanced Text Report Fonts and Colors from the WinCross menu options to display the Enhanced Text Report Fonts and Colors Overall table layout dialog box r TABLE OF CONTENTS 4 Overall table layout Justification Table 1 Page 1 Table 1 Title Me T Table of contents Table 2 Page 2 Table 2 Title Table 1 Page 1 Table and page number E cak 9 00 00 Jul 4 2076 Job logo oe Job title line 1 S Right Job title line 2 Job title Job title line 3 Job title line 4 A Set Font Table title line 1 Table title line 2 Table title line 3 A Set Font Color Table title line 4 Table subtitle line 1 Table subtitle line 2 Table subtitle line 3 Table subtitle line 4 Table title width 120 lt lt Job Logo Image gt gt 4 Table subtitle Row text width 25 ae ae Total bine l hf el v Show blank lines Show cell borders Vertical percent Banner headings Background options Mean k 27 93 Standard deviation Solid color v Job logo Column headings Row text Cell elements Frequenc oe E Background Image saa X Remove Vertical percent Horizontal percent octane m g ar fH Save Style As E3 Load Style i Restore Defaults Expand All Collapse All teibabenamrhAel ameota Changing the blank line option or job logo requires Enhanced Text Reports to be re run Q Select the Center option in the Overall table la
36. lumn to use for ranking as Clear All Statistical Testing EES E Current column Current row Cell width Cell height Total width 33 LJ Enter 3 in the Number of columns field or use the arrows to advance from 1 to 3 then select Apply The Columns list should now display three columns numbered 1 3 no n Edit Rows Columns Cells Layout Help Banner title Filter title Filter logic Column to use for ranking ao gt A B C Q Position the cursor in column 1 and enter TOTAL Select the Tab key to advance the cursor to the next column Q Enter MALE Select the Tab key to advance the cursor to the next column LJ Enter FEMALE The Analytical Group Inc Exploring WinCross 26 E I DP b ll Merge Selected Cells Ctrl M out Help Banner title Unmerge Selected Cell Ctrl U Filter title Select All Ctrl A Column to use for M i Left Justify Ctrl L Bi ss Right Justi Ctrl R Lowercase Shift Ctrl L Uppercase Shift Ctrl U Title Case Shift Ctrl T Columns Trim Spaces Auto Size Underlines r Q Let s center the banner text you just entered by highlighting the text and selecting Center Justify from the Cells menu You will want to create a dashed line above MALE and FEMALE that will span these two columns so you can enter the title GENDER over the spanned columns eee Te ee T T Edit Rows Columns Cells Layout Help Ins
37. oring WinCross 6 Conventions Used in This Evaluation As you proceed through the evaluation the steps you will want to perform are indicated by a blank square U Everything else is narrative so watch for the squares Additionally the squares are provided so that you can check each one as you complete a step This helps ensure a successful evaluation experience Consider the following example LJ Enter User then press Enter Illustrations used in this evaluation generally appear above a series of steps you are about to undertake with the screen capture depicting how the dialog box should appear once you have completed the subsequent steps T he Analytical Group Inc Exploring WinCross 7 Quick Try Evaluation WinCross lets you create profiles of settings that can be used for future jobs with similar settings WinCross will always maintain a set of default settings that can be used by selecting Default as your Active profile This collection of default settings will always remain the same and cannot be edited This can be useful when you have a client who likes all of their reports with particular settings Or you can use a saved profile as the baseline for a new profile Here is how Profile Settings and Job Settings work Profile Settings contains the initial settings for your job and are used when you are creating a new job Job Settings initially contains the settings from the selected profile for new jobs or the settings f
38. pecially useful when creating summary tables Let s create tables for the remainder of the variables in the EXAMPLE SAV data file A _ z 55 Variables 41 selected 100 Cases 12 Tables 11 selected Find a table Find Next Find a variable Ess Find Next Name Title z v Scan data when creating tables o Q22 Q 2 Agreement with the following statement I wish the parks were open for longer hours FE Q2_3 Q 2 Agreement with the following statement I wish all of the local parks in Arizona had after school progre _ Q24 Q2 Agreement with the following statement I trust that the Arizona Parks and Recreation staff are well t Create One Table Q2_5 Q 2 Agreement with the following statement I usually visit an Arizona park at least once a week miih Many Rows Q2_6 Q 2 Agreement with the following statement I wish all hiking paths in Arizona parks were paved Create One Table Q2_7 Q 2 Agreement with the following statement I enjoy visiting the Arizona Parks and Recreation visitor centy Using Net Logic Q2_8 Q 2 Agreement with the following statement I like being able to reserve ramadas at Arizona parks for fami Q2_9 Q 2 Agreement with the following statement I love the bike trails in some Arizona parks Q2_10 Q 2 Agreement with the following statement I hope that more parks are built as the population of Arizona Summary of Frequencies ai Summary of Means MN umorne
39. rcent Constant percent Hide blank rows F Suppress weighting L subtitle Agreement Table Number Indent levels C Eootnote Agreement How often Ee V Show percent sign as lee Renumber F Show dollar sign ow Oo en How often Edit as Text Show comma How ol ten E Append next table oy ot ten How often Filter How often you Ranking options How often do you YJ Table Options Method Order How often you Importance of th By frequencies means Ascending Importance of th Statistics F Rank j Importance of th By percents means 3 Descending Tmnortance of io C Comments By a previous table Show rank number in all cells Percent decimal places 1 Agreement Agreement Agreement Agreement Agreement Agreement Agreement Agreement A AP DAD A PR AE Q 2 Q 2 Q 2 Q 2 Q 2 Q 2 Q 2 Q 2 Q 2 ie Q 3 Q 3 Q 3 Q 3 Q 3 Q 3 Q 3 Q 3 Q 3 Q 3 Q 4 Q 4 9 4 NA 53 tables 1 selected Find a table Q Highlight Table No Q1 in the Tables list and select Table Options LI Disengage the option entitled No answer you can select Help within the Table Options dialog box then display the Table Options topic to learn about this option L Select OK The Analytical Group Inc Exploring WinCross 22 E e imma Filter type Rows to exclude from Filter title Total Answering Filter logic If weigh
40. rom an old job created in a previous version of WinCross While working on your job changes you make to Job Settings affect all tables in the job file existing or new You can still make changes to individual tables using Setup Tables or to a group of tables using Setup Globally Modify Tables as in previous versions of WinCross WinCross jobs created in older versions of WinCross will keep their Job Settings These existing jobs will not use the Profile Settings feature New jobs created in WinCross will require the selection of a profile first WinCross contains a Default Profile Use Setup Profile Settings to review the Default Profile settings to determine if this profile will work for you when creating new jobs Or you may want to create a new profile This can be done by making changes to the Default Profile settings and saving it as a new profile name Saving new profiles will allow you to create a set of custom profiles you can use when creating new jobs There are two ways to create a new profile You can use each tab of Profile Settings to change your settings or you can select Import Settings from Active Job to create a profile from the settings of an existing WinCross job file Whenever changes are made to profile settings WinCross will ask you to name the profile You can replace an existing profile with the exception of Default Profile or you can create a new profile by supplying a new name In summary when you start a new job
41. rst hand We think you will find WinCross so easy to use you can just start exploring on your own To do so open the EXAMPLE VARIABLE JOB job file and corresponding EXAMPLE SAV SPSS data file or the EXAMPLE ASCII JOB job file and corresponding EXAMPLE DAT ASCII data file installed with your WinCross software and explore the various menus and their options The example files are located in the EXAMPLE subfolder of C TAG WC13EVAL If you can t find what you are looking for during this evaluation try the extensive WinCross online help which includes detailed information about all of its features Additionally feel free to call us for customer support at 1 800 WINCROSS 1 800 946 2767 For more information about WinCross phone us visit our Website at www AnalyticalGroup com and or send an e mail to info AnalyticalGroup com About WinCross Filetypes WinCross creates job files report files and log files You furnish the data files which WinCross processes according to your specifications You open each file separately in WinCross typically only as it is needed A job file contains the job specifications You can assign any filename to which WinCross appends its JOB file extension filetype You will be creating another small JOB file during this evaluation A report file contains the results of reports you run in WinCross Again you can assign any filename to which WinCross appends an RPT file extension or you can save your
42. s per week al Q 2 Agreement w following stateme 5 _ _ Ing es Deselect All _2 Q 2 Agreement wi e following statemen Run options _3 Q 2 Agreement with the following statement __ T z Q 2 Agreement with the following statement Create tables Q 2 Agreement with the following statement No data Q 2 Agreement with the following statement Q 2 Agreement with the following statement Q2_8 Q 2 Agreement with the following statement Records per case Q2_9 Q 2 Agreement with the following statement Q2_10 Q 2 Agreement with the following statemer Cases torun 400 Q3_1 Q 3 How often do you Send or read e mail Q3_2 Q 3 How often do you Read news and curre Q3_3 Q 3 How often do you Participate in organiz Q3_4 Q 3 How often do you Hike or bike in Arizon 4R i j Find a table Find Next Table mai a Ban Print blank significance lines Check syntax Q You can choose the Select All option adjacent to the Select tables list box or just select a few tables from the Select tables list UL Verify that Plain text report is selected for the Report viewing format LJ Choose Run to run your tables Your tables should appear momentarily and have been formatted as a Plain text report The Analytical Group Inc Exploring WinCross 31 Table Page 1 Table Q1 Page 2 Q 1 On average how many hours per week do you spend participating in outdoor activities at Arizona parks Table Q2 1 Page 3
43. ss job file option codes you may want to explore using the Edit feature in Setup Express Tables for SPSS Data to edit your tables at creation time The Analytical Group Inc Exploring WinCross _20 6 Making Changes to Tables Created from a Labeled SPSS File LI Select Setup Tables to display the tables you created from your labeled SPSS data file Table title Gender y Cut Copy Paste Table Number Renumber Edit as Text Y Eilter Table Options Statistics C Comments Find a table Notice the row names and row logic that were generated for the GENDER table You can select through the tables in the Tables list box and make any desired changes using the Setup Tables options without having to enter the majority of the rows for each table The Analytical Group Inc Exploring WinCross 21 7 Adjusting Table Options amp Table Filters You may recall previously setting preferences for WinCross tables using features accessed from the Setup Profile Settings menu Those settings are in effect for every table created You will now use table and filter options to change settings for an individual table A Setup Tables Table Options Table Q1 Table title Table options Q 1 On average how many hours per week do you spend participating Summary rows Frequency decimal places Total Total answering Tables Masan ia Table No Table title V Frequency W Vertical percent Horizontal pe
44. ted show unweighted filter Frequency Vertical Percent Horizontal percent If weighted show effective sample size Constant percent used for statistics l Hide filter Volumetric filter Show percent sign Filter title options 0 Show filter title under table title Show filter title on filter row Now you will modify a filter for this table Q Choose Filter Q Change the Filter type from Total to Total Answering U Verify the Filter logic field reads TN LI Select OK The Analytical Group Inc Exploring WinCross__ 23 8 Working with Statistics Often you or a client will want statistics such as mean standard deviation and or standard error to appear on reports In reporting such data it may be necessary to exclude certain rows from the calculations as you ll learn in this example LI Select table Q6_1 in the Tables list box _ Table Statistics Table Q6_1 Scaling Exclusions 7 Mean Do not scale Select rows if any to Standard deviation Divide by 10 Seale fom stahsucs Standard error janice by 100 Strongly Disagree E Divide by 1 000 Somewhat Disagree F Grouped median Divide by 10 000 Somewhat Agree Minimum e a E Maximum Statistical testing om Koos 1st Quartile Haaa 3rd Quartile Percents Mode Chi Square F Statistics base Effective sample size Decimal places Show dollar sign Central tendency 2 E Show comma Percentiles Variabi
45. ty to answer any questions you may have and to talk with you about how we can fulfill your crosstabulation needs We also invite you to participate in any of our WinCross training classes please contact us for scheduling and pricing The Analytical Group Inc also offers other software and market research services from questionnaire development through advanced data analysis Visit us on the Web at www AnalyticalGroup com Our email address is info AnalyticalGroup com The Analytical Group Inc Exploring WinCross 39 Sample Questionnaire for EXAMPLE Job Files Please refer to this sample questionnaire as you run through the Quick Try evaluation that starts on page 7 Please answer the following questions about Arizona Parks and Recreation Respondent number Resp 1 4 Gender Gender 5 Male 1 Female 2 Q 1 On average how many hours per week do you spend participating in outdoor activities at Arizona parks Q1 6 Less than 1 hour per week 1 10 15 hours per week 5 1 3 hours per week 2 16 20 hours per week 6 4 6 hours per week 3 More than 20 hours per week 7 7 9 hours per week 4 Q 2 Agreement with the following statements Strongly Somewhat Somewhat Strongly Disagree Disagree Agree Agree I consider myself an outdoors person 1 2 3 4 Q2_1 7 I wish the parks were open for longer hours 1 2 3 4 Q2_2 8 I wish all of the local parks in Arizona had after school programs for kids 1 2 3 4 Q2_3 9 I trust that the Ari
46. yout Justification dialog box Q Select the Show cell borders option from Table options on the Overall table layout dialog box L Select the Background color option from Background options on the Overall table layout dialog box LI Select one of the colors from the Basic colors list in the Colors dialog box and select OK The Analytical Group Inc Exploring WinCross _33 Enflgncel Text Refibrt Fonts and Colo nD ie ae aia Table title o TABLE OF CONTENTS O O 4 Overall table layout justification Table 1 Page 1 Table 1 Title P 3 Table 1 Page 1 Table and page number 9 00 00 Jul 4 2076 Job logo 4 Job title Banner headings Column headings Row text 4 Cell elements peers BB Background Image Vertical percent E Backgr image i Horizontal percent M SB Backoroynd Colores Load Style Expand Ai Colapse Al ox Changing the blank line option or job logo requires Enhanced Text Reports to be re run Job logo Q Select Table title Q Select the Set Font option in the Table title dialog box LI Select a Font style of Bold and a Size of 14 and select OK LI Select the Set Font Color option in the Table title dialog box LI Select the color Red and OK LJ Select OK to close the Enhanced Text Report Fonts and Colors dialog box The formatting changes that you selected should be displayed on your Enhanced Text Report Tables TABLE OF CONTENTS B
47. zona Parks and Recreation staff are well trained 1 2 3 4 Q2_4 10 usually visit an Arizona park at least once a week 1 2 3 4 Q2_5 11 I wish all hiking paths in Arizona parks were paved l 2 3 4 Q2_6 12 enjoy visiting the Arizona Parks and Recreation visitor centers 1 2 3 4 Q2_7 13 I like being able to reserve ramadas at Arizona parks for family gatherings 1 2 3 4 Q2_8 14 I love the bike trails in some Arizona parks 1 2 3 4 Q2_9 15 I hope that more parks are built as the population of Arizona grows l 2 3 4 Q2_10 16 Q 3 How often do you Never Rarely Sometimes Often Always Send or read email 1 2 3 4 5 Q3_1 17 Read news and current events 1 2 3 4 5 Q3_2 18 Participate in organized sports at Arizona parks 1 2 3 4 5 Q3_3 19 Hike or bike in Arizona parks 1 2 3 4 5 Q3_4 20 Use the after school program offered at some parks 1 2 3 4 5 Q3_5 21 Children participate in summer recreation programs at Arizona parks 1 2 3 4 J Q3_6 22 Use equipment offered through the Arizona Parks and Recreation department 1 2 3 4 5 Q3_7 23 Hold family gatherings or parties at Arizona parks 1 2 3 4 5 Q3_8 24 Walk your dog in the park 1 2 3 4 5 Q3_9 25 Reserve baseball diamonds or basketball or volleyball courts at Arizona parks 1 2 3 4 5 Q3_10 26 Q 4 Importance of the following to you Very Somewhat Somewhat Very Unimportant Unimportant Important Important Having access to Arizona parks 1 2 3 4 Q4_1 27
Download Pdf Manuals
Related Search