# Question-1 (initial Overview)

The Minimum, Maximum and average of Opening gross, total US and Non-US gross and opening theaters are illustrated in the excel exhibit below, to provide an initial overview of the dataset.Furthermore, it can be evaluated that, the total number of comedy movies in the dataset amounts to 23 and the total number of R-rated movies amount to 15.

Hollywood Rules Harvard Case Solution & Analysis

 Question-1 Opening Gross Total U.S. Gross Total Non-U.S. Gross Budget Opening Theatres Mean 17,468,466 59,620,651 59,560,983 49,273,333 2,766 Minimum 4,120,497 13,090,630 0 20,000,000 852 Maximum 68,033,544 198,000,317 456,235,122 100,000,000 3,964 No. of Comedies 23 No. of R-Rated Movies 15

# Question-2 (Michael London Declaration)

## Part-(a)

To justify Michael London’s Declaration the return on investments of the US gross has been calculated, as illustrated in the Excel file calculated through the dividing budget with the US gross. In which, it can be determined that, the returns for all the movies present in the dataset is significantly higher than 12%.

## Part-(b)

The mean of US Gross ROI has been calculated at 95% confidence interval using descriptive statistics function in excel, illustrated in the exhibit below.

 (a) US Gross ROI Mean 129% Confidence Level (95.0%) 0.16

## Part-(c)

From the above exhibit, it can be evaluated that, the mean of ROI generated from U.S, is significantly higher at 129% than the 12% London cited. Therefore, it can be determined that, the 12% historic return London cited was justified, attributed to the Extensive average ROI generated from the data set provided in the case.

# Question-3

## Part-(a)

To compare the U.S gross revenues generated for the movies in the dataset, which was the main factor to estimate the success of the movie. The U.S gross revenues were distributed based on their genres, and by implementing a descriptive statistic function in excel helped us to identify, which genres of movies contributed towards generating the highest average US gross revenues. However, it can be determined that, Comedy and Adventure genre movies contributed towards generating the highest average U.S gross revenues in Hollywood. Despite the fact that, comedy and adventure genre movies were significantly lessor in numbers, compared to other genre movies available in the dataset. Therefore, it can be determined that, mean of comedy movies was significantly higher than the other non-comedy movies available in the dataset.

Additionally, it can be evaluated that, the kurtosis of comedy movies amounted to a negative 0.09 whereas, the kurtosis for all non-comedy genre moviesamounted to a positive 4.29. Whichmeant that, the probability of next value being generated low in the comedy genre distribution was high and it would reach its outliers less frequently. Whereas, for all non-comedy genre movies the probability of next value being generated high in the distribution, was high and it would meet its outlier more frequently.................

This is just a sample partial work. Please place the order on the website to get your own originally done case solution.

Other Similar Case Solutions like