Business Analytics
3rd Edition
ISBN: 9780135231678
Author: Evans, James R. (james Robert)
Publisher: PEARSON EDUCATION (COLLEGE)
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 2, Problem 10PE
In the Purchase Orders database, conduct a Pareto analysis of the cost per order data. What conclusions can you reach?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Sleep Late, a large hotel chain, has been using activity-based costing to determine the cost of a night’s stay at their hotels. One of the activities, “Inspection,” occurs after a customer has checked out of a hotel room. Sleep Late inspects every 10th room and has been using “number of rooms inspected” as the cost driver for inspection costs. A significant component of inspection costs is the cost of the supplies used in each inspection Mary Adams, the chief inspector, is wondering whether inspection labor-hours might be a better cost driver for inspection costs. Mary gathers information for weekly inspection costs, rooms inspected, and inspection labor-hours as follows:
Q.Plot the data and regression line for rooms inspected and inspection costs. Plot the data and regression line for inspection labor-hours and inspection costs. Which cost driver of inspection costs would you choose? Explain.
Identify several types of manufacturing companies for which process costing would be an appropriate product-costing system. What characteristics do the products of these companies have that would make process costing a good choice?
How is process costing similar and different in a second or later processing department?
Spring is a peak time for selling houses. Suppose the data below contains the selling price, number of bathrooms, square footage, and number of bedrooms of 26 homes sold in Ft. Thomas, Kentucky, in spring 2018.
Selling Price Baths Sq Ft
Selling Price
160,000
170,000
178,000
182,500
195,100
212,500
245,900
250,000
255,000
258,000
267,000
268,000
275,000
1.5 1,786
2 1,768
1 1,219
1 1,578
1.5 1,125
2 1,196
2 2,128
N W
3
2
1,280
1,596
3.5 2,374
2.5 2,439
2 1,470
2 1,688
Beds
3
3
3
2
3
2
3
3
3
4
3
4
4
295,000
325,000
325,000
328,400
331,000
344,500
365,000
385,000
395,000
399,000
430,000
430,000
454,000
Baths Sq Ft
2.5 1,860
3 2,056
3.5 2,776
2
1,408
1.5 1,972
2.5 1,736
2.5 1,990
2.5 3,640
2.5 1,928
2 2,108
2
2,462
2 2,615
3.5 3,700
Beds
3
4
4
4
3
3
4
4
4
3
4
4
4
Consider the estimated regression equation we developed that can be used to predict the selling price given the number of bathrooms, square footage, and number of bedrooms in the house. (x, denotes number of bathrooms, x₂ denotes…
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
- Use this data for the exercises that follow: In 2013, there were roughly 317 million citizens in the United States, and about 40 million were elderly (aged 65 and over).[34] 60. It is predicted that by 2030, one in five U.S. citizens will be elderly. How much greater will the chances of meeting an elderly person be at that time? What policy changes do you foresee if these statistics hold true?arrow_forwardA survey about social media reported that 82% of B2B marketers (marketers that focus primarily on attracting businesses) plan to increase their use of social media, as compared to 55% of B2C marketers (marketers that primarily target consumers). The survey was based on 1,286 B2B marketers and 1,731 B2C marketers. The accompanying table summarizes the results. Complete parts (a) through (d) below. A. What is the probability that a randomly selected respondent is a B2C marketer? B. What is the probability that a randomly selected respondent plans to increase use of social media or is a B2C marketer? C. Explain the difference in the results in (a) and (b)arrow_forwardA survey about social media reported that 79% of B2B marketers (marketers that focus primarily on attracting businesses) plan to increase their use of social media, as compared to 54% of B2C marketers (marketers that primarily target consumers). The survey was based on 1,333 B2B marketers and 1,669 B2C marketers. The accompanying table summarizes the results. Complete parts (a) through (d) below. A Click the icon to view the contingency table about social media use and marketers. Contingency table a. What is the probability that a randomly selected respondent plans to increase use of social media? (Round to three decimal places as needed.) Increase Use of Social Media? Business Focus B2B B2C Total b. What is the probability that a randomly selected respondent is a B2C marketer? Yes 1,049 901 1,950 (Round to three decimal places as needed.) No 284 768 1,052 Total 1,333 1,669 3,002 c. What is the probability that a randomly selected respondent plans to increase use of social media or is…arrow_forward
- Help Please!arrow_forwardConsider a business owner, how would you use methodology and the data results to increase sales or improve overall profitability? What are some of your recommendations?arrow_forwardIn 2011, home prices and mortgage rates fell so far that in a number of cities the monthly cost of owning a home was less expensive than renting. The following data show the average asking rent and the monthly mortgage on the median-priced home (including taxes and insurance) for 10 cities where the average monthly mortgage payment was less than the average asking rent (The Wall Street Journal, November 26–27, 2011). 7. City Rent ($) Mortgage ($) Atlanta 840 539 1062 1002 Chicago Detroit 823 626 DATA file Jacksonville, Fla. Las Vegas 779 711 796 655 RentMortgage 1071 953 Miami 977 Minneapolis Orlando, Fla. 776 851 695 762 651 654 Phoenix St. Louis 723 Develop a scatter diagram for these data, treating the average asking rent as the inde- pendent variable. Does a simple linear regression model appear to be appropriate? b. Use a simple linear regression model to develop an estimated regression equation to predict the monthly mortgage on the median-priced home given the average asking…arrow_forward
- Most engaged couples expect or at least hope that they will have high levels of marital satisfaction. However, because 54% of first marriages end in divorce, social scientists have begun investigating influences on marital satisfaction. (Data Source: National Center for Health Statistics.) A counseling psychologist sets out to look at the role of having children in relationship longevity. She decides to measure marital satisfaction in a group of couples with children and a group of childless couples. She chooses the Marital Satisfaction Inventory, because it refers to "partner" and "relationship" rather than "spouse" and "marriage," which makes it useful for research with both traditional and nontraditional couples. Higher scores on the Marital Satisfaction Inventory indicate greater satisfaction. Assume that these scores are normally distributed. A sample of 39 couples with children scored an average of 51.1 with a sample standard deviation of 9.2 on the Marital Satisfaction…arrow_forwardMost engaged couples expect or at least hope that they will have high levels of marital satisfaction. However, because 54% of first marriages end in divorce, social scientists have begun investigating influences on marital satisfaction. (Data Source: National Center for Health Statistics.) A counseling psychologist sets out to look at the role of having children in relationship longevity. She decides to measure marital satisfaction in a group of couples with children and a group of childless couples. She chooses the Marital Satisfaction Inventory, because it refers to "partner" and "relationship" rather than "spouse" and "marriage," which makes it useful for research with both traditional and nontraditional couples. Higher scores on the Marital Satisfaction Inventory indicate greater satisfaction. Assume that these scores are normally distributed. A sample of 39 couples with children scored an average of 51.1 with a sample standard deviation of 9.2 on the Marital Satisfaction…arrow_forwardHelp me fastarrow_forward
- A recent survey showed that 42% of recent college graduates named flexible hours as their most desired employment benefit. In a graduating class of 860 college students, how many would you expect to rank flexible hours as their top priority in job benefits?arrow_forwardPlease help with part b. Thanks.arrow_forwardTV Viewing Times. Data from a sample of Americans yielded the following estimates of average TV viewing time per month for all Americans 2 years old and older. The times are in hours and minutes; Q1 stands for first quarter. [SOURCE: The Cross-Platform Report, Quarter 1, 2011. Published by The Nielsen Company, _c 2011.]arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
The Shape of Data: Distributions: Crash Course Statistics #7; Author: CrashCourse;https://www.youtube.com/watch?v=bPFNxD3Yg6U;License: Standard YouTube License, CC-BY
Shape, Center, and Spread - Module 20.2 (Part 1); Author: Mrmathblog;https://www.youtube.com/watch?v=COaid7O_Gag;License: Standard YouTube License, CC-BY
Shape, Center and Spread; Author: Emily Murdock;https://www.youtube.com/watch?v=_YyW0DSCzpM;License: Standard Youtube License