The objective of this assignment is to demonstrate your Excel skills that you have learnt throughout this course using a real dataset (download from Kaggle).

The content of the report should include Table of Contents, Introduction, Methodology and Results, Discussion and Conclusion.

1. Download a data set from Kaggle.com. Your can trim the dataset, but it must consist of at least 100 observations. In order to avoid duplication, please register your dataset using the link below.

1. Describe the data set in the Introduction in terms of where this data set came from and what you plan to do with the data set (Objective and Problem Statement)

1. In the Methodology and Results section, conduct the following analysis:

• Design TWO queries using logical functions
• Design a retrieval application using a combination of VLOOKUP/MATCH/INDEX/IF functions
• Design a PivotTable, and use this Table to show/extract TWO different information and visualise these information using PivotChart
• Create FOUR different charts and ONE combination chart
• Create ONE sparklines
• Comment on the frequency distribution and histogram of a categorical variable
• Comment on the frequency distribution and histogram ofa numerical variable
• Comment on the mean, median and mode for one of the variable
• Use the Excel Descriptive Statistics Tool, compare the numerical statistical measures for two of the variables
• Investigate the relationship between two variables, and interpret the coefficient
• Build a regression model, and use this model for a prediction.

1. Discuss the results
2. Provide your conclusion