Describes the regression model you used

Assignment Help Other Subject

Reference no: EM133767348

Overview
While bivariate regression is used to predict the impact of one independent variable on one dependent variable, multivariate regression is used to predict the impact of two or more independent variables on one dependent variable.

In this scenario, you will continue to work as a business consultant trainee with the TC Ice Cream client. TC Ice Cream would like to know which variables have an impact on the Quantity Sold variable. The TC Ice Cream management team would like you to create multivariate regressions to analyze the data. Remember that TC Ice Cream is interested in whether specific trends are identified that can help grow its business through improved operations and sales. You have decided that the best analysis will be to perform multivariate regressions.

For each of the multivariate regressions, your dependent variable will be Quantity Sold and you will be selecting a quantitative independent variable. Then you will create a PowerPoint presentation for the TC Ice Cream management team in which you describe the regression models, the variables, and the testing conducted.

Prompt
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.

Reference no: EM133767348

Questions Cloud

Do you believe that clients who are intoxicated : Do you believe that clients who are intoxicated or in withdrawal have the capacity to provide informed consent? Why or why not? What safeguards would you put

Do you think patenting of new inventions-in life sciences : Do you think that the patenting of new inventions (medicines, techniques, etc.), in the life sciences, promotes or hinders innovation.

What draws you into connection : what draws you into connection and find somewhere to sit and reflect. Ideally, you are seated on the ground. Experience being in the place.

Was the public involved in any of the planning stages : How was the project implemented? Was the public involved in any of the planning stages?

Describes the regression model you used : Create a PowerPoint presentation for the TC Ice Cream management team in which you describe the regression models, the variables, and the testing conducted

What role does organizational culture play in promoting : What role does organizational culture play in promoting or obstructing social justice? How can social justice frameworks be applied to improve organizational

Create a table listing your regulatory agencies : Identify regulatory agencies that regulate health and the health care system within the US, create a table listing your 5 regulatory agencies and address

Analyzing and composing a variety of texts : Define and apply key rhetorical concepts through analyzing and composing a variety of texts several genres and modes (print, visual, digital, oral, multimodal)

Is the current employment rate and crime rate : Do you think because El Paso, TX is a border town that could contribute to the rise in crime? Is the current employment rate and crime rate;

User Account

All Pages