Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

The morgues song for kirsten dunst

17/11/2021 Client: muhammad11 Deadline: 2 Day

Make sure you've read and understand these pages:

Basic Project Requirements (Read This)
Week 2 - Keeping Data Separate from Analysis

Project Instructions:

This project is focused on wrangling and analyzing data using pivot tables and complex formulas.

This project uses data that was scraped from IMDB websites. The original data set was downloaded early 2017 from: https://www.kaggle.com/deepmatrix/imdb-5000-movie-dataset (Links to an external site.)Links to an external site..

Download the dataset for this project here: movie_metadata.csvPreview the documentView in a new window and load the file into Excel to get started. Remember, the submission must be in .xlsx format (Excel).

Part A Wrangle:

1. Scroll to "Movie_IMDB_Link" Column in the dataset. That column contains a URL string that we want to extract a specific variable from. Specifically we want to extract a specific range of characters (letters and numbers) that looks like "tt0499549" from every URL string. This is going to be a unique identifier for the table (primary key).
Each row can then be identified by this field.

Create a formula learned in class to extract the primary key from the "Movie_IMDB_Link" column into a new column (call that new column Primary Key and make it the first column dataset). Leave the "Movie_IMDB_Link" column untouched. Create a named range for the new column called "PrimaryKey". Make sure you leave the formula that you created intact so that I can see your process.
10pts

2. Format the table as a table. Create named ranges for these columns: Director, Country, Gross (Gross Revenue), Budget and Title Year.
5pts

3. Copy and paste the new primary key column and the genres column into a new worksheet (call it the genre worksheet). Use an Excel feature to give each genre it's own column: label the columns Genre1, Genre2, etc. Create a function that counts the number of movies that are described with at least 3 genres.
5pts

So if you have a single cell that has "Action, Comedy, Romance" it should now be:

Action | Comedy | Romance

Where | represents a new column.

4. Modify the movie_title column and remove the unique character that exists in the cell values.
5pts

5. Format the budget column in U.S. Dollars. Create a conditional formatting on the budget column. Use the best conditional formatting that shows the differences between the amounts in each cell.
5pts.
5a. Scroll through the dataset, what do you notice? Is formatting the column as dollars an appropriate choice, why or why not? Explain.
5pts

Part B Analysis:

Q. Which countries produced the most number of movies?
6. Create another worksheet called "Countries". Copy and paste a distinct listing of countries from the raw data. Use a formula learned in class to count the total number of movies made by the particular country, make sure to use the appropriate named range in your equation. Create another column called "Ranking by Count" and use a function learned in class to rank the countries by their respective count. Which Countries were in the top 5 based on quantity of movies produced?
10pts

Note: Do not use pivot tables.

Q. Which countries had the largest gross revenue and biggest movie budgets?
7. In the same Countries worksheet, use another formula learned in class to bring in the Total Gross Revenues and Total Budgets of all movies by country. Again make sure to use the appropriate named range in your equation. Create two additional columns called "Ranking by Gross Revenue" and "Ranking by Total Budget" and use a function learned in class to rank the countries by each measure respectively. Does the countries in your top 5 change from the total revenue versus the budget total?
10pts

7a. Describe the issue that is present in number 7 and describe how you would go about solving it.
5pts

Note: Do not use pivot tables.

Q. How many movies was each actor in?
8. In a new worksheet called "Actors", create an unduplicated listing of all actors (from columns actor_1_name, actor_2_name, actor_3_name) in 1 column. Sort the column from A-Z. Use a function learned in class to count the total number of movies each actor appears in (regardless of whether they are in column they are in).
10pts

8a.Create a new column called "Flag" and write an equation that "Flags" the actor if they appeared in more than 25 films. Filter the table by this "flag". Create another function learned in class to count the number of actors who appeared in 30 movies or more.
10pts

Note: Do not use pivot tables.

Q. How many movies did each director make by year within the US?
9. Use the pivot table feature in Excel to help you answer this problem.

In a new worksheet called "Directors", create your pivot and filter it by: Year >= 2010 and Country = USA. Include the director_name as your first column and additional column names for each of the years from 2010 - 2015. Next bring in the Primary Key field (that you created in Step 1) as your value to be counted for each director in each year respectively. Create a Total column and Total row to sum the data accordingly.
10pts

Note: Do not use equations.

10. Create your own analysis with the data. Clearly describe the problem/question that you're trying to address, show your work, and explain the answer that you derived at. And make sure the analysis is complex. It should not be something as simple as "the total number of movies in the dataset" or even the "total number of movies by year". Make sure your analysis is more interesting and complicated than that. And make sure it's not similar to one of the other problems in this project.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Study Master
Finance Master
Ideas & Innovations
Helping Engineer
Phd Writer
Professional Accountant
Writer Writer Name Offer Chat
Study Master

ONLINE

Study Master

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$23 Chat With Writer
Finance Master

ONLINE

Finance Master

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$37 Chat With Writer
Ideas & Innovations

ONLINE

Ideas & Innovations

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$38 Chat With Writer
Helping Engineer

ONLINE

Helping Engineer

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$15 Chat With Writer
Phd Writer

ONLINE

Phd Writer

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$26 Chat With Writer
Professional Accountant

ONLINE

Professional Accountant

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$34 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Off task behavior checklist - &LOVE% Marriage +91-7023339183 Problems solution MOLviji - SLP4: The Marketing Plan - New touchstone ( CORRECTION PAPER) - Dun and bradstreet industry average ratios - Barangays of catarman northern samar - Sheknives face reveal - Creativity the work and lives of 91 eminent people - Which of the following best describes relationship conflict - How immigrants become other marcelo m suarez - Ethical Relativism - Don sabo pigskin patriarchy and pain - Is booklocker worth it - Mcphersons chemist broughty ferry - High frequency response of bjt - Comedy as a literary genre can be defined as - Musical fountain in china with audio of bhagavad gita - Bunurong marine national park - Live wire hot rod shop follows the revenue recognition principle - Leddy and pepper's professional nursing - Epa Answer - Northern bay college abn - +91-8890675453 love marriage problem solution IN Tumkur - Web design course outline - After the accounts have been adjusted at april 30 - Muslim Molvi 7340613399 OnLine No 1 FaMOUs VashIKaraN sPecIaLIsT IN Berhampur - Lab - Environmental sciences - Cambridge igcse chemistry 4th edition - War is where the young and stupid are tricked - How does atar scaling work wace - Articles of confederation constitution compare contrast - Essay with sources - Dell xps 8500 motherboard sata ports - 14759 pearl rd strongsville oh 44136 - Hartford research issues bonds dated january 1 - Homo sapiens book pdf - Small business dilemma case study - Cardiff university extenuating circumstances - Rough Draft I ... - Romeo and juliet tattoo - Think safe work safe home safe - Average gamer reaction time - Http www sumanasinc com webcontent animations content pcr html - Nur340vulnerable populationchoice - Health problem analysis worksheet - According to the gate control theory of pain - Aluminium window infill panels - Does burkes outlet drug test - 93 waldegrave crescent vincentia - Bite fingernails psychology - Vocabulary - M edge bluetooth keyboard - Cisco rps 2300 eol - Hershey kisses target market - What did mrs margarine think about her sister's husband - Work level standards aps 4 - Marketing ethics product safety and pricing - Critical Thinking Paper for Master Data Collections - Cavalier king charles breeders victoria - A thousand splendid suns sparknotes - Purpose of a bed stick - Su cámara digital adjetivo la cámara digital suya pronombre la suya - Troy ecampus blackboard - Evidence-Based Project, Part 4: Critical Appraisal of Research - What is cricos registration - Problems with modern portfolio theory - Which clinical initiatives require informatics to be optimally effective - Experimental determination of absolute zero - Entertainment speech examples pdf - The dulac box plant produces 500 - Freewriting is a tool used to _____ - Youtube llc going global by acting local case study - Four seasons hotel financial statements - Flexsim help - Cdc distracted driving study tradução do texto - Network management system definition - Enzymatic browning of apples experiment - How many gallons of gas for 600 miles - Sociobiography - What is business law ppt - Stop nessus service windows - Prepare a 10 column worksheet - A chemist finds that 30.82 g of nitrogen - Ifsm 300 quiz 5 - Aspergers and intimate relationships - Raew - Qbo intuit com redir testdrive - Non inverting amplifier gain formula - Twitter Hack - Netapp fas2020 power consumption - Amul recruitment written test - Group therapy a live demonstration - Is magnesium oxide amphoteric - Portfolio Assignment: The Role of the Nurse Informaticist in Systems Development and Implementation,NURS 5051/NURS 6051: Transforming Nursing and Healthcare Through Technology - Traditional Chinese - Agenda Setting - Jp morgan swot analysis 2015 - Scott road medical centre selby - Lf meaning in construction