Use PivotTables to find the number of sales transactions by product and region, total amount of revenue
Question:
Use PivotTables to find the number of sales transactions by product and region, total amount of revenue by region, and total revenue by region and product in the Sales Transactions database.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 69% (13 reviews)
Sales Transactions July 14 Cust ID Region Transaction Code Amount Product 10001 East 93816545 2019 DVD 10002 West 74083490 1785 DVD 10003 North 64942368 2398 DVD 10004 West 70560957 2351 Book 10005 So...View the full answer
Answered By
Zubair Ahmed
I am pursuing chartered Accountancy from ICAI. I have completed my graduation in commerce from SOL. I am CA-Final Student. I choose CA because it provides me a practical exposure in finance and taxation which helps in teaching with point of practical aspect. I just don't teach how to prepare financial statements. I have practically prepared various financial statements of various entities of different industries. For me knowledge is not just around text book, it is around the practical scenarios you have.
0.00
0 Reviews
10+ Question Solved
Related Book For
Business Analytics Methods Models and Decisions
ISBN: 978-0321997821
2nd edition
Authors: James R. Evans
Question Posted:
Students also viewed these Business Communication questions
-
Use PivotTables to find the number of loans by different purposes, marital status, and credit risk in the Excel file Credit Risk Data. Illustrate the results on a PivotChart.
-
In the Excel file Cell Phone Survey, use PivotTables to find the average for each of the numerical variables for different cell phone carriers and gender of respondents.
-
The Excel file Cell Phone Survey reports opinions of a sample of consumers regarding the signal strength, value for the dollar, and customer service for their cell phone carriers. Use PivotTables to...
-
What (if anything) is wrong with each of the following statements? a. if (a > b) then c = 0; b. if a > b { c = 0; } c. if (a > b) c = 0; d. if (a > b) c = 0 else b = 0;
-
Turn to Figure and find the S& P 60 future. a. Suppose you buy one contract for March delivery. If the contract closes in March at a price of 720, what will your profit be? b. How many March...
-
Burnard (1992) sent a questionnaire to a stratified sample of nursing tutors and students in Wales, to study what the tutors and students understood by the term experiential learning. The population...
-
Suppose there are only 3 rating categories: A, B, D. Their one-year transition probabilities are given by the following matrix. Construct the transition probability matrix for two years. Ending...
-
Pearson Company owns 90% of the outstanding common stock of Spring Company. On January 1, 2011, Spring Company sold equipment to Pearson Company for $200,000. Spring Company had purchased the...
-
Find the sum of the geometric series, if possible. 9 1)5(2)" n=1 34 8 T 2) n=
-
A frictionless piston maintains a constant pressure of 120 kPa as 0.6 kg of air is being heated in a cylinder. Estimate the work and the heat transfer required if the initial temperature of the air...
-
Create a PivotTable to find the average amount of travel expenses for each sales representative in the Excel file Travel Expenses. Illustrate your results with a PivotChart.
-
Create a PivotTable for the data in the Excel file Weddings to analyze the wedding cost by type of payor and value rating. What conclusions do you reach?
-
Which of the following is not a source of information from which the IRS identifies possible audit targets? a. A computer scoring system that identifies possible errors on tax returns b. The client...
-
What is catering theory, and how does it impact a firms dividend policy?
-
Define (1) information content and (2) the clientele effect, and explain how they affect dividend policy.
-
What is credit quality, and how is it assessed?
-
How can the yield to maturity on a firms outstanding debt be used to estimate its before-tax cost of debt?
-
Why might other investors prefer low-dividend-paying stocks?
-
Give foci and corresponding directrices of ellipses centered at the origin of the xy-plane. In each case, use the dimensions in Figure 11.47 to find the eccentricity of the ellipse. Then find the...
-
A fuel pump sends gasoline from a car's fuel tank to the engine at a rate of 5.88 10-2 kg/s. The density of the gasoline is 735 kg/m3, and the radius of the fuel line is 3.18 10-3 m. What is the...
-
Given the following diagram, determine the total system reliability if the individual component reliabilities are: A = 0.94, B = 0.90, and C = 0.87. B A
-
A simple electronic assembly consists of two components in a series configuration with reliabilities as shown in the figure below. (Design Option A) Engineers would like to increase the reliability...
-
A simple electronic assembly consists of two components in a series configuration with reliabilities as shown in the figure below. (Design Option A) Engineers would like to increase the reliability...
-
A car trip lasts 3h 36 min at 86 km/h, including a half-hour break for lunch. How much time would we save by driving at 100 km/h without taking a break? (When the automobile is moving, we assume that...
-
Sylvia is interested in financial laws and regulations. She enjo make sure they are in compliance with laws and regulations. career should Sylvia consider?
-
Mariah Lucas is restructuring the budget process at her company, Lucas Lodging, Inc. She envisions a budget process driven by management and lower-level employees, but aligned with the company's...
Study smarter with the SolutionInn App