Data Exercise 2

Data Exercise 3

Download this document to your computer and please read all directions carefully. This exercise is worth 15 points.

Please download the dataset at this link . This dataset consists of tv shows and movies available on Netflix as of 2019. Source: Kaggle

Using these data, please reproduce the following data visualizations (5 points each). Pay attention to the colors, formats and legends in each.

1. Using the netflix_titles worksheet:

· Compute the total titles that are movies

· Compute the total number of titles that are TV shows

· Create a pie chart showing the breakdown of titles by type

· Add a chart element to display the percentage of titles of each type

2. Using the netflix_titles worksheet:

· Compute the number of releases by release year

· Create a 2-D line chart showing the number of releases by year from 2010-2020

· Pay attention to font colors and line styles

3. Using netflix_titles worksheet:

· Using UNIQUE, generate a list of unique rating types in Column G

· Using COUNTIF, count the number of titles by rating type

· Using COUNTIFS, count the number of titles by rating of each type (TV Show & Movies)

· Create a stacked bar chart showing titles by rating type broken down into TV Shows & Movies

Turn in

At the completion of the exercise, please turn in the following:

· Excel workbook with original data and calculations

· Word document data visualizations pasted into the document