Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Computer Engineering Expert

If you could take a look at this please? I have up to number 5 done but am stuck on the rest.

Project: Advanced Spreadsheet ProcessingDescription

  1. 1.You can find movie information at http://www.imdb.com/chart/top
  2. 2.Create a new MS Excel spreadsheet and enter the following information about ten movies of the last decade (2003-2012) with the highest IMDB rating:
  3. 3.Title, Rating, Budget (if available), Gross (if available)
  4. 4.Turn the range of cells into a table
  5. 5.Add a new column "Success". Use logical "IF" formula to fill cells in that column. A movie is successful if its Gross to Budget ratio is greater than 2.
  6. 6.Build a column chart with movie titles as horizontal axis labels and budget/gross as data series
  7. 7.Add (or convert) rating as a secondary axis.
  8. 8.Build a bar chart based on movie gross value
  9. 9.Change bar chart style to the one with colored background. 

Requirements

  • Table with the highest rated movies of the last decade
  • Four specified columns in the table
  • Column chart with budget and gross as primary axis
  • Movie rating as a secondary axis on the same chart
  • Movie rating is a line chart
  • Bar chart for movie gross value only
  • Bar chart style with background


Attachment:- Copy of week 5 movie project.xlsx

Computer Engineering, Engineering

  • Category:- Computer Engineering
  • Reference No.:- M91547115
  • Price:- $30

Guranteed 24 Hours Delivery, In Price:- $30

Have any Question?


Related Questions in Computer Engineering

Stuck in the mud is a popular dice game in uk the game uses

Stuck in the mud is a popular dice game in UK. The game uses five (5) 6-sided dice to play. The players play in turns. Choose one player to start the game. The player will roll all five (5) dice. If the player rolled any ...

Question suppose the array begins with 0 followed by the

Question : Suppose the array begins with 0, followed by the remaining even integers in descending order, followed by the odd numbers in descending order. (For n = 8, the array would be [0,8,6,4,2,7,5,3,1].) How many comp ...

Describe a ping of death attack as an attack that causes

Describe a ping of death attack as an attack that causes the victim computer to freeze and malfunction.

Assignmentyou have been requested to develop a healthcare

Assignment You have been requested to develop a healthcare system with the following characteristics: A hospital plans to build a healthcare system, which manages patient information. A hospital has a CEO, 5 doctors, 5 n ...

Suppose that the wall street journal reports that we are

Suppose that the Wall Street Journal reports that we are headed for a recession. You are the manager of a firm that produces Starcho Lunch. Your marketing research people tell you that the demand for your product is give ...

In reconnaissance provide three different methods or means

In Reconnaissance Provide three different methods or means to locate information about your target. What sorts of information would you expect to obtain using each source? What might you use the information obtained from ...

A new machine averages 4 clock cycles per instruction and

A new machine averages 4 clock cycles per instruction, and runs at a system clock of 20 MHz. The Axiom-Verge algorithm set to benchmark the system will take an even 3000 instructions to complete. a) Knowing how many cloc ...

Sorted golf scores - need flowchartdesign a program that

Sorted Golf Scores - need flowchart Design a program that asks the user to enter 10 golf scores. The scores should be stored in an Integer array. Sort the array in ascending order and display its contents. Looking for "" ...

Elm industries receives profits from polluting according to

Elm Industries receives profits from polluting according to the formula: (pi=10Q-Q^2) The Damages associated with pollution from this facility are estimated to be: (D=Q^2+2Q) (Q= pollution emitted in tons) , and profits ...

Heights of women follow a normal distribution with

Heights of women follow a normal distribution with mean μ=63.6 inches and standard deviation of σ=2.5 inches.  Suppose random samples of 10 women are chosen and their mean height calculated. Please calculate the mean and ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As