***DUE ON TUESDAY APRIL 30 UNTIL 5PM**

***DUE ON TUESDAY APRIL 30 UNTIL 5PM**

I will provide the data and instructions.!!!

It’s 2017 and Da Best Flicks is a new, but well-financed movie production Company that

has a mission to be recognized in the industry as one of the top movie production

houses. To get started, their leadership team has had a small group of business

students working as interns to put together some historical information on the movie

industry. The core data files generated by the interns include the following information

is provided in a starter file for this project:

 Selected Historical Movie Data (information on 1,000 key movies produced

between 1937 and 2016 that were of interest to the management group)

 Leading Actor/Actresses – Codes and Names Table

 Movie Category/Genre – Codes and Descriptions Table

The interns got as far as they could go putting this data together. This project is now

being turned over to you, a recognized expert in using Excel for Data Analytics. You

will create and submit an Excel Workbook with the following tabs in the order listed

below.

When you open the Module 4 Project 2 File you will see the worksheet tabs listed

below. Tabs 4 and 5 are VLOOKUP tables for your project. Tab 6 is information on the

selected list of movies which requires some enhancement. And Tabs 1-3 will be key

project information and analysis you are submitting. The full list of Tabs is as follows:

1 – Genre Analysis

2 – Leading Actor Analysis

3 – Answer Sheet (Other Questions)

4 – Actor Code Table (provided)

5 – Category/Genre Code Table (provided)

6 – Selected Movie Data (provided)

Step 1 – Data Preparation for Analysis

1. Review the Selected Movie Data (Tab 6) and the reference Tables provided in

Tabs 5-6.

2. As a key step in data acquisition, update sheet number 6 with additional data

that could be useful to your analysis: