TC Ice Cream is a private-label ice cream manufacturer. Located in the northern region of Michigan, TC Ice Cream specializes in premium ice cream flavors. TC Ice Cream is categorized in the food/ag

Data measurement is an important aspect of data analytics. Identifying trends in key attributes of data is a fundamental measurement for various aspects of business data and an important skill for business professionals. In this scenario, you are a business consultant trainee assigned to work with your first client, TC Ice Cream. TC Ice Cream is a private-label ice cream manufacturer. Located in the northern region of Michigan, TC Ice Cream specializes in premium ice cream flavors. TC Ice Cream is categorized in the food/agriculture business sector. The company has gained popularity over the past three years due to recent publicity such as winning awards on network television food shows, hosting and attending promotional events, and actively using social media. The management team of TC Ice Cream is looking to see if there are specific trends that could be identified to help them improve their operations and sales and grow their business. You will report the research and analysis of the data to the TC Ice Cream management team. Periodically, you will be expected to apply your training and submit a deliverable to the management team. The TC Ice Cream information technology team has provided you with a data set, TC Ice Cream Excel Workbook, that contains data about orders over a span of three years. You will use the data variables to create descriptive statistics and visualizations for TC Ice Cream. This will enable you to effectively and efficiently gain helpful insights into the data and its attributes. You will continue to delve further into your analysis of TC Ice Cream throughout the course.  Prompt For this assignment, you will perform the following steps as you begin your analysis of the data provided. Within the TC Ice Cream Excel Workbook, review the sheet “Data Dictionary.” This will help you understand the data provided and specific information about each variable. Review the sheet “TC Ice Cream Data.” DO NOT EDIT this data.  Next, you will calculate the central tendency of the TC Ice Cream data set using the average, median, minimum, maximum, and range. You will also create multiple charts to present the descriptive analysis you performed.  Specifically, you must address the following rubric criteria: Create a table to represent the average, median, minimum, maximum and range values for each variable. Within the TC Ice Cream Excel Worksheet, use the sheet “Descriptive Statistics” to create the following table. Use Excel formulas to calculate the average, median, minimum, maximum, and range values for each of the quantitative variables (Quantity Sold, Advertising Expenses, Flavor Rating, Social Media Posts, Event Promotions). Create charts to represent the key variables of the data. Within the TC Ice Cream Excel Worksheet, use the sheet “Overall Analysis” to create the charts listed below. It is recommended that you use pivot tables/pivot charts to create the visualizations. Feel free to use this sheet to create any additional visualizations that might help you better understand the data. Create a pie chart using the qualitative variable Region and the quantitative variable Quantity Sold to provide a visualization of percentage overview of quantity sold by region. 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. Create a bar chart using the qualitative variable Flavor and the quantitative variable Quantity Sold to provide a visualization displaying quantity sold by flavor. Use the Module One PowerPoint Template to create a PowerPoint presentation that explains the data and its key variables. This should include key visualizations and analysis to support your answers. The PowerPoint Template includes specific questions to answer as you explain the data and variables. Use the visualizations and data analysis you created in the “Descriptive Statistics” and “Overall Analysis” sheets to support your analysis. What to Submit TC Ice Cream Excel Workbook: Submit the TC Ice Cream Excel Workbook. For this assignment, work should be completed in the “Descriptive Statistics” and “Overall Analysis” sheets. PowerPoint Presentation: Submit a PowerPoint Presentation using the Module One PowerPoint Template. If references are included, they should be cited in APA format. Consult the Shapiro Library APA Style Guide for more information on citations.

TBI Assignment Traumatic Brain Injury (TBI) has increasingly affected combat service members as the injuries sustained in combat have continued to evolve. TBI can affect the physical,

TBI Assignment Traumatic Brain Injury (TBI) has increasingly affected combat service members as the injuries sustained in combat have continued to evolve. TBI can affect the physical, psychological, sensory, and many other functions of service members during and after combat. However, the symptoms are easily misdiagnosed for other conditions, or missed completely. The purpose of […]

Prompt: Should social media companies have to pay damages to Seattle Public Schools for their role in the youth mental health crisis? Purpose of the assignment: In this assignment,

Purpose of the paper: The Source Integration Writing Assignment allows you to develop your ideas about an article. Basic Guidelines: Your paragraph(s) must have a clear, argumentative thesis statement in the first paragraph. This is a statement of your position about the subject of the article. Your paragraph(s) must include a brief summary of the […]

You have been working on the Developmental Self-Reflection Paper in installments throughout this course. This paper must consider developmental issues that may impact

You have been working on the Developmental Self-Reflection Paper in installments throughout this course. This paper must consider developmental issues that may impact you as a professional counselor, as well as the strengths and challenges that you will bring to the profession based on your own unique developmental history. It should also address your spiritual […]

Planning Your Presentation Aid Discussion Content Question INITIAL POST A major component of Informative Speech 2 is the presentation aid. Spend time considering how you will select and create an effective aid for your upcoming speech

Planning Your Presentation Aid Discussion Content Question INITIAL POST A major component of Informative Speech 2 is the presentation aid. Spend time considering how you will select and create an effective aid for your upcoming speech. Describe how you think you will utilize the presentation aid in your own speech and how the potential aid […]

Purpose of the paper: The Source Integration Writing Assignment allows you to develop your ideas about an article. Basic Guidelines: Your paragraph(s) must have a clear, argumentative thesis statement in the first paragraph.

Purpose of the paper: The Source Integration Writing Assignment allows you to develop your ideas about an article. Basic Guidelines: Your paragraph(s) must have a clear, argumentative thesis statement in the first paragraph. This is a statement of your position about the subject of the article. Your paragraph(s) must include a brief summary of the […]

Read 1 article from a major trade journals websites and write a paper on it Journals such as Chef Magazine, Restaurants & Institutions, the National Culinary Review, Prepared Foods, Modern Baking, Food Service Director, Restaurant USA, etc. are suitable

Read 1 article from a major trade journals websites and write a paper on it Journals such as Chef Magazine, Restaurants & Institutions, the National Culinary Review, Prepared Foods, Modern Baking, Food Service Director, Restaurant USA, etc. are suitable. Consumer magazines (Bon Appetite, Gourmet, etc) are not acceptable for this assignment. Readings must be from […]

Read 4 feature length articles. (Again; each is due on different weeks of the semester. Check the calendar on page 2 of this syllabus): Two need be from major trade journals websites and two from other web sites.

READING ASSIGNMENTSOBJECTIVE: To expose you to the wealth of up-to-date information available by regularlyreading professional publications.DUE DATES: there are 4 assignments and they are due on different dates. See the classschedule on page 2 page of this syllabus.READING PORTION GUIDELINES:Read 4 feature length articles. (Again; each is due on different weeks of the semester.Check the […]

Assignment #4: Sacred Water Research and Preparation: Research a specific site in Thailand where sacred water is central to religious practice. This could be a temple, shrine, or natural water source with religious significance

Assignment #4: Sacred Water Research and Preparation: Research a specific site in Thailand where sacred water is central to religious practice. This could be a temple, shrine, or natural water source with religious significance, such as the Wat Phra Kaew (Temple of the Emerald Buddha), the Chao Phraya River, or any other site.Directions: Research and […]

Probation sentences are used more often than any other sentencing option in the United States for correctional purposes. As a result, there are benefits and drawbacks to the system.

Assignment Details Probation sentences are used more often than any other sentencing option in the United States for correctional purposes. As a result, there are benefits and drawbacks to the system. Using the knowledge that you have gained from this week’s reading assignments, Intellipath and MUSE assets, and other information provided, address the following questions […]

Scroll to top