![Page 1: How To Find Out Which Product Attributes Your Customers Value the Most By Using Conjoint Analysis With Dummy Variable Regression in Excel](https://reader033.vdocuments.us/reader033/viewer/2022061212/5493f7c6b479594c4d8b49bc/html5/thumbnails/1.jpg)
How To Find Out Which Product Attributes Are Most Important By
Using Conjoint Analysis With Dummy Variable Regression in Excel
http://blog.excelmasterseries.com/
![Page 2: How To Find Out Which Product Attributes Your Customers Value the Most By Using Conjoint Analysis With Dummy Variable Regression in Excel](https://reader033.vdocuments.us/reader033/viewer/2022061212/5493f7c6b479594c4d8b49bc/html5/thumbnails/2.jpg)
What Is Conjoint Analysis?
● Conjoint Analysis Calculates the Customer’s “Utility,” or Degree of Liking, for Each Product Attribute
● Conjoint Analysis Allows the Marketer To Find Out What Group of Product Attribute Choices the Consumer Values Most, and By How Much
http://blog.excelmasterseries.com/
![Page 3: How To Find Out Which Product Attributes Your Customers Value the Most By Using Conjoint Analysis With Dummy Variable Regression in Excel](https://reader033.vdocuments.us/reader033/viewer/2022061212/5493f7c6b479594c4d8b49bc/html5/thumbnails/3.jpg)
The 6 Steps to Conjoint Analysis in Excel
1) List All Product Attributes for 1 Product 2) List All Possible Attribute Combinations 3) Have Consumer Rate Each Attribute Combination 4) Prepare Completed Survey For Regression 5) Run Regression in Excel 6) Derive Attribute Utilities From Regression Output
http://blog.excelmasterseries.com/
![Page 4: How To Find Out Which Product Attributes Your Customers Value the Most By Using Conjoint Analysis With Dummy Variable Regression in Excel](https://reader033.vdocuments.us/reader033/viewer/2022061212/5493f7c6b479594c4d8b49bc/html5/thumbnails/4.jpg)
1) List All Product Attributes for 1 Product
http://blog.excelmasterseries.com/
![Page 5: How To Find Out Which Product Attributes Your Customers Value the Most By Using Conjoint Analysis With Dummy Variable Regression in Excel](https://reader033.vdocuments.us/reader033/viewer/2022061212/5493f7c6b479594c4d8b49bc/html5/thumbnails/5.jpg)
2) List All Possible Combinations of Those Attributes
![Page 6: How To Find Out Which Product Attributes Your Customers Value the Most By Using Conjoint Analysis With Dummy Variable Regression in Excel](https://reader033.vdocuments.us/reader033/viewer/2022061212/5493f7c6b479594c4d8b49bc/html5/thumbnails/6.jpg)
3) Have the Consumer Rate Each Attribute Combination
![Page 7: How To Find Out Which Product Attributes Your Customers Value the Most By Using Conjoint Analysis With Dummy Variable Regression in Excel](https://reader033.vdocuments.us/reader033/viewer/2022061212/5493f7c6b479594c4d8b49bc/html5/thumbnails/7.jpg)
4) Prepare Completed Survey For Regression
![Page 8: How To Find Out Which Product Attributes Your Customers Value the Most By Using Conjoint Analysis With Dummy Variable Regression in Excel](https://reader033.vdocuments.us/reader033/viewer/2022061212/5493f7c6b479594c4d8b49bc/html5/thumbnails/8.jpg)
5) Run the Regression in Excel
http://blog.excelmasterseries.com/
![Page 9: How To Find Out Which Product Attributes Your Customers Value the Most By Using Conjoint Analysis With Dummy Variable Regression in Excel](https://reader033.vdocuments.us/reader033/viewer/2022061212/5493f7c6b479594c4d8b49bc/html5/thumbnails/9.jpg)
6) Derive Attribute Utilities From Regression Output
![Page 10: How To Find Out Which Product Attributes Your Customers Value the Most By Using Conjoint Analysis With Dummy Variable Regression in Excel](https://reader033.vdocuments.us/reader033/viewer/2022061212/5493f7c6b479594c4d8b49bc/html5/thumbnails/10.jpg)
Final Attribute Utility Values
![Page 11: How To Find Out Which Product Attributes Your Customers Value the Most By Using Conjoint Analysis With Dummy Variable Regression in Excel](https://reader033.vdocuments.us/reader033/viewer/2022061212/5493f7c6b479594c4d8b49bc/html5/thumbnails/11.jpg)
Showing That Removing Dummy Variables Has No Effect On The Output
![Page 12: How To Find Out Which Product Attributes Your Customers Value the Most By Using Conjoint Analysis With Dummy Variable Regression in Excel](https://reader033.vdocuments.us/reader033/viewer/2022061212/5493f7c6b479594c4d8b49bc/html5/thumbnails/12.jpg)
![Page 13: How To Find Out Which Product Attributes Your Customers Value the Most By Using Conjoint Analysis With Dummy Variable Regression in Excel](https://reader033.vdocuments.us/reader033/viewer/2022061212/5493f7c6b479594c4d8b49bc/html5/thumbnails/13.jpg)