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).

FORMULAS TO BUILD:

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.