Analyze some Data and Excel Works

Read the bookbinder case study. Identify top 1000 customers (in terms of choice probability) from the holdout sample - use only logistic regression. If the book price is $45, the mailing charge is $1 and the average cost of book production is $20, what would be your expected profit (with choice modeling) ? How much extra profit can be generated with this choice modeling technique (compared to the no choice modeling case)? 2. Read the Kirin case study and answer the following questions, a. How would you segment the imported beer market (segmentation analysis)? Explain in details. b. Run conjoint analysis to identify best possible product design for Kirin. Estimate Kirin's market share with this new product. c. Can Kirin introduce 'Kirin New' (as suggested by Kirin's own market research team) as well as the new product that you developed for Kirin in 2b in the market? Do you see any potential problem of cannibalization (i.e. one of Kirin's brands is eating away the market share of the other brand introduced by Kirin)? d. Identify the distinct segment of consumers who would prefer the proposed new product (positioning analysis). Please be as detailed as possible with all your answers. Also, try to justify all your recommendations with proper quantitative analysis. Upload the main word document as well as all the excel files where you have performed the data analysis. No point will be awarded if you fail to upload the data analysis files.