Question
Choose a dataset of your interest ( either from Kaggle or the existing datasets offered in the course material). Your dataset should not be similar
Choose a dataset of your interest ( either from Kaggle or the existing datasets offered in the course material). Your dataset should not be similar to any of the previous assignments.
Create some research questions (goals)
Use at least 7 of the following topics to apply a good quality data analysis and knowledge discovery task to the dataset.
Range Names, Lookup Functions, Index Function, Match Function, Using Pivot Tables and slicers to describe data
The Data Model, Filtering data and removing duplicates, Array Formulas and Functions
Text Functions, Date and Time Functions, Time & time functions
Summarizing Data by Using Histograms and Pareto Charts,
Importing Data from a Text File or Document,
Validating Data Reading
Step 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