Excel project assignment – the blockbuster statistical project

 

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

The goal of the project is to get familiarize with the process of (a) collecting and (b) organizing both quantitative and qualitative data by means of visually relevant graphic statistical tools (tables, graphs, charts, etc.) in order to facilitate a primarily descriptive statistical analysis of the “blockbuster” phenomenon within the US-based Film Industry.

 

If properly done, the study will enable you to better understand how the Big Studios leverage their risk factor to ensure financial success of their entertainment product, and hence increase their understanding of the interaction between economic and artistic factors in the world of business entertainment.

 

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

The methodology and tools acquired while completing this project could then be used to replicate similar studies in other entertainment related fields such as e-games, music, TV shows, mobile apps, etc.

 

(1) Collecting Data:

 

You 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 I-phone app Box Office Hits.

For our study, we 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:

 

You will initially 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

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

 

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

 

  1. A pie chart with the genre distribution among the 50 blockbusters.
  2. A pie chart that represents the Rating breakdown of the 50 blockbusters.
  3. A pie chart that represents the IP breakdown of the 50 blockbusters.

 

  1. A time series graph that would show the distribution of blockbusters from one year to another.

 

  1. A Pareto chart with the most financially successful studios based on total box-office returns per studio.
  2. A Pareto chart with the most successful studios based on total number of blockbuster movies released.

 

  1. A histogram that represents a frequency distribution based on budget (how many blockbusters for each $100Mil spent).
  2. A histogram that represents a frequency distribution based on box-office (how many blockbusters for each $100Mil in revenue).

 

  1. A bar chart that presents the Top 20 most successful films based on R1.
  2. 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, and then choose from the Charts menu the relevant chart; Excel will then generate the chart automatically.

 

 

(4) Interpretation of Data

 

Finally you will write a one-paragraph (minimum 6 sentences) containing an interpretation of (at least) one chart/histogram of your choice from the 12 charts they have generated. You should choose the one that you find the most revealing and significant. When exploring the data, you should also 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 you place yourself in the shoes of a studio executive that reviews such data.

 

(5) Grade breakdown

 

Collecting & Organizing Data       30 points

Visual Representation of Data       30 points (=12X2.5pts)

Interpretation of Data                    30 points

Excel Formatting & Grammar       10 points

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

It's no longer good enough to create a high-quality product at a reasonable cost.
That is why we have created 9 compelling warranties to make your usage of our service pleasant, simple, and secure.

Money-back guarantee

You must be completely confident in the quality of your products in order to provide a money-back guarantee. This is precisely how custom paper writing services work. We double-check that there are no hidden issues with this promise and that you are completely happy with the quality of your purchase.

Read more

Zero-plagiarism guarantee

Our writers do not employ others’ writing tricks, because we are aware that plagiarism may cost a lot to our clients and take away their reputation.

Read more

Free-revision policy

We want you to be satisfied with your order, so we offer a free revision policy. If you are not completely happy with your order, let us know and we will revise it for free.

Read more

Privacy policy

We care about our customers and always strive to keep their trust. That’s why Customwritingspapers.com guarantees privacy and safety of your personal information. To ensure total security, we take the following measures:

Read more

Professional Editors

Our team of editors works tirelessly to ensure that all papers meet our high standards for quality. They check for the instructions, grammar, punctuation, and spelling mistakes as well as for plagiarism.

Read more

Fair-cooperation guarantee

We would never want to jeopardize our relationship with you, and that is why we offer a fair-cooperation guarantee: If for any reason you are not satisfied with your order, you can always get your money back.

Read more

Professional Writers

We only hire the best, most qualified professionals to work on your order. Each writer is a degree holder with extensive experience in their field. You can be assured that your project will be handled by a true expert.

Read more

Quality Control

Our quality assurance department ensures that each paper is of excellent quality before it is sent to you. You can be sure that your paper will meet all of the requirements that you set. Our experts are highly skilled and will follow your specific instructions to the letter.

Read more

Customer support

We have a highly professional and qualified customer support team that is available 24/24, 365 days a year. They will be more than happy to answer any questions or concerns that you may have about our company or products. You can contact them by phone, email, or chat on our website.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Open chat
1
Order through WhatsApp!
customwritingspapers.com
Hello!
You Can Now Place your Order through WhatsApp

Order your essay today and save 30% with the discount code DISCOUNT2022