USA: +1(669)289-8683 
Sign in
Excel Graph Homework
Visual Representation of Data
Please if possible include excel formulas and instructions so i can better understand how to make the graphs.
Please make sure graphs represent all the information required. (sorry but the other answer i purchased was incorrect)
You will generate the following graphs:
- A Pareto chart with the most financially successful genres (based of number of films).
- A Pareto chart with the most financially successful genres (based on total revenue generated)
- A pie chart with the genre distribution among the 50 blockbusters.
- A pie chart that represents the Rating breakdown of the 50 blockbusters.
- A pie chart that represents the IP breakdown of the 50 blockbusters.
- A time series graph that would show the distribution of blockbusters from one year to another.
- A Pareto chart with the most financially successful studios based on total box-office returns per studio.
- A Pareto chart with the most successful studios based on total number of blockbuster movies released.
- A histogram that represents a frequency distribution based on budget (how many blockbusters for each $100Mil spent).
- A histogram that represents a frequency distribution based on box-office (how many blockbusters for each $100Mil in revenue).
- A bar chart that presents the Top 20 most successful films based on R1.
- 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.
>Sheet ear
enre
ating
0
ox
-1 1
97
N Y 200 AA N PG-13 SF N PG 5
Fox SF N PG 11 7
.91
.91
WB AA Y PG-13 0
8
A Y PG 0
AA N PG 11 . .55
BV AA N PG-13 5
3
$1.88 BV A N G 423 BV A N G 200 3
BV AA Y PG-13 200 unger Games
2012 AA Y PG-13 AA Y PG-13 Uni. SF Y PG-13 : Revenge of the Fallen
SF N PG-13 200 402 $2.01 WB F Y PG-13 $2.05 BV A N G 94 381 $3.05 Fox SF N PG-13 2003 F Y PG-13 94 8
2004 Sony AA Y PG-13 200 2004 D N R 30 2013 Uni. A N PG 2011 P/DW SF N PG-13 2002 NL F Y PG-13 94 3
Sony AA Y PG-13 2010 BV AA Y PG 200 1994 Par. D Y PG-13 55 2007 P/DW A Y PG 3
Par. AA Y PG-13 WB F Y PG 125 318 2008 Par. AA Y PG-13 2001 NL F Y PG-13 93 2010 Par. AA Y PG-13 200 2002 Fox SF N PG 2007 BV AA N PG-13 Fox SF N PG 33 309 Fox SF N PG-13 75 2003 BV AA N PG-13 140 2012 Sony AA N PG-13 200 2012 WB F Y PG-13 2009 WB F Y PG 2010 D N PG-13 68 2009 Sum. D N PG-13 50 2010 WB F Y PG-13 1999 BV H N PG-13 40 2009 BV A N PG $1.67 $0.67 2010 WB SF N PG-13 160 293 1
#
Title
Y
Studio
G
IP
R
Budget
BO US
A
R1
R2
1
Avatar
20
9
F
SF
N
PG
3
23
7
7
6
$3.
21
$2.21
2
Titanic
19
Par.
D
PG-
13
200
601
$3.01
$2.01
3
Marvel’s The Avengers
20
12
BV
AA
PG-13
623
$3.12
$2.12
4
The Dark Knight
200
8
WB
18
5
5
33
$2.88
$1.88
5
Star Wars: Episode I – The Phantom Menace
1999
Fox
11
4
31
$3.
75
$2.75
6
Star Wars
1977
30
$
27
$
26
7
The Dark Knight Rises
2012
25
44
$1.79
$0.79
8
Shrek 2
2004
DW
15
4
41
$2.
94
$1.94
9
E.T.: The Extra-Terrestrial
1982
Uni.
4
35
$
39
55
$
38
10
Pirates of the Caribbean: Dead Man’s Chest
2006
22
42
$0.88
11
The Lion King
1994
45
$9.
40
$8.40
12
Toy Story 3
2010
415
$2.08
$1.08
13
Iron Man
2013
409
$2.05
$1.05
14
The
H
LGF
78
408
$5.23
$4.23
15
Spider-Man
2002
Sony
139
404
$2.91
$1.91
16
Jurassic Park
19
93
63
402
$6.38
$5.38
17
Transformers
2009
P/DW
$1.01
18
Harry Potter and the Deathly Hallows Part 2
2011
125
381
$3.05
19
Finding Nemo
2003
$4.05
20
Star Wars: Episode III – Revenge of the Sith
2005
113
380
$3.
36
$2.36
21
The Lord of the Rings: The Return of the King
NL
37
$4.02
$3.02
22
Spider-Man 2
374
$1.87
$0.87
23
The Passion of the Christ
NM
371
$12.37
$11.37
24
Despicable Me 2
76
366
$4.82
$3.82
25
Transformers: Dark of the Moon
195
352
$1.81
$0.81
26
The Lord of the Rings: The Two Towers
34
$3.65
$2.65
27
Spider-Man 3
2007
258
337
$1.31
$0.31
28
Alice in Wonderland (2010)
334
$1.67
$0.67
29
Forrest Gump
330
$6.00
$5.00
30
Shrek the Third
160
32
$2.02
$1.02
31 Transformers 2007 P/DW SF N PG-13
1
50
319
$2.13
$1.13
32 Iron Man
2008
140
318
$2.27
$1.27
33
Harry Potter and the Sorcerer’s Stone
2001
$2.54
$1.54
34
Indiana Jones and the Kingdom of the Crystal Skull
185
317
$1.71
$0.71
35
The Lord of the Rings: The Fellowship of the Ring
316
$3.40
$2.40
36
Iron Man 2
312
$1.56
$0.56
37
Star Wars: Episode II – Attack of the Clones
115
311
$2.70
$1.70
38
Pirates of the Caribbean: At World’s End
300
309
$1.03
$0.03
39
Return of the Jedi
1983
$9.36
$8.36
40
Independence Day
1996
306
$4.08
$3.08
41
Pirates of the Caribbean: The Curse of the Black Pearl
305
$2.18
$1.18
42
Skyfall
304
$1.52
$0.52
43
The Hobbit: An Unexpected Journey
180
303
$1.
68
$0.68
44
Harry Potter and the Half-Blood Prince
250
302
$1.21
$0.21
45
The Twilight Saga: Eclipse
Sum.
301
$4.43
$3.43
46
The Twilight Saga: New Moon
297
$5.94
$4.94
47
Harry Potter and the Deathly Hallows Part 1
242
296
$1.22
$0.22
48
The Sixth Sense
294
$7.35
$6.35
49
Up
175
293
50
Inception
$1.83
$0.83
