EXTRA ACTIVITY -3

EXTRA ACTIVITY WEEK -3

Perform the following on the dataset:

(i): Pick a suitable dataset from a trustable source of  your own interest (For example: cricket, music, bollywood data, food, agriculture, football, etc.). The selected dataset should comprise at least 1000 rows and at least 5 columns which contain both categorical (at least 2) and numerical (at least 3) variables. Kindly cite the link of the data source and refrain yourself from using the data that are not intended for public consumption. 

OR

You can use the same dataset which you have used in the previous activity. (Make sure all conditions for dataset is fulfilled and cite the link of the previous data source as well)

(ii): Transfer the data from the source mentioned above into a Google Spreadsheet. You can either embed the spreadsheet directly into your Student Portfolio page or provide a link to access it.

Create another Google Spreadsheet named “Activity-3” and execute the following tasks within it.

1. Identify the following from your dataset and also give the reason behind it:

• Measures of central tendency (by visualization also)

• Measures of dispersion

2. Select any two categorical variables from your dataset and  find the association between them. Also, provide your insights regarding the observed relationship between the variables based on plotting a 100% stacked bar chart.

3. Select any two numerical variables, say X1 and X2,  from your dataset and plot the scatter plot between them. Also, provide your insights regarding the observed relationship between the variables based on the scatter plot visualization.

4. Find the covariance and correlation between the above selected two variables and interpret the relationship between the variables based on the obtained values.

please  see the details below . 

A BRIEF  Analysis on Movie Dataset 

This spreadsheet provides a comprehensive overview of movies across various key attributes, offering valuable insights for movie enthusiasts, researchers, and industry analysts. It is structured to analyze trends, patterns, and relationships in the world of cinema. The dataset includes essential variables like movie titles, release years, directors, actors, ratings, runtimes, censorship certifications and  genres.

SOURCE :-https://www.kaggle.com/datasets/rakkesharv/imdb-5000-movies-multiple-genres-dataset

I have chosen a dataset from trusteed website    www.kaggle.com/datasets  on IMDB rating  which contain 5563 rows and 7 column of numerical and categorical data .  PLEASE CLICK ON SPREADSHEET GIVEN BELOW  you will get the insights including visuals , about the data and their analysis with measures of  central tendency and dispersion   etc.