Students can form into groups consisting of three students and send their names

Students can form into groups consisting of three students and send their names to the instructor for the respective CRN and select one dataset from the datasets provided in the below link. The datasets were chosen from The Saudi Open Data Portal, and you are required to select ONLY the datasets from Ministry of Hajj and Umrah which can be accessed via the following link:

https://od.data.gov.sa/Data/en/dataset?q=الحج&sort…

Use only selected or assigned datasets and analyze the data using Microsoft Excel to discover the structure of data, trends, patterns, or any anomalies in the data based on your own hypothesis.

Perform the following tasks. You should use visualization to aid your answer.

Your project will include two main parts:

1. The final project report which must incorporate all the following 5 tasks and is written using the provided template. (10 marks distributed among the below tasks).

2. An oral presentation that illustrates your five tasks. (4 marks)

==========================================================

Task 1: Understand and describe the nature and structure of the selected dataset. (2 marks)

A brief description regarding the dataset.

Identify the features of dataset.

Propose hypothesis / assumptions (between two variables) to validate.

Task 2: Reduce the dimension of the datasets to support the hypothesis validation. If necessary, do data preprocessing on any missing values, duplicate values, etc. You can also generate new features from any of the provided features that may support your hypothesis. Due to the limitation of processing power of some devices, you can reduce your dataset to 1000 tuples. (2 marks)

Task 3: Provide descriptive statistics for some features using statistical methods to understand the dataset more and answer the following analysis questions :(3 marks)

Compare different attributes (features). What trend did you find?

Include any of the “measure of central tendency” such as the mean, median, and mode.

Describe the spread of your data. This may include the measure of variance, standard deviation, skewness, and kurtosis.

(You are encouraged to impose other analysis questions based on any trend you notice in the dataset).

Task 4: Validate the hypothesis in Task 3 by investigating the relationship between two quantitative variables you have chosen using correlation, regression and R-squared with possible conclusions. (2 marks)

Task 5: Show visual representation of your analysis (hint: use the right chart/graph for your data analysis). (1 mark)