Problem Statement: The dataset provided is related to IMDB Movies. A potential problem to investigate could be: "What factors influence the success of a movie on IMDB?" Here, success can be defined by high IMDB ratings. The impact of this problem is significant for movie producers, directors, and investors who want to understand what makes a movie successful to make informed decisions in their future projects.
This project aims to carry out the in-depth analysis of IMDB movie dataset. Excel is used to draw insights and analyze to find genre, budget, director and more.
A.Cleaning the data:: This is one of the most important step to perform before moving forward with the analysis.(Dropping columns, removing null values, etc.)
TASKS:- A. Movie Genre Analysis: Analyze the distribution of movie genres and their impact on the IMDB score. Task: Determine the most common genres of movies in the dataset. Then, for each genre, calculate descriptive statistics (mean, median, mode, range, variance, standard deviation) of the IMDB scores.
B. Movie Duration Analysis: Analyze the distribution of movie durations and its impact on the IMDB score. Task: Analyze the distribution of movie durations and identify the relationship between movie duration and IMDB score.
C. Language Analysis: Situation: Examine the distribution of movies based on their language. Task: Determine the most common languages used in movies and analyze their impact on the IMDB score using descriptive statistics.
D. Director Analysis: Influence of directors on movie ratings. Task: Identify the top directors based on their average IMDB score and analyze their contribution to the success of movies using percentile calculations.
E. Budget Analysis: Explore the relationship between movie budgets and their financial success. Task: Analyze the correlation between movie budgets and gross earnings, and identify the movies with the highest profit margin.