- 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 > Variation Analyst > Arranging Data for Testing
Group Variation Analyst Arranging Data for Testing The data is key, and the GIGO concept holds true: Garbage In Garbage Out. Before looking at the assumptions that must be met in order to run a reliable variation analysis lets discuss the form and kind of data suitable for the analysis. There are two main situations when we want to analyze performance: - To find out differences in internal and external data. The former refers, for instance, to our product only and the latter accounts for competitors as well.
- To find out differences in spatial and time data, such as several geographic areas and time series.
The picture above shows the different data sets. The four tables show hypothetical data concerning sales performance in several situations. In the top-left region the table shows measurements for the same product in three different geographic areas: area 1, 2 and 3. Each area is made of six zones (or stores if you like), and the data shows sales growth by zone. For instance, the value in cell B2 is obtained by dividing the sales value for Dash in Zone 1 of Area 1 in August 2004 by the sales value in the same zone for July 2004 minus 1. This test may be of great value to managers, for example when evaluating the effectiveness of promotional actions. Say you want to increase sales in the short run by means of a promotional campaign, and you have doubts concerning which of three concepts should be applied: price discount, increased quantity, or bundling a convenience package. Surveying a sample of consumers could produce the data needed to make an informed decision based on customer preference and profitability, because Variation Analyst supplies values that make clear the advantage of one offer against the others. You may have noticed there are missing values in two of the tables. Variation Analyst handles such cases without requiring the user to take any action. Read more concerning missing data in the section Technicalities. The tables in the picture show percent values, but unit or monetary data can also be used. The important thing is that the variances of the groups (columns) are equal or close. In this instance, Variation Analyst produces reliable results. However, if one of the stability assumptions is unmet, it may produce unreliable and, therefore, dangerous results. The section Technicalities supplies information concerning the assumptions underlying the data arrangement for this analytical tool. |