Excel workbook guidelines
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 , 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 explainsthe 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 . For this assignment, work should be completed in the Descriptive Statistics and Overall Analysis sheets.
- 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 One Excel Workbook Rubric
| Criteria | Exceeds Expectations (100%) | Meets Expectations (90%) | Partially Meets Expectations (70%) | Does Not Meet Expectations (0%) | Value |
|---|---|---|---|---|---|
| Create Table: Descriptive Statistics | Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner | Creates a table that represents the descriptive statistics for each quantitative variable and includes accurate calculations of average, median, maximum, minimum, and range. | Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include calculating the average, median, maximum, minimum, and range for each attribute | Does not attempt criterion | 30 |
| Create Charts: Key Visualizations | Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner | Creates a pie chart, line chart, and bar chart to represent the key variables of the data | Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include creating a pie chart, line chart, and bar chart to represent all key variables of the data | Does not attempt criterion | 30 |
| PowerPoint Presentation: Explanation of Data and Variables | Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner | Explains the data and its key attributes accurately and provides data and visualizations to support the analysis | Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include explaining data and its variables with greater detail and insight | 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 |
| Total: | |||||
Requirements: PowerPoint and excel sheet
Calculate the price of your order
Select your paper details and see how much our professional writing services will cost.
- Freebies
- Format
- Formatting (MLA, APA, Chicago, custom, etc.)
- Title page & bibliography
- 24/7 customer support
- Amendments to your paper when they are needed
- Chat with your writer
- 275 word/double-spaced page
- 12 point Arial/Times New Roman
- Double, single, and custom spacing
-
We care about originality
Our custom human-written papers from top essay writers are always free from plagiarism.
-
We protect your privacy
Your data and payment info stay secured every time you get our help from an essay writer.
-
You control your money
Your money is safe with us. If your plans change, you can get it sent back to your card.
How it works
-
1
You give us the detailsComplete a brief order form to tell us what kind of paper you need.
-
2
We find you a top writerOne of the best experts in your discipline starts working on your essay.
-
3
You get the paper doneEnjoy writing that meets your demands and high academic standards!
Get your own paper from top experts
Order nowPerks of our essay writing service
We offer more than just hand-crafted papers customized for you. Here are more of our greatest perks.
Frequently asked questions
Get instant answers to the questions that students ask most often.
See full FAQHow do you find the best essay writer for me?
Our professional writing service focuses on giving you the right specialist so the one assigned will have the knowledge about the right topic. However, if you’ve used our essay service before, you can ask us to assign you the expert writer who used to complete papers for you in the past. We can easily do so if the specialist in question is available at the moment.
If you’re ordering from our essay writing service for the first time, we will assign you a suitable expert ourselves and ensure that your academic essay writer is a pro. Moreover, let us know how complex your assignment is so that we can find the best match for your order.
We’ve hired the best writers in 80+ academic subjects to complete any paper you need. As soon as we hear, “Write my essays,” our support team assigns you the writer who understands your needs and subject.
In case you need to make sure we’ve picked a great specialist to deal with your paper, you can chat with the expert writers directly. We do our best to make sure you’re happy with the writer we’ve selected for you.
How can you prove that your paper writing service is not a scam?
We have been selling original essays for more than 15 years. To prove that we are a trustworthy custom essay writing company, we provide quick delivery and a money-back guarantee. If we can’t complete your paper for any reason, we’ll send your money back to the credit card. We want to deliver the finest services, so you can decide if the paper is good enough; from our side, we’ll edit it according to your primary requirements to make the writing perfect. Our online paper writing service is about both giving you the materials you need when you need them and ensuring that your private data is safe. Check out our guarantees to see how we control the quality of your assignment and protect you as a customer.