Module Five Excel Workbook mba504

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.

Reminder: The division WEST NORTH CENTRAL cannot be used for your assignment. Use the division and two flavors you selected in Module Three.

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

What to Submit

TC Ice Cream Excel Workbook: Submit the . This should include work completed in the Flavor One Multi. Regression and Flavor Two Multi. Regression sheets. Do not remove any worksheets from the workbook.
PowerPoint Presentation: Submit a PowerPoint presentation using the . If references are included, they should be cited in APA format. Consult the for more information on citations.

Module Five Excel Workbook Rubric

Criteria	Exceeds Expectations (100%)	Meets Expectations (90%)	Partially Meets Expectations (70%)	Does Not Meet Expectations (0%)	Value
Multivariate Regression: Flavor One	Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner	Performs multivariate regression accurately for the given data set	Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include aligning the independent and dependent variables correctly to perform the regression	Does not attempt criterion	30
Multivariate Regression: Flavor Two	Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner	Performs multivariate regression accurately for the given data set	Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include aligning the independent and dependent variables correctly to perform the regression	Does not attempt criterion	30
PowerPoint Presentation: Explanation of Regression Results	Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner	Explains the results of the bivariate regressions performed and provides an accurate analysis using the questions provided	Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include explaining the results of the bivariate regressions performed and providing an accurate analysis using the questions provided	Does not attempt criterion	30
Clear Communication	Exceeds expectations with an intentional use of language that promotes a thorough understanding	Consistently and effectively communicates in an organized way to a specific audience	Shows progress toward meeting expectations, but communication is inconsistent or ineffective in a way that negatively impacts understanding	Shows no evidence of consistent, effective, or organized communication	10

WRITE MY PAPER

Overview

Prompt

What to Submit

Module Five Excel Workbook Rubric

Comments

Leave a Reply Cancel reply