Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Create multiple charts to represent the division you have selected. The division “West North Central” cannot be used for your analysis. Within the TC Ice Cream Excel Workbook, use the “Division Analys

  1. Create multiple charts to represent the division you have selected. The division “West North Central” cannot be used for your analysis. Within the TC Ice Cream Excel Workbook, use the “Division Analysis” sheet to create the following charts. It is recommended that you use pivot table filtering functionality to filter the data to the specific division you have selected.
    • Create a pie chart using the qualitative variable Flavor and the quantitative variable Quantity Sold to provide a visualization of percentage overview of quantity sold by flavor for the division.
    • 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 for the division.
    • Create a bar chart using the qualitative variable Flavor and the quantitative variable Flavor Rating to provide a visualization displaying average flavor rating by flavor.
    • Create a combo chart using the qualitative variable Date (x-axis) and the quantitative variables Quantity Sold (clustered column) and Advertising Expenses (line – secondary axis).
    • Create a combo chart using the qualitative variable Flavor (x-axis) and the quantitative variables Quantity Sold (clustered column) and Average Flavor Rating (line – secondary axis).
  2. Use the Module Two PowerPoint Template to create a PowerPoint presentation that explains the identified patterns, trends, and correlations. This should include key visualizations and analysis to support your answers. The template includes specific questions to answer. Use the visualizations and data analysis you created in the “Division Analysis” sheet to support your analysis.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Module 1 – CaseEquilibrium, Supply and DemandAssignment Overview Supply and Demand in the Real World A commodity is the focus of this case which uses real data for price fluctuations over 6 months. Y

Module 1 – CaseEquilibrium, Supply and DemandAssignment Overview Supply and Demand in the Real WorldA commodity is the focus of this case which uses real data for price fluctuations over 6 months. You will research reasons for the changes and develop a multifaceted economic analysis. Case 1 Resources Introduction to

Module 1 – SLPEquilibrium, Supply and DemandAssignment OverviewProfessional Application with Excel Throughout the MBA program, you will have multiple opportunities to work with Excel using discipline-

Module 1 – SLPEquilibrium, Supply and DemandAssignment OverviewProfessional Application with Excel Throughout the MBA program, you will have multiple opportunities to work with Excel using discipline-specific tools. Beyond learning to analyze data, it is crucial to apply findings for practical situations. Combining data, economic theory, and research provides hands-on practical

Discussion Thread: Setting Direction, Advantages / Disadvantages, and Decision Models Strategy is critical to the process of charting a company’s direction in the business environment. When evaluating

Discussion Thread: Setting Direction, Advantages / Disadvantages, and Decision Models Strategy is critical to the process of charting a company’s direction in the business environment. When evaluating strategic choices, it is important to understand key advantages and disadvantages of the various options under consideration. Decision models continue to impact strategy

Discussion Reply: Strategy Development, Strategy Decisions, and Decision Models You will reply to one of your classmate’s thread. Minimum of 250 words in the body. Minimum of 2 sources from the litera

Discussion Reply: Strategy Development, Strategy Decisions, and Decision ModelsYou will reply to one of your classmate’s thread.Minimum of 250 words in the body.Minimum of 2 sources from the literature in addition to course texts.Use bolded headings below in the reply.Current APA format must be used.Use the following Outline:• Summary –

REPLIES: INSTRUCTIONS The student must reply to at least two classmates’ threads by 11:59 p.m. (ET) Sunday of the assigned Module: Week. Your replies must include meaningful and substantive contributi

REPLIES: INSTRUCTIONSThe student must reply to at least two classmates’ threads by 11:59 p.m. (ET) Sunday of theassigned Module: Week. Your replies must include meaningful and substantive contributions tothe discussion, and ideally provoke and challenge the thinking of your colleagues. Each replymust be 200-300 words.Replies: Specific Reference RequirementsFor Discussion Replies:

The student will post one thread of 700– 900 words by 11:59 p.m. (ET) on Sunday of the assigned Module Discussion Questions In what ways can a retailer such as Nordstrom take advantage of revenue mana

The student will post one thread of 700–900 words by 11:59 p.m. (ET) on Sunday of the assigned Module Discussion Questions In what ways can a retailer such as Nordstrom take advantage of revenue management opportunities? What revenue management opportunities are available to a manufacturer? How can it take advantage

CASE STUDY: TO SAVOR OR TO GROUPON? ASSIGNMENT INSTRUCTIONS OVERVIEW This week there is a focus on how managers use pricing as a lever to better match supply and demand and grow revenue derived from

CASE STUDY: TO SAVOR OR TO GROUPON? ASSIGNMENT INSTRUCTIONS OVERVIEW This week there is a focus on how managers use pricing as a lever to better match supply anddemand and grow revenue derived from supply chain assets. Revenue management can reduceimbalances between supply and demand through pricing. There is also

Prepare either a 3–4 page report or a 12-slide presentation in which you analyze financial information and risks associated with an investment to expand an organization and make a recommendation on wh

Prepare either a 3–4 page report or a 12-slide presentation in which you analyze financial information and risks associated with an investment to expand an organization and make a recommendation on whether or not to invest in expansion. Collapse AllIntroduction This portfolio work project will help you to not only

REPLIES For all Discussions, each reply must incorporate at least 1 scholarly citation in the current APA format and 1 Biblical principle/verse (Note: for each reply for the Discussion: Disruptive Mar

REPLIESFor all Discussions, each reply must incorporate at least 1 scholarly citation in the current APAformat and 1 Biblical principle/verse (Note: for each reply for the Discussion: DisruptiveMarketing, at least 1 Biblical verse needs to cited, in current APA format, under the BiblicalIntegration subject header). Any sources cited must have

Discussion Thread: Exploring Employee Engagement, Globalization, and Christian Worldview Thread: Specific Reference Requirements For Discussion Thread: Introducing HR and Christian Worldview and Discu

Discussion Thread: Exploring Employee Engagement, Globalization, and Christian Worldview Thread: Specific Reference RequirementsFor Discussion Thread: Introducing HR and Christian Worldview and Discussion Thread: Shapingthe Future of HR, include a references section, and be sure to have in-text citations for thefollowing sources:• At least 2 citations from Valentine: Human Resource Management.•

Discussion Thread: Disruptive Marketing For this module’s discussion, you will summarize your Disruptive Marketing Plan. You would never attach your paper here – but summarize key concepts/learnings.

Discussion Thread: Disruptive Marketing For this module’s discussion, you will summarize your Disruptive Marketing Plan. You would never attach your paper here – but summarize key concepts/learnings. NSTRUCTIONSThe student will post one thread of at least 750 words not to exceed 1,250 words by 11:59 p.m.(ET) on Thursday of the

Virtual Marketing Campaign Simulation This creative assignment measures your mastery of ULOs 3.3 and 4.1. Assignment Overview: In this assignment, you will take on the role of a digital marke

Virtual Marketing Campaign Simulation This creative assignment measures your mastery of ULOs 3.3 and 4.1. Assignment Overview: In this assignment, you will take on the role of a digital marketing manager tasked with creating a comprehensive virtual marketing campaign for a new product or service. The campaign will be designed

Consider that you found an online job posting for your dream job. Practice completing a résumé package that includes a cover letter, a résumé, and a professional strengths, weaknesses, opportunities,

Consider that you found an online job posting for your dream job. Practice completing a résumé package that includes a cover letter, a résumé, and a professional strengths, weaknesses, opportunities, and threats (SWOT) analysis. This résumé package is designed to help you prepare for a future job search. Cover Letter

Discussion Thread: Strategy Development, Strategy Decisions, and Decision Models Developing strategy begins with thinking strategically and knowing what the key decisions are. The decision models that

Discussion Thread: Strategy Development, Strategy Decisions, and Decision ModelsDeveloping strategy begins with thinking strategically and knowing what the key decisions are. Thedecision models that you employ will directly impact the quality of the decisions you make sounderstanding them is critical.Minimum of 500 words in the body.Minimum of 2 sources from