Proceed as in Problem 1, but now create a pivot table that has two fields from the
Question:
Proceed as in Problem 1, but now create a pivot table that has two fields from the Products table, Product Family and Product Department, in the Rows area and two fields from the Stores table, Country and Region, in the Columns area. Use this to find the percentage of revenue from any product family or any product department that comes from any country or any region of any country. That is, a single pivot table should answer all such questions. For example, you should find that 17.48% of all revenue from the Seafood department comes from the Central region of Mexico?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 60% (5 reviews)
Sum of Revenue Country Region Canada Canada Total Mexico Mexico Total USA USA Total Grand Total ProductFamily ProductDepartment Canada West Mexico Cen...View the full answer
Answered By
JAPHETH KOGEI
Hi there. I'm here to assist you to score the highest marks on your assignments and homework. My areas of specialisation are:
Auditing, Financial Accounting, Macroeconomics, Monetary-economics, Business-administration, Advanced-accounting, Corporate Finance, Professional-accounting-ethics, Corporate governance, Financial-risk-analysis, Financial-budgeting, Corporate-social-responsibility, Statistics, Business management, logic, Critical thinking,
So, I look forward to helping you solve your academic problem.
I enjoy teaching and tutoring university and high school students. During my free time, I also read books on motivation, leadership, comedy, emotional intelligence, critical thinking, nature, human nature, innovation, persuasion, performance, negotiations, goals, power, time management, wealth, debates, sales, and finance. Additionally, I am a panellist on an FM radio program on Sunday mornings where we discuss current affairs.
I travel three times a year either to the USA, Europe and around Africa.
As a university student in the USA, I enjoyed interacting with people from different cultures and ethnic groups. Together with friends, we travelled widely in the USA and in Europe (UK, France, Denmark, Germany, Turkey, etc).
So, I look forward to tutoring you. I believe that it will be exciting to meet them.
3.00+
2+ Reviews
10+ Question Solved
Related Book For
Business Analytics Data Analysis And Decision Making
ISBN: 1209
6th Edition
Authors: S. Christian Albright, Wayne L. Winston
Question Posted:
Students also viewed these Statistics questions
-
Using the Elecmart Sales file from this section, experiment with slicers as follows. a. Create a pivot table that shows the average of TotalCost, broken down by Region in the row area and Time in the...
-
The Access database file Foodmart.mdb mentioned earlier has the tables and relationships shown in Figure 17.1. Import the tables into an Excel Data Model. Then create a pivot table that shows, for...
-
The file Adventure Works.cub contains sales data on biking and related products. It was created in Microsoft SQL Server software and stored as an offline cube. There are two dimension hierarchies,...
-
Determine the force P needed to support the 100 lb weight. Each pulley has a weight of 10 lb. Also determine the reactions at A and B. Figure 2 in
-
Determining the proper costing system Professor Julia Silverman received the following e-mail message. I dont know if you remember me. I am Tim Wallace. I was in your introductory accounting class a...
-
The company Cool Chairs is producing and selling designer chairs. It is now considering introducing a new chair and has carried out a small survey asking about potential customers willingness to pay....
-
The price of gold. Some people recommend that investors buy gold to protect against inflation. Here are the prices of an ounce of gold at the end of the year for the years between 1985 and 2007....
-
Two flow control loops axe shown in the drawing. Indicate whether each system is either a feedback or a feed-forward control system. Justify your answer. It can be assumed that the distance between...
-
Which of the following statements regarding a 30-year (360-month) $100,000 fixed-rate mortgage is CORRECT? (Ignore all taxes and transactions costs.) a. Because it is a fixed rate mortgage, the...
-
Plot on a weekly basis the ratio of currency (FRED code: CURRENCY) to checkable deposits (FRED code: TCD) from the start of 2000 through 2002. Download the data and identify the week of the downward...
-
The file P17_26.xlsx contains Gender, Age, Education, and Success (Yes/No) data of 1000 people. The purpose is to see how a classification tree method can use the first three variables to classify...
-
The file P17_05.xlsx contains data on 100 consumers who drink beer. Some of them prefer light beer, and others prefer regular beer. A major beer producer believes that the following variables might...
-
Bond Discount with Interest Paid Semiannually On January 1, Pear Corporation received $474,624 when it issued $500,000 of 3-year bonds with a stated interest rate of 8 percent. Interest is paid every...
-
(ii) State Wilkie's updating equation in respect of the force of inflation and explain carefully what each of the components of the equation represents. State also which type of time series process...
-
Compute the double integral D x y dA over the domain D indicated as 0 x 5, x y 2x + 3. (Use symbolic notation and fractions where needed.) f(x, y) A = D
-
4. (10 points) A researcher believes that length of time spent listening to classical music increases memory for previously learned material. She has 4 groups of 5 subjects listen to either 10 min.,...
-
We find a binary system consisting of a 1 solar mass star, still in its main sequence phase, and a white dwarf. Assume both stars formed at the same time and that they did not significantly influence...
-
The equity sections from Atticus Group's 2015 and 2016 year-end balance sheets follow. Stockholders Equity (December 31, 2015) Common stock $6 par value, 50,000 shares authorized, 35,000 shares...
-
By the time you are in college, you are in charge of at least some of your own finances. How well you manage your personal budget may indicate how well you will manage your companys budget on the...
-
In Problem use absolute value on a graphing calculator to find the area between the curve and the x axis over the given interval. Find answers to two decimal places. y = x 3 ln x; 0.1 x 3.1
-
The file P17_22.xlsx contains the following data on 84 people: annual income, amount invested in the stock market, and a 0-1 variable on whether they subscribe to the Wall Street Journal. a. Use...
-
The file P17_10.xlsx contains customer data on acceptance of products with various attributes. This is explained more fully in the file. There are three potential Yes/No dependent variables, Acceptl,...
-
Play Things is developing a new Miley Cyrus doll. The company has made the following assumptions: The doll will sell for a random number of years from 1 to 10. Each of these 10 possibilities is...
-
Create a Data Table to depict the future value when you vary the interest rate and the investment amount. Use the following assumptions: Interest Rates: Investment Amounts:-10.0% $10,000.00 -8.0%...
-
Isaac earns a base salary of $1250 per month and a graduated commission of 0.4% on the first $100,000 of sales, and 0.5% on sales over $100,000. Last month, Isaac's gross salary was $2025. What were...
-
Calculate the price, including both GST and PST, that an individual will pay for a car sold for $26,995.00 in Manitoba. (Assume GST = 5% and PST = 8%) a$29,154.60 b$30,234.40 c$30,504.35 d$28,334.75...
Study smarter with the SolutionInn App