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

Lisa bonet age difference age husband tina turner jason momoa

11/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.
10pts

Basic Project Requirements (Read This)

Basic Requirements:

· The file(s) submitted must be the appropriate file type

· .XLSX (Excel)

· .PBIX (Power BI)

· etc

· Keep the raw data untouched (unless specifically told to modify).

· Any new columns should be added after the last column in the existing data set (that way if new data is appended, the existing formulas can be copied and pasted in the following rows).

· Make sure you keep your analysis and data separate so as new data is added you don't have to redo all of your analysis work (pivots would have to be refreshed, of course).

· All analysis, unless otherwise stated, should be easily repeatable and data updates should not impact the analysis. Meaning, if you refresh or update the data source, does that break all of your equations? It shouldn't. Points will be deducted if the equations are not flexible enough to handle a data update or refresh (as data updates will occur often in analysis projects).

· Ask if you have questions about this.

· Make sure you have read and understood this page: Week 2 - Keeping Data Separate from Analysis

· Make sure to number the solutions like: Part A #1, Part B #2 so that I can clearly see how each problem is answered

· Make sure to leave the formulas within the cell that provides the answer so that I can "see" your work.

· Full credit cannot be given for just answers without the ability to see the equation at work

· Make sure the appropriate files (Excel, Power BI, etc) have been uploaded for every project as appropriate so that I can see your work.

· The work you submit must be your own

· 0 credit will be earned if the work submitted is not your own

· If any outside sources are used in references to these questions, be sure to provide a proper citation and URL

· Submit your file and make sure to follow this naming convention: projectOne_LastName_FirstName.xlxs

· (e.g. projectOne_Smith_John.xlsx)

· Since there are multiple ways to accomplish goals in Excel, make sure that you are using the learning modules within the course to answer and solve these problems. To ensure full credit, you need to demonstrate that you're using the elements taught in the learning modules. Let me know if you have any questions about this.

· Again, make sure you've read this page on Flexible Equations: Week 2 - Keeping Data Separate from Analysis

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:

Finance Professor
Write My Coursework
Top Writing Guru
Top Academic Tutor
Professional Accountant
Chartered Accountant
Writer Writer Name Offer Chat
Finance Professor

ONLINE

Finance Professor

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.

$35 Chat With Writer
Write My Coursework

ONLINE

Write My Coursework

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.

$30 Chat With Writer
Top Writing Guru

ONLINE

Top Writing Guru

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

$28 Chat With Writer
Top Academic Tutor

ONLINE

Top Academic Tutor

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.

$16 Chat With Writer
Professional Accountant

ONLINE

Professional Accountant

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.

$38 Chat With Writer
Chartered Accountant

ONLINE

Chartered Accountant

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.

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

Strategic information systems planning example - Butl_ Learnign Feamework - Business process standardization and integration - Pacific scientific cmm 26 20 202 - Balanced chemical equation for zinc and copper ii sulfate - Amc backstage associate self service - Random number generator iwb - Https tmidm uspto gov id master list public html - What best describes the rightness or wrongness of plagiarism - What is prs in younique - Basic beryllium acetate structure - Print network diagram ms project - Awesome god proclaim chords - Christina's bed and breakfast saco maine - Australiancurriculum edu au science - Appointment in samarra short story summary - Sine and cosine graph word problems - High country inc produces and sells many recreational products - Laureate online education amsterdam - Marxist literary criticism ppt - Whs questions and answers - Wh questions in past - White goods replacement scheme - EMAN - John george psychiatric pavilion - Business partnership proposal email - Is it Right to be a Relativist? - On her loving two equally rhyme scheme - Stand a bottle carnival game - Does mythica from skin wars have cancer - The book thief conflict quotes - You are going to be assessed for: Your skills and knowledge using written and observation activities that apply to the workplace. Your ability to apply your learning. - Information Governance - Do all federal court opinions have parallel cites - Assignment (Paper 2) - Nursing care plan for self mutilation - Anne sexton snow white analysis - Week 1 project - Wk 10 ethics discussion with student response - University of essex student satisfaction survey - Characters in twelfth night - Discovering qualitative methods ethnography interviews documents and images - Cinderella and the two ugly sisters - Australian curriculum visual art - Carolina windom 40 plus - Bus 475 week 3 individual assignment - What is the paradox of hedging balance sheet exposure - Size constancy muller lyer illusion - Monash exam timetable release date - Black spot on crucifix orchids - One sp hybridized carbon and two sp hybridized carbons - Nestle ice cream in cuba case study - Disney consumer products competitors - 3820 mod 2 - Harvard business school global supply chain management simulation answers - 100 best road trip songs - How do humans affect the biosphere - Risk management dashboard examples - Domino's case study ppt - Clinical development plan example - Berliner luft drink australia - The song of the wreck charles dickens analysis - Using excel solver to maximize profits - 1 quiz 1 short essay - Wk 6 forum 1 Brittney - Informative speech dream interpretation outline - Intel Annual Report Evaluation - Basic advice on first aid at work government leaflet - Using grignard reagent to make alcohol - Beats by dre swot analysis - Is oreo a proper noun - Assignment - The glass castle test answers - Public health - Why is foopets not free anymore - 735 Wk 11 DQ 1 - Marina square wentworth point - Magnesium reacts with silver nitrate solution - Managerial Epidemiology Week 4 Discussion - Need out line and complete - Fiddlers lane primary school - Discussion - Biology WEEK 5 DISCUSSION - Height in visual field psychology - Sections 55 of the estate agents act 1980 - Jane yolen america's cinderella - Xchg instruction in 8085 - List of airbus a380 orders and deliveries - Unintended consequences essay - Leader vs Manager - Glasgow royal infirmary consultants - Act 5 scene 9 macbeth summary - Econ 214 exam 2 - Answer all questions that apply to the quantitative and/or qualitative study that you selected. Include a title page and article citation (APA format) on the title page. - The chrysalids chapter 3 - Calculate the ph of the following aqueous solution - Business Report - Ism suffix medical terminology - Practical strategies for technical communication 2013 pdf - Insights Into Criminal Behavior