Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started