Statistics project due Sunday
Part 1: Collecting Data:
List the top 50 movies theatrically released in the US based on their box office success. The data is found at www.boxofficemojo.com. Use the Box Office/All Time/Domestic reports (on the left menu bar).
Part 2 Organizing data :
The students will organize the data in a 9-caption table, with the following headers:
1. Title of the movie.
2. Year the movie was released
3. Studio that produced/distributed (use 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. Rating (G, PG, PG-13, R)
6. Budget (rounded to the nearest million). For the few movies that do not list a budget, additional research might be necessary. Most of the time, a simple google search will reveal a few good estimates; use your best judgment in choosing one of them.
7. Box-Office USA (domestic revenue generated through theatrical distribution; rounded to the nearest million).
8. Simple Profitability Ratio R1 (='Box-Office'/'Budget') rounded to two decimals. This formula will reveal how much the movie made for each dollar spent to produce.
9. Simple Profitability Ratio R2 (=['Box-Office'—'Budget']/'Budget') rounded to two decimals. This formula reveals what was the return of investment for each dollar spent to produce. This formula does not take into consideration distribution fees, P&A expenses, etc. To assess the full financial profitability of a movie, one needs to use far more complicated formulas that go beyond the scope of this project.