Question: Here are the steps: Convert the data file to a table Calculate descriptive statistics for the following variables tmdb _ popularity runtime imdb _ score
Here are the steps:
Convert the data file to a table
Calculate descriptive statistics for the following variables
tmdbpopularity
runtime
imdbscore
Create the following PivotTable
Mean tmdbpopularity by DramaAlpha Columns and Decade Rows
Create a stacked histogram for the following variables using PivotCharts
Count of title by type ColumnsAxis and tmdbpopularity RowsLegend; Group by Starting at Ending at By ; Add slicers for Decade and ActionAlpha
Create boxplots for the following variables
tmdbscore by SciFiAlpha
Create the following stacked bar chart using PivotCharts
Mean tmdbpopularity by ActionSciFiAlpha ColumnsAxis and type RowsLegend; Add a slicer for Decade
Create a scatterplot for the following variables
tmdbscore by imdbscore
Create a correlation a matrix that includes the following variables
tmdbpopularity
runtime
imdbscore
Action
Drama
SciFi
Comedy
European
Western
Animation
Dramedy
ActionDrama
ActionSciFi
DramaSciFi
ActionDramaSciFi
Conduct a market basket analysis using the same variables for the correlation matrix to determine which of the variables predict tmdbpopularity
Include as many regression analysis steps as are needed to identify the variables that predict tmdbpopularity
Calculate the lift for each variable from the final regression model
Using the data mining results, prepare an Executive Summary of pages for Netflix that explains which variables predict movie popularity. Include in your summary the following:
A description of the analyses that were conducted
Charts, PivotTables, and PivotCharts showing the relationship of the key variables to the movie popularity
A summary table showing the key variables and their lift as calculated in your analyses
Any recommendations that you can provide to Netflix
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
