Find movie information, 1.You can find movie information

Find movie information

Assignment Help Basic Computer Science

Reference no: EM13878599

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.You can find movie information at https://www.imdb.com/chart/top
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.Title, Rating, Budget (if available), Gross (if available)
4.Turn the range of cells into a table
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.Build a column chart with movie titles as horizontal axis labels and budget/gross as data series
7.Add (or convert) rating as a secondary axis.
8.Build a bar chart based on movie gross value
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

Reference no: EM13878599

Questions Cloud

Calculate the expected return on each stock : SML Suppose you observe the following situation: Return if State Occurs State of Probability of Economy State Stock A Stock B Bust .15 − .10 − .08 Normal .60 .09 .08 Boom .25 .32 .26 a. Calculate the expected return on each stock. (Do not round inter..

The cloud service to become operational again : Over the past 3 years, a cloud service has been unavailable for a total of 36 hours, primarily due to a denial of service attacks. Additionally, the physical server hosting the cloud service crashed once. It took the cloud provider 4 days to replace ..

Describe one or two characteristics of that accounting : Do you think that it was a manual system, legacy system, or an integrated IT system? Describe one or two characteristics of that accounting information system that lead you to your conclusion.

The historical return on equity : Juggernaut Satellite Corporation earned $18 million for the fiscal year ending yesterday. The firm also paid out 30 percent of its earnings as dividends yesterday. The firm will continue to pay out 30 percent of its earnings as annual, end-of-year di..

Find movie information : 1.You can find movie information at http://www.imdb.com/chart/top2.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

Search for the terms client server and scalable : Using an Internet search engine, search for the terms client server and scalable. From the results you find, explain why client server systems are scalable.

What is the estimated value per share of boehms stock : Boehm Incorporated is expected to pay a $3.80 per share dividend at the end of this year (i.e., D1 = $3.80). The dividend is expected to grow at a constant rate of 9% a year. The required rate of return on the stock, rs, is 19%. What is the estimated..

Market is in equilibrium with the required return : Simpkins Corporation does not pay any dividends because it is expanding rapidly and needs to retain all of its earnings. However, investors expect Simpkins to begin paying dividends, with the first dividend of $1.00 coming 3 years from today. what is..

Write an application that plays guess the number : (Guess the Number) Write an application that plays "guess the number" as follows": Your program chooses the number to be guessed by selecting a random integer in the range 1 to 1000. The application displays the prompt 'Guess a number between 1 and..

User Account

All Pages