How many movies had the smallest count of four

Assignment Help Basic Computer Science

Reference no: EM131905216

Excel Assignment

This assignment demonstrates that the student can use the spreadsheet to analyze and organize data (make sure you save this sheet after each bullet).

Using the provided excel spreadsheet, apply the following by performing each bullet.

1. Using the pivot table sheet - create the table below the output from #1 - you want to group by region and show the sum of the # orders and total sales - the grand totals are 2490 and 613874

2. On the what-if sheet, create the following Mortgage Calculator using the following data cells

a. Loan Amount:160000

b. Term: 30

c. Int rate: 2.50

d. Calculate payment using the IFERROR function. PMT function in the true part and 0 in the false part.

e. Calculate the total paid using the IFERROR function with the total paid in the true part and 0 in the false part.

f. Create your what-if table below the above data with the following columns provided:

i. Interest Rate - fill with the data .025 through .075
ii. Monthly Payment
iii. Total Payments
iv. Total Interest

g. Using the appropriate data, fill what you need in the what-if data and then setup the what-if analysis properties. To check your work, the ending total interest paid for .075 should be 277919.28 (or close).

h. When you change the Loan Amount, the table should reflect the change.

3. Using the Goal function in the "what-if" scenario, what would you have to put in savings to accommodate your income of 5670 (1353 is the answer).

4. Open the "filter" sheet.

a. Using the Filter, which movie had the opening theater count between 4500 and 5000 - 1 movie and type your answer in "answer sheet"
b. How many movies had the smallest count of 4?
c. Which movie had the highest dollar amount in both domestic and weekend?
d. Using the advanced filter, how many movies can sit over 4300?

Attachment:- Assignment-Starter-File.rar

Reference no: EM131905216

Questions Cloud

Explain what operations can be performed on a stack : What exactly is a stack and explain what operations can be performed on a stack? Exactly how is a stack implemented using the program stack1.java?

Write the constructor accessor mutator and tostring methods : Write a client class to test creating Trivia objects. Write the constructor, accessor, mutator and toString methods.

How is the sales budget prepared : Why is its accuracy so important? Consider this in the context of the rest of master budget schedules and provide some substantive comments.

Determine dividend equivalency : A redemption is treated as payment in exchange for the shareholder's stock when it is not essentially equivalent to a dividend.

How many movies had the smallest count of four : How many movies had the smallest count of 4? Which movie had the highest dollar amount in both domestic and weekend?

What is the probability the sum is even or exactly divisibl : What is the probability the sum is less than 4 or greater than 9 (decimal 2places) and what are the odds? (Fraction)

Calculate the projected net income : A proposed new investment has projected sales of $840,000. Variable costs are 55 percent of sales, and fixed costs are $173,000;

What is the cost of preferred stock capital for ford : Preferred stock of Ford Motors pays a dividend of $5 each year and trades at a price of $30. What is the cost of preferred stock capital for Ford?

How much data is in the first segment : How much data is in the first segment? In the acknowledgement that Host B sends back to Host A, what will be the acknowledgement number?

User Account

All Pages