The last few decades have seen a revolution in market research techniques. Often these techniques involve advanced mathematics and are inherently difficult to apply. StatWizards is committed to making these tools accessible via Excel add-ins at no sacrifice in functionality. For experienced users, StatWizards provides a huge boost in productivity. One of these techniques is discrete-choice modelling. The idea underlying this technique is that by observing the choices people make between products or services, one can model how individuals trade off product or service features with pricing. Results from models like this can be placed in an Excel-based simulator in which marketers can project how different products might fare in a competitive marketplace. Another technique consists of Fader-Hardie models. These models address a wide range of business issues, from calculating customer lifetime value for a product's entire customer base to projecting repeat bookings for luxury cruise lines. A distinct feature of Fader-Hardie models is that they simultaneously produce granular product forecasts at individual and market levels.
The Simulator Wizard builds an Excel-based market simulator from a discrete-choice model. Starting with the output from a statistical estimation program, the Wizard steps you through a process that produces a full-featured market simulator that is instantly deliverable to users and chock full of features. The Wizard makes building a simulator astonishingly simpler, faster and better.
A discrete-choice project consists of a predictable number of steps. Typically a project starts with assembling a list of product attributes and levels used to generate an experimental design, adding store visits to a questionnaire, then going to field. Data from the field need to be reorganized to serve as input to a discrete-choice statistical package. The Data Wizard facilitates this process, reducing what is normally a tedious, complex exercise taking hours to a short burst of calculation in Excel.
The Latent GOLD Format Wizard helps you import the results from a Latent GOLD estimation into Excel, adding useful charts and formatting. The Format Wizard makes preparing Latent GOLD estimations for analysis and presentation simpler, faster and better.
The Forecast Wizard applies Fader-Hardie models to a number of common business problems, such as understanding the composition of sales volume, calculating customer lifetime value based on recency, frequency and monetary value of purchases, projecting customer retention and attrition, forecasting sales based on trial results, predicting online behavior and improving marketing campaigns.
The Design Wizard helps you develop an experimental design for a discrete-choice questionnaire. Starting with a simple Excel list of product attributes and levels, the Wizard steps you through a process that generates efficient choice sets, camera-ready store visits and a variety of output formats. The Design Wizard makes the process of generating a design simpler, faster and better than any of its competitors. Making use of Excel's power, the Wizard can also generate designs that are far more complex.