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

2006 hess corp nyse truck and racers

26/10/2021 Client: muhammad11 Deadline: 2 Day

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:

Assignment Solver
Quick N Quality
Fatimah Syeda
Accounting & Finance Specialist
Engineering Exam Guru
Professional Accountant
Writer Writer Name Offer Chat
Assignment Solver

ONLINE

Assignment Solver

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$27 Chat With Writer
Quick N Quality

ONLINE

Quick N Quality

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$27 Chat With Writer
Fatimah Syeda

ONLINE

Fatimah Syeda

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$18 Chat With Writer
Accounting & Finance Specialist

ONLINE

Accounting & Finance Specialist

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$41 Chat With Writer
Engineering Exam Guru

ONLINE

Engineering Exam Guru

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$16 Chat With Writer
Professional Accountant

ONLINE

Professional Accountant

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$50 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

Chapter 3 rocks materials of the solid earth - Amoeba sisters natural selection worksheet - Paper on race and culture - Spirituality in nursing standing on holy ground pdf - SOFTWARE CRACKERS - Assignment 1 - Pacific northwest enterprise risk forum - Density of air at 27c - Buckley v tutty 1971 - Identify All The Underlying Causes Of Bipolar Disorder - Ucl meng computer science - Practice with Commentary - Week 3 reflective journal personal learning strategies - Baddie winkle flick of the wrist - Chunking refers to the process whereby: - Principles of underwater sound - Lit - Aginares a la polita - Lse accounting and finance - 6 steps decision making process example - Ewles and simnett model - Jim jam flim flam combo video - Http mondeca com index php en any place en - Therapeutic communication questions and answers pdf - Unit 3 Assessment - Preparing for Your Mock Interview - 1425 calories a day - Palestrina kyrie from pope marcellus mass tempo - What is a case in medisoft - Ridge buchignani ranch carignane 2017 - The flowers by alice walker theme - Engineering - Due Sunday by 1 pm - Strayer university cyber security - Every organization has its own organizational culture - What area does one gallon of paint cover - 537 SLP 4 - 2 pg Case Study "Active Shooter" - What are four bases for dna - Triangle inequality proof complex - Psychologists use different levels of analysis that offer complementary outlooks - #2 Two Discussion Responses Needed 100 words each 200 words - Pa 28 161 checklist pdf - One acre fund case study - Inversion charge in mosfet - Uber going global from day one - OP Dis -6 - Bbc schools science clips characteristics of materials - Max mara chatswood chase - Woolworths car insurance drive less pay less - Week 3 Discussion - Mark kyle webber wentzel - Golden treasure baptist academy - Ethical autobiography outline - Alison lea medical centre - The jade peony character analysis - Essay on iron man - Virtualization - John garside slim pc - Demi lovato skechers commercial - Graded assignment lab report levers and pulleys - 2.6 radians to degrees - Writing formulas from names - Ato weekly tax table 2015 - Can someone do my Week 1 & Week 2 Discussion in Principles in Managerial Accounting? - Why do technologies often improve faster than customer requirements - General solutions of trigonometric equations - Po9 1 it risk management framework - A bar of steel has the minimum properties - According to the international fisher effect - Questions on rhetoric and style letter from birmingham jail - 8 elements of music - Ferroli optimax 25s manual - Specific weight of benzene at 20 c - States of matter concept map - Training and development advisor - Nothing's changed tatamkhulu afrika - Everyday use analysis essay - Pos inbound processing engine - Hager emergency light test kit wiring diagram - The helping process assessment to termination - 88.9 kg in grams - Is the handmaid's tale a feminist book - Brown black green gold resistor - How to make a dna model with paper - La población hispanohablante (spanish-speaking population) ha aumentado. - Challenges with realising aspirations of the common good - Skin care from the makers of proactive - How to tame a wild tongue pdf - Essay - Which parts of this excerpt from edgar allan poe's "the cask of amontillado" use irony? - Literary Movements - Business valuation report template - Module 1 Lab 3: Quantum Mechanics and Rutherford Scattering - Read and respond-CH 12 - +971561686603 Abortion pills in Dubai/Abu Dhabi-mifepristone & misoprostol in DUBAI - Principles of person centred counselling - Vertices edges and faces - Ocr ict for a2 - Diverse Workforce Writing Help - Law essay