– (100% Good rated) conjoint analysis/Marketing

Use “Airbnb_Travelers_for case writeup.xlsx” excel spreadsheet to perform analyses we have done in class and answer the following questions
1) Estimate the treatment effects of “$25 off” and “free taxi”. Perform the analyses in Excel and write down your answers below. Are the estimated effects statistically significant (Please refer to the p-value)?
2) If the manager only wants to use one promotion plan to acquire new customers in Eugene, which promotion plan should the manager use? Why?