After taking care of these problems, your workbook should look like this: Ignore any problems with unresolved links when you open the file.
#Xlstat tutorial simulator
The Simulator Wizard can turn the output from these models into full-featured simulators in Excel.įor this example, we use one of XLStat's tutorial files, demoCBCHB.xlsm, which can be downloaded here. XLStat, the premier vendor of Excel-based advanced statistical applications, sells a choice-based conjoint module that supports a number of choice models, including CBC/HB. Separate equations describe the choice profiles of each respondent in the sample. One important advantage of HB is that it generates individual parameter estimates. HB in its Sawtooth implementation assumes that all parameters vary mixed logit allows selected parameters to vary and offers significance tests for dispersion measures (the hypothesis that a dispersion measure is zero is equivalent to saying that no significant heterogeneity exists for that parameter). Both techniques assume that consumer tastes, represented by choice parameters, vary across the population. HB resembles mixed logit in a number of respects. Parameters for these lower models describe individual behavior but also borrow information from the group. The lower part consists of choice models for each individual respondent. Their technique, Hierarchical Bayes (HB), assumes that individual choice parameters are described by a normal distribution throughout the population. One of today's most powerful techniques emerged in 1995 with a ground-breaking paper by Greg Allenby and James Gintner. The Wizard will later extend the table by adding calculations for t statistics and p values.įor a number of years, researchers have grappled with ways to model heterogeneity in consumer tastes, which often confound traditional logit models. The above table describes the attributes and levels used in the study, along with the model's parameter estimates. Click on that tab now, and scroll down until you see the following section: To run the tutorial, you must go to the worksheet containing model results, in this case CBC. Once you have done that, you should see the sample file: You might also want to save the workbook to your desktop. Click OK at any prompts you see regarding external links.
After downloading the file and opening it in Excel, click the yellow Enable Content button to allow you to modify the workbook.
#Xlstat tutorial download
We will use one of XLStat's demonstration files, demoCBC.xlsm, available for download by clicking on the preceding hyperlink. Choice-based conjoint is synonymous with discrete-choice modeling using aggregate utilities. XLStat's Choice-Based Conjoint (CBC) module estimates an aggregate-level conditional logit model based on a given set of attributes and levels combined with an Excel data sheet of responses. Click on the associated file name to download the corresponding demonstration file. For a detailed overview of a specific module, click its name in the table below. Each XLStat module is accompanied by a demonstration file, which the Wizard also uses as a demonstration file. The Simulator Wizard can build simulators from any of these. XLStat's conjoint module supports a number of choice models, including choice-based conjoint (CBC), hierarchical Bayes (CBC/HB), conditional logit and basic conjoint.