Home

Ruby Laser Basic: User Manual

1. G9 7 Low 43 Life Stage 8 Low Middle gt Life Stage stage 9 High Middle 4 amp 3 Socioeconomic Strata 10 High Socioeconomic Level soc_eco 11 Single No child 4 amp 3 Cohorts 12 Married No child chas 13 Oldest Child 0 11 g 14 Oldest Child 12 17 TF Macror SP atuent banner 15 Oldest Child 18 4 Core Customers Core Customers 43 Millionaires Millionaires 43 Traditional Affluent Traditional Affluent i W Fiter Q Y A Weight wt1 2012 13 MacroMonitor Basic Report New Report 2 Logged in as SBIClient Ruby Laser 2 5 0 92 RubyCom 2 5 1 18 Ooo e Table Chart OK Cancel Dashboard Ruby Laser Basic Users Manual 11 HOW TO CREATE A TABLE How to Begin To create a table you will need to move an axis from the Axes Menu into the top right hand frame for the banner the population across the top of your table and a second axis into the bottom right hand frame for the stub the labels down the left side of your table Ruby Laser Mozilla Firefox AE File Edit View History Bookmarks Tools Help Ruby Laser Search b Demographics gt EJ Products amp Services gt b Access gt Attitudes gt EJ Pre Built Profiles To create a table select a banner axis and a stub axis from the Axes Menu Table
2. y Chart OK Cancel _ Dashboard Basics1 V26 Table of Contents loaded 100467 characters of XML Logged in as SBIClient Ruby Laser 2 5 0 84 RubyCom 2 5 1 13 6 Ruby Laser Basic Users Manual 12 To move the axis into the frame highlight and drag and drop it into a frame OR highlight the axis and click on the large black arrow HOW TO CREATE A TABLE Step 1 Define Your Stub To define your stub move the Age of primary head of household axis into the bottom right hand frame To move the axis you can use one of two methods e Highlight the axis and drag and drop it into a frame OR e Highlight the axis and click on the large black arrow in the tool bar that runs down the left side of the stub frame Ruby Laser Mozilla Firefox File Edit View History Bookmarks Tools Help Ruby Laser eres Ly cS o v Bing D 4 Search 4 Demographics gt EJ Income gt EJ Education gt Marital Status gt EJ Presence of Children gt EJ Life Stage gt I Race and Ethnicity b Products amp Services b Access Attitudes 4 amp Pre Built Profiles gt EJ Demographic Profile DIET Calculated inancial Profile 4 MacroMonitor Banners amp Created Variables 43 MacroMonitor Standard Banner Standard Banner gt EJ Life Stage gt EJ Socioeconomic Strata gt FA_Cohorts Age of primary head of hous
3. New Spec Edit Spec Properties ES F Drill switch Save Save As Export y Top Standard Banner Side Incidences of having specific types of investa accounts ACC The additional W Total financial assets 0 to 50 000 9999 O est Le of Education filter is connected The label for the additional r des Millennia Generati Younger Older ent Low High j 7 to the previous Is on X i Boomers eases jaie Middle kdd de filter IS i Weighted Base 13939 6353 3829 1751 796 1198 12 1547 2178 4733 a ppend ed to filter with AND 000 100 100 100 100 100 100 100 100 100 100 100 lo g ic 5094 2358 1232 726 286 481 12 304 760 1644 236 the text of the E account Net 37 37 32 41 36 40 100 20 35 35 44 a lave packaged or 1838 834 346 451 87 119 0 139 453 606 64 Previous filter 13 13 9 26 11 10 0 9 21 13 12 H 200 23 91 24 13 49 0 0 98 55 4 via passa 1 0 2 1 2 4 0 0 4 1 1 fave Wrap or 90 90 0 0 0 0 0 0 0 67 31 1 1 0 0 0 0 0 0 0 1 o l l 163 155 7 0 0 0 0 o 0 100 1 2 0 0 0 0 0 0 0 2 1 604 217 275 101 0 0 12 79 78 75 37 account 4 3 7 6 o 05 100 5 4 2 7 Paar eens 529 318 166 29 15 0 0 15 66 114 33 4 5 4 2 2 0 0 1 3 2 6 354 63 280 11 0 0 0 0 16 213 1 3 1 7 1 0 0 0 0 1 4 2 PRI 2240 909 375 367 164 413 12 71 276 674 121y obio d e Table Chart Dashbo
4. Hide My Account Hide My Settings Hide Roll 1 Max Codes Select Spreadsheet in the Table View drop down menu SOOO Oo uw o o a gt Open Axes Folders Open Gallery KOC RL ttOn Cable view gt Spreadeheet EDk Tile Forward Wheel Up Tree Node Tooltips Short gt Click Save and then Close Specifies the report table view as using the new spreadsheet or the a traditionally drawn table SS a ance Use this page to maintain your Ruby Laser login settings preferences and account Logged in as SBIClient Ruby Laser 2 5 0 84 RubyCom 2 5 1 13 Ruby Laser Basic Users Manual HOW TO SAVE A TABLE As an Excel Spreadsheet continued Step 3 Click on the Excel icon at the upper right of your screen In your computer s Save As menu give your table a file name select a destination on your computer and click Save NOTE After changing the table view to Spreadsheet in the Settings menu you may need to click on Edit Spec and rerun your table before clicking on the Excel icon Ruby Laser Mozilla Firefox JB File Edit View History Bookmarks Tools Help Ruby Laser ei B www redcentresoftware com rubylaser wre o 7 Bing PIS p om J ee con a Save save As Export v Galleries Side Age of primary head of household a7B_P Base Primary head of household presen
5. 2012 13 MacroMonitor Basic Report New Report 2 Logged in as SBIClient Ruby Laser 2 5 0 92 RubyCom 2 5 1 18 OO Ruby Laser Basic Users Manual 10 BANNER AXES Eight axes are programmed as banners the MacroMonitor Standard banner and its three component banners and the MacroMonitor Affluent banner and its three component parts These banner axes are in the Pre Built Profiles folder The Pre Built Profiles folder contains pre formatted banners MacroMonitor Standard and Affluent banners The banners definitions are at the end of this User Manual The two full banners definitions also start on page vii of the MacroMonitor Crosstabulations at http www strategicbusinessinsights com cfd 2012public 2012crosstabs shtml Ruby Laser Mozilla Firefox See File Edit View History Bookmarks Tools Help E Ruby Laser no ww redcentresoftware com rubylaser O SAT AN A p Demographics 4 Count_ base cwf a gt Products amp Services ia 1 All U S Households b Access 4 bansri base cwf 1 Millennials gt bid gt 3 Pre Built Profiles 2 Generation X Code gt Demographic Profile 3 Younger Boomers O a y J Net Calculated Financial Profile Sum 4 Older Boomers 4 MacroMonitor Banners amp Created Variables LI Mean 5 Silent Generation 6 Greatest Generation 23 MacroMonitor Standard Banner
6. Basics1 V26 Report New Report 6 Logged in as SBIClient Ruby Laser 2 5 0 84 RubyCom 2 5 1 13 Ruby Laser Basic Users Manual 17 HOW TO WORK WITH TABLES Edit Your Table Change the Stub or Banner To change the stub or banner in your table click Edit Spec in the menu bar at the top of the frame Ruby Laser Mozilla Firefox File Edit View History Bookmarks Tools Help Ruby Laser bein tome contents New Spec Edit Spec Properties de F Drill gt Switch p w Galleries 4 A Save Save As f Export gt l 130606 32655 25485 2916 0 0 Under 25 2 0 0 8630 0 0 ae 7 0 0 15563 0 0 9838 7252 0 To edit your table select Edit Spec 121081 Older Boomers 17937 100 0 0 17937 100 0 0 0 0 0 0 0 0 ent Generati 21884 100 0 0 21884 100 0 0 0 0 0 0 0 0 reatest Generati 2950 100 0 0 2950 100 0 0 0 0 0 Low 24453 100 0 0 24453 100 1137 5 2179 9 2447 10 2054 8 3151 13 2551 Low Middle 26372 100 0 0 26372 100 930 4 2039 8 3496 13 1751 7 1843 7 2623 _ 13294 13294 z 10 41 4 Search Basics1 V26 Report New Report 6 Ruby Laser Basic Users Manual Y Standard Banner x Age of primary head of household 278_P Base Primary head of household present A ios Millennia Generati Younger Househo
7. Basicsi V26 Report New Report 6 Ruby Laser Basic Users Manual To save your table as a JPG image click on the Disc icon In the Save As menu give your table a file name select a destination on your computer and click Save 43 HOW TO END YOUR SESSION AND EXIT RUBY LASER To END your session and return to your Login menu click on the large gray X in the top right corner of your window To EXIT Ruby Laser click on the white X in the red box in the uppermost right hand corner of your screen no Logoff option exists To exit Ruby Laser click on the Ruby Laser Mozilla Firefox File Edit View History Bookmarks Tools Help e ad o gt E J white X In Ruby Laser Laser fw redcentresoftware com rubylaser C 7 Pend ca AE the red JNE box New Spec Edit Spec Properties Pe gt Drill gt Switch gt Save save As Export y Top Standard Banner fx el Side Age of primary head of household a7B_P Base Primary head of household present v Galleries A wti All To end YOur ent Greatest session and SUB Millennia Generati Younger Older Gnerai G nerati _ Low High Hic Is onX Boomers Boomers p Middle Middle 3 return to the Weighted Base 130606 29695 32655 25485 17937 21884 2950 24453 26372 28830 5095 000 100 100 100 100 100 100 100 100 100 100 100 Login menu 0 0 0 0 0 0 0 0 0 0 lick on th 0 0 0 0 0 0 0 0 0 0 o cli
8. To change the formatting click on Properties in the tool bar at the top left of your window Ruby Laser Mozilla Firefox File Edit View History Bookmarks Tools Help Ruby Laser i ta iai l ANA Y ve B Bing Save Save as Export Side Age of primary head of household a7B_P Base Primary head of household present A wti All To make changes to the format of a F table click on Properties AUS lent Greatest la t a Millennia Generati Younger Older Generati Generati T Low High Single Mari ls on X Boomers Boomers en ni Middle Middle No child No cl 29695 32655 25485 17937 21884 2950 24453 26372 28830 50950 11268 12 100 100 100 100 100 100 100 100 100 100 100 iq 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 29695 32655 25485 17937 21884 2950 24453 26372 28830 50950 11268 12 F 100 100 100 100 100 100 100 100 100 100 100 10 2916 0 0 0 0 0 1137 930 450 399 699 1 10 0 0 0 0 0 5 4 2 1 6 1 8630 0 0 0 0 0 2179 2039 2939 1474 2822 11 29 0 0 0 0 0 9 8 10 3 25 1 15563 0 0 0 0 0 2447 3496 4453 5167 3621 3 52 0 0 0 0 0 10 13 15 10 32 2586 7252 0 0 0 0 2054 1751 2104 3929 1804 High Weighted Base 000 No answer Number answering Under 25 9 F x e Table Chart Dashboard W Freq W Col Row L Sig Log
9. 0 A 1 1 0 3 0 0 0 0 0 2 1 l 1031 282 445 185 84 36 0 344 217 289 if 1 1 2 1 1 0 0 1 1 1 1 3413 867 1526 718 144 145 12 767 431 1093 112 account 4 3 6 5 1 1 1 3 2 5 7 TOERE ESA 1840 835 634 135 236 0 0 482 412 273 67 2 3 3 1 2 0 0 2 2 1 4 1583 364 839 139 21 220 0 45 236 557 74 2 1 3 1 0 2 0 0 1 2 4 His joder 9303 2367 2334 1379 1624 1301 298 1499 1893 2622 328v 4 e Table Chart Dashboard W Freq v Col Row 2012 13 MacroMonitor Basic Report New Report 4 Logged in as SBIClient Ruby Laser 2 5 0 95 RubyCom 2 5 1 22 oje 23 Ruby Laser Basic Users Manual HOW TO WORK WITH TABLES How to Filter Add More Filters Using Drill Feature You can successively add one or more filters to your table using the Drill feature Each time you add a filter it is added to the previous filter or filters with an AND statement Data in the table will automatically reflect the additional filter The label for the added filter will be appended to the previous filter label connected by an ampersand 4 NOTE Ampersand 4 is the symbol to represent a logical AND and pipe represents a logical OR The symbol is on your keyboard directly below the backspace key PC or delete key MAC Ruby Laser Mozilla Firefox SEE File Edit View History Bookmarks Tools Help E i Ruby Laser BM www redcentresoftware com rubylaser Google 2
10. Bing P A A Enter a report name and select the User or Folder under which the report will be saved in the TOC table of contents If a report of the same name already exists then it will be overwritten 42 ssiClient Test 9 bbb Example Check the box next to Create New Folder Enter a name for your and enter a name for table in the Save the folder DH Create New Folder Case B j Report Name box Save Report Name Documenti Ready to save to SBIClient Case B Documenti To save your report click OK 38 Ruby Laser Basic Users Manual HOW TO SAVE A TABLE As an Excel Spreadsheet Step 1 To begin saving your table as an Excel spreadsheet on your computer click on the wrench icon at the top right of the screen to access the User Preferences menu Ruby Laser Mozilla Firefox Sees File Edit View History Bookmarks Tools Help Ruby Laser QA re www redcentresoftware com rubylaser Ly oy o Bing P New Spec Edit Spec Properties F gt __ Drill J switch J seve Saves expor y Galleries 4 All t y Top Standard Banner Side Age of primary head of household a7B_P Base Primary head of household present dl WEA 7 To save your Millennia Generati Younger Older E Low High table as an ls onX Boomers Boomers lios aii Middle Middle E 13060 29695 32655 25485 17937 21884 2950 26372 28830 XCE 100 100 100 100 100 100 100 10
11. amp Created Variables 4 MacroMonitor Standard Banner Standard Banner gt 43 Life Stage gt EJ Socioeconomic Strata gt GA_Cohorts Code J Net Y Sum J Mean 4 v Count_ base cwf 1 All U S Households 4 v bansri base cwf 1 Millennials 2 Generation X 3 Younger Boomers 4 Older Boomers 5 Silent Generation 6 Greatest Generation 7 Low 8 Low Middle 4 v Count base cwf 1 Weighted Base 000 4 278_P base cwf 1 No answer 4 Y 278 _P 1 4ge of primary head of household All Excluding No answ b v Count base cwf b v a7B_P base cwf 4 272_P_ raw base cwf v cmn Mean cme Median To generate and a stub click OK Table Chart _ Dashboard 2012 13 MacroMonitor Basic Table of Contents loaded 98767 characters of XML Logged in as SBIClient Ruby Laser 2 5 0 92 RubyCom 2 5 1 18 OO Ruby Laser Basic Users Manual display a table after selecting a banner and 15 HOW TO WORK WITH TABLES Frequencies Column Percents and Row Percents Default tables will have two rows of numbers for each stub Frequencies or weighted numbers of households in white rows and Column percents or vertical percents in blue rows To view row percents or horizontal percents in your table check the box next to Row in the tool bar at the bottom right of the screen Row percents will automatically
12. base cwf 1 Weighted Base 000 4 478_P base cwf gt 1 No answer db E Fer monitor anna 4 Y 278_P 1 4ge of primary head of household All Excluding No answer Standard Banner 2 Code _ Net gt Count base cwf gt a we Life stage gt O Sum gt 2728_P base cwf J Mean 4 v a7B_P_raw base cwf cmn Mean cme Median 4 Count base cwf Ww Vv al Pee EJ a Le Table Chart oK Cancel Wj A Weight wt10 Dashboard 2012 13 MacroMonitor Basic Report New Report 2 Logged in as SBIClient Ruby Laser 2 5 0 92 RubyCom 2 5 1 18 je gt 3 Socioeconomic Strata p Cohorts b MacroMonitor Affluent Banner Ruby Laser Basic Users Manual HOW TO CREATE A TABLE Step 3 Generate Your Table After selecting and moving the stub and banner axes click OK to generate and display the table Ruby Laser Mozilla Firefox Seli File Edit View History Bookmarks Tools Help Ruby Laser PM i www redcentresoftware com rubylaser LY G 5 Bing P 4 A Search 4 Demographics 4 Age Age of primary head of household a7B_P Base Primary head of household present b Sex b Income b Education b Marital Status b Presence of Children b Life Stage Race and Ethnicity b Products amp Services p Access Attitudes 4 amp Pre Built Profiles b Demographic Profile b Calculated Financial Profile 4 MacroMonitor Banners
13. 62 57 232 LJ Sig 2012 13 MacroMonitor Basic Report New Report 4 Logged in as SBIClient Ruby Laser 2 5 0 95 RubyCom 2 5 1 22 je 21 HOW TO WORK WITH TABLES How to Filter Switch between Filtered Tables After clicking on a Switch variable your original table will automatically appear filtered on the new variable The label for the new filter will appear at the top of the table Using the UNDO and REDO green arrows you can now switch back and forth between a view of your table with the Drill filter s and a view of your table with the Switch filter Ruby Laser Mozilla Firefox SEE File Edit View History Bookmarks Tools Help mm Ruby Laser E mi A www redcentrasoftware com rubylaser Wve B Google To switch between a view ODES of your table with the Switch filter and a view of your table with the Drill After selecting a Switch fi i All US filter s click on the filter your original table UNDO and REDO green arrows New Diii Edit Spec s is filtered on only the rr Millennia Generati Younger Older i Low new filter ls onX Boomers Boomers jije men tn Middle Middle gt No i 2316 3334 3292 1891 1616 262 975 1670 2622 7444 000 100 100 100 100 100 100 100 100 100 100 100 inne 7610 1181 1926 2236 1014 1016 238 390 503 1477 5240 account Net 60 51 58 68 54 63 91 40 30 56 70 Have packaged or 2127 306 527 72
14. If the Parameter field is blank all six columns will be tested against each other Where cell pairs are significantly different the larger will have the letter of the smaller in it These tests use the same adjustments to variance estimation that the reference tests use Row Groups When Row Groups is checked row letters in the Parameter field will indicate which blocks of rows will be tested For example ABC FGH who should means test rows ABC against each other and test rows FGH against each other If the Parameter field is blank all rows will be tested against each other Where cell pairs are significantly different the larger has the letter of the smaller in it These tests use the same adjustments to variance estimation that the reference tests use 35 Ruby Laser Basic Users Manual HOW TO FORMAT TABLES View Your Table Unweighted To view your table with Unweighted counts or frequencies first UNCHECK all BUT the Freq box in the bottom right of the window with your table showing Check Edit Spec In the bottom left of the Edit Spec window UNCHECK the box to the left of Weight Rerun your table The Frequencies in your table will appear unweighted Ruby Laser Mozilla Firefox Em Ax File Edit View History Bookmarks Tools Help 0 Ruby Laser HA www redcentresoftware com rubylaser DAS ES gt Google Lt b Demographics 4 v Count_ base cwf b Products amp Services 1 All U S Households
15. and Switch menus by clicking on the magnifying glass icons while in the New Spec or Edit Spec windows Click on the magnifying glass with the in the middle to bring up the Drill menu Click on the clear magnifying glass to bring up the Switch menu Ruby Laser Mozilla Firefox File Edit View History Bookmarks Tools Help 0 shai Laser Tr yaww redcentresoftware com rubylaser LW Cc ES Google Search b Demographics v Count_ base cwf b Products amp Services 1 All U S Households b Access v bansri base cwf b Attitudes 1 Millennials gt Pre Built Profiles 2 Generation X 3 Younger Boomers 4 Older Boomers 5 Silent Generation Click on the 6 Greatest Generation magnifying glass d 7 L00w 8 Low Middle icons to bring up the 9 9 High Middle Drill and Switch filter 4 Count base cwf 1 Weighted Base 000 men us 4 v a7B_P base cwf M6 1 No answer 40 278 _P 1 Age of primary head of household All Excluding No answer gt v Count base cwf gt 278_P base cwf a7B_P_raw base cwf am 2 Table 7 Chart oK Cancel I Dashboard 2012 13 MacroMonitor Basic Report New Report 2 Logged in as SBIClient Ruby Laser 2 5 0 92 RubyCom 2 5 1 18 Ooo Ruby Laser Basic Users Manual HOW TO FORMAT TABLES How to Format After you have created a table you can make changes to the formatting in the table
16. appear in pink rows To include or exclude the rows to appear in your table check or uncheck the boxes to the left of Freq Col and Row Ruby Laser Mozilla Firefox AE File Edit View History Bookmarks Tools Help Ruby Laser e G af Bi vw redcentresoftware com rubylaser Y ve o gt Bing ya A rara 3 t reatest z Millennia Generati Younger Older ee Low High Single Mari jigi Is onX Boomers Boomers Es a Lo Middle Middle Fogh No child No cl 29695 32655 25485 17937 21884 2950 24453 26372 28830 50950 11268 12 100 0 0 50950 100 399 1 1474 100 0 0 11268 100 100 0 0 100 0 0 26372 100 930 4 2039 100 0 0 100 0 0 25485 100 0 0 0 100 0 0 17937 100 0 0 0 100 0 0 100 0 0 29695 100 2916 10 8630 To include or exclude rows 29 100 0 0 32655 100 0 0 0 0 0 24453 100 1137 5 2179 100 2 0 0 0 9 8 10 3 1 with frequencies column i 15563 0 0 0 2447 3496 4453 S167 34 ercents or row percents Sea ERS a eee Se A i p p 2586 7252 0 0 0 O 2054 1751 2104 3929 1804 2 check or uncheck the 8 9 22 0 0 0 0 8 7 7 8 16 1 appropriate boxes to the left of seis 13294 O 13294 0 0 0 O 3151 1843 3020 5282 2321 3 10 0 41 0 0 0
17. bonds REITs unit investment trusts zero coupon bonds CMOs and treasury securities and balances in custodial accounts education savings accounts IRA and SEP accounts individual annuities and Keogh accounts and cash value of life insurance Net_4 ASSETS 1 through ASSETS 17 ASSETS 19 through ASSETS 29 ASSETS 31 and ASSETS 29 The primary head of household is defined as the head of household with the greater contribution to household income Q O 18 Retired household are households in which the age of the primary head is gt 65 AND no head of household works 20 or more hours per week Q O 9 OR the age of primary head is gt 50 AND one head of household is retired Q 0 12 AND the other head of household if present does not work 20 or more hours per week OR No male head of household is present Q A 7 Col A AND the female head of household is gt 50 years of age AND NOT working for pay temporarily laid off or unemployed and looking for work RETIRED 96 Ruby Laser Basic Users Manual For questions and help please contact M F 8 30 am to 5 30 p m Eastern Kathryn Spring 1 804 272 0270 kspring sbi i com To report error messages support redcentresoftware com Consumer Financial Decisions Strategic Business Insights PO Box 2410 Princeton New Jersey 08543 cfid sbi i com Ruby Laser Basic Users Manual
18. completed Younger Retired Primary head is under 70 years of age AND household does not support any dependent children AND household is retired household Older Retired Primary head is 70 years of age or older AND household does not support any dependent children AND household is retired household All U S Unweighted Total number of actual respondents The primary head of household is defined as the head of household with the greater contribution to household income Q O 18 Retired household where the age of primary head is gt 65 AND no head of household works 20 or more hours per week Q O 9 OR the age of primary head is gt 50 AND one head of household is retired Q O 12 AND the other head of household 1f present does not work 20 or more hours per week OR No male head of household is present Q A 7 Col A AND the female head of household is gt 50 years of age AND NOT working for pay temporarily laid off or unemployed and looking for work RETIRED Assets minus liabilities where assets include checking accounts savings accounts CDs U S Savings Bonds MMDAs MMMEFs stock bond MFs publicly traded and non traded stock ETFs closed end funds hedge funds corporate and municipal bonds REITs unit investment trusts zero coupon bonds CMOs treasury securities custodial accounts education savings accounts 529 plans IRA and SEP accounts salary reduction plans individual annuities Keogh accounts businesses valu
19. head of household is 8 grade or less some high school or a high school degree Q 0 8 PHH Some College Households in which the highest level of education achieved by the primary head of household is some college or technical school Q O 8 PHH College Degree Households in which the highest level of education achieved by the primary head of household is a college degree Q O 8 PHH Post Grad Work or Higher Households in which the highest level of education achieved by the primary head of household is some postgraduate work a Master s degree a professional doctorate in education law medicine etc or a Ph D Q O 8 90 Ruby Laser Basic Users Manual Getting Started Children Preretired Retired HHI 50K to lt 100K HHI 100K to lt 150K HHI 150K Ruby Laser Basic Users Manual DRILL VARIABLES continued Includes two Life Stage segments Single No Child households in which primary head is lt 45 AND household does not support any dependent children Q A 2a AND NOT a retired household AND head of household is single OR divorced OR separated OR widowed Q A 8 and Married No Child households Primary head is under 45 years of age AND household does not support any dependent children AND NOT a retired household AND heads of household are married OR living together but not married OR other from MacroMonitor s Standard Banner Includes three Life Stage segments Oldest Child 0 11 household supports at
20. of O QA decimal places in your table click Save Ruby Laser Basic Users Manual HOW TO FORMAT TABLES How to Test Significance To add significance testing to a table check the box to the left of Show Significance in the Significance menu of Report Properties and check the type of significance you want from the list in the box below Show Significance Select the percent values you desire under Significance Levels More details about significance testing preferences follow on page 36 To effect any changes you make click Save at the bottom right of the frame The saved changes will affect the current table only Ruby Laser Mozilla Firefox Sel File Edit View History Bookmarks Tools Help EF Ruby Laser po y redcentresoftware com rubylaser Y ve 5 Bing Report Properties New Report 6 To add significance testing to a table check Show gt Show Significance Significance and click single Cell on the desired type of f O ReferenceColumn Column Groups testing i Reference Row Row Groups Labels Cells Significance Series Axes Significance Test To select the level of testing you desire change the values under Significance Levels Significance Levels High 99 Middle 95 Low To have any Pa
21. rubylaser Enter your User Name and Password Check Remember Me Click Login Ruby Laser Mozilla Firefox SE File Edit wiew History Bookmarks Tools Help E Ruby Laser amp MA www redcentresoftware com rubylaser RCS Data Portal Ruby Laser Login User Name SBIClient Password eo Click Login m Login Check Remember Me D remeber ma Type in your User Name and Password o Ready to login Enter your User Name and Password to login to Ruby Laser Not logged in Ruby Laser 2 5 0 84 RubyCom 2 5 1 13 0 Ruby Laser Basic Users Manual HOW TO BEGIN A SESSION Here is your Home Page To begin a session click 2012 13 MacroMonitor Basic NOTE The User Preferences menu shown on page 41 of this manual is where you select My Settings Ruby Laser Mozilla Firefox File Edit View History Bookmarks Tools Help 0 Ruby Laser MA www redcentresoftware com rubylaser 2012 13 MacroMonitor Basic S My Settings dy SBI Basics1 Theme NS Last update 10ct2013 Cases 4261 Animated Charts 3 D Effect Hide My Settings Hide My Account Max Codes Open Gallery Table View Node Tip Type Click on 2012 13 MacroMonitor Basic Desert False False False False 500 False Spreadsheet Short Ruby Laser Home Page Logged in as SBIClient Ruby Laser 2 5 0 92 RubyCom 2 5 1 18 Ruby Laser Basic Users Manual THE BASICS To view the contents of 2012 13 MacroMonitor Basi
22. stockbrokerage 3828 634 4 Ly e v Google Have 529 plan e Table Chart Dashboard W Freq v Col Row 2012 13 MacroMonitor Basic Report New Report 4 Logged in as SBIClient Ruby Laser 2 5 0 95 RubyCom 2 5 1 22 je Ruby Laser Basic Users Manual HOW TO WORK WITH TABLES How to Filter Add a Filter Using Switch Feature Using the Switch feature you can view your table with a different filter without losing your table with the Drill filter s Click on the Switch button for a drop down menu of predefined variables Click on a variable You can apply only one filter with the Switch feature NOTE Definitions of the SWITCH variables are at the end of this User Manual beginning on page 56 Ruby Laser Mozilla Firefox File Edit View History Bookmarks Ruby Laser To view your original table with a different filter without losing your table with the drill filter s click on the Switch button for a drop down menu of predefined variables Save As Expor Top Standz Hispanic Side Incide Q Asian Y Total fina Q African American amp wti All Q Delegators Q Collaborators Tent Q self Reliant F Se Generati O investors rs Boomers m Weighted Base Q Business Owners Laina n 000 100 100 Q Boomerang Households Have investment Households with Adult Dependents ae eee account Net O a na 37 33 A Q Ma
23. the left of the folder or double click on the folder label Axis Icon A AN AXES FOLDER To open an axes folder and view its contents click on the small black arrow to the left of the folder You also can open a folder by double clicking on the title or text to the right of the folder icon The Demographics folder in the Axes menu is shown here fully expanded An icon with two crossed arrows indicates the item 1s an axis Ruby Laser Mozilla Firefox File Edit View History Bookmarks Tools Help E Ruby Laser Search E JI Demographics 43 Age de Age of primary head of household a7B_P Base Primary head of household pre 43 Sex de Sex of primary head of household a7A_P Base All U S Households 43 Income Total 2011 income before taxes 017 Base All U S Households 4 amp 3 Education a Highest Level of Education o8P Base Primary head of household present 43 Marita Status de Mantal status a8 Base All U S Households Presence of Children A Dependent children supported by household a2a Base All U S Households PY Life Stage he Life Stage stage Base All U S Households 43 Race and Ethnicity Ethnic background Net 019 Base All U S Households gt Products amp Services gt EJ Access Basics1 V26 Table of Contents loaded 100467 characters of XML Logged in as SBIClient Ruby Laser 2 5 0 84 RubyCom 2 5 1 13 Rub
24. value of CDs U S Savings Bonds MMDAs MMMEFs stock bond MFs publicly traded and non traded stock ETFs closed end funds hedge funds corporate and municipal bonds REITs unit investment trusts zero coupon bonds CMOs and treasury securities and balances in custodial accounts education savings accounts 529 plans IRA and SEP accounts salary reduction plans individual annuities and Keogh accounts and cash value of life insurance Net_2 ASSETS 1 through ASSETS 20 and ASSETS 26 through ASSETS 32 RT 1abilities include mortgages on primary home and other real estate margin loans vehicle loans consumer loans life insurance policy loans and outstanding credit card balances Ruby Laser Basic Users Manual 53 Hispanic Asian African American Delegators Collaborators Self Reliant Investors Business Owners Boomerang Households Households with Adult Dependents Ruby Laser Basic Users Manual SWITCH VARIABLES Households in which either the male or the female head of household is self described as Hispanic Q O 19 Households in which either the male or the female head of household is self described as Asian Households in which either the male or the female head of household is self described as African American Households in which financial professionals make most or almost all of the savings and investments decisions for the household Q N 9 Items 1 and 2 Households in which the household make
25. 0 100 S p rea d S h e et 0 0 0 0 0 0 0 0 J naan 0 0 0 0 0 0 0 0 0 click on the 130606 29695 32655 25485 17937 26372 28830 wren ch con 100 100 100 100 100 100 2916 0 0 0 930 450 10 0 0 0 4 2 8630 0 0 0 2039 2939 29 0 o 8 10 15563 0 0 3496 4453 52 o 13 15 2586 0 1751 9 o 7 0 0 1843 0 O 7 ft Fabs Househo Weighted Base ait Number answering Under 25 UJ W Na Eg un o UA 2 as uy uy M eee LO T gt LO 9 Zoom _ e Table Q Chart Dashboard Y Freq Y Col _ Row _ Sig Basics1 V26 Report New Report 6 Logged in as SBIClient Ruby Laser 2 5 0 84 RubyCom 2 5 1 13 Oo 39 Ruby Laser Basic Users Manual HOW TO SAVE A TABLE As an Excel Spreadsheet continued Step 2 In the User Preferences screen select Settings In the Table View menu make sure the default setting Spreadsheet 1s selected Click on Save and close the User Preferences window NOTE The User Preference menu contains the same features that My Settings on your home page contains You can select the Spreadsheet table view on your home page before beginning a session Mozilla Firefox gt Ruby Laser File Edit View History Bookmarks Tools Help Ruby Laser i www redcentresoftware com rubylaser DA ob Bing PD amp User Preferences 4 Ruby Laser 3 D Effects Animated Charts
26. 0 13 7 10 10 21 2 Freq Col and Row A pro E _ 1708 0 17108 0 0 0 2551 2623 2597 4337 o z check indicates the row type will appear in your table e e e Logged in as SBIClient ps OO a Ruby Ruby Laser Basic Users Manual 16 HOW TO WORK WITH TABLES Edit Your Table Switch Stub And Banner Positions To switch the positions of the two table axes so that the original stub axis becomes the banner axis and the original banner axis becomes the stub axis go to the Edit Spec window and click on the yellow arrow icon at the left side of the tool bar on the right Ruby Laser Mozilla Firefox File Edit View History Bookmarks Tools Help Ruby Laser B www redcentresoftware com rubylaser L7 C ok Bing Search b Demographics Mm 4 Count_ base cwf gt Q Products amp Services 1 All U S Households b Access 4 e bansri base cwf gt Attitudes 1 Millennials gt Pre Built Profiles Mk 2 Generation X 3 Younger Boomers 4 Older Boomers To switch the 5 Silent Generation positions of the o reis Generation banner and stub 4 Count base DN axes click on 1 Weighted Base 000 4 272_P base cwf the yellow arrow core 4 Y 278 _P 1 4ge of primary head of household All Excluding No ans gt Count base cwf gt v a7B_P base cwf 4 278_P_raw base cwf rmn Mean J Chart OK Cancel _ Dashboard
27. 4 50 000 74 999 250 000 499 999 5 50 000 99 999 250 000 499 999 6 75 000 99 999 250 000 499 999 High No of Hhid Non retired amp Retired amp Members Annual Income of Net Worth of l 50 000 250 000 2 75 000 250 000 3 75 000 500 000 4 75 000 500 000 5 100 000 500 000 6 100 000 500 000 LIFE STAGE Single No Child Primary head is under 45 years of age AND household does not support any dependent children Q A 2a AND NOT a retired household AND head of household is single OR divorced OR separated OR widowed Q A 8 Married No Child Primary head is under 45 years of age AND household does not support any dependent children AND NOT a retired household AND heads of household are married OR living together but not married OR other Oldest Child 0 11 Household supports at least one dependent child under 12 years of age AND does not support any dependent children 12 years of age or older Q A 2b Oldest Child 12 17 Household supports at least one dependent child 12 to 17 years of age AND does not support any dependent children 18 years of age or older Oldest Child 18 Household supports at least one dependent child 18 years of age or older Preretired Primary head is 45 years of age or older AND household does not support any dependent children AND NOT a retired household Ruby Laser Basic Users Manual 2012 13 MACROMONITOR STANDARD BANNER Age Cohorts Socioeconomic Level Life Stage LIFE STAGE
28. 5 382 187 0 260 184 479 1205 AAA 17 138 16 22 20 12 0 2 11 18 16 765 0 101 380 182 102 0 0 174 64 526 AE SE eae 6 0 3 12 10 6 0 0 10 2 7 Have wrap or 630 0 286 180 82 82 0 12 72 0 546 ed 5 0 9 5 4 5 0 1 4 0 7 824 155 378 64 119 108 0 0 0 194 630 5 7 11 2 6 7 0 0 0 7 8 1455 208 399 600 67 165 16 60 52 578 764 account 11 9 12 18 4 10 6 6 3 22 10 TER 792 259 230 141 58 104 0 12 46 199 535 4 4 Table Chart Dashboard x Freq v Col Row _ Sig 2012 13 MacroMonitor Basic Report New Report 4 Logged in as SBIClient Ruby Laser 2 5 0 95 RubyCom 2 5 1 22 aja 28 Ruby Laser Basic Users Manual HOW TO WORK WITH TABLES How to Filter Choose None in Switch Menu Choosing None in the Switch menu will clear any and all set filters including the Drill filters Your original table will reappear with NO filters Ruby Laser Mozilla Firefox efx File Edit View History Bookmarks Tools Help MA www redcentresoftware com rubylaser Wve B Google P A A Ruby Laser i Properties Drill Switch Save Save A E Choose None in the Properties dea Dri switch yeso eo Switch menu to clear all sy Top Standard EQ Hispanic fx id 3 Side Incidence Q Asian accounts ACCTS Base All U S Households
29. F 2 99 Ruby Laser Basic Users Manual SWITCH VARIABLES completed Child Free No children present in the household Q A 2a AND neither head of household is retired Q O 12 Item 7 AND the head s of household is 40 to 54 years of age Q A 7 Col B AND there is no indication of children supported by household in 14 financial goals and life events including birth or adoption of a child a child entering college a child moving from the household or a child returning to the household Q O 1 Columns A and B no custodial account education account or 529 plan established for children Q D 8d Columns A B and C AND specific goals and most important goal for household s savings and investments do not included Getting married having children Q E la and E 1b AND no adult children living with household who cannot be claimed as dependents on household s tax returns Q A 3 LGBT Households Heads of household are lesbian gay bi sexual or other not heterosexual DINKY No children present in the household Q A 2a AND two heads of household present Q A 6 AND both heads of household working 20 hours or more per week O 9 AND household income is 125 000 or more Q O 17 AND NOT retired household Investable assets include balances in checking and savings accounts value of CDs U S Savings Bonds MMDAs MMMEs stock bond MFs publicly traded and non traded stock ETFs closed end funds hedge funds corporate and municipal
30. Label Width Ol Top Side Diagnostic Prefix or Cell Height in the the L Filter Weight Diagnostic Prefix Side menu To affect any changes you ve made to the cell formatting click Save Save Basicsi V26 Report New Report 6 Logged in as SBIClient Ruby Laser 2 5 0 84 RubyCo Ruby Laser Basic Users Manual HOW TO FORMAT TABLES How to Format Use Decimal Places To add or delete decimal places to or from the frequencies or numbers in your table change the values for Frequencies in the Cells window of Report Properties To add or delete decimal places to or from the column percents or row percents in your table change the values for percents To effect any changes you make click Save NOTE The saved changes will affect the current table only Ruby Laser Mozilla Firefox Seles File Edit View History Bookmarks Tools Help 63 Ruby Laser PA vw redcentresoftware com rubylaser EE Report Properties New Report 6 Wwre E so 2D A To add or delete decimal places to the frequencies Labels _ Significance Series Axes or numbers In YOur table Decimal Places change the value for P crequeices ol Frequencies 7 p da Statistics 18 Expressions 18 To add or delete decimal Ban Frequencies places to the column A percents or row percents Row in your table change the value for percents To effect any changes you ve made to the number
31. STRATEGIC BUSINESS INSIGHTS RUBY LASER BASIC USER MANUAL November 2013 Issued by Consumer Financial Decisions Strategic Business Insights PO Box 2410 Princeton New Jersey 08543 cfd sbi i com Contents Page 3 4 rd ica died ia Donaire eat 5 e teeaatoeke 6 T 8 A a E Gi 9 A Table Axis for a Banner n n AAA IIS 10 A A A E tas 11 How to Create a Table nn 12 How to Work With Tables orita dr Se 16 HOWAO CIE YO Ue AO aero tai ce ee hat eas haan sees ohn aa e ies nae net Geen dell Suite ets reads 17 Switch Stub and Banner Positions uri id 17 Chande Nest ODA a o cue O 18 Remove Table Rows and COMAS vesosesncrrriar arar A AA a A bd 20 HOW tO PING aca wo dechy tarada A ARA DS SAA ERAS ade hate nee ARA E E e RES ac Ra 21 DAIRE DESCIDION eirinen ae a prlde 22 Remove Add Change Utero lidia propietat aa 23 Use the Switch FITO ar dd isos 29 Use Magnifying Glasses A rotas 30 Howto FOMA a DIGS sis da tada 31 EE OAE MA do a ys 37 How to End Yoursession and Exit Ruby A lee e e do 43 Appendix MacroMonitor Standard Banner tia A aa e dabas 44 MatroMontor Allien Banner ss a dd oie ace 47 MIL WAI ES srta oe cies os IEE eee Se eee ow ute ce aoe EEEE eee dd eee 50 SG Vanables ini o E E id EES 54 Ruby Laser Basic Users Manual HOW TO LOG IN Ruby Laser is a web based application that allows you to create MacroMonitor tables quickly and easily To begin using Ruby Laser Basic go to http www redcentresoftware com
32. ard x Freq v Col _ Row _ Sig Search 2012 13 MacroMonitor Basic Report New Report 4 Logged in as SBIClient Ruby Laser 2 5 0 95 RubyCom 2 5 1 22 oje 24 Ruby Laser Basic Users Manual HOW TO WORK WITH TABLES Filtering Change Filter Logic If you applied more than one filter to your table and wish to change the logic statement from AND to OR click on Edit Spec while your filters are in place The combined filter labels will appear at the bottom left of the screen with an amp separating the parts of the filter Changing an ampersand 4 to a pipe will change the logic in the filter from AND to OR NOTE Removing the check from the box to the left of Filter in the bottom left menu will turn off the Drill and Switch filters NOTE Removing the filter definition from the bottom left will remove the Drill and Switch filters from your table Ruby Laser Mozilla Firefox Ea File Edit View History Bookmarks Tools Help A edo Laser yw redcentresoftware com rubylaser A E lt A Search gt 9 Demographics 4 v Count_ base cwf a gt E Products amp Services B 1 All U S Households O b Access 4 v bansri base cwf gt 3 Attitudes B 1 Millennials gt Pre Built Profiles J Code 2 Generation X Net 3 Younger Boomers Sum B 4 Older Boomers J O Mean B 5 Silent Generation 6 Greatest Generation G 7 Lo
33. arried Cchabiting Select and click on a predefined variable Tp E Hav oe a Q a a a a a a a a a a as A a a a a a a a a a a account Net Am Table Chart Dashboard W Freq Y Col Row 2012 13 MacroMonitor Basic Report New Report 4 y ae in as SBIClient Ruby Laser 2 5 0 95 RubyCom 2 5 1 22 no 21 Ruby Laser Basic Users Manual HOW TO WORK WITH TABLES Filtering Drill Filter Description Your table will automatically be filtered by the variable you selected The filter label will appear at the top of the table below the table descriptor The blue arrow to the left of the filter indicates the table has an active filter NOTE You can collapse the detailed information about your table by clicking on the round button at the top left of your table When the detail is hidden the blue triangle remains indicating an active filter on the table Ruby Laser Mozilla Firefox File Edit View History Bookmarks Tools Help E3 1 Ruby Laser SEE To collapse information about the table click on the round button at the top left of the table 2012 13 MacroMonitor Basic Report New Report 4 Ruby Laser Basic Users Manual ec Edit Spec Properties F Drill Switch gt er 2 v Fin l Assets lt 100K p Standard Banner aecific types of i
34. b Access 4 bansri base cwf b Attitudes 1 Millennials gt Pre Built Profiles 2 Generation X 3 Younger Boomers 4 Older Boomers 5 Silent Generation 6 Greatest Generation G 7 Low 8 Low Middle To view your table with 2 Hligh Middle unweighted frequencies 4 Count base cw uncheck the box to the ee 4 v a7B_P base cwf left of Weight and rerun 9 1 No answer 40 278 _P 1 Age of primary head of household All Excluding No answer you r table E gt v Count base cwf b v a7B_P base cwf 4 v a7B_P_raw base cwf cmn Mean cme Median 4 Count base cwf 2 Table Chart I Dashboard 2012 13 MacroMonitor Basic Report New Report 2 Logged in as SBIClient Ruby Laser 2 5 0 92 RubyCom 2 5 1 18 Ruby Laser Basic Users Manual HOW TO SAVE A TABLE Within Ruby Laser Step 1 Click on Save As in the tool bar at the top of the screen Ruby Laser Mozilla Firefox Seles File Edit Yiew History Bookmarks Tools Help Ruby Laser B O TOR Y ve 5 Bing To save a table within Ruby v Galleries B All users 6 Top Standard Banner Side Age of primary head of household a7B_P Base Primary head of household present i Laser A wti All J lent Greatest cl ick on Save Ho e Millennia Generati Younger Older aneri Generik Low High Hiah a 4 Is onX Boomers Boomers a as Middle Middle g N AS Weighte
35. c click New Spec in the tool bar at the top left of the screen Ruby Laser Mozilla Firefox File Edit View History Bookmarks Tools Help E Ruby Laser All users To view contents click on New Spec Table J Chart J Dashboard hei e _ Row Basics1 V26 Table of Contents loaded 100467 characters of XML Logged in as SBIClient Ruby Laser 2 5 0 84 RubyCom 2 5 1 13 5 Ruby Laser Basic Users Manual AXES MENU Your window now has three frames The left hand frame contains the Axes Menu with five folders Axes are preformatted variables for a selection of tables and banners found in the 2012 13 MacroMonitor Crosstabulations You can view the full sets of crosstabulations run by MacroMonitor s Standard and Affluent banners at http www strategicbusinessinsights com cfd 2012public 2012crosstabs shtml Ruby Laser Mozilla Firefox EJ File Edit View History Bookmarks Tools Help Ruby Laser i Ly e B Bing Search SL b Demographics Products amp Services Access p Attitudes gt EJ Pre Built Profiles Axes Menu MY Filter gt o e Qa e Table Chart OK Cancel Y A Weight wt1 J Dashboard Basics1 V26 Table of Contents loaded 100467 characters of XML Logged in as SBIClient Ruby Laser 2 5 0 84 RubyCom 2 5 1 13 0 Ruby Laser Basic Users Manual To open a folder click on the black arrow to
36. ck on the j 130606 29695 32655 25485 17937 21884 2950 24453 26372 28830 5095 gray X Number answering z 100 100 100 100 100 100 100 100 100 100 100 2916 2916 0 0 0 0 0 1137 930 450 3 Under 25 e 2 10 0 0 0 0 0 5 4 2 1 6 255 8630 8630 0 0 0 0 O 2179 2039 2939 147 pe 7 29 0 0 0 0 0 9 8 10 3 3 15563 15563 0 0 0 0 O 2447 3496 4453 516 i 12 52 0 0 0 0 0 10 13 15 10 9838 2586 7252 0 0 0 O 2054 1751 2104 393 E 8 9 22 0 0 0 0 8 7 7 8 mn 13294 O 13294 0 0 0 O 3151 1843 3020 528 a 10 0 41 0 0 0 0 13 7 10 10 me 12108 O 12108 0 0 0 O 2551 2623 2597 43 E 9 0 37 0 o 0 0 10 10 9 gi gt Dashboard W Freq Y Col _ Row _ Sig Basicsi V26 Report New Report 6 Logged in as SBIClient Ruby Laser 2 5 0 84 RubyCom 2 5 1 13 je 43 Ruby Laser Basic Users Manual 2012 13 MACROMONITOR STANDARD BANNER Age Cohorts Socioeconomic Level Life Stage All US Households Total US economic households AGE COHORT All US households segmented by year of birth Q A 7 Col B of primary head Millennials Millennials include households where the primary head was born after 1976 Generation X Generation X includes households where the primary head was born between 1963 and 1976 Younger Boomers Younger Boomers include households where the primary head was born between 1954 and 1962 Older Boomers Older Boomers include households where the primary head was born between 1946 an
37. d 1953 Silent Generation Silent Generation includes households where the primary head was born between 1930 and 1945 Greatest Generation Greatest Generation includes households where the primary head was born before 1930 SOCIOECONOMIC LEVEL For non retired households the segments are defined by the number of persons in the household Q A la AND the household s total 2011 income before taxes or any other deductions Q O 17 OR For retired households the segments are defined by the number of persons in the household AND by net worth Low No of Hhld Non retired amp Retired amp Members Annual Income of Net Worth of l lt 10 000 lt 50 000 2 lt 20 000 lt 50 000 3 lt 20 000 lt 100 000 4 lt 30 000 lt 100 000 5 lt 40 000 lt 100 000 6 lt 40 000 lt 100 000 Low Middle No of Hhld Non retired Retired amp Members Annual Income of Net Worth of l 10 000 29 999 50 000 149 999 2 20 000 39 999 50 000 149 999 3 20 000 39 999 100 000 249 999 4 30 000 49 999 100 000 249 999 5 40 000 49 999 100 000 249 999 6 40 000 74 999 100 000 249 999 44 Ruby Laser Basic Users Manual 2012 13 MACROMONITOR STANDARD BANNER Age Cohorts Socioeconomic Level Life Stage SOCIOECONOMIC LEVEL continued High Middle No of Hhld Non retired amp Retired amp Members Annual Income of Net Worth of l 30 000 49 999 150 000 249 999 2 40 000 74 999 150 000 249 999 3 40 000 74 999 250 000 499 999
38. d Base 130606 29695 32655 25485 17937 21884 2950 24453 26372 28830 50950 100 100 100 100 100 100 100 100 100 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0 05 05 0 0 0 0 05 0 0 Number answering 130606 29695 32655 25485 17937 21884 2950 24453 26372 28830 50950 100 100 100 100 100 100 100 100 100 100 100 5 3 cu S 2 ro 2916 2916 0 0 0 0 O 1137 930 450 399 ini 2 10 0 0 0 0 0 5 4 2 1 8630 8630 0 0 0 0 0 2179 2039 2939 1474 iui 7 29 0 0 0 0 0 9 8 10 3 15563 15563 0 0 0 0 O 2447 3496 4453 5167 oe 12 52 0 0 0 0 0 10 13 15 10 9838 2586 7252 0 0 0 O 2054 1751 2104 3929 aim 8 9 22 0 0 0 0 8 7 7 8 13294 0 13294 0 0 0 O 3151 1843 3020 5282 penen 10 0 41 0 0 0 0 13 7 10 10 al 3 B e Table Chart Dashboard W Freq Y Col Row _ Sig Basics1 V26 Report New Report 6 Logged in as SBIClient Ruby Laser 2 5 0 84 RubyCom 2 5 1 13 0 37 Ruby Laser Basic Users Manual HOW TO SAVE A TABLE Within Ruby Laser Step 2 In the Save Report window check the box next to Create New Folder and enter a folder name in the window Ruby Laser will save your table as a report Enter a report name for your table in the Save Report Name box and click OK Ruby Laser Mozilla Firefox ek File Edit View History Bookmarks Tools Help ATAR eS a ah i Ruby Laser A vw redcentresoftware com rubylaser Y e
39. d has a net worth of less than 1 000 000 Ruby Laser Basic Users Manual 48 2012 13 MACROMONITOR AFFLUENT BANNER Traditional Affluent Affluent Core Customers Millionaires Total assets include Checking accounts savings accounts certificates of deposit U S savings bonds money market deposit accounts money market mutual funds stock or bond mutual funds publicly traded stock non traded stock closed end funds corporate or municipal bonds REITs unit investment trusts zero coupon bonds collateralized mortgage obligations treasury bills bonds or notes ETFs hedge funds custodial accounts education savings accounts 529 plan funds IRAs SEPs 401 k 403 b and 457 plan funds individual annuities Keogh accounts value of business minimum selling price of primary home value of other real estate value of tangible assets value of owned vehicles and cash value of life insurance NET_ 1 did Financial assets include all items in Total Assets see above minus the value of business the minimum selling price of primary home and the value of other real estate tangible assets and owned vehicles NET_2 a Retired household where the age of primary head is gt 65 AND no head of household works 20 or more hours per week Q O 9 OR the age of primary head is gt 50 AND one head of household is retired Q O 12 AND the other head of household if present does not work 20 or more hours per week OR No male head of household
40. e of primary home and other real estate tangible assets value of owned vehicles and cash value of life insurance ASSETS 1 through ASSETS 32 and where liabilities include first and junior mortgages on primary home and other real estate margin loans loans on owned vehicles consumer loans life insurance policy loans and credit card balances LIAB 1 through LIAB 8 46 Ruby Laser Basic Users Manual 2012 13 MACROMONITOR AFFLUENT BANNER Traditional Affluent Affluent Core Customers Millionaires Total Affluent Affluent households are households with a 2011 total income before taxes or any other deductions Q O 17 of equal to or greater than 100 000 OR total assets NET_ 1 excluding the value of the primary home ASSET 22 of equal to or greater than 500 000 TRADITIONAL AFFLUENT Balanced Builders Affluent households with financial assets NET 2 excluding cash value of life insurance ASSET 26 of 300 000 or more AND primary home value of 200 000 or more Focused Builders Affluent households with financial assets excluding cash value of life insurance of 300 000 or more AND ahome value of less than 200 000 Real Asset Builders Affluent households with financial assets excluding cash value of life insurance of under 300 000 AND a home value of 200 000 or more Emerging Affluent Affluent households with financial assets excluding cash value of life insurance of under 300 000 AND a home value of less than 200 000 Wealthy Retir
41. ed Affluent households AND household is retired Entrepreneurs Affluent households AND ownership or operation of a business or professional practice is the primary occupation of either the male or the female head of household Q O 15d AFFLUENT CORE CUSTOMERS Affluent households based on household s share of its savings and investments held in the various types of institutions Q C 28 Ifthe highest percentages are equal for two or more institutions segment determination is based on response to Q C 1a current primary financial institution and Q C 1b preferred primary financial institution Banking Institution Affluent households whose percentage of savings and investments with a bank or credit union Q C 28 Items 5 6 is greater than at any other type of institution Brokerage Net Affluent households whose percentage of savings and investments with a full service or discount stockbrokerage Q C 28 Items 11 12 is greater than that at any other type of institution 47 Ruby Laser Basic Users Manual 2012 13 MACROMONITOR AFFLUENT BANNER Traditional Affluent Affluent Core Customers Millionaires AFFLUENT CORE CUSTOMERS continued Mutual Fund Co Financial Planning Co Insurance Co Pension Plan s Affluent households whose percentage of savings and investments with a mutual fund company Q C 28 Item 13 1s greater than at any other type of institution Affluent households whose percentage of savings and investme
42. ed as a table In addition to containing programming for the responses to a particular question from the MacroMonitor survey it contains rows with the weighted base the no answers the number of respondents answering the means the medians and the unweighted base Ruby Laser Mozilla Firefox Ja tx File Edit View History Bookmarks Tools Help Ruby Laser AAJA Q 00g e Search 4 Demographics 43 Age Age of primary head of household a7B_P Base Primary b Sex b Income b Education b Marital Status b Presence of Children gt b Life Stage An axis contains programming for the weighted 4 w Count base cwf 1 Weighted Base 000 4 v a7B_P base cwf gt Race and E 9 1 No answer gt Products amp Services O Code 4 WV a72_P 1 4ge of primary head of household All Excluding No answer base the no p Access A Net 4 Count base cwf answers the p Attitudes i z O Sum 1 Number answering Pre Built Profiles C Mean 4 278_P base cwf number of th aminde 25 respondents 13 75 79 answering 9 14 80 and over 4 w 27B_P_raw base cwf the means 0 omn Mean the medians 0 cme Median 4 v Count base cwf and the 0 Unweighted Base unweighted qa The base Chart OK Cancel Y A Weight wt1 2012 13 MacroMonitor Basic Report Ne
43. ehold a785_P RSSe Primary head of household present Y v Filter banner x a g E o g Le Table Y A Weight wt1 2012 13 MacroMonitor Basic Table of Contents loaded 98767 characters of XML Ruby Laser Basic Users Manual Chart OK Cancel _ Dashboard Logged in as SBIClient Ruby Laser 2 5 0 92 RubyCom 2 5 1 18 OO HOW TO CREATE A TABLE Step 2 Define Your Banner To define your banner move the MacroMonitor Standard banner axis into the top right hand frame Ruby Laser Mozilla Firefox Ea lx File Edit View History Bookmarks Tools Help E Ruby Laser 2 4 J Demographics 43 Age Age of primary head of household a7B_P Base Primary head of houseg To move the axis into the frame 4 v Count_ base cwf E o 1 All U S Households 4 bansri base cwf c c i ex 1 Millennials highlight and b Income 2 Generation X click the b Education 3 Younger Boomers b Marital Status 4 0lder Boomers black arrow b Presence of Children 5 Silent Generation 6 Greatest Generation OR drag and Life Stage b Race and Ethnicity 7 Low d rop the p Products amp Services 8 Low Middle b Access 9 High Middle axis 10 High gt EJ Attitudes 43 Pre Built Profiles b Demographic Profile b Calculated Financial Profile 4 MacroMonitor Banners amp Created Var s 4 v Count
44. ged in as S8IClient Ruby Laser 2 5 0 84 RubyCom 2 5 1 13 Search Basics1 V26 Report New Report 6 Ruby Laser Basic Users Manual HOW TO FORMAT TABLES How to Format Change Cell Height and Width To change the height or width of Column cells in your table select the Top menu in the Labels window and change the values for Label Height or Cell Width To change the width or height of Row cells in your table select the Side menu in the Labels window and change the values for Label Width or Cell Height To effect any changes you make click Save at the bottom right of the frame The saved changes will affect the current table only Ruby Laser Mozilla Firefox Seles File Edit View History Bookmarks Tools Help C Ruby Laser PIS A Ly e S sing B vw redcentresoftware com rubwylaser Sh oa y rr Report Properties New Report 6 To change the height or width of column cells change the value s in Labels Cells Significance Series Axes as id o Pe Crop Group Height o LU Group Text Vertical IN tne E menu in the Label Height 40 LJ Label Text Vertical Labels window Cell Width 58 LJ Diagnostic Prefix Group Width o Wi Group Text Vertical To change the width or l Label Width 1328 Ll Label Text Vertical height of FOW cells change Cell Height un 205 Ll Diagnostic Prefix the value s in
45. gt Save Save As Export e 2 Top Standard Banner Side Incidences of having specific types of inve EN accounts ACCTS Base All U S Households After changing the otal financial asse 0 t0 550 000 ho a Level of Education College degree four years z wti AIN TA ts 0 to 50 000 99 999 Highest Level of Education Coll logic connector In in sets o Highest Level o ucation College degree four years US A lent Greatest A the filter from amp to Househo Mile Generati Younger Older Cana Genemi Low High pig a ls onX Boomers Boomers ae an Middle Middle the table data will Weighted Base 100900 28096 27458 18736 12141 13289 1180 25433 23798 2740 000 100 100 100 100 100 100 100 100 100 u pd ate PA 32979 7260 9093 7150 4449 4345 682 6064 7956 1481 account Net 33 26 33 38 37 33 58 24 33 54 automatically with AVE packaged or 10777 2416 2465 2738 2019 1084 55 2644 2739 TaI relationship banking the revised logic 11 9 15 17 8 5 10 12 the filter description eran 3 2 5 6 OO IK 2 2756 481 971 716 464 8 681 485 Have wrap or 1323 147 560 179 8 95 554 will also reflect the 0 A 1 1 3 1 0 2 a 1436 496 326 178 0 217 revised log IC Use private banking 1 2 2 o 1 1 Manage custodial 4926 2083 1253 257 12 account 5 8 7 2 1 2 6 Have education 2848 1088 390 328 0 savings account 4 2 0 2 2 1532 739 124 14 236 915 6 4 4 Have
46. is present Q A 7 Col A AND the female head of household is gt 50 years of age AND NOT working for pay temporarily laid off or unemployed and looking for work RETIRED eee Net worth NET_ 6 is Total Assets NET_ 1 minus Total Liabilities NET 5 Total Liabilities include first and junior mortgages on primary home mortgages on other real estate margin loans vehicle loans consumer loans life insurance policy loans and credit balances eres Investable Assets NET 4 include all items in Financial Assets see above minus 401 k 403 b 457 and 529 plan funds 49 Ruby Laser Basic Users Manual DRILL VARIABLES Millennials Includes households in which the primary head of household was born after 1976 from MacroMonitor s Standard Banner Q A 7 Col B Generation X Includes households in which the primary head was born between 1963 and 1976 from MacroMonitor s Standard Banner Q A 7 Col B Boomers Includes Younger Boomers households primary head born between 1954 and 1962 and Older Boomers households primary head was born from 1946 to 1953 from MacroMonitor s Standard Banner Q A 7 Col B Silent Greatest Generation Includes Silent Generation households primary head born between 1930 and 1945 and Greatest Generation households primary head born before 1930 from MacroMonitor s Standard Banner Q A 7 Col B PHH HS Degree or Less Households in which the highest level of education achieved by the primary
47. itudes gt EJ Pre Built Profiles 1 All U S Households 4 bansri base cwf 1 Millennials 2 Generation X 3 Younger Boomers 4 Older Boomers To remove any part s of Code To expand the view of a 5 Silent Generation the banner Mean 6 Greatest Generation a f E contents of the FET specifications anner axis specs _ 8 Low Middle a iahli S senate highlight the ICK on the blac 10 High part s to 9 11 Single No child arrow to the left of the red dot in the banner frame remove and 4 Count base cwf EE gt 1 Weighted Base 000 click on the 4 o a7B_P base cwf J red X 1 No answer 40 378_P 1 Age of primary head of household All Excluding No an e Code 4 gt Table kJ Chart OK Cancel _ Dashboard Basics1 V26 Report New Report 6 Logged in as SBIClient Ruby Laser 2 5 0 84 RubyCom 2 5 1 13 20 Ruby Laser Basic Users Manual HOW TO WORK WITH TABLES How to Filter Add a Filter Using the Drill Feature To ADD a filter to your table click the Drill button in the menu at the top of the screen Select and click on a predefined variable in the drop down menu NOTE Definitions of the drill variables are at the end of this User Manual beginning on page 52 Ruby Laser Mozilla Firefox SEE File Edit View Hist
48. le fin l decision maker ave packaged o a 8 2019 1084 relationship banki Q Female fin l decision maker L T J accoun Q Both fin l decision makers 2 ave asset or li 716 464 investment Q Used a financial advisor recently oe De 6 3 mananementacei Q Have a life insurance agent fave wrap or 10 179 148 tely manag QQ Child Free A fi 17 ive 17 3 1 1 P eee 1436 282 496 326 178 154 ee 1 1 2 2 1 1 Manage custodial 4926 1071 2083 1253 257 250 account 5 4 8 1 2 2 Have education 2848 1013 1088 390 328 28 savings account 3 4 4 2 3 0 a ener 3440 676 1532 739 124 355 A 3 2 6 4 1 3 Have stockbrokerage 15565 2887 3828 3095 2671 2450 4 Ruby Laser Basic Users Manual Zoom reatest Generati 1180 100 682 58 55 5 8 1 8 1 0 0 12 1 0 0 14 1 634 Table J Chart J Dashboard Low 24265 100 4148 17 1656 7 220 1 46 0 344 1 767 3 482 2 45 1499 ent accounts ACCTS Base All U S Households Highest Level of Education College degree four yea Low Middle 25433 100 6064 24 2644 10 681 3 95 217 1 495 2 412 236 1 2202 Click on a variable in the Switch menu Your original table will ua appear filtered only by 231 the new variable 10 7956 33 2739 12 485 2 554 297 1 1342 6 495 915 4 _3135 Y Freq Y Col Rows 148 373 14 137
49. least one dependent child under 12 years of age AND does not support any dependent children 12 years of age or older Q A 2b and Oldest Child 12 17 household supports at least one dependent child 12 to 17 years of age AND does not support any dependent children 18 years of age or older and Oldest Child 18 household supports at least one dependent child 18 years of age or older from MacroMonitor Standard Banner Includes one Life Stage segment Preretired households in which the primary head is 45 years of age or older AND household does not support any dependent children AND NOT a retired household from MacroMonitor Standard Banner Includes two Life Stage segments Younger Retired primary head is under 70 years of age AND household does not support any dependent children AND household is retired household and Older Retired primary head is 70 years of age or older AND household does not support any dependent children AND household is retired household from MacroMonitor s Standard Banner Households with a 2011 income before taxes or deductions of 50 000 to 99 999 Q O 17 Households with a 2011 income before taxes or deductions of 100 000 to 149 999 Households with a 2011 income before taxes or deductions of 150 000 or more 51 Fin Assets lt 100K Fin Assets 100K to lt 500K Fin Assets 500K to lt 1M Fin Assets lt 1M Total Debt 0 Total Debt 1 to lt 100K Total Debt 100K Married C
50. lly reflect the removal To reapply the filter click on the right pointing green REDO arrow and the table will again be automatically filtered The Undo Redo green arrow buttons allow you to change views of your table quickly with and without a filter Ruby Laser Mozilla Firefox SEE File Edit View History Bookmarks Tools Help i Ruby Laser www redcentresoftware com rubylaser Ly g B Google AAA To reapply the filter to To remove the filter spec Proper Prope sd leo your table click on the y Top Standard Banner right pointing aL from your table ice a Side Incidences of having specific types of investment accounts ACCTS Base Al U S Households click on the left W Fin l Assets lt 100K REDO arrow hte A wti All pointing green E Fi Millennia Generati Younger Older PENS SEME Low High _ U N DO arrow ls on X Boomers Boomers iaj iae Lene Middle Middle Hig 26674 24180 15570 10214 11079 824 24265 24969 22474 1682 000 100 100 100 100 100 100 100 100 100 100 100 hve nents 23612 6317 6725 4626 2904 2695 345 4148 5694 6797 697 27 24 28 30 28 24 42 17 23 30 41 fave packaged or 8458 2095 1965 2143 1404 815 36 1656 2619 2492 16S 10 8 8 14 14 7 4 7 10 11 10 H 1171 25 240 525 227 154 0 220 487 275 16 oe eens 1 0 1 3 2 1 0 1 2 1 lave wrap or 605 150 22 399 7 27 0 46 25 390 14
51. ndent financial planner or consultant an independent insurance agent an insurance company agent a bank officer or investment advisor a private banker or trust officer a credit union officer or investment advisor a full service or discount stockbroker a mutual fund company investment advisor a certified financial planner CFP an accountant or CPA a lawyer or some other type of financial professional Q N 5a Have A Life Insurance Agent Someone in the household has someone they consider to be their life insurance agent Q L 11 Retired Household Households in which the primary head of household is 65 years of age or older Q A 7 Col B AND no head of household works 20 or more hours per week Q O 9 OR the primary head is gt 50 AND one head of household is retired Q O 12 and the other head of household if present does not work 20 or more hours per week OR there 1s no male head of household present Q A 7 Col A and the female head of household is gt 50 years of age and not working for pay temporarily laid off or unemployed and looking for work Q O 12 Revolving Retired Households in which the primary head of household is 55 years of age or older AND the household supports no dependent children Q A2a AND the primary head is partially retired went directly from full time to part time or is no longer retired OR retired completely and then returned to work full time or part time OR retired but is planning to return to work Q
52. nts with a financial planning company Q C 28 Item 14 1s greater than at any other type of institution Affluent households whose percentage of savings and investments with an insurance company Q C 28 Item 19 is greater than at any other type of institution OR whose percentage of savings and investments at an insurance company 1s 30 or greater AND household is not a core customer of a bank brokerage mutual fund company financial planning company pension plan or other Affluent households whose percentage of savings and investments with a former or current employer pension plan Q C 28 Item 20 is greater than at any other type of institution Other Affluent households whose percentage of savings and investments with another financial institution Q C 28 Item 21 is greater than at any other type of institution MILLIONAIRES Affluent households whose total assets net worth NET 6 financial assets or investable assets NET 4 are equal to or greater than 1 000 000 Total Assets Affluent household AND household has total assets of equal to or greater than 1 000 000 Net Worth Affluent Household AND household has a net worth of equal to or greater than 1 000 000 Financial Assets Affluent household AND household has financial assets of equal to or greater than 1 000 000 Investable Assets Affluent household AND household has investable assets of equal to or greater than 1 000 000 Mass Affluent Affluent household AND househol
53. nvestment accounts ACCTS Base All U S Households The title of the added filter will appear at the top of the table below the table descriptor The filter indicates it U S gt n r Milenio Genemi Younger IE Genera Genera Low ao tie 26674 24180 15570 10214 11079 824 24265 24969 22474 000 100 100 100 100 100 100 100 100 100 100 TRE 23612 6317 6725 4626 2904 2695 345 4148 5694 6797 27 24 28 30 28 24 42 17 23 30 blue arrow to tave packaged or 8458 2095 1965 2143 1404 815 36 1656 2619 2492 10 8 8 14 14 7 4 7 10 11 the left of the H 1171 25 240 525 227 154 0 220 487 275 co 1 0 1 3 2 1 0 1 2 1 ave wrap or J J Ss E 1031 282 445 185 84 36 0 344 217 289 7 1 1 2 1 1 0 0 1 1 1 1 3413 867 1526 718 144 145 12 767 431 1093 11 account 4 3 6 5 1 1 1 3 2 5 7 bon 1840 835 634 135 236 0 O 482 412 273 67 2 3 3 1 2 0 0 2 2 1 4 1583 364 839 139 21 220 0 45 236 557 74 2 1 3 1 0 2 0 0 1 2 4 9303 2367 2334 1379 1624 1301 298 1499 1893 2622 3247 4 2 Have stockbrokerace Table Chart LI Dashboard Y Freq W Col _ Row L Sig Logged in as SBIClient Ruby Laser 2 5 0 95 RubyCom 2 5 1 22 4 22 HOW TO WORK WITH TABLES How to Filter Remove a Filter To remove the filter from your table click on the left pointing green UNDO arrow The filter will be removed and the table will automatica
54. ohabiting Single Never Married Separated Divorced Widowed DRILL VARIABLES continued Households with financial assets of less than 100 000 Households with financial assets of 100 000 to 499 999 Households with financial assets of 500 000 to 999 999 Households with financial assets of 1 000 000 or more Households with no liabilities Households with liabilities of 1 to 99 999 Households with liabilities of 100 000 or more Households in which the heads of household are married or cohabiting Q A 8 Households in which the heads of household are single never married Households in which the heads of household are separated divorced or widowed The primary head of household is defined as the head of household with the greater contribution to household income Q O 18 Retired household are households in which the age of the primary head is gt 65 AND no head of household works 20 or more hours per week Q O 9 OR the age of primary head is gt 50 AND one head of household is retired Q O 12 AND the other head of household if present does not work 20 or more hours per week OR No male head of household is present Q A 7 Col A AND the female head of household is gt 50 years of age AND NOT working for pay temporarily laid off or unemployed and looking for work RETIRED Ruby Laser Basic Users Manual 92 DRILL VARIABLES completed Financial assets include balances in checking and savings accounts
55. ory Bookmarks Tools Help 0 Ruby Laser gt New Spec Edit Spec Properties Properties gt e Switch gt Save Save As Export nnials Generation X Boomers types of investment accounts ACCTS Base All U S Households To add a filter to your table click on the Drill button for a drop down menu Silent Greatest Generation PHH HS Degree or Less ent reatest PHH Some College Generati Younger Older Low High onX Boomers Boomers SS A ai Middle Middle PHH Post Grad Work or Higher 32655 25485 17937 21884 2950 24453 26372 28830 5095 Getting Started 100 100 100 100 100 100 100 100 100 Children 12737 11112 8250 10166 1991 4300 6287 11140 309 39 44 46 46 67 18 24 39 61 3365 4285 3144 2483 297 1710 2677 3790 793 10 17 18 11 10 7 10 13 16 692 1365 1263 1385 205 265 707 686 2 5 7 6 7 3 2 512 805 458 763 96 677 2 3 3 3 3 2 827 469 339 337 9 346 2 2 2 o 1 1858 514 591 32 1539 7 1 5 731 181 5 722 3 0 3 Single Never Marned 1359 800 134 1344 Seperated Divorced Widowed 3 3 1 3 Have stockbrokerage 3575 5463 1743 1591 2380 4971 1974 21 59 7 9 17 39 PHH College Degree PreRetired Retired HHI 50K to lt 100K HHI 100K to lt 150K HHI 150K Fin Assets lt 100K Fin l Assets 100K to lt 500K Fin l Assets 500K to lt 1M Fin Assets 1M Total Debt 0 Total Debt 1 to lt 100K Total Debt 100K M
56. our table a file name select a destination on your computer and click Save Ruby Laser Mozilla Firefox Ea Ex File Edit View History Bookmarks Tools Help Ruby Laser En fo B www redcentresoftware com rubylaser a E S Bing ya A A Dh e J e Ja P F Drill gt Switch gt Save Save As Export a Top Standard Banner Side Age of primary head of household a7B_P Base Primary head of household present A wti All lent reatest Housea Milena ene mars poses Generati Generati low piae age 130606 29695 32655 25485 17937 21884 2950 24453 26372 28830 000 100 100 100 100 100 100 100 100 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 130606 29695 32655 25485 17937 21884 2950 24453 26372 28830 100 100 100 100 100 100 100 100 100 j 100 lnder25 2916 2916 0 0 0 0 0 1137 930 450 Under 25 A 2 10 0 0 0 0 0 5 4 2 8630 8630 0 0 0 0 0 2179 2039 2939 7 29 0 0 0 0 0 9 8 10 15563 15563 0 0 0 0 0 2447 3496 4453 12 52 0 0 0 0 0 10 13 15 9838 2586 7252 0 0 0 0 2054 1751 2104 8 9 22 0 0 0 0 8 7 7 13294 O 13294 0 0 0 0 3151 1843 3020 vic 10 0 41 0 0 0 0 13 7 10 12108 O 12108 0 0 0 0 2551 2623 2597 it 9 0 37 0 0 o 0 10 g je 2 Zoom e Table Chart Dashboard Y Freq W Col Row _ Sig Logged in as SBIClient Ruby Laser 2 5 0 84 RubyCom 2 5 1 13 0
57. rameter a pe change in the Significance menu take effect in your table Basicsi V25 Report New Repo S in as 5BIClient Ruby Laser 2 5 0 84 Rubycom 2511314 click Save 34 Ruby Laser Basic Users Manual HOW TO FORMAT TABLES HOW TO TEST SIGNIFICANCE continued Single Cell When Single Cell is checked each cell is compared statistically with the expected value in the row and column totals in the underlying raw crosstab This test uses no continuity coefficients or other adjustments so it exactly replicates the equivalent test from SurveyCraft Reference Column When Reference Column is checked the first column serves as a reference against which all other columns compare Significant cells have colored text depending on the level of significance These tests use typical adjustments to variance estimation so will be slightly more conservative than the single cell test Reference Row When Reference Row is checked the first row serves as a reference against which all other rows compare Significant cells have colored text depending on the level of significance These tests use typical adjustments to variance estimation so will be slightly more conservative than the single cell test Column Groups When Column Groups 1s checked column letters in the Parameter field will indicate which blocks of columns will be tested For example ABC FGH statistically tests columns ABC against each other and test columns FGH against each other
58. s some or most of its savings and investment decisions and financial professionals make some of the household s savings and investment decisions Q N 9 Items 3 and 4 Households in which the household makes all of 1ts savings and investment decisions Q N 9 Item 5 Household owns any mutual funds Q E 10a OR any securities Q E 17A AND has investable assets of 100 000 or more Either the male head of household or the female head of household 1s owner or part owner of a professional practice such as a medical dental law or accounting practice or a business Q O 15a Household has at least one adult child living in the household who cannot be claimed as a dependent on the household s tax returns Q A 3 Household supports at least one infirm aged disabled or handicapped adult either living in the primary home or living elsewhere such as a nursing home Q A 4a 94 SWITCH VARIABLES continued Male Fin Decision Maker The male head of household handles most of the major financial affairs of the household Q A 10 Female Fin Decision Maker The female head of household handles most of the major financial affairs of the household Both Fin l Decision Makers Both the male and female heads of household handle most of the major financial affairs of the household Used A Fin Advisor Recently Household has obtained financial information and advice in the last 2 years from a financial professional including an indepe
59. set filters including the Y Business OM aro american i i IAI wti All drill filters Your original A wer A Q Delegators J Q Collaborators a table will automatically Older _ Silent Greatest Low High S Q self Reliant G g enerati Generati Low High reappear with NO filters Q Investors pp Weighted Base a 1891 1616 262 975 1670 2622 7444 000 ee ee 100 100 100 100 100 100 100 3 Have investment Q Households with Adult Dependents st i e Siasi sta al sini account Net ai 54 63 91 40 30 56 70 arr ie He Q Female fin decision maker Ii aa i eu ure ato 105 relationship banking A accoun Q Both fin l decision makers ae Ta ave asset or 182 102 0 0 174 64 526 investment Q Used a financial advisor recently mananement account Q Have a life insurance agent a ma m s de ae Lin ave at or y c a rre 82 82 0 12 72 0 546 a vs 4 5 0 1 64 0 7 T f binii 155 378 64 119 108 0 0 0 194 630 oe 7 11 2 6 7 0 0 0 7 8 Manage custodial 208 399 600 67 165 16 60 52 578 764 account 9 12 18 4 10 6 6 3 22 10 Have education 259 230 141 58 104 0 12 46 199 5335 v 4 e Table Chart Dashboard x Freq Col _ Row _ Sig 2012 13 MacroMonitor Basic Report New Report 4 Te in as SBIClient Ruby Laser 2 5 0 95 RubyCom 2 5 1 22 Ojo Ruby Laser Basic Users Manual HOW TO WORK WITH TABLES How to Filter Use Magnifying Glasses You can also access the Drill
60. sics1 V26 Report New Report 6 Ruby Laser Basic Users Manual _ Net t Sum LJ Mean 4 Count_ base cwf 1 All U S Households 4 bansri base cwf 1 Millennials 2 Generation X 3 Younger Boomers hen the stub axis is on the red X to c delete Po base 000 4 7 a7B_P E cwf 1 No answer gt Oc Count base cwf gt 0 a7B_P base cwf 4 272 P_raw base cuf v cmn Mean cme Median Unweighted Base Table J Chart OK Cancel J Dashboard Logged in as SBIClient Ruby Laser 2 5 0 84 RubyCom 2 5 1 13 na highlighted click 19 HOW TO WORK WITH TABLES Edit Your Table Delete Columns and Rows To delete a column s from your table return to the Edit Spec window To expand the contents of the banner axis specifications click on the black arrows to the left of the red dots in the banner frame To delete any part s of the banner axis that you do not want to appear in your table click on and highlight the part s you want to remove and then click on the red X in the menu at the right hand side of the frame Ruby Laser Mozilla Firefox AE File Edit View History Bookmarks Tools Help Ruby Laser Pit R www redcentresoftware com rubylaser LI C B Bing gt 9 Demographics gt EJ Products amp Services gt EJ Access p Att
61. t AAA g H a Millennia Generati Younger Older G all hae L Low High Hiah 1 mas ls onX Boomers Boomers g nee ee i Middle Middle g Weighted Base 130606 29695 32655 25485 17937 21884 2950 24453 26372 28830 50950 Click on the 000 100 100 100 100 100 100 100 100 100 100 100 0 0 0 0 0 0 0 0 0 0 0 No answer Excel ICON 0 0 0 0 0 0 0 0 0 0 0 rT 130606 29695 32655 25485 17937 21884 2950 24453 26372 28830 50950 In the Save As AR 100 100 100 100 100 100 100 100 100 100 100 7 2916 2916 0 0 0 0 O 1137 930 450 399 menu give ai 2 10 0 0 0 0 0 5 4 2 1 your table a z 8630 8630 0 0 0 0 O 2179 2039 2939 1474 7 7 29 0 0 0 0 0 9 8 10 3 file name m 15563 15563 0 0 0 0 O 2447 3496 4453 5167 12 52 0 0 0 0 0 10 13 15 10 select a 9838 2586 7252 0 0 0 O 2054 1751 2104 3929 cm 8 9 22 0 0 0 0 8 7 7 8 destination on mpm 13294 O 13294 0 0 0 O 3151 1843 3020 5282 your 10 0 41 0 0 0 0 13 7 10 10 pe 12108 O 12108 0 0 0 O 2551 2623 2597 4337 computer 9 0 37 0 0 0 0 10 10 9 9 lick S 14639 0 O 14639 o 0 O 2129 2517 3024 6969 ClIC ave Basicsi V26 Report New Report 6 Logged in as SBIClient Ruby Laser 2 5 0 84 RubyCom 2 5 1 13 41 Ruby Laser Basic Users Manual HOW TO SAVE A TABLE As a JPG Image Click on the disc icon in the upper right corner of your table In your computer s Save As menu give y
62. w B 8 Low Middle B 9 High Middle To remove all filters A i gt 4 AcCcTS base get Count 1 from YOur table _net 1 13 Have investment account Net uncheck the Filter ea 9 1 Have packaged or relationship banking account B 2 Have asset or investment management account i i 1 b O me 3 Have wrap or separately managed account After clicking on Edit Spec PA O sum 4 Use private banking the combined filter labels _ Mean 5 Manage custodial account will appear with the amp logic connector s Change an amp to to change the logic from AND 6 Have education savings account 7 Have 529 plan 8 Have stockbrokerage account Net 9 9 Have full service stockbrokerage account Cr eee 5 re m _ _ ____ _22___P_ _ o i ld assets2 1 5 amp 08p 6 A Chart C Dashboard to OR 2012 13 MacroMonitor Basic Report New Report 4 Logged in as SBIClient Ruby Laser 2 5 0 95 RubyCorrz 5 r zz 7 34 20 Ruby Laser Basic Users Manual HOW TO WORK WITH TABLES How to Filter Change Filter Logic continued After changing the logic connector in the filter statement from amp to the data in your table will automatically update with the new OR logic The filter description will also reflect the revised connector as a symbol Ruby Laser Mozilla Firefox SEE File Edit View History Bookmarks Tools Help e Ruby Laser MOM New Spec Edit Spec Properties e Drill gt Switch
63. w Report 2 hear in as SBIClient Ruby Laser 2 5 0 92 RubyCom 2 5 1 18 Ojo Dashboard Ruby Laser Basic Users Manual A TABLE AXIS FOR A BANNER An axis is set up as a table it is not set up to be a banner An axis can be used as a banner if you remove the programming for the excess table columns before running a table OR by removing excess columns after saving a table as an Excel spreadsheet Ruby Laser Mozilla Firefox File Edit View History Bookmarks Tools Help a Ruby Laser 42 Demographics 43 Age Age of primary head of household a7B_P Base Primary b Sex b Income gt Education gt Marital Status b Presence of Children gt EJ Life Stage b Race and Ethnicity Products amp Services b Access b Attitudes p Pre Built Profiles Code J Net Y Sum LJ Mean E Ja lx 4 Count base cwf 1 Weighted Base 000 y To use an axis for El a banner remove 4 v a7B_P base cwf 1 No answer 40 378_P 1 Age of primary head of household All Excluding No answer 4 Count base cwf L 1 Number answering 4 v a7B_P base cwf 2 Under 25 3 25 29 13 75 79 14 80 and over excess programming before running a table OR removing excess columns after 4 278_P_raw base cwf v cmn Mean ome Median saving a table as an Excel 4 Count base cwf Unweighted Base y Dashboard l spreadsheet OK Cancel
64. y Laser Basic Users Manual Title Age of primary head of household this axis contains age ranges for the primary head of household THE AXIS DEFINITION The title or text to the right of an axis icon 1s the description of the information in the axis The alphanumeric indicator to the right of an axis title indicates the question in the 2012 13 MacroMonitor Questionnaire from which the information derives Ruby Laser Mozilla Firefox AE File Edit View History Bookmarks Tools Help Ruby Laser EA Sw redcentresoftware com rubylaser Y ve B Bing P 2 s AO m 4 es E Demographics g pase Primary head of household presen Alphanumeric a B_P a refers gt El income to A of the gt EJ Education gt EJ Marital Status gt Presence of Children b Life Stage b EJ Race and Ethnicity gt EJ Products amp Services gt Access b Attitudes gt Pre Built Profiles questionnaire 7 refers to Q 7 B refers to column B and P indicates the data is for the primary head of household Table kJ Chart OK Cancel J Dashboard Logged in as SBIClient Ruby Laser 2 5 0 84 RubyCom 2 5 1 13 09 Basics1 V26 Table of Contents loaded 100467 characters of XML Ruby Laser Basic Users Manual AXIS COMPONENTS An axis is a variable formatt
65. y ls onX Boomers Weighted Base 130606 29695 32655 25485 000 100 100 100 100 0 0 0 o answer 0 0 0 0 High Middle 28830 100 0 0 28830 100 450 2 2939 10 4453 15 2104 7 3020 10 2597 High 50950 100 0 0 50950 100 399 1 1474 3 5167 10 3929 8 5282 10 4337 fe dl Single Mar No child No cl 11268 12 100 10 e Table J Chart J Dashboard Fi Freg Y Col Row Logged in as SBIClient Ruby Laser 2 5 0 84 RubyCom 2 5 1 13 L Sig 18 HOW TO WORK WITH TABLES Edit Your Table Change the Stub or Banner To replace a stub axis you must first delete your current stub axis from the bottom right hand frame Highlight the stub axis specifications in the frame Click on the top row of the specifications in the frame hold down your shift key and click on the last row of the specifications Click the red X to delete the stub Move a new stub from the Axes menu into the empty stub frame Click OK to generate and display the new table Ruby Laser Mozilla Firefox File Edit View History Bookmarks Tools Help Ruby Laser Seis oy gt e E an gt 9 Demographics gt EJ Products amp Services b Access gt Attitudes b Pre Built Profiles To delete a stub axis highlight the stub contents Click on the top row hold down your shift key and click on the last row Ba

Ruby Laser Basic: User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents