Answered step by step
Verified Expert Solution
Question
1 Approved Answer
=>Using a Pivot Table: a) Calculate the sum of Payment methods for each Customer Type with each Gender. b) Based on your calculations, create a
=>Using a Pivot Table: a) Calculate the sum of Payment methods for each Customer Type with each Gender. b) Based on your calculations, create a chart with all the metrics and appropriate labels. c) Write a small paragraph describing what you see in the chart and what you can conclude.
PART I: INTRODUCTION \\& BACKGROUND CASE STUDY: SPECIALTY FOODS INC. You will continue to work on the Specialty Foods case for the exploratory data analysis step of a typical data analytics project. Please refer to mini project 1 for a detailed description of the company, the previous data provided and other related information including your analytic tasks and objectives. INTRODUCTION: Recall that given your data analytic skills, your manager has asked you to help the marketing team by gathering insights into the type of customers the company has and the products they buy. You are also asked to review past campaigns and suggest improvements for future marketing campaigns. In addition to gaining a better understanding of the business your analysis should result in specific recommendations on how the company can improve business results. ANALYSIS: For this mini project each team should work on exploratory data analysis. Please review the information provided at the beginning of this mini project that covers the various steps in the EDA process. This mini project focuses on Exploratory Data Analysis \\& Data Visualization which follows on from mini project 1 \\& 2 that covered understanding the Business Problem and Data Curation, respectively. Mini Project 4 will cover advanced Chart Title PART I: INTRODUCTION \\& BACKGROUND CASE STUDY: SPECIALTY FOODS INC. You will continue to work on the Specialty Foods case for the exploratory data analysis step of a typical data analytics project. Please refer to mini project 1 for a detailed description of the company, the previous data provided and other related information including your analytic tasks and objectives. INTRODUCTION: Recall that given your data analytic skills, your manager has asked you to help the marketing team by gathering insights into the type of customers the company has and the products they buy. You are also asked to review past campaigns and suggest improvements for future marketing campaigns. In addition to gaining a better understanding of the business your analysis should result in specific recommendations on how the company can improve business results. ANALYSIS: For this mini project each team should work on exploratory data analysis. Please review the information provided at the beginning of this mini project that covers the various steps in the EDA process. This mini project focuses on Exploratory Data Analysis \\& Data Visualization which follows on from mini project 1 \\& 2 that covered understanding the Business Problem and Data Curation, respectively. Mini Project 4 will cover advanced Chart TitleStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started