Statistics: Excel Block buster project

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:

 

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.