FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use pivot tables to find the number of sales transactions by product and region, the total amount of revenue by region, and the total amount

Use pivot tables to find the number of sales transactions by product and region, the total amount of revenue by region, and the total amount of revenue by region and product in the accompanying sales transaction data.

Client ID

Region

Transaction code

Amount

Product

10001

It is

94229674

20.46

DVD

10002

West

74083490

18.09

DVD

10003

Norte

64942368

23.98

DVD

10004

West

71769545

24.75

Book

10005

On

35208817

15.42

Book

10006

West

20978903

17.30

DVD

10007

It is

80167293

178.37

Book

10008

West

14132683

22.56

Book

10009

West

40128225

15.92

DVD

10010

On

52719590

23.89

DVD

10011

On

57398827

24.46

Book

10012

It is

34400661

20.39

Book

10013

Norte

56005132

22.06

DVD

10014

It is

62597750

153.38

Book

10015

West

51555882

21.01

DVD

10016

West

56472871

22.99

DVD

10017

West

26623353

20.91

Book

10018

West

78594431

20.16

Book

10019

West

92919041

18.11

DVD

10020

West

69868417

17.76

DVD

Quantity count

It is

Norte

On

West

Grand total

Book

anything

anything

anything

anything

anything

DVD

anything

anything

anything

anything

anything

Grand total

anything

anything

anything

anything

anything

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Analytics Methods Models And Decisions

Business Analytics Methods Models And Decisions

Authors: James R. Evans

2nd Edition

321997824, 978-1119298588, 978-0321997821

More Books

Students also viewed these General Management questions

Question

Why are accountants suited to play a role in reporting to stakeholders and assuring them that ESG claims are solid? Accountants are skilled in auditing and can provide assurance services. Accountants...

Answered: 1 week ago

Question

Standard Costing - Variance Analysis - H.O#2 Q.1:- The standard mix for producing 8,000 bottles of Product-X is as follows; Material: A Material: B from an input of: 1,000 liters 2,000 liters Re....

Answered: 1 week ago

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.

Answered: 1 week ago

Question

★★★★★
Suppose a town concludes that it costs on average $30.00 per household to manage the disposal of the waste generated by households each year. It is debating two strategies for funding this cost: (1)...

Answered: 1 week ago

Question

★★★★★
Prove the following results used in the proof of the local flatness theorem in 6.2: (a) The number of independent values of 2x/x'x'|0 is 40. (b) The corresponding number for 3x/x' x' xv'|0 is 80....

Answered: 1 week ago

Question

★★★★★
Sale prices of apartments. A Minneapolis, Minnesota, real-estate appraiser used regression analysis to explore the relationship between the sale prices of apartment buildings sold in Minneapolis and...

Answered: 1 week ago

Question

★★★★★
Irene has a Facebook page and she is very keen to have a large number of friends there. The number of friends added to her page follows a Poisson process with a rate of ???? = 3 persons per week. (i)...

Answered: 1 week ago

Question

★★★★★
The New England Soap Company is considering adding some processing equipment to the plant to aid in the removal of impurities from some raw materials. By adding the processing equipment, the firm can...

Answered: 1 week ago

Question

★★★★★
4 5 . A controller action in which there is a con - tinous relation between the values of controlled variable and the rate of change of conrolled output signal is called the............... action. A...

Answered: 1 week ago

Question

★★★★★
Packer Concrete Company pours concrete slabs for single-family dwellings. Wolff Construction Company, which operates outside Packer's normal sales territory, asks Packer to pour 50 slabs for Wolff's...

Answered: 1 week ago

Question

★★★★★
King, Ryan and Kenjie are owners in their individual business, after they reunite and discussing about their individual business they are thinking of combining it into one partnership on March 1,...

Answered: 1 week ago

Question

★★★★★
CoursHeroTranscribedText Problem 216: The partial derivatives are = r (ar + brs + cs) e s + s r and = as (dr + ers + fs) e s + sr where a = b = C= d = e = f =

Answered: 1 week ago

Question

★★★★★
Identify and list the functional components (aperture, receiver, storage, distribution, mechanism, and control mechanism) for each of these SECSspictured. SECS description Aperture Receiver Storage...

Answered: 1 week ago

Question

★★★★★
A. Show the solution for each. Compute in details the Variable Manufacturing Overhead Variances - Spending and Efficiency. B. Show the solution for each. Compute in details the Fixed Manufacturing...

Answered: 1 week ago

Question

★★★★★
The related data: The following transactions of Marian Company for the month of June are as follows: 1. Purchase merchandise on account of 200,000 with freight of 20,000 of goods to supplier. 150,000...

Answered: 1 week ago

Question

★★★★★
Consder the following information: a. Calculate the expected return for the two stocks Note: Do not round intermediate calculations ond entar your answers as a percent rounded 10 2 decimal places,...

Answered: 1 week ago

Question

★★★★★
Medi-Exam Health Services, Inc. (MEHS), located in a major metropolitan area, provides annual physical screening examinations, including a routine physical, EKG, and blood and urine tests. MEUS's...

Answered: 1 week ago

Question

★★★★★
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...

Answered: 1 week ago

Question

★★★★★
A community health status survey obtained the following demographic information from the respondents: Compute the relative frequency and cumulative relative frequency of the age groups. Age 18 to 29...

Answered: 1 week ago

Question

★★★★★
Create a bubble chart for the first five colleges in the Excel file Colleges and Universities for which the x- axis is the Top 10% HS, y- axis is Acceptance Rate, and bubbles represent the...

Answered: 1 week ago

Question

★★★★★
11.43. The Economist magazine5 developed a qualityof-lifc index for nations as the predicted value obtained by regressing an average of lifesatisfaction scores from several surveys on gross domestic...

Answered: 1 week ago

Question

★★★★★
11.41. A study3 of mortality rates found in the U.S. that states with higher income inequality tended to have higher mortality rates. The effect of income inequality disappeared after controlling for...

Answered: 1 week ago

Question

★★★★★
11.34. Refer to the "OECD data" file at the text Web site, shown in Table 3.11 on page 62 of Chapter 3. Pose a research question about how at least two of the variables shown in that table relate to...

Answered: 1 week ago

Previous Question Next Question