Exploring WinCross - The Analytical Group
Contents
1. m Filter options M Show filter row Show filter title on filter row C Show filter title below table title MV Center table filter title MV Show frequency on filter row MV Show vertical percent on filter row l Show horizontal percent 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 H Save Profile As C ame O re 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 Q Select Save Profile As to save the profile as a new name Save Profile As Cancel E Help LJ Enter Display Percent2. 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 l Ez Setup Glossary Variables i Ee wN RECODE Q6_1 R7 4 1 3 2 2 3 1 4 H Save Data As Tests Line 1 Column i1 LI Choose Setup Glossary variables LJ Enter RECODE O60 1 R7 4 1 3 2 2 3 1 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 LI Select OK to close the Setup Glossary Variables dialog box 10 Saving Your Work Q 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 WinCross title bar The Analytical Group Inc Exploring WinCross 27 11 Running Tables Once you have created a table you can run a crosstab If you did not create a banne
3. 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 Making Changes to Tables Created from a Labeled SPSS File You may not be interested in using all of the tables created from your labeled SPSS data file and or you may wish to change row text row logic table titles or add new tables to your job file The WinCross Setup Tables menu option lets you make these changes LI Select Setup Tables to display the tables created for you from your labeled SPS
4. 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 WinCross 11 2 Creating a New Job To begin a new job in WinCross you must select File New Job or File New Job from SPSS File For purposes of this evaluation we will use File New Job from SPSS File This is the easiest way to quickly create tables if your data file is a labeled SPSS file LJ Select File New Job from SPSS File novo tom sess e E Settings Variable names Use settings from the active profile Use SPSS variable names up to 64 characters C Use abbreviated SPSS variable names up to 11 characters SPSS data file EE O Q Click on the dropdown arrow on the New Job from SPSS File dialog box to select the profile you just saved Display Percent Sign Prorile Q Select OK to use Display Percent Sign Profile asthe profile for your new job L Select the Browse button in the SPSS data file list box to browse to the C TAG WC12EVAL EXAMPLE folder and select EXAMPLE SAV as the SPSS data file Q Select OK to create a new job from the EXAMPLE S
5. 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 18 6 Adjusting Table Options amp Table Filters You will recall you previously set 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 oo oc A Setup Tables ss fF 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 lo Tota Percent decimal places E Total answering Sigma ere Tie ansaan Table No i d Add Table Cut Copy Paste Agreenent i Renumber Agreement H t 2 Di oj a ee F Edit as Text J fee Eat How of ten Display commas How often Y Filter How of ten Append next table How of ten you z Table Options How of ten you 4 Ranking options How of ten you How often you Statistics r Order C Ascendin c x Frequency Vertical percent Percentage Off Horizontal percent Hide blank rows Suppress weighting subtitle Indent levels Meeme Agreement A
6. 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 Statistics Enhanced Text Reports m Tables V Show blank tables WV Center tables MV Show frequency Decimal places lo X MV Show vertical percent I Show horizontal percent rams M Show percent sign M Show dollar sign M Show comma Show footnote E l Show table of contents M Show date of run Show time of run Decimal places for V H percents m Table titles M Center table title Table title width 120 Filters Page Layout Ranking Job File Font and Colors Statistics Rows Rounding Chart Style Summary Rows Banners MV Show banner title Above table title C Below table title M Center banner title M Center banner filter title M Show underlines in banner M Show significance indicators in banner M Show statistical footnote below table Table rows M Show blank rows Indent levels under nets sub nets Row text width 25 Blank cells M Show blank cell characters Blank cell characters Show blank cell characters for 2 frequency cells only Show blank cell characters for all Job title top of page e C Left justify Center justify Right justify Job title bottom of page ee C Left justify Cent
7. sports at Arizona parks 1 2 3 4 Hike or bike in Arizona parks l 2 3 4 Use the after school program offered at some parks l 2 3 4 Children participate in summer recreation programs at Arizona parks 1 2 3 4 Use equipment offered through the Arizona Parks and Recreation department 1 2 3 4 Hold family gatherings or parties at Arizona parks l 2 3 4 Walk your dog in the park l 2 3 4 Reserve baseball diamonds or basketball or volleyball courts at Arizona parks 1 2 3 4 Q 4 Importance of the following to you Very Somewhat Somewhat Unimportant Unimportant Important Having access to Arizona parks l 2 3 Longer hours at Parks and Recreation after school programs 1 2 3 Well maintained playgrounds 1 2 3 Well maintained baseball diamonds 1 2 3 Being able to participate in organized hikes 1 2 3 Educational classes held at Parks and Recreation visitor s centers l 2 3 Volunteering as a park steward l 2 3 Maintained the natural beauty of Arizona in the parks 1 2 3 Silent Sundays no cars allowed l 2 3 Clean bathroom facilities l 2 3 Strongly Agree 4 4 AHH A KA Always Very 5 Maan an Nn Q2_1 7 Q2_2 8 Q2_3 9 Q2_4 10 Q2_5 11 Q2_6 12 Q2_7 13 Q2_8 14 Q2_9 15 Q2_10 16 Q3_1 17 Q3_2 18 Q3_3 19 Q3_4 20 Q3_5 21 Q3_6 22 Q3_7 23 Q3_8 24 Q3_9 25 Q3_10 26 Important 4 AAAA AHH A Q4_1 27 Q4_2 28 Q4_3 29 Q4_4 3
8. 0 Q4_5 31 Q4_6 32 Q4_7 33 Q4_8 34 Q4_9 35 Q4_10 36 The Analytical Group Inc Exploring WinCross 37 Q 5 Choose the statement below that best describes your opinion of Arizona parks Q5 37 Don t have much interest in 4 Noisy and unorganized Not well supervised Well maintained l 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 l Somewhat Disagree 2 NNNN WN 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 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 Go GW GW LW Lo 5 6 Strongly Agree 4 AaAAAAADA Don t Know NNNNA 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
9. 35 Sample Questionnaire ooo cc ccc cceecscecscsecsesecsesessesecsesecsececsecacsecsesecaesesseecaeeeees 36 C Exploring WinCross 3 T he 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 v Wide array of statistical testing including T Test Z Test ANOVA and Chi Square v Unlimited number of tables and respondents VY Multi threaded processing for machines with multiple processors v Glossary logic looping and color coded editor v Up to 6000 rows per table v Up to 255 banner columns per banner Y Memorized reports queue for running tables frequencies and marginals v Create marginals frequencies counts and percents v Sample balancing and weighting v Factor analysis Segmentation v Automatically generated frequency tables with actual values as row text v Job file color coding of specific job file elements for easier identification v Data entry and data verification module v Sort Merge module v Ability to edit clean and recode data v Automatic table creation from an SPSS sav file v Ability to output a labeled SPSS sav file v Save reports in multiple formats ASCII Web
10. AV SPSS data file ercon A new job file has been created from the selected SPSS file LI Select OK to close the Job File Created message box WinCross uses the variable names from the SPSS data file as table names the value labels as row text the values as codes and the variable labels as table titles The title bar on the WinCross main menu now displays WinCross New Job The Analytical Group Inc Exploring WinCross 12 3 Opening Your Data File Selecting the SPSS data file for use in creating a new job does NOT open the date file you will still need to open the data file after creating the tables File type Data viewing options All C Partial Records to view None Files l Read only W View data in grid Variables Record length Data viewing options All ail Records G Example sav CP to view pee C None E W Read only l View data in grid Variables M Use first row as variable labels Record length LI Select SPSS sav from the dropdown list of file types L Select EXAMPLE SAV within the C TAG WC12EVAL 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 were using a non labeled SPSS file or an ASCII data file and used File New Job to begin a new job you would be ready to add a new table at this point Please refer to the sample questionnai
11. Q Select variables 02 1 02 2 andQ2_ 3 from the list of variables on the Run Frequency dialog box Q 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 _35 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 opportunity 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 Sample Questionnaire for EXAMPLE Job Files Please refer to
12. S data file Table title Respondent Id oF Add Table oF Add Row a Cut fF Add Frequency Row B Edit Row Paste Cut i Renumber E3 Copy Edit as Text IE Paste Y Filter W Row Options W Table Options Statistics Row po Cancel E Help In the example above you can see that a table was created for the variable RESP from your SPSS data file This would normally not be a useful table so you may want to delete that table Q Highlight Table No RESP in the Tables list box and select the Cut button to delete this table LJ Select the next table GENDER in the Tables list box The Analytical Group Inc Exploring WinCross 17 A F F Add Row Agreement wi 7 Agreement wi u P Add Frequency Row Agreement wi l Agreement wi it Edit Row Agreement wi Ej z Agreement wi Agreenent wi Fas Cut Agreement wi Agreement wi l Copy Agreement wi t H ft Howat tan Edit as Text Paste How often How of ten W Filter Row Options How of ten How of ten F 3 How aften Table Options How of ten How often Statistics How of ten Tmonrtance of thie F O Comments 54 tables 1 selected Find a table z2 3 4 5 a26 Q27 a25 M2_9 M2_10 a_l a32 ca M3_4 M3_5 a36 a37 a38 a33 M3_10 SOD ss O O O a E DJ Lo Gd dd bo d bd dd bd bA A A A A a a a a a a e ao _ e i Notice the row names and row
13. WINCROSS Version 12 0 CS The Analytical Group Inc Exploring WinCross 2 Version 12 0 Copyright 1994 2012 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 In Table of Contents Introducing WinGross ooo ccccccsessessseessessseeaneesneeseesesssessneesneeseeseeseeen 4 Exploring Win ross eeeeessssesessssssssssssssssssssssersrrrrrensrrnnnnrnrininnnnrnnnnnrnnrrnrnnrrrrenrrennns 5 About WinCross Filetypes cccicatascsnesesdaitandesdees sand sekaniteden tees stheicced ganiesdastanadedenseendatiahtondantiesdeds 5 Conventions Used in This Evaluation ccccccccecccccceceeseeeeeeeeeeeeseeeeeseeeeeeesseeeaeeeeeeeeessaaageees 6 QUICK Try Evaluation oo cccccsececscscscscsesesesecacscsssesenssececsessecsesesscecsesesesens 7 1 Creating a New Profile cccseicccisescentvawnecendanstecentovieentansbexeveinesas tauededevoas aces tdanincer attaeexdoondedevens 8 2 Creating a New JOD cceecccccccsssseeeceeeeeeeecceeeseeeeeceeaseeeeessausecesessauseeesssaaaeeeeesseageeeeessagess 11 3 Opening Your Data File aint cectsccacceiseasiandanadenenesteduexdsweccendairessandanadecevacsduanmanoenemuissteanantonsdedevecs 12 4 Ad
14. andard deviation and or standard error to appear on reports In reporting such data it is often necessary to exclude certain rows from the calculations as you ll learn in this example LI Select table 06 1 in the Tables list box Scaling Exclusions 0 do not scale Select rows if any to divide by 10 exclude from statistics M Standard deviation ss v Standard error A ees a ue Strongly Disagree tedilar C 3 divide by 1000 Somewhat Disagree Grouped median C 4 divide by 10000 Som Minimum Maximum Statistical testing ist Quartile W Means 3rd Quartile lf Percents Mode l chi Square Statistics base Effective sample size Decimal places Show dollar si F Show ar sign Central tendency 2 Show comma Variability 2 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 Statisti
15. browser Microsoft Word RTF Microsoft Excel Adobe PDF format vV Save job settings as client profiles for use with new jobs Y Publish charts to Microsoft Excel PowerPoint and or Word v Write tables to Excel with multiple formatting options v WinCross Runtime v Automatic online software updates v Advanced Enhanced Text Report formatting options for tables frequencies marginals sample balancing and factor analysis reports 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 first 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 If you can t find what you are looking for d
16. bs created in WinCross 12 0 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 in WinCross 12 0 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
17. cs dialog box The Analytical Group Inc Exploring WinCross 21 8 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 22 Banner title Filter title Filter logic Column to use for ranking fi m a 2 Logic Width and Spacing Options Horizontal Percents Weights Comparison Groups Banner logic for selected column Select All araa Statistical Testing Preview Banner ox Cancel Help Current column 1 Current row 1 Cell width 10 characters Cell height 1 line Total width 33 Wy 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 fa IS Banner Editor Banner Edit Rows Columns Cells Layout Help E Banner title Filter title Filter logic y Column to use for ranking fi 7 A B Cc Q Position the cursor in c
18. currently selected tab on the Banner Editor dialog box If it is not the currently selected tab select the Logic tab Q 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 The Analytical Group Inc Exploring WinCross 25 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 lt Table Title gt GENDER lt Table Filter Title gt Copy to Clipboard a 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 _26 9 Glossary Variables The WinCross glossary allows you to write statements to manipulate your data You can v Save the modifications to a new data file v Use the modifications as is without permanently changing your data
19. d participating in outdoor activities at Arizona parks Table Q2 1 Page 3B 0 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 140 140 100 0 Line 1 Column INS Tables completed 3 Elapsed time The Analytical Group Inc Exploring WinCross 29 12 Formatting Reports WinCross enables you to customize your table report by using the Setup Enhanced Text Report Fonts and Colors 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 E Enhanced Text Report Fonts and olc 5 H Overall table layout Overall frequency layout H Overall marginal layout Di T Show cell AN Load Style W Restore Default Style OK Cancel E Help Changing the blank line option requires Enhanced Text Reports to be re run Q Select the Background color option from Background options on the Overall table layout dialog box Q Select one of the colors from the Basic colors list in the Colors dialog box and select OK Q Verify the Center option in the Overall table layout Justification dialog box is selected Q Select the Show cell borders option from Cell border options on the Overall table layo
20. ding a Table with ROWS u cccccccccssssseceeeeeeeseeeeeseeeeeeeeeseeesceeeeseeeseeeeeseeaseeeessaeeeeeeessaaess 13 5 Making Changes to Tables Created from a Labeled SPSS File cceeeeeeeeeeeeeeeeees 16 6 Adjusting Table Options amp Table Filters ccccccccseessecceeeeeeeeeeeeeeeeeeeeseaeaeseeeeeeessaaaaeees 18 Ta Working With Statistics sashes cst eyed tres cee ord ner a a E 20 8 Adoaingo Banners sissssrsanereiaerei a na a a aana aaa aea a 21 9 Glossary Variables errisicsssitinisreiniinordinend arnim inak ni Rein EA EENE AEE iN RAE EANO ETR Eaa 26 10 Saving Your WV OMK gic oseceescsncosdcneseasashtanetsbnededesoatnted cmctontsuitaneseGzsiesesiokndsddensiesianitacesebasiesaaiss 26 Bolo FAA G WINES gc ce cess sanie EE EE Ra EEEN REEE RE 27 12 Formatting Reports siedscinaiandunstansnerientsndneiadanvinninsdamutandnetnenivedusiadusinnsatosixaclwedwereandvaiantadesins 29 13 Saving Reports in XML Format sncesiscsccceesnsceezessuiectnte anci vehicseistgitt lt seen vase seicti exands vebvaneeiteeaiies ees 32 14 Viewing Browser Reports peaches wesire vepnaidejeremmer cae ancied tha vaatin manana stone masa netes hex etee ue aeevanecinceem 32 15 R nning Marginals Jens zat sacinien ceca metnar tt canta saninin Natta maa ciate orks wah Cama ents 33 16 Running TCS NGS Sai crs nate wien mas rahe ewe zasantn dba eaeemansereresvonun sageaciesbexetee ue ae ancouncun 34 More About WinCross and The Analytical Group Inc
21. ed 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 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 Enhanced Text Report Tables Group inc Line 8 Column 9 INS Tables completed 3 Modified A T he Analytical Group Inc Exploring WinCross 32 13 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 your Internet browser 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
22. er justify Right justify Table numbering M Show table numbers Table number position Left Center Right Filter options M Show filter row Show filter title on filter row C Show filter title below table title MV Center MV Show frequency on filter row table filter title MV Show vertical percent on filter row Show horizontal percent on filter row Show percent sign on filter row types of cells M Show subtitle E fa Save Profile As 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 Profile Settings if it is not already the currently selected tab W Show blank tables W Center tables W Show frequency Decimal places fo W Show vertical percent Show horizontal percent Decimal places l Show comma Show footnote W Show table of contents l Show date of run M Show time of run LI Select the Show percent sign option in the Tables box of Profile Settings The Analytical Group Inc Exploring WinCross 9 LI Now select the Filters tab on the Profile Settings dialog page Table Presentation Enhanced Text Reports Page Layout Chart Style Summary Rows Statistics Rows Wording for Rows Statistics Fites Ranking Rounding Job File Font and Colors m Filter type Total answering C Sigma
23. greenent Agreenent Agreement Agreement Agreenent Agreement Agreement rh 4 we Di LaLa ICO St LE LE Ld rE ee ee ae Oo Po Po Bo MA Pt tt tt ttt tt ttt tet tet tl ns Meo co I oe oR ooo eon o Se se oo O O O O D o pE E Dd bd bJ bd eo A a a Po Po Po fe How of ten you _ Tmnmortance of thi PL comments C Rank 54 tables 1 selected Find a table a E 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 19 Filter type Total e fotlansuend C soma Rows to exclude from C Total Answering C Sigma If weighted show 7 Frequenc v Er H inweghted filter W Vertical Percent i If weighted show Horizontal percent effective sample size Hide filter used for statistics W Display sign Volumetric filter Filter title options C Show filter title under table title f Show filter title on filter row Now you will modify a filter for this table Q Choose Filter LI Change the Filter type from Total to Total Answering Q Verify the Filter logic field reads TN Q Select OK The Analytical Group Inc Exploring WinCross 20 7 Working with Statistics Oftentimes you or a client will want statistics such as mean st
24. lect 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__ 28 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 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 LJ 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 spen
25. 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 2 Q 11 Which of the following best represents the highest level of education you have completed Education 63 Some high school or less 1 High school diploma or G E D Some college Associate s degree Bachelor s degree Graduate or professional degree Nn 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 38 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 000 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
26. ly 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 36 The Analytical Group Inc Exploring 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 ap
27. n use the globe button on the right WinCross toolbar The Analytical Group Inc Exploring WinCross 33 15 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 LJ Choose Run Marginal Run Marginal CET OoOo o oooO O O O N Total answering base MW Suppress blank positions W Show blank cells with dashes l Use glossary transformations M Show output for columns LJ Select Run The Analytical Group Inc Exploring WinCross _34 16 Running Frequencies A frequency provides a distribution count of the values in a field 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 fields are listed by variable labels To select fields that are non contiguous keep the Ctrl key depressed while individually selecting each desired field LI Choose Run Frequency es Select the variables for frequency analysis from the list below WinCross alias Variable name RESP GENDER Enter variables using name or card col format separated by commas er a a E o Mode Cases l a C Weight Cases to run 400 E Run Filter X Statistics Sort Options Value Lines per page 60 C Frequency V Use glossary transformations l Show field on report
28. nner logic for selected column Select All earan Statistical Testing f Preview Banner Cancel Help Current column 2 Current row 1 Cell width 10 characters Cell height 1 line Total width 33 A LJ 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 LJ Position the cursor in the second 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 0 From the Banner Editor tools menu select Cells Merge Selected Cells The Analytical Group Inc Exploring WinCross__ 24 ar P E P b aas saa E F Edit Rows Columns Cells Layout Help Banner title Filter title Filter logic Column to use for ranking f 7 Ss NNN A B c LJ Position the cursor in the second row of column 2 and enter dashes across the spanned row LJ Position the cursor in the first top row of column 2 and enter GENDER Now you are ready to enter logic for each of the three banner columns 5 Banner Editor Banner 1 p s Edit Rows Columns Cells Layout Help Banner title i Filter title Filter logic Column to use for ranking ja 7 ee A B C LI Confirm the Logic tab is the
29. olumn 1 and enter TOTAL Select the Tab key to advance the cursor to the next column LJ Enter MALE Select the Tab key to advance the cursor to the next column LJ Enter FEMALE The Analytical Group Inc Exploring WinCross 23 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 a Banner Editor Banner 1 at at Caren Row Insert Below Selected Row Delete Selected Rows Merge Eligible Rows p Logic Width and Spacing Options Horizontal Percents Weights Comparison Groups p Memme la ma Fae mnla mna a e ma a Q Position the cursor in any column of the new banner and select Rows Insert at Current Row from the Banner Editor tools menu Repeat this action so the end result is the addition of two new rows in the banner These new rows will be used to enter the dashed line and title GENDER above the MALE and FEMALE columns I Banner Editor me S Edit Rows Column ennt Merge Selected Cells Ctrl M Banner title Filter title sce justif Filter logic V Center Justify z Column to use for Number of columns 3 Right Justify p H_a Smooth Justify a Lowercase Uppercase Capitalize Trim Spaces m Columns Logic Width and Spacing Options Horizontal Percents Weights Comparison Groups 1 Ba
30. oor 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 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
31. pear 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 from 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 jo
32. r 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 Pe Banner 1 M Use glossary transformations C Interweave banners L Excel Options L Run Filter Report viewing 54 tables 3 selected OF Plain text report gt epor GENDER Gender H Select All l Enhanced text report Q1 9 1 On average how many hours per week do Q2_1 Q 2 Agreement with the following statement 5 Deselect All Q2_2 Q 2 Agreement with the following statement Q2_3 Q 2 Agreement with the following statement Run options Q2_4 Q 2 Agreement with the following statement Edit Selections Create tables Q2_5 Q 2 Agreement with the following statement C No data Q2_6 Q 2 Agreement with the following statement ee Q2_7 Q 2 Agreement with the following statement Syntax check Q2_8 Q 2 Agreement with the following statement Records per case Q2_9 Q 2 Agreement with the following statement Q2_10 9 2 Agreement with the following statemer i ko Q3_1 0 3 How often do you Send or read e mail eee fain Q3_2 0 3 How often do you Read news and curre Q3_3 0 3 How often do you Participate in organiz Q3_ 4 0 3 How often do you Hike or bike in Arizon 7 H Find a table Q You can choose the Se
33. re on page 36 of this WinCross Exploring Guide for this Adding a Table with Rows section If you are using a labeled SPSS data file and used File New Job from SPSS file to begin a new job you can skip to the next section of this evaluation Making Changes to Tables Created from a Labeled SPSS File A Setup Tables Table title 0 480 Tables Table no Table title sk Add Table Cut Table number E ISE Rows Copy Number of tables to add fb Paste M Automatically renumber Cancel amp Help i Renumber Y Filter A sels Row Options Table Options Statistics O Comments Z logic 0 tables Find a table OK Cancel E Help LI 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 answer 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 LI Select Add Row The Analytical Group Inc Exploring WinCross 14 Setup Tables Table title 77 480 Q 1 Hours per week spent participating in outd
34. 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 quick 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
35. 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 The Analytical Group Inc Exploring WinCross 36 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 l 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 Disagree Disagree Agree I consider myself an outdoors person l 2 3 I wish the parks were open for longer hours l 2 3 I wish all of the local parks in Arizona had after school programs for kids 1 2 3 I trust that the Arizona Parks and Recreation staff are well trained l 2 3 usually visit an Arizona park at least once a week l 2 3 I wish all hiking paths in Arizona parks were paved l 2 3 enjoy visiting the Arizona Parks and Recreation visitor centers l 2 3 I like being able to reserve ramadas at Arizona parks for family gatherings 1 2 3 I love the bike trails in some Arizona parks l 2 3 I hope that more parks are built as the population of Arizona grows l 2 3 Q 3 How often do you Never Rarely Sometimes Often Send or read email 1 2 3 4 Read news and current events l 2 3 4 Participate in organized
36. uring 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 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 automatical
37. 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 E Save Report File Organize New folder J w 7 Local Disk C tag wel example E Desktop H Name Date Type i Downloads 4 x T Li TUY r i E 3 Recent Places No items match your search mM Libraries E3 Documents a Music Pictures E Videos ji Computer 2 Local Disk C G voll tag_corp F Cw projects taaweb2 G oa Filename WCEVAL Report F Microsoft Excel 1997 2003 xls Microsoft Excel 2007 2010 xlsx Adobe PDF pdf All files Hide Folders Q Verify that the Tables report that you just formatted using Setup Enhanced Text Report Fonts and Colors 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 button circled adjacent to the Save as type field 0 Select Enhanced Text reports xml LJ Name your file WCTUTOR Report then select Save WinCross automatically appends the XML file extension 14 Viewing Browser Reports Once you have successfully saved your report in XML format it is immediately available for viewing with your Internet browser LI Choose View Report in Browser from the WinCross menu alternatively you ca
38. ut dialog box The Analytical Group Inc Exploring WinCross _30 E Enhanced Text Report Fonts and Colors i kej Bottom title H Overall frequency layout H Overall marginal layout Blank line options Cell border options Load Style E Restore Default Style Show blank lines Show cell borders Hide blank lines Hide cell borders OK Cancel EJ Help Changing the blank line option requires Enhanced Text Reports to be re run LJ Expand the Overall table layout field to display the Table title line LJ Expand the Table title field to display each line of the title Q Select Line 1 of the Table title Q Select the Font option in the Table title Line 1 dialog box LI Select a Font style of Bold a Size of 14 and Color of Red and select OK 0 Select the Apply to table titles option to apply the same font choices to all lines of each table title LI 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 INS Tables completed 3 Elapsed time The Analytical Group Inc Exploring WinCross 31 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 list
Download Pdf Manuals
Related Search