Kibata

Sign In

Our Services

Get 15% Discount on your First Order

Order Now
[rank_math_breadcrumb]

MBA 504 Project Guidelines and RubricCompetencies In this project, you will demonstrate your mastery of the following competencies: MBA-50716: Use descriptive statistics for business analysisMBA-50679

MBA 504 Project Guidelines and RubricCompetencies

In this project, you will demonstrate your mastery of the following competencies:

  • MBA-50716: Use descriptive statistics for business analysis
  • MBA-50679: Perform regression analysis to address an authentic problem
  • MBA-50880: Apply statistics in the business environment

Overview

You have been hired as a consultant by TC Ice Cream. As part of its expansion plan, TC Ice Cream wants to limit the number of flavors that they sell and only focus on those that are the most profitable. You will do an analysis of two flavors for a specific division and determine which flavor should be kept and which should be removed.

  • Option A: Keep Flavor One
  • Option B: Keep Flavor Two

The TC Ice Cream management team has tasked you with doing an in-depth analysis to determine which of the two options will be the most profitable, given the monthly advertising expense of $5,000. Use the division that you selected in Module Two and the two flavors that you selected for Milestone One. Consider the TC Ice Cream data set that contains data about quantity sold, advertising expenses, flavor rating, social media posts, and event promotions.

Prompt

Part 1: Data Analysis Workbook 

Analyze the data from the provided TC Ice Cream data set and identify current and future trends and patterns in operations.

Complete the following visualizations for each flavor. The visualizations for Flavor One should be completed in the “Flavor One Analysis” sheet and the visualizations for Flavor Two should be completed in the “Flavor Two Analysis” sheet of the TC Ice Cream Excel Workbook. It is recommended that you use pivot table filtering to filter the data to the specific division and flavor you have selected.

Specifically, you must address the following rubric criteria:

  1. Present the key descriptive statistics for the five quantitative variables in a table (quantity sold, advertising expenses, flavor rating, social media posts, and event promotions). The key descriptive statistics include the mean, median, standard deviation, and range.
  2. Analyze the TC Ice Cream data to identify trends and patterns for the two flavors you have selected. For each flavor, create the following visualizations:
    1. Create a line chart (also known as a trend chart) using the qualitative variable Date and the quantitative variable Quantity Sold to provide a visualization displaying quantity sold by month.
    2. Create a line chart (also known as a trend chart) using the qualitative variable Date and the quantitative variable Flavor Rating (average) to provide a visualization displaying flavor rating (average) by year/quarter/month.
    3. Create a combo chart using the qualitative variable Date (x-axis) and the quantitative variables Quantity Sold (clustered column) and Advertising Expenditures (line – secondary axis).
    4. Create a combo chart using the qualitative variable Date (x-axis) and the quantitative variables Quantity Sold (clustered column) and total – Social Medial Posts and Event Promotions (line – secondary axis). Hint: create a pivot table variable to sum the social media posts and event promotions.
    5. Create a box and whiskers chart using the qualitative variable Quantity Sold. This will help identify any outliers in the Quantity Sold data.
    6. Create a histogram for the qualitative variable Flavor Rating. It is recommended to use the data analysis “add-in” and the analysis tool “Histogram” to create the data for the visualization.
  3. Outliers: Identify any outliers that you see and explain how they have an impact on the overall admission and expense trends. Outliers are the data points that can have an impact on your averages and basic descriptive analysis.
  4. Perform two bivariate regressions to provide recommendations.
    1. 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).
    2. Use the Flavor One Bivariate Analysis sheet.
    3. 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).
    4. Which independent variable seems most appropriate to lead you to a monthly quantity sold of 3,000–12,000 gallons?
  5. Perform two multivariate regressions to provide recommendations.
    1. 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.
    2. Which combination of the attributes seems most appropriate to lead you to the expense of $5,000?
    3. 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.
    4. Which combination of the attributes would seem appropriate to lead you to a monthly quantity sold of 3,000–12,000 gallons?

Part 2: Final Recommendation Analysis PowerPoint PresentationCreate a PowerPoint presentation designed for the TC Ice Cream management team to share the results of your analysis and provide your final recommendation. 

  1. Current State Analysis (slides 1–4): State the option (A or B) that you chose and three reasons for your choice.
  2. Predictions and Trends Analysis (slides 5–7): Present the predictions based on the regressions that you have analyzed.
  3. Executive Audience Summary (slide 8): Summarize your findings for an executive audience.

What to Submit

To complete this project, you must submit the following:

  • TC Ice Cream Excel Workbook: Submit your completed TC Ice Cream Excel Workbook as an Excel file.
  • Final Recommendations Analysis Presentation: Submit a PowerPoint presentation with 8 to 10 slides. There is no template for this assignment, so you may use an earlier presentation template or create your own design. Any sources should be cited according to APA style. Consult the Shapiro Library APA Style Guide for more information on citations.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Order Now

Related Questions

Reply: The student must then post 1 reply to another student’s post. The reply must summarize thestudent’s findings and indicate areas of agreement, disagreement, and improvement. It must besupported

Reply: The student must then post 1 reply to another student’s post. The reply must summarize thestudent’s findings and indicate areas of agreement, disagreement, and improvement. It must besupported with scholarly citations in the latest APA format and corresponding list of references.The minimum word count for Integrating Faith and Learning

SPSS Questions Chapter 6 Using the ChapterSixData.sav file, do the following problems. Print your outputs after typing your interpretation on them. Please circle the key parts of the output that you d

SPSS Questions Chapter 6 Using the ChapterSixData.sav file, do the following problems. Print your outputs after typing your interpretation on them. Please circle the key parts of the output that you d SPSS QuestionsChapter 6Using the ChapterSixData.sav file, do the following problems. Print your outputs after typingyour interpretation on them.

QUANTITATIVE ANALYSIS: DESCRIPTIVE STATISTICS, ORDINAL SCALE AND DICHOTOMOUS VARIABLE ASSIGNMENT SPSS Problems Chapter 4 Using the CollegeStudentData.sav file (see Appendix A), do the following proble

QUANTITATIVE ANALYSIS: DESCRIPTIVE STATISTICS, ORDINAL SCALE AND DICHOTOMOUS VARIABLE ASSIGNMENT SPSS Problems Chapter 4 Using the CollegeStudentData.sav file (see Appendix A), do the following proble QUANTITATIVE ANALYSIS: DESCRIPTIVE STATISTICS, ORDINAL SCALE ANDDICHOTOMOUS VARIABLE ASSIGNMENTSPSS ProblemsChapter 4Using the CollegeStudentData.sav file (see Appendix A), do the following problems. Print youroutputs and circle

SPSS Questions Chapter 6 Using the ChapterSixData.sav file, do the following problems. Print your outputs after typing your interpretation on them. Please circle the key parts of the output that you d

SPSS QuestionsChapter 6Using the ChapterSixData.sav file, do the following problems. Print your outputs after typingyour interpretation on them. Please circle the key parts of the output that you discuss. Use theinformation in the appropriate “Output Interpretation” and “How to Write” sections.6.1 Compute Cohen’s kappa to assess reliability using Rater 1

Discussion Thread: Selecting and Interpreting Inferential Statistics Respond to the following short answer questions from Chapter 5 of the Morgan, Leech, Gloeckner, & Barrett textbook: D4.5.1 Comp

Discussion Thread: Selecting and Interpreting Inferential Statistics Respond to the following short answer questions from Chapter 5 of the Morgan, Leech, Gloeckner, & Barrett textbook: D4.5.1 Compare and contrast a between-groups design and a within-subjects design. D4.5.2. What information about variables, levels, and design should you keep in mind in

Module 2 – CaseHypothesis Testing: t-Tests & ANOVAsAssignment Overview Hypothesis Tests & ANOVA **Complete Module 2 SLP before Module 2 Case** One-Way ANOVA (Analysis of Variance) tests if the

Module 2 – CaseHypothesis Testing: t-Tests & ANOVAsAssignment Overview Hypothesis Tests & ANOVA **Complete Module 2 SLP before Module 2 Case** One-Way ANOVA (Analysis of Variance) tests if there are statistical differences between the means of three or more independent groups. Case 2 Resources Analysis of Variance (ANOVA)Single factor ANOVA

Module 2 – SLPHypothesis Testing: t-Tests & ANOVAsAssignment Overview Two Sample Hypothesis Tests **Complete Module 2 SLP before Module 2 Case** Comparing two samples provides insights. Are emplo

Module 2 – SLPHypothesis Testing: t-Tests & ANOVAsAssignment Overview Two Sample Hypothesis Tests **Complete Module 2 SLP before Module 2 Case**Comparing two samples provides insights. Are employees with an MBA more productive than those without? If our results support the contention, then hiring more MBAs would be good for business.

QUANTITATIVE ANALYSIS: DESCRIPTIVE STATISTICS, ORDINAL SCALE AND DICHOTOMOUS VARIABLE ASSIGNMENT SPSS Problems Chapter 4 Using the CollegeStudentData.sav file (see Appendix A), do the following proble

QUANTITATIVE ANALYSIS: DESCRIPTIVE STATISTICS, ORDINAL SCALE ANDDICHOTOMOUS VARIABLE ASSIGNMENTSPSS ProblemsChapter 4Using the CollegeStudentData.sav file (see Appendix A), do the following problems. Print youroutputs and circle the key parts of the output that you discuss.4.1.For the variables with five or more ordered levels, compute the skewness. Describe theresults. Which variables in

The student must then post 1 reply to another student’s post. The reply must summarize the student’s findings and indicate areas of agreement, disagreement, and improvement. It must be supported with

The student must then post 1 reply to another student’s post. The reply must summarize thestudent’s findings and indicate areas of agreement, disagreement, and improvement. It must besupported with scholarly citations in the latest APA format and corresponding list of references.The minimum word count for Integrating Faith and Learning discussion

DISCUSSION ASSIGNMENT INSTRUCTIONS The student will complete 8 short-answer discussions in this course and 1 long-answer Integrating Faith and Learning discussion. In the thread for each short-answer

DISCUSSION ASSIGNMENT INSTRUCTIONSThe student will complete 8 short-answer discussions in this course and 1 long-answerIntegrating Faith and Learning discussion. In the thread for each short-answer discussion thestudent will post short answers to the prompted questions. The answers must demonstratecourse-related knowledge and support their assertions with scholarly citations in the latest

BUSINESS ANALYSIS REPORT Introduction After completing the business simulation at a competent level (a score above 0.000 for the cumulative total performance at the end of Q6), you will create a writt

BUSINESS ANALYSIS REPORT Introduction After completing the business simulation at a competent level (a score above 0.000 for the cumulative total performance at the end of Q6), you will create a written report, using the attached “Business Analysis Template,” for stockholders and the board of directors to review. Analyze the

SPSS Problems Chapter 4 Using the CollegeStudentData.sav file (see Appendix A), do the following problems. Print your outputs and circle the key parts of the output that you discuss. 4.1.For the varia

SPSS ProblemsChapter 4Using the CollegeStudentData.sav file (see Appendix A), do the following problems. Print youroutputs and circle the key parts of the output that you discuss.4.1.For the variables with five or more ordered levels, compute the skewness. Describe theresults. Which variables in the dataset are approximately normally distributed/scale? Whichones are

Please follow the Instructions and NO plagiarism! All submissions should have a title page and reference page (not included in page count).Narrative component submitted in a Word document, which may i

Please follow the Instructions and NO plagiarism! All submissions should have a title page and reference page (not included in page count). Narrative component submitted in a Word document, which may include tables, graphs, and other resources as needed. Include an introductory and summary paragraph/statement. The page count should be

INVESTOR PRESENTATION: MBA ATTACHED ARE THE COMPLETED QUARTERS. DO NOT CREATE A VIDEO, JUST THE PPT SLIDES Introduction An important aspect of running a successful start-up business is acquiring fundi

INVESTOR PRESENTATION: MBA ATTACHED ARE THE COMPLETED QUARTERS. DO NOT CREATE A VIDEO, JUST THE PPT SLIDES Introduction An important aspect of running a successful start-up business is acquiring funding from potential investors based on information about the business. In this task, you will use the skills you have acquired

Write a 2–3-page paper recommending solutions to challenges and opportunities that are based on evidence-based strategies about Allina Health Collapse AllIntroduction In this assessment, you will app

Write a 2–3-page paper recommending solutions to challenges and opportunities that are based on evidence-based strategies about Allina Health  Collapse AllIntroduction In this assessment, you will apply innovative, strategic, and sustainable approaches using systems theory to consider forces and impact across the system. Now that you have conducted market data analysis, you

Create a 9–10-slide PowerPoint presentation and conduct a 5–10-video recording of the delivery of the presentation, synthesizing information to make decisions that are focused on the development and j

Create a 9–10-slide PowerPoint presentation and conduct a 5–10-video recording of the delivery of the presentation, synthesizing information to make decisions that are focused on the development and justification of recommendations of evidence-based strategies based on Allina Health Collapse AllIntroduction This portfolio work project is the final piece of your

Write a 2–3-page paper recommending solutions to challenges and opportunities that are based on evidence-based strategies about Allina Health Collapse AllIntroduction In this assessment, you will app

Write a 2–3-page paper recommending solutions to challenges and opportunities that are based on evidence-based strategies about Allina Health  Collapse AllIntroduction In this assessment, you will apply innovative, strategic, and sustainable approaches using systems theory to consider forces and impact across the system. Now that you have conducted market data analysis, you