Your task is to perform multivariate regressions using Excel. You will also create a PowerPoint presentation that describes the regression model you used and analyze specific criteria provided by TC Ice Cream.

For each of the multivariate regressions, your dependent variable will be Quantity Sold. For the independent variable, you will be given the variables to use per the below instructions. Then you will create a presentation for the TC Ice Cream management team in which you describe the regression models, the variables, and the testing you chose to analyze.

Within the TC Ice Cream Excel Workbook, use the "Flavor One Multi. Regression" and "Flavor Two Multi. Regression" sheets to create and place the multivariate regression models. For this assignment you will be using the Excel Data Analysis "add-in" and specifically the Regression Analysis tool. The regression analysis output will provide critical information such as the R2 value, regression coefficients, linear regression equation, and p values.

Specifically, you must address the following rubric criteria:

Multivariate Regression for Flavor One:

• Use the sheet "Flavor One Multi. Regression" to create and place your multivariate regression models.
• Create a Multivariate regression model: the dependent variable is Quantity Sold and the independent variables are Advertising Expenses and Flavor Ratings.

Multivariate Regression for Flavor Two:

• Use the sheet "Flavor Two Multi. Regression" to create and place your multivariate regression models.
• Create a Multivariate regression model: the dependent variable is Quantity Sold and the independent variables are Advertising Expenses and Flavor Ratings.

Then, use the Module Five PowerPoint Template to create a presentation explaining the results of the multivariate regressions. This should include key visualizations and analysis to support your answers. The template includes specific questions to answer. Use the multivariate regression models from the "Flavor One Multi. Regression" and "Flavor Two Multi. Regression" sheets to support your analysis.

Note: You will need to refer to your analysis from Milestone One to assist you in answering the questions.