Business Analytics
3rd Edition
ISBN: 9780135231678
Author: Evans, James R. (james Robert)
Publisher: PEARSON EDUCATION (COLLEGE)
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 2, Problem 39PE
To determine
Delineate the way to construct a Pivot Table for the Cell Phone Survey database and also show the number of sales transactions by product and region, total amount of revenue by region, and total amount of revenue by region and product.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Charity Navigator is America's leading independent charity evaluator. The data in the Excel Online file below show the total expenses ($), the percentage of the total budget spent on administrative expenses, the percentage spent on fundraising, and the percentage spent on program expenses for 10 supersized charities. Administrative expenses include overhead, administrative staff and associated costs, and organizational meetings. Fundraising expenses are what a charity spends to raise money, and program expenses are what the charity spends on the programs and services it exists to deliver. The sum of the three percentages does not add to 100% because of rounding. Construct a spreadsheet to answer the following questions.
Charity Navigator is America's leading independent charity evaluator. The data in the Excel Online file below show the total expenses ($), the percentage of the total budget spent on administrative expenses, the percentage spent on fundraising, and the percentage spent on program expenses for 10 supersized charities. Administrative expenses include overhead, administrative staff and associated costs, and organizational meetings. Fundraising expenses are what a charity spends to raise money, and program expenses are what the charity spends on the programs and services it exists to deliver. The sum of the three percentages does not add to 100% because of rounding. Construct a spreadsheet to answer the following questions.
Explain Scheduling Daily Work Times?
Chapter 2 Solutions
Business Analytics
Ch. 2 - Explain the difference between a data set and a...Ch. 2 - For the Monthly Product Sales Excel file, use the...Ch. 2 - For the Monthly Product Sales Excel file, use the...Ch. 2 - What does the term filtering mean in the context...Ch. 2 - Convert the Credit Risk database to an Excel...Ch. 2 - Sort the data in the purchase orders database from...Ch. 2 - Prob. 2.4CYUCh. 2 - Prob. 3.1CYUCh. 2 - Prob. 3.2CYUCh. 2 - Prob. 3.3CYU
Ch. 2 - Prob. 4.1CYUCh. 2 - In the Purchase Orders database, what will =...Ch. 2 - Prob. 4.3CYUCh. 2 - Prob. 5.1CYUCh. 2 - Prob. 5.2CYUCh. 2 - Prob. 5.3CYUCh. 2 - Prob. 5.4CYUCh. 2 - Prob. 6.1CYUCh. 2 - Prob. 6.2CYUCh. 2 - Prob. 6.3CYUCh. 2 - The Excel file MBA Motivation and Salary...Ch. 2 - Prob. 2PECh. 2 - The Budget Forecasting database shows estimated...Ch. 2 - Convert the Store and Regional Sales database to...Ch. 2 - Convert the Purchase Orders database to an Excel...Ch. 2 - Prob. 6PECh. 2 - The Excel file Corporate Default Database...Ch. 2 - Open the Excel file Store and Regional Sales...Ch. 2 - In the Excel file Automobile Quality, search for...Ch. 2 - In the Purchase Orders database, conduct a Pareto...Ch. 2 - Conduct a Pareto analysis for the number of...Ch. 2 - Prob. 12PECh. 2 - In the Sales Transactions database, use Excels...Ch. 2 - Filter the data in the Bicycle Inventory database...Ch. 2 - Use the Excel file Credit Risk Data that was...Ch. 2 - Apply the Advanced Filter to the Credit Risk Data...Ch. 2 - Prob. 17PECh. 2 - Prob. 18PECh. 2 - Modify the data in the Base Data worksheet in the...Ch. 2 - Prob. 20PECh. 2 - Figure 2.41 shows the 2016 U.S. federal income tax...Ch. 2 - For the Bicycle Inventory database, write a...Ch. 2 - Prob. 23PECh. 2 - A manager needs to identify some information from...Ch. 2 - The Excel file SP 500 provides open, high, low,...Ch. 2 - Enhance the Sales Transactions database file to...Ch. 2 - Prob. 27PECh. 2 - For this exercise, use the Purchase Orders...Ch. 2 - Use INDEX and MATCH functions to fill in a table...Ch. 2 - Prob. 30PECh. 2 - Prob. 31PECh. 2 - Prob. 32PECh. 2 - Prob. 33PECh. 2 - Prob. 34PECh. 2 - A college graduate who is living in Cincinnati...Ch. 2 - The Excel file Payroll Data provides hourly...Ch. 2 - Construct PivotTables showing the counts of gender...Ch. 2 - Prob. 38PECh. 2 - Prob. 39PECh. 2 - Prob. 40PECh. 2 - Prob. 2.1C
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- Two cars with the same purchase price are not worth the same amount at the end of the year. Some cars depreciate faster than others. A truck depreciates at 45%45% and a Jeep depreciates at 25%25% per year. Assume the initial purchase price is $19,000.$19,000. Use a spreadsheet to determine how much more the Jeep is worth in three years.arrow_forwardA furniture manufacturing company makes dining room tables and chairs. The relevant manufacturing data are given in the table. How many tables and chairs should be made each day to realize a maximum profit? What is the maximum profit? avec Assembly department Finishing department profit per unit Labor-hours per unit Chair 2 Table 8 2 $90 1 $25 Maximum labor-hours available per day 400 120arrow_forwardRey is choosing a profession in engineering. He is choosing between civil, chemical and mechanical engineering. He searched about the annual income of each engineering profession and wants to consider this when choosing. An Civil Engineer earns an average of 196,000 per year with a tax rate of 25%, a Chemical Engineer earns an average of 221,000 a year with a tax rate of 25%, and lastly, Mechanical Engineer earns an average of 587,000 a year with a tax rate of 32%, which among this profession should he choose if he will consider the net income?arrow_forward
- Calculate 5,6 & 7 Please do not give solution in images formatarrow_forwardIf you spend x million dollars on labor and y million dollars on capital (that is, machinery, buildings, etc.), then your factory producesarrow_forwardAn organization estimated that in a particular year the population of a country spent $10.5 trillion in personal consumption. The major categories of these expenditures are durable goods($1.1trillion; for example, cars, furniture, recreational equipment), nondurable goods($2.1trillion; for example, food, clothing, fuel), and services($7.1trillion; for example, health care, education, transportation). Complete parts (a) through (e) below. a. What is the approximate annual per capita spending for personal consumption? Assume a population of 265million. (Round to the nearest dollar as needed.) b. What is the approximate daily per capita spending for personal consumption? (Round to the nearest dollar as needed.) c. On average about what percentage of personal spending is devoted to services? (Round to the nearest percent as needed.) d. Spending on health care was estimated to be$1.1 trillion in that year. About what percentage of all personal…arrow_forward
- How is co-ordination achieved in team-based, project-based and process-based structures?arrow_forwardThe table shows the 2015 per capita total expenditure on health in 35 countries with the highest gross domestic product in that year. Health expenditure per capita is the sum of public and private health expenditures (in PPP, international $) divided by population. Health expenditures include the provision of health services, family-planning activities, nutrition activities, and emergency aid designated for health; health expenditures exclude the provision of water and sanitation. Per capita total expenditure on health (international dollars) Country Argentina Australia Austria Belgium D:1 Dollars 1390 4492 5138 4782 1200 Side-by-Side O Macmillan Learning Which country is the high outlier? O Switzerland Norway Germany O Indonesia O United Statesarrow_forwardFlowcharts are common process design and analysis tools used in both manufacturing and services. What is a key feature of flowcharts used in service operations that differentiates between the front-office and back-office aspects of the system?arrow_forward
- What might the key processes for health care organizations be?arrow_forwardThe total budgeted cost of a project is 899,642 dollars. The project completion time is 21 weeks. The project is in its performing phase. At the end of week 14, the project team meets to evaluate the progress of the project. The project has consumed a total of 378,053 dollars and the project cumulative earned value is 468,994 dollars. From the project plan, the project cumulative budgeted cost is 407,137 dollars at the end of week 14. If the project continues to perform at the current cost performance index from now on, the project completion time is estimated to be weeks. Use at least 4 decimals.arrow_forwardcan you provide a step-by-step explanation on each processarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Elementary Geometry for College StudentsGeometryISBN:9781285195698Author:Daniel C. Alexander, Geralyn M. KoeberleinPublisher:Cengage Learning
Elementary Geometry for College Students
Geometry
ISBN:9781285195698
Author:Daniel C. Alexander, Geralyn M. Koeberlein
Publisher:Cengage Learning
Solve ANY Optimization Problem in 5 Steps w/ Examples. What are they and How do you solve them?; Author: Ace Tutors;https://www.youtube.com/watch?v=BfOSKc_sncg;License: Standard YouTube License, CC-BY
Types of solution in LPP|Basic|Multiple solution|Unbounded|Infeasible|GTU|Special case of LP problem; Author: Mechanical Engineering Management;https://www.youtube.com/watch?v=F-D2WICq8Sk;License: Standard YouTube License, CC-BY
Optimization Problems in Calculus; Author: Professor Dave Explains;https://www.youtube.com/watch?v=q1U6AmIa_uQ;License: Standard YouTube License, CC-BY
Introduction to Optimization; Author: Math with Dr. Claire;https://www.youtube.com/watch?v=YLzgYm2tN8E;License: Standard YouTube License, CC-BY