It is important to provide your stakeholders with the background of how and why you chose specific ways to identify trends and make predictions. As a consultant, you must be able to articulate this kind of information to people who may not have the background in statistics that you do; after all, you were hired for your expertise. Specifically, you need the ability to explain which regressions were used and why.

Your detailed goals for this phase of your work are as follows:

Use current data and analyses to identify future trends and attributes that can have an impact on sales.

Use the TC Ice Cream Data Set to complete this step.

Perform two linear bivariate regressions and two multiple regressions to provide specific recommendations.

Choose key TC Ice Cream attributes out of the following four for regressions: Advertising Expenses, Flavor Rating, Social Media Posts, and Event Promotions. Quantity Sold is a dependent variable.

Use the hypothesis from Milestone One to validate and predict using regressions.

Dependent and independent variables for your analyses should come from the provided data only.

Prompt

Your task is to identify future trends and variables that impact sales. Given monthly production levels and flavor variety, the monthly quantity sold is most optimal between $3,000$ and $12,000.$ Your work will be completed in the Flavor One Bivariate Analysis, Flavor Two Bivariate Analysis, Flavor One Multi. Analysis, Flavor Two Multi. Analysis worksheets in the TC Ice Cream Excel Workbook. You will then use this information to create a predictions and trends report. You will submit both the workbook and a PowerPoint presentation of the report in this milestone.

Reminder:

The division $$WEST NORTH CENTRAL$$ cannot be used for your assignment. Use the division and two flavors you selected in previous modules.

Specifically, you must address the following rubric criteria:

Excel Workbook.

Identify future trends and attributes that impact sales. Use the worksheets specified below to complete your work.

Perform two bivariate regressions to provide recommendations.

For the first bivariate regression for Flavor One, the dependent variable should be Quantity Sold. Choose an independent variable from one of the remaining attributes $($Advertising Expenses, Flavor Rating, Social Media Posts, Event Promotions$).$ Use the Flavor One Bivariate Analysis sheet.

For the second bivariate regression for Flavor Two, the variable should be Quantity Sold. Choose an independent variable from one of the remaining variables $($Advertising Expenses, Flavor Rating, Social Media Posts, Event Promotions$).$ Use the Flavor Two Bivariate Analysis sheet.

To provide guidance and analysis to this hypothesis range, select one of the following questions and answer the question for both Flavor One and Flavor Two. You will address this question in your PowerPoint presentation.

In the upcoming year, if TC Ice Cream used the average monthly advertising expenses for the given flavor plus an additional $12\%,$ would the monthly quantity sold fall between $3,000$ and $12,000$ gallons? Answer this question for Flavor One and Flavor Two separately.

In the upcoming year, if TC Ice Cream targeted a flavor rating for the given flavor of $8\mathrm{.}75$ per a given region$/$division$/$flavor$/$month$,$ would the monthly quantity sold fall between $3,000$ and $12,000$ gallons? Answer this question for both Flavor One and Flavor Two separately.

In the upcoming year, if TC Ice Cream targeted the number of social media posts for the given flavor of ice cream as $15$ per a given region$/$division$/$flavor$/$month$,$ would the monthly quantity sold fall between $3,000$ and $12,000$ gallons? Answer this question for both Flavor One and Flavor Two separately.

In the upcoming year, if TC Ice Cream targeted the number of sponsored events for the given flavor of ice cream as $135$ per a given region$/$division$/$flavor$/$month$,$ would the monthly quantity sold fall between $3,000$ and $12,000$ gallons? Answer this question for both Flavor One and Flavor Two separately.

Perform two multivariate regressions to provide recommendations.

For the first multivariate regression, the dependent variable should be Quantity Sold $($the column in the data set$).$ Choose two independent variables from one of the remaining attributes $($Advertising Expenses, Flavor Rating, Social Media Posts, Event Promotions$).$ Use the Flavor One Multi. Analysis sheet.

For the second multivariate regression, the dependent variable should be Quantity Sold $($the column name in the data set$).$ You should choose two independent variables from one of the remaining attributes $($Advertising Expenses, Flavor Rating, Social Media Posts, Event Promotions$).$ Use the Flavor Two Multi. Analysis sheet.

To provide guidance and analysis to this hypothesis range, select one of the following questions and answer the question for both Flavor One and Flavor Two. You will address this question in your PowerPoint presentation.

In the