Skip to content

5. Visualize Data Relationships

Playback Speed:
Transcript

Only one person in your group should make the graph shown in this video.

Before you begin, make sure you know which graph you are responsible for.

Ask a group member if you are unsure.

In this video, you’ll analyze the relationship between a movie budget and revenue.

If you spend more money to make a movie, will that give you a better return at the box office?

Should you spend money to make money?

It is almost difficult to get this information just from looking at the data in your spreadsheet.

You can compare the budget and revenue of individual movies, but you can not see patterns in the data.

Graphing helps you group data points and identify these patterns.

To visualize the relationship between the budgets and revenues of the movies in your data set, insert a graph.

In the Movie Data sheet, select the entire “Budget” column.

Then, hold the shift or control key, and select the Box Office Revenue column, too.

Then, select “Insert, and Chart.”

There are many ways to visualize data.

In this case, a scatterplot makes the most sense.

This chart shows the relationship between how much you spend on a movie and the amount it brings in.

In this example, Google Sheets recommends a scatterplot.

If the scatter plot does not appear, go to “Chart Types” and select it.

Next, customize your graph.

If you’d like, change the: Title Fonts Background color Or colors of your graph.

Label the horizontal axis “Budget” and the vertical axis “Box Office Revenue.”

You can also alter the size or shape of the dots to make your scatterplot easier to read.

Next, remove the legend from your graph.

A legend is useful if you are comparing different types of data on the same graph.

But here, the legend just makes the graph more difficult to read.

Your partners may be inserting their graphs at the same time.

Take a look at your graph.

Dots that are high on the graph indicate movies that made more money at the box office.

Dots to the right of the graph had bigger budgets, and therefore cost more to make.

Look at the relationship between these data points.

The movies in the upper left had smaller budgets, but made a lot of money.

These movies were very profitable.

The dots in the lower right, on the other hand, represent movies that had very large budgets, but did not make much money.

These movies were not profitable.

If you are curious about which movies these are, sort and scroll through the movie data spreadsheet to find the movie with the same budget and revenue.

To make the graph clearer, add a trendline.

A trendline helps show the pattern in the data.

Double click on the graph, and select “Series.”

Select the “trendline” checkbox.

Select the line that best represents the data in your graph.

For the most part, the points fall in a linear pattern.

Select the linear trendline.

Change the line color, opacity, or thickness to make it more legible for you and your viewers.

Now you can easily visualize the relationship between a movie’s budget and the amount of money it made at the box office.

As you can see, in general, movies with larger budgets make more money.

But you can’t budget 75 million dollars for your movie and then expect to make 250 million dollars.

Not all high-budget movies bring in high revenues.

Use the relationship between budget and box office as one part of your data analysis to help you make better decisions about which movies to produce.

When you finish, check on your partners to see if they need help creating their graphs.

When you are all ready, move on to the next video Now, it’s your turn: Select both the budget and the box office revenue columns in the movie data spreadsheet.

Insert a scatter plot chart.

Change the title, fonts, background color, or colors of the graph if you would like.

Remove the legend and make your scatterplot easy to read.

Add a linear trendline and make it legible.

Then, check on your partners to see if they need help.

When you have all finished creating your graphs move on to the next video to wrap up data visualization.

Next
Instructions
  1. Select the budget and box office revenue columns in the movie data spreadsheet.
  2. Insert a scatter plot.
  3. Change the title, fonts, background color, or colors of the graph if you'd like.
  4. Remove the legend.
  5. Add a linear trendline and format the line.
  6. Check on your partners.
  7. Move on to the next video.