Please show excel work and steps

A consumer package goods company recently conducted a conjoint analysis on consumer's preference for toothpaste. In the study, the company asked 400 consumers to rate how much they like a toothpaste with a specific combination of features. The data contains the following variables: - Brand: three brands - Colgate, Crest, or Sensodyne - Anti-cavity: High, Enhanced, or Standard - Whitening: yes or no - Flavor: chocolate, coffee, cupcake, strawberry - Shelf life: 12 months, 18 months, 24 months - Price: Retail price per tube, $2,$3, or $4 - Evaluation: the consumer's evaluation of the toothpaste on a scale of 0-10 from least favorable (0) to most favorable (10) Run a regression with "Evaluation" as the dependent variable (y) and brand, anti-cavity, whitening, flavor, shelf-life, and price as the xs (after appropriate coding for categorical variables whenever applies) and answer the following questions. a. Everything else equal, which brand is the most highly evaluated? On average, how much higher in evaluation does the most popular brand receive over the least popular brand? b. Everything else equal, if we change a toothpaste's anti-cavity from "high" to "standard", how much do we have to lower the price in order to remain the same in evaluation? c. Compare two toothpaste configurations: - Brand: Colgate, Anti-cavity: Standard, Flavor: Coffee, Shelf life: 12 months, at $3 - Brand: Sensodyne, Anti-cavity: Enhanced, Flavor: Strawberry, Shelf life: 18 months, at $4. Everything else equal, on average, which one will receive a higher evaluation? A consumer package goods company recently conducted a conjoint analysis on consumer's preference for toothpaste. In the study, the company asked 400 consumers to rate how much they like a toothpaste with a specific combination of features. The data contains the following variables: - Brand: three brands - Colgate, Crest, or Sensodyne - Anti-cavity: High, Enhanced, or Standard - Whitening: yes or no - Flavor: chocolate, coffee, cupcake, strawberry - Shelf life: 12 months, 18 months, 24 months - Price: Retail price per tube, $2,$3, or $4 - Evaluation: the consumer's evaluation of the toothpaste on a scale of 0-10 from least favorable (0) to most favorable (10) Run a regression with "Evaluation" as the dependent variable (y) and brand, anti-cavity, whitening, flavor, shelf-life, and price as the xs (after appropriate coding for categorical variables whenever applies) and answer the following questions. a. Everything else equal, which brand is the most highly evaluated? On average, how much higher in evaluation does the most popular brand receive over the least popular brand? b. Everything else equal, if we change a toothpaste's anti-cavity from "high" to "standard", how much do we have to lower the price in order to remain the same in evaluation? c. Compare two toothpaste configurations: - Brand: Colgate, Anti-cavity: Standard, Flavor: Coffee, Shelf life: 12 months, at $3 - Brand: Sensodyne, Anti-cavity: Enhanced, Flavor: Strawberry, Shelf life: 18 months, at $4. Everything else equal, on average, which one will receive a higher evaluation