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 to any of the previous assignments.

A.Create some research questions (goals)
B.Use at least 7 of the following topics to apply a good quality data analysis and knowledge discovery task to the dataset.
C.Range Names, Lookup Functions, Index Function, Match Function, Using Pivot Tables and slicers to describe data
D.The Data Model, Filtering data and removing duplicates, Array Formulas and Functions
E.Text Functions, Date and Time Functions, Time & time functions
F.Summarizing Data by Using Histograms and Pareto Charts,
G.Importing Data from a Text File or Document,
H.Validating Data Reading

Answer 1

For this assignment, you will collect sports data and analyze it using histograms, boxplots, and probability distributions.

Step-by-step explanation:

Analyzing Sports Data

For this assignment, you can collect sports data from the internet or a newspaper, such as baseball averages, basketball scores, or football odds. Once you have your data, you can create a histogram and a boxplot to visualize the distribution. Then, you can determine which probability distribution best fits your data. Finally, you can discuss your findings with your classmates.

Keywords: sports data, histogram, boxplot, probability distribution