Use Pivot Tables to find the number of sales transactions by product and region, total amount...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use Pivot Tables to find the number of sales transactions by product and region, total amount of revenue by region, and total amount of revenue by region and product in the accompanying Sales Transactions data Click the icon to view the Sales Transactions data. Use Pivot Tables to find the number of sales transactions by product and region. (Type whole numbers.) Count of Amount Book DVD Grand Total East North South West Grand Total ELE Sales Transactions Cust ID Region Transaction Code 10001 East 94108738 10002 West 74083490 10003 North 64942368 72753924 35208817 10004 West 10005 South 10006 West 10007 East 10008 West 20978903 80321173 14132683 10009 West 40128225 10010 South 51285539 10011 South 57398827 34400661 55795055 62597750 51555882 10012 East 10013 North 10014 East 10015 West 10016 West 10017 West 10018 West 10019 West 62042214 26623353 78594431 96522414 10020 West 69868417 Print Amount Product 20.52 18.12 23.98 23.85 15.42 17.30 179.94 21.84 15.92 24.38 25.14 20.39 20.28 153.44 21.01 23.23 DVD DVD DVD Book Book. DVD Book Book DVD DVD Book Book DVD Book DVD DVD 21.83 Book 20.16 Book 17.95 DVD 18.18 DVD. Done O Use Pivot Tables to find the number of sales transactions by product and region, total amount of revenue by region, and total amount of revenue by region and product in the accompanying Sales Transactions data Click the icon to view the Sales Transactions data. Use Pivot Tables to find the number of sales transactions by product and region. (Type whole numbers.) Count of Amount Book DVD Grand Total East North South West Grand Total ELE Sales Transactions Cust ID Region Transaction Code 10001 East 94108738 10002 West 74083490 10003 North 64942368 72753924 35208817 10004 West 10005 South 10006 West 10007 East 10008 West 20978903 80321173 14132683 10009 West 40128225 10010 South 51285539 10011 South 57398827 34400661 55795055 62597750 51555882 10012 East 10013 North 10014 East 10015 West 10016 West 10017 West 10018 West 10019 West 62042214 26623353 78594431 96522414 10020 West 69868417 Print Amount Product 20.52 18.12 23.98 23.85 15.42 17.30 179.94 21.84 15.92 24.38 25.14 20.39 20.28 153.44 21.01 23.23 DVD DVD DVD Book Book. DVD Book Book DVD DVD Book Book DVD Book DVD DVD 21.83 Book 20.16 Book 17.95 DVD 18.18 DVD. Done O
Expert Answer:
Answer rating: 100% (QA)
Answer The pivot table is made using the above data and the below information is extracted as The nu... View the full answer
Related Book For
Business Analytics Methods Models and Decisions
ISBN: 978-0321997821
2nd edition
Authors: James R. Evans
Posted Date:
Students also viewed these finance questions
-
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.
-
Use Exercise 68 to find the number of different equivalence relations on a set with n elements, where n is a positive integer not exceeding 10. Let p(n) denote the number of different equivalence...
-
Use the given information to find the number of degrees of freedom, the critical values X2L and X2R, and the confidence interval estimate of S. The samples are from Appendix B and it is reasonable to...
-
Timetrics 2016 survey of insurance professionals explores the use of technology in the industry. The file Technologies contains the responses to the question that asked what technologies these...
-
7,500 lb/h of a 50 wt% aqueous solution of FeC13 at 100C is cooled to 20C. At 100oC, the solubility of the FeC13 is 540 g/100 g of water. At 2PC, the solubility is 91.8 g/100 g water and crystals of...
-
As CEO of Ocean World, Dana Stuckey knows it is important to control costs and to respond quickly to changes in the highly competitive boat-building industry. When IDG Consulting proposes that Ocean...
-
The U.S. 3-month interest rate (unannualized) is 1 percent. The Canadian 3-month interest rate (unannualized) is 4 percent. Interest rate parity exists. The expected inflation over this period is 5...
-
A partially completed pension spreadsheet showing the relationships among the elements that comprise the defined benefit pension plan of Universal Products is given below. The actuary's discount rate...
-
Reminders: Chi-square is a form of statistical analysis used to compare the actual results (observed) with the expected results. The equation tests the null hypothesis for the problem being analyzed....
-
The compound beam ABCDE shown in the figure consists of two beams (AD and DE) joined by a hinged connection at D. The hinge can transmit a shear force but not a bending moment. The loads on the beam...
-
Question: Calculate Jensen's alpha values for stock A and stock B. Based on the calculated alpha values, discuss the position that you would like to take in each stock. Assume you observe the...
-
Identifying Training Needs at the U.S. Department of Agricultures Animal Plant and Health Inspection Service (APHIS). APHIS created an innovative training program to keep supervisors up to date and...
-
Why is the public relations function regarded as something of a step child in government?
-
What are the pros and cons of using different types of database management system (relational, object, and object-relational)? Why do you think object database never took off? What do you think is...
-
Consider the challenges retailers face as they attempt to perfect their demand-management systems and improve their order fulfillment capabilities. Select a product that you can buy at both a local...
-
Why would a modern organizatioj like massey energy repeat the legacy of hawks nest by compromosing worker safety?
-
On December 31, 2025, Sheffield Company signed a $1,038,100 note to Tamarisk Bank. The market interest rate at that time was 11%. The stated interest rate on the note was 9%, payable annually. The...
-
Calculate I, , and a for a 0.0175 m solution of Na 3 PO 4 at 298 K. Assume complete dissociation. How confident are you that your calculated results will agree with experimental results?
-
MJ Logistics has decided to build a new warehouse to support its supply chain activities. They have the option of building either a large warehouse or a small one. Construction costs for the large...
-
Use the Outsourcing Decision Model Excel file to compute the cost of in house manufacturing and outsourcing for the following levels of demand: 800, 1000, 1200, and 1400. Use this information to set...
-
Gales Products manufactures ribbon for thermal transfer printing, which transfers ink from a ribbon onto paper through a combination of heat and pressure. Different types of printers use different...
-
Andreas Delons Compensation. Andreas Delon is a French citizen who has been offered the position of CEO of LakePharma, a large French pharmaceuticals firm. LakePharma produces high-quality chemicals...
-
EuroVirtuals EPS Sensitivity to Exchange Rates (A). On January 15, 2015 the Swiss National Bank (SNB) decided to unpeg the franc, which was fixed at CHF1.20/ since 2011. Suppose the SNB was to...
-
EuroVirtuals Consolidated Earnings. EuroVirtual pays different tax rates for each of its country operations. a. What are its earnings per share in EUR after deducting taxes? b. What is the proportion...
Study smarter with the SolutionInn App