How many rentals from that state

Assignment Help Computer Engineering

Reference no: EM133369122

Question: The boss is wondering if we can stop accepting some types of credit cards because of the high fees they charge us. There is a need of a pivot table with...
• Each payment type (AmEx, etc.) on its own row.
• One column for each year of data (use Date Rental Begins, per note on page 2).
• Total rental revenue calculated in the body of the pivot table.
• Format the total revenue as follows: no dollar sign, two decimal places, and use
commas as thousands of separators.
• Rename the sheet to be: "Pivot 1 - Payment Types"

The marketing department wants to know which geographic markets provide the most customers. They'd like you to do an analysis by State (one state per row on the pivot table) that answers the following questions:

• How many rentals from that state?
• Sort the results in order of descending number of rentals (i.e. the state with the most rentals should be at the top and the fewest at the bottom).
• Rename the sheet to be: "Pivot 2 - Geographic Analysis"

Reference no: EM133369122

Questions Cloud

Encryption algorithm and deriving an encryption key : Explain the difference between breaking an encryption algorithm, deriving an encryption key, and determining the plaintext that corresponds to a given piece

How information is flowing through the proposed system : ISM 3113 University of South Florida diagram will help the programmers understand how information is flowing through the proposed system

How long would it take to crack a 64-bit key : how long would it take to crack a 64-bit key with similar hardware? This question seeks to determine whether the security of DES would have been substantially

What are present value and duration of your obligation : What are present value and duration of your obligation? What maturity zero-coupon bond would immunize your obligation? Suppose you buy a zero-coupon bond

How many rentals from that state : How many rentals from that state and Sort the results in order of descending number of rentals (i.e. the state with the most rentals should be at the top

How does ben age affect his decision to get an mba : How does Ben's age affect his decision to get an MBA? What other, perhaps nonquantifiable, factors affect Ben's decision to get an MBA?

How is the feedback disrupted by diabetes : How is the feedback disrupted by diabetes? Explain your answer by referencing the roles of pancreatic beta cells within the homeostatic pathway.

Describes the processes performed by aims : BINS 3307 University of Arkansas, Little Rock describes the processes performed by AIMS. We, as a system analyst, were asked to make the Context data flow

What strategies do you use to avoid procrastination : What are the main insights you got from this talk? What strategies do you use to avoid procrastination?

User Account

All Pages