How do I do a turf analysis in Excel?

How do I do a turf analysis in Excel?

Setting up a TURF analysis After opening XLSTAT, select the XLSTAT / Sensory data analysis / TURF command, or click on the corresponding button of the XLSTAT-Sensory data analysis button (see below). Once the button is clicked, the dialog box appears. You can then select the data on the Excel sheet.

What is a turf study?

What is TURF Analysis? TURF stands for Total Unduplicated Reach and Frequency. It’s a method of statistical analysis used by businesses and researchers to estimate media or market potential, as well as to produce optimized communication strategies with limited organizational resources.

What is MaxDiff research?

Definition: MaxDiff analysis, also known as the best-worst scaling is an analytic approach used to gauge survey respondents preference score for different items. Researchers ask the respondents to pick the most and least important factors in given answer options.

What is the idea behind conjoint analysis?

Conjoint analysis definition: Conjoint analysis is defined as a survey-based advanced market research analysis method that attempts to understand how people make complex choices. We make choices that require trade-offs every day — so often that we may not even realize it.

What is MaxDiff scaling?

Maximum Difference Scaling (MaxDiff) is a survey research technique for obtaining preference scores for a list of items. It allows you to prioritize a set of product features or test concepts. In a MaxDiff exercise, survey participants are asked to select their most and least favorite type of candy.

What is a conjoint simulator?

Principle of simulation for conjoint analysis Conjoint analysis is a comprehensive method for the analysis of new products in a competitive environment. Once the analysis has been performed, the major advantage of conjoint analysis is its ability to perform market simulations using the obtained utilities.

How do you do MaxDiff?

To create a MaxDiff survey, create a survey as normal, and then add a MaxDiff question where you see fit. You can add an unlimited amount of attributes for respondents to evaluate. You can display up to fifty sets (50) or display all attributes inside one set.

What is a MaxDiff study?

How can I run a TURF Analysis in Excel?

Excel by itself is not set up to run complex analyses like TURF, but you do have options: Use the free and friendly Conjoint.ly TURF Analysis Simulator and export results with nice formatting into Excel. Use an R package (such as turfR) together with an Excel-R connector (such as BERT ).

What is the TURF analysis simulator?

Conjoint.ly’s user-friendly TURF Analysis Simulator is an automated tool that helps automatically find top claim combinations. It can be used for product claim selection, range optimisation, and other applications (both using data from Conjoint.ly experiments and from other sources.

How do I create a turf report?

Step #3: Create a TURF report. To create a TURF Report go to Results > Reports. Under the Create Report button select TURF. Name the report and choose your checkbox question in the Source Question drop-down. Define the Simulation Level. This is the number of options you wish to compare in combination.

What is TURF algorithm?

TURF algorithm evaluates all the possible permutations and combinations by considering answer options provided under a multiple choice question. Due to this, one needs to be selective of the product/service options they have under a multiple choice question.