Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed =>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. image text in transcribedimage text in transcribed

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 Title

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions