- Part 1. Introduction to MM4XL
- Part 2. MM4XL Tools
- 1. Strategic Tools
- BCG Matrix
- Brand Mapping
- Brand Switch
- Decision Tree
- Forecast Manager
- McKinsey Matrix
- Profile Manager
- Quality Manager
- Risk Analyst
- Risk Analyst Expert in a Few Minutes
- Introduction to Decision Analysis
- Introducing Risk Analyst with an example
- 1. How to run Risk Analyst
- 2. Simulation Never heard of it
- 3. Examples
- 4. Functions
- 1. Property Functions
- 2. Utility Functions
- 3. Distribution Functions
- mmBETA (Scale, Shape)
- mmBETAGEN (Scale, Shape, [Optional: Lower], [Optional: Upper])
- mmBINOMIAL (Trials, Successes)
- mmCHI2 (Degrees)
- mmDISCRETE (InputRange, Probabilities)
- mmERF (Mean)
- mmERLANG (Scale, Shape)
- mmEXPON (Mean)
- mmEXTVAL (ModalValue, StDeviation)
- mmGAMMA (Scale, Shape)
- mmGAUSSINV (Mean, Scale)
- mmGEO (Trials)
- mmHYPERGEO (Sample, Defects, BatchSize)
- mmINTUNI (Lower, Upper)
- mmLOGISTIC (Mean, StDeviation)
- mmLOGNORMAL (Mean, StDeviation)
- mmNEGBIN (Failures, Successes)
- mmNORMAL (Mean, StDeviation)
- mmPARETO (Location, ModalValue)
- mmPARETO2 (Location, ModalValue)
- mmPERT (Lower, ModalValue, Upper)
- mmPOISSON (Mean)
- mmRANDBETWEEN (Lower, Upper)
- mmRAYLEIGH (ModalValue)
- mmSTUDENT (Degrees)
- mmTRI (Lower, ModalValue, Upper)
- mmUNIFORM (Lower, Upper)
- mmWEIBULL (Life, Shape)
- Probability functions
- Technicalities
- Sources
- 2. Analytical Tools
- Business Formulas
- mmBASS, Bass Diffusion Model
- mmBEI, Brand Equity Index
- mmBEP, Break-Even Point
- mmBEPR, Break-Even Point with Fixed Rate of Return
- mmBUYRATE, Purchase Rate Model
- mmCAGR, Compound Annual Growth
- mmCHIp, Chi Squared Test
- mmCODING, Coding of variables
- 1. Customer Satisfaction
- 2. Database Functions
- mmDHMS, Number to Time
- mmEI, Evolution Index
- mmEXPECT, Expected values
- 3. Forecast Errors
- mmGROWTH
- mmGROWTHBACK
- mmGRP, Gross Rating Points
- mmHERF, Herfindahl Index
- mmINTERPOLE, Linear Interpolation
- mmLEARN, Learning Curve
- mmMSAR, Market Share to Advertising Ratio
- 4. Opportunity Index
- 5. Performance Ranking
- 6. Project Management
- mmPREMIUM, Price Premium
- mmPRESS, Product Performance Index
- 7. Price Indexes
- 8. Queuing Theory
- mmRANGE
- mmREBUY, Repeat Purchase Rate
- mmREBUYS, Estimated Number of Re-Purchases
- mmRELATIVE
- mmSAMPLE, Sample Size
- mmSAMPLEMIN, Minimum Sample for Significant Values
- mmSEASON, Seasonality Indexes
- mmSHARE
- mmSIGNIF, Significance Test
- mmVARc, Coefficient of Variation
- Cluster Analysis
- CrossTab
- Descriptive Analyst
- Gravitation Analysis
- Proportion Analyst
- Sample Manager
- Segmentation Tree
- Variation Analyst
- 3. Charts and Maps
- mytest
- Version MM4XL
- contribute
- copytest
- css
- emails
- excel market analysis software
- finance
- download dbx
- download eu
- download manual
- download na
- download removed
- finance dbx
- finance eu
- finance manual
- finance na
- finance removed
- ---NO TITLE----
- ---NO TITLE----
- help
- Part 1. Introduction to MM4XL
- Part 2. MM4XL Tools
- 1. Strategic Tools
- BCG Matrix
- Brand Mapping
- Brand Switch
- Decision Tree
- Forecast Manager
- McKinsey Matrix
- Profile Manager
- Quality Manager
- Risk Analyst
- 1. How to run Risk Analyst
- 2. Simulation Never heard of it
- 3. Examples
- 4. Functions
- 1. Property Functions
- 2. Utility Functions
- 3. Distribution Functions
- mmBETA (Scale, Shape)
- mmBETAGEN (Scale, Shape, [Optional: Lower], [Optional: Upper])
- mmBINOMIAL (Trials, Successes)
- mmCHI2 (Degrees)
- mmDISCRETE (InputRange, Probabilities)
- mmERF (Mean)
- mmERLANG (Scale, Shape)
- mmEXPON (Mean)
- mmEXTVAL (ModalValue, StDeviation)
- mmGAMMA (Scale, Shape)
- mmGAUSSINV (Mean, Scale)
- mmGEO (Trials)
- mmHYPERGEO (Sample, Defects, BatchSize)
- mmINTUNI (Lower, Upper)
- mmLOGISTIC (Mean, StDeviation)
- mmLOGNORMAL (Mean, StDeviation)
- mmNEGBIN (Failures, Successes)
- mmNORMAL (Mean, StDeviation)
- mmPARETO (Location, ModalValue)
- mmPARETO2 (Location, ModalValue)
- mmPERT (Lower, ModalValue, Upper)
- mmPOISSON (Mean)
- mmRANDBETWEEN (Lower, Upper)
- mmRAYLEIGH (ModalValue)
- mmSTUDENT (Degrees)
- mmTRI (Lower, ModalValue, Upper)
- mmUNIFORM (Lower, Upper)
- mmWEIBULL (Life, Shape)
- Probability functions
- Risk Analyst Expert in a Few Minutes
- Introduction to Decision Analysis
- Introducing Risk Analyst with an example
- Technicalities
- Sources
- 2. Analytical Tools
- Business Formulas
- 1. Customer Satisfaction
- 2. Database Functions
- 3. Forecast Errors
- 4. Opportunity Index
- 5. Performance Ranking
- 6. Project Management
- 7. Price Indexes
- 8. Queuing Theory
- mmBASS, Bass Diffusion Model
- mmBEI, Brand Equity Index
- mmBEP, Break-Even Point
- mmBEPR, Break-Even Point with Fixed Rate of Return
- mmBUYRATE, Purchase Rate Model
- mmCAGR, Compound Annual Growth
- mmCHIp, Chi Squared Test
- mmCODING, Coding of variables
- mmDHMS, Number to Time
- mmEI, Evolution Index
- mmEXPECT, Expected values
- mmGROWTH
- mmGROWTHBACK
- mmGRP, Gross Rating Points
- mmHERF, Herfindahl Index
- mmINTERPOLE, Linear Interpolation
- mmLEARN, Learning Curve
- mmMSAR, Market Share to Advertising Ratio
- mmPREMIUM, Price Premium
- mmPRESS, Product Performance Index
- mmRANGE
- mmREBUY, Repeat Purchase Rate
- mmREBUYS, Estimated Number of Re-Purchases
- mmRELATIVE
- mmSAMPLE, Sample Size
- mmSAMPLEMIN, Minimum Sample for Significant Values
- mmSEASON, Seasonality Indexes
- mmSHARE
- mmSIGNIF, Significance Test
- mmVARc, Coefficient of Variation
- Cluster Analysis
- CrossTab
- Descriptive Analyst
- Gravitation Analysis
- Proportion Analyst
- Sample Manager
- Segmentation Tree
- Variation Analyst
- 3. Charts and Maps
- images
- img
- Test pages
- js
- licenses
- lightbox
- logs
- marketing resources
- picture_library
- plesk stat
- press release
- res
- brochures
- copytest
- icons
- links
- proudly_serve
- seminars
- tabs
- tools
- test
- apacheasp
- cgi
- coldfusion
- fcgi
- miva
- perl
- php
- python
- ssi
- treeview_img
- weyou
|
|
Part 2. MM4XL Tools > 2. Analytical Tools > CrossTab > 2. How To Run CrossTab > Parameters page
CrossTab Parameters page The Parameters page is where to define how to cross tabulate input data. On the left side, the panel From List shows the title of each variable in the chosen Dataset range. Select with the mouse one or more variables from this list and click on the appropriate Add>> button for copying the selection to one of the two lists on the right side of the window. The codes of variables copied to the To Row list will be shown in the tables as row items. The listbox Sort row values is set by default on Ascending order, but row tables cab be also displayed with descending row order. As opposite to rows, codes of variables copied to the list To Column will be shown as column items. To remove variables from the lists on the right select one or more entries with the mouse and click on the respective <<Remove button. The selection above would produce 6 tables printed in two blocks each made of 3 tables. Note: The Add and Remove buttons are activated and deactivated depending on the list panel where the cursor is placed on. |