Analyzing Total Gross and Average Ratings to understand Film Profitability

This project analyses film industry in terms of average rating of each movie genre and total gross that can be derived from each genre to identify the most profitable one that microsoft studio can invest in.

Box office has provided us with their data on the movies they air, their ratings, their production budget as well as their gross profit

we will use provided data on ratings and gross to get the most profitable genre of film for microsoft studio. The movie data, ratings and ross will be merged to form a single table for easy analyses. after combining the table, we will merge the foreign and domestinc gross to get the total expected gross. from which we will get there we will use bar carts to see the relationship of each to each genre.

In conclusion, understanding film profitability considers both financial success (Total Gross) and critical reception (Average Ratings). By examining these metrics in relation to genre, we can gain valuable insights into which genres tend to be the most profitable.

As much as there are other factors that could affect the profitability of any given film, the profit from each genre as well as the ratings seams to affect the industry most. The high rating indicates that the film will stay on demand for long thus continue earning from the film for a long duration of time. I would recommend to start by adventure genre since it has the highest average profitability in relation to both total gross and average rating.

This project will give you a valuable opportunity to develop your data science skills using real-world data. The end-of-phase projects are a critical part of the program because they give you a chance to bring together all the skills you've learned, apply them to realistic projects for a business stakeholder, practice communication skills, and get feedback to help you improve. You've got this!