(Business Analytics 3rd edition) Chapter 4 Problem 17:Attracted by possible returns from a protfolio movies, hedge funds have invested in the movie industry by financially backing individual films and/or studios. The hedge fund star ventures is currently conduction some research involving movies involving adam sandler, An American actor, Screenwriter, and film producer. As a first step, Star Ventures would like to cluster Adam Sandler movies based on their gross box office returns and movie critic ratings. Using the data in the file Sandler, apply K-means clustering with k = 3 to characterize three different types of Adam Sandler movies. Base the Clusters on the variables Rating and Box Ratings. Ratings corresponds to movie ratings provided by critics (a higher score represents a movie receiving better reviews). Box represents the gross box office earnings in 2015 dollars. Normalize the values of the input variables to adust for the different magnitudes of the variables. Report the characteristics of each cluster using a PivotTable that includes a count of movies, the average rating of movies and the average box office earning of movies in each cluster. How would you characterize the movies in each cluster.

1. Atracted by the possible returns from a portfolio of movies, hedge funds have invested in the movie industry by financially backing individual films and/or studios. The hedge fund Star Ventures is currently conducting some research involving movies involving Adam Sandler, an American actor, screenwriter, and film producer. As a first step, Star Ventures would like to cluster Adam Sandler movies based on their gross box office returns and movie critic ratings. Using the data in the file Sandler, apply k-means clustering with k=3 to characterize three different types of Adam Sandler movies. Base the clusters on the variables Rating and Box. Rating corresponds to movie ratings provided by critics (a higher score represents a movie receiving better reviews). Box represents the gross box office earnings in 2015 dollars. Normalize the values of the input variables to adjust for the different magnitudes of the variables. Report the characteristics of each cluster using a PivotTable that includes a count of movies, the average rating of movies and the average box office earnings of movies in each cluster. How would you characterize the movies in each cluster