Abstract
This paper aims to develop a MS Excel macro program for the statistical analysis of choice experiment data. Estimation results from a conditional logit model are obtained by inputting the choice experiment's choice sets and responses into separate sheets of an MS Excel workbook, and executing the macro program. This macro program has several advantages in comparison with an earlier MS Excel program. First, it can be used to analyze choice experiment questions that have up to 6 possible alternatives. Second, since it automatically generates a data set for the conditional logit model from the input data, the time taken to input the data set suited to the model and the probability of mistakes in inputting data are reduced. Finally, it can calculate goodness-of-fit measures as well as the t-value and p-value of each estimated coefficient. However, the results of the macro program differ slightly from those of econometric software packages used widely in previous papers where choice experiments were applied. The users of the macro program have to be alert to possible calculation errors.
