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

Melissa theuriau miss france 2000

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

Excel Data

Project Make sure you’ve read and understand these pages:Project Instructions:This project

Make sure you’ve read and understand these pages: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.csv 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. 5pts3. 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. 5ptsSo if you have a single cell that has Action Comedy Romance it should now be:Action | Comedy | RomanceWhere | 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. 10pts

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:

Math Guru
Ideas & Innovations
Academic Mentor
Write My Coursework
Assignment Guru
Professional Coursework Help
Writer Writer Name Offer Chat
Math Guru

ONLINE

Math Guru

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$24 Chat With Writer
Ideas & Innovations

ONLINE

Ideas & Innovations

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.

$20 Chat With Writer
Academic Mentor

ONLINE

Academic Mentor

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.

$27 Chat With Writer
Write My Coursework

ONLINE

Write My Coursework

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$33 Chat With Writer
Assignment Guru

ONLINE

Assignment Guru

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$44 Chat With Writer
Professional Coursework Help

ONLINE

Professional Coursework Help

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.

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

Analysis and Evaluation of Frameworks and Theories - Justin robinson and the mary onettes - Homer tomorrow when the war began essay - Escucha la conversación y completa las oraciones - Leo marx the machine in the garden summary - Transistor as an amplifier animation - Calabash caye field station - H2s04 acid or base - Was steve jobs an ethical leader - Hypothesis Testing - MKTG201 Week 2 Discussion - Pedagogy of the oppressed chapter 1 discussion questions - To determine if the type of agar affects bacterial growth - Martinez company's relevant range of production - Why is the sea blue - Solution of heat equation by separation of variables - Making pronouns and antecedents agree - An Organization’s Story and Change Lessons week 2 mgmt - Generally the least expensive source of long-term capital is - Delinquency crime and differential association - Lord of the flies ralph age - Specific purpose statement for informative speech example - Does texting affect writing michaela cullington summary - Coso internal control integrated framework 2013 ppt - Anthropology1 Discussion Forum - Math homework help linear equations - Passport to leisure bradford - What are supply chain drivers - Aem boost gauge 30 4406 install - ACCOUNTING - Graduate Assistance - Point of view worksheet answers - Dr sean tan crows nest - Herbert stern trying cases to win pdf - Pick one of Fingarette's main arguments. How convincing do you find it? Make specific reference to at least two different passages from the Analects to support your assessment. - Airbag lab baking soda and vinegar - Importance of consumer behaviour ppt - What is the relative fitness of a sterile mule - Components of just in time system - Chemistry year 7 quiz - Assignment self awareness and conflict resolution - Wk7 DQ - Data Analysis & Business Intelligence - Commission for independent education - Why is radioactive decay so predictable - Kanopy - Facebook whatsapp acquisition case study - Technology trends proposal part l - Discussion Questions - Windows 7 pinyin input - CM ASSG 3 - Fish 4 ever tuna coles - Open ended addition problems - The medical assistant realizes information was documented inaccurately - Dr joseph john cmc ludhiana - Ieee 488 to usb converter - Business - Where does toms shoes donate to - Conveyor belt project part 3b answers - A group of college students built a self guided rover - Engl 102 test 2 answers - Practice note sc cl 3 - The wanderer translated by charles w kennedy - Who was duke ellington's composing partner - Trevor off key i love my light - Nsw teachers parental leave - Ccna exam code 200 125 - Damaged care laura dern - Science teddy bear - Gino severini blue dancer - Anne frank compare and contrast - Woolworths third party insurance - Negotiation preparation worksheet - A summer's reading bernard malamud - Part 1, 2, and 5 - S2 magic monitor download - Fraud Examination - Mercantile credit co v garrod - Database systems is considering expansion into a new product line - Boston scientific gold probe electrical connector - Static and kinetic friction lab report answers - A fairly subtle approach to advertising is _____. - Write a two page summary and analysis on chapters 1-3 (six pages total) on Raising the States : E-Sports and the Professionalization of Computer Gaming book - Discussion about shared security responsibility model - DrRacket programming - Wzzm13 on your sidelines scores - Lln specialist - Which activities at dirt bikes create the most value - My lady's presence makes the roses red summary - Knowlege check - Dunn's auto sales picayune ms - Chem 5 june 2015 - All horses are the same color - Evaluate Part of an Organizational Improvement Plan - The correct order of presentation in a classified balance sheet - Lumberjack st 2000 15 deg staking tool - Emerald city wizard of oz characters - Intervention Planning - Ato postal address albury nsw - Analyze Walmart DUE 2 Nov 2020 by 1pm eastern time zone - 377 common idioms and their meanings