Question: Lab Exercise : Pivot Table Online Management Training Inc. Transaction Log: October 28 Column Labels -1 Sum of Amount Product/Source / Region eBook Credit Paypal

Lab Exercise : Pivot Table Online Management

Lab Exercise : Pivot Table Online Management Training Inc. Transaction Log: October 28 Column Labels -1 Sum of Amount Product/Source / Region eBook Credit Paypal Grand Total 9772.23 5544 15316.23 Email 3099.17 1674.49 4773.66 833.38 101.55 934.93 East North 162.21 130.44 292.65 South 1117.21 1235.49 2310.59 West 986.37 Web 10542.57 6673.06 1661.18 East 2447.39 North 631.17 1855.45 1659.98 118.28 1324.22 3869.51 786.21 1224.28 824.91 1034.11 1564.67 349.8 22.51 59.66 South West 2484.89 2720.73 3754.84 Online 2920.71 e Email 748.05 4485.38 1097.85 121.72 East 99.21 192.75 252.41 North South West 126.58 116.36 242.94 329.51 151.27 480.78 eWeb 2172.66 1214.87 3387.53 East 561.18 162.65 723.83 North 587.56 386.07 267.35 201.49 321.16 588.51 South West 958.06 529.57 1487.63 Grand Total 12692.94 7108.67 19801.61 Please use Pivot Table Data Set File in UV. 1. Where do most of our book customers come from? The answer might tell managers where to spend more marketing resources, or to initiate new marketing efforts for increasing book sales. 2. What is the most effective source of advertisement to sell books in the South region? Is it also the most efficient? So what should OMT do? 3. Are there regional differences in the sources of advertisements for our book customers? Perhaps in certain regions email advertisement is more effective, while it is web banners in others. The answer to this complicated question could help managers develop an enhanced regional marketing strategy. 4. What is the total revenue generated from the sale of books that are priced between RM150 to RM200, paid using PayPal? (Hint: Use the Filter function instead)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

For your information, this question is from Management Information System (MIS) Subject Lab Exercise : Pivot Table Online Management Training Inc. Transaction Log: October 28 Sum of Amount Column...

This question is from Management Information System (MIS) Subject Lab Exercise : Pivot Table Online Management Training Inc. Transaction Log: October 28 Product / Source / Region Credit Paypal Grand...

BADB1023: : Management Information System Based on the data sets involving OMT below, you will develop pivot tables. Lab Exercise 2: Pivot Table Online Management Training Inc. Transaction Log:...

Management Information System Questions Lab Test Questions (Set A) Instructions: Answer ALL questions below using either the Pivot Table or the Filter feature available in Microsoft Excel. Print...

how would i calculate fastest average transit time from shenzen to sav. the data set is much bigger but if you could kindly explain how to do it i can use the formula on the whole set. X K H8...

Lab 3 In-class Exercise: Excel Pivot Table Excel is a great tool with which to convert transaction information into analytical information. In this excel, we will use the pivot table function in...

- Lab Chapter 1 Introduction to Business Analytics Review of Spreadsheet Commands Given the datasets for Lab Exercises 1-1 to 1-3, perform the following instructions: Lab Exercise 1-1 - Use Dataset...

Excel Power Pivot Exercise Excel's PowerPivot builds upon what you have learned from Pivot tables and entity relationship diagrams as you pull fields from multiple linked tables. PowerPivot allows...

Complete Lab 3 : Summit Ridge Mountain Resort: Luxury Condo Sales. Basic instructions are in the Lab Overview page. You will be required to use your skills from the text and tutorials to complete the...

A bank has kept records of the checking balances of its customers and determined that the average daily balance of its customers is $300 with a standard deviation of $56. A random sample of 200...

the length of a painting is 2 inches longer than the width. The area of the painting is 48in^(2). If a 3 inch frame is put around the painting what is the area of the frames?

6 . 1 2 An investor in the Treasury securities expects inflation to be \ ( 2 . 1 \ % \ ) in year 1 , \ ( 2 . 7 \ % \ ) in year 2 , and \ ( 3 . 6 5 \ % \ ) each year thereafter. Assume that the real...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...