Mathematics, 25.02.2020 16:33 cooper2017

Use PivotTables 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.

Use PivotTables to find the number of sales transactions by product and region.

Cust ID Region Transaction Code Amount Product
10001 East 94361225 20.37 DVD
10002 West 74083490 18.11 DVD
10003 North 64942368 23.98 DVD
10004 West 70385587 23.81 Book
10005 South 35208817 15.82 Book
10006 West 20978903 17.30 DVD
10007 East 80161506 179.89 Book
10008 West 14132683 21.92 Book
10009 West 40128225 15.92 DVD
10010 South 51357358 24.29 DVD
10011 South 57398827 25.79 Book
10012 East 34400661 20.39 Book
10013 North 55124884 20.81 DVD
10014 East 62597750 153.27 Book
10015 west 51555882 21.01 DVD
10016 West 56999364 23.23 DVD
10017 West 26623353 20.98 Book
10018 West 78594431 20.16 Book
10019 West 92881032 17.66 DVD
10020 West 69868417 17.89 DVD

Answers: 2

Show answers

Another question on Mathematics

Mathematics, 21.06.2019 14:30

Which expression is equivalent to (3^2)^-2 a.-81 b.-12 c.1/81 d.1/12

Answers: 2

Answer

Mathematics, 21.06.2019 14:40

The class wants to raise a total of $750.if they receive a profit of $1.25 from each candybar sold, how many bars must they sell to reachtheir goal

Answers: 1

Answer

Mathematics, 21.06.2019 17:20

Researchers were interested in whether relaxation training decreases the number of headaches a person experiences. they randomly assigned 20 participants to a control group or a relaxation training group and noted the change in number of headaches each group reported from the week before training to the week after training. which statistical analysis should be performed to answer the researchers' question?

Answers: 2

Answer

Mathematics, 21.06.2019 18:00

Carmen begins her next painting on a rectangular canvas that is 82.7 cm long and has a area of 8,137.68 cm2. will the painting fit in a frame with an opening that is 82.7 cm long and 95 cm wide? explain

Answers: 3

Answer

You know the right answer?

Use PivotTables to find the number of sales transactions by product and region, total amount of reve...

Questions

Mathematics, 08.04.2021 15:40

In a town, 45% of all households have a pet and 35% have children. 40% of all households with children have a pet. A household is chosen at random. Fi...

Mathematics, 08.04.2021 15:40

You roll a 6-sided die. What is P(not divisor of 30)? Write your answer as a fraction or whole number....