The students will collect data from www.boxofficemojo.com using the Box Office/All Time reports; additional information could be found on www.IMDB.com or by using the free Iphone app Box Office Hits. For their study, the students will use the most successful 50 movies theatrically released in the US, according to any of the above sources (preferably the www.boxofficemojo website). (2) Organizing data: The students will organize the data in a 10-caption table, with the following headers: 1. Title 2. Year the movie was released 3. Studio that produced/distributed (used standard abbreviations in the industry: Disney, BV, WB, etc.) 4. Genre (using a seven-category distribution: (1) Animation [A], (2) Sci Fi [SF], (3) Fantasy [F], (4) Action/Adventure [AA], (5) Drama [D], (6) Comedy [C] (both adult and children), and (7) Horror [H]. 5. IP, Intellectual Property behind (whether adaptation or not [y] or [n]) 6. Rating (PG, PG 13, R, NC-17, etc.) 7. Budget (rounded to the nearest million) 8. Box-Office USA (domestic revenue generated through theatrical distribution; rounded to the nearest million) 9. Simple Profitability Ratio R1 (Box-Off/Budget, rounded to two decimals; how much the movie made for each dollar spent to produce). 10. Simple Profitability Ratio R2 (ROI Percentage=[Box-Off—Budget]/Budget, rounded to two decimals; what was the return of investment for each dollar spent to produce; this is just a simple formula that does not include distribution fees, P&A expenses, etc. To assess the financial profitability of a movie, one needs to use far more complicated formulas that go beyond the scope of this project). See example below: Title Year Studio Genre IP Rating Budget BO USA R1 R2 1 Avatar 2009 Fox SF N PG 13 280 761 2.72 1.72 (3) Visual Representation of Data The students will generate the following graphs: 1. A Pareto chart with the most financially successful genres (based of number of films). 2. A Pareto chart with the most financially successful genres (based on total revenue generated) 3. A pie chart with the genre distribution among the 50 blockbusters. 4. A pie chart that represents the Rating breakdown of the 50 blockbusters. 5. A pie chart that represents the IP breakdown of the 50 blockbusters. 6. A time series graph that would show the distribution of blockbusters from one year to another. 7. A Pareto chart with the most financially successful studios based on total box-office returns per studio. 8. A Pareto chart with the most successful studios based on total number of blockbuster movies released. 9. A histogram that represents a frequency distribution based on budget (how many blockbusters for each $100Mil spent). 10. A histogram that represents a frequency distribution based on box-office (how many blockbusters for each $100Mil in revenue). 11. A bar chart that presents the Top 20 most successful films based on R1. 12. A bar chart that presents the Top 20 most successful films based on R2. To generate the charts, one needs to select from the table the two relevant columns to be correlated, then choose from the Charts menu the relevant chart; Excel will then generate the chart automatically. (4) Interpretation of Data Students will write a one-paragraph (minimum 6 sentences) containing an interpretation of (at least) one chart/histogram of their choice from the 12 charts they have generated. They should choose the one that they find the most revealing and significant. When exploring the data, they should focus on the insights that that particular chart reveals, and reflect on how would this particular chart affect their decisions as far as green-lighting a film, should they place themselves in the shoes of a studio executive that reviews such data.