Business Analytics (2nd Edition)
2nd Edition
ISBN: 9780321997821
Author: James R. Evans
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 3, Problem 19PE
Use Excel’s filtering capability to (1) extract all orders for control panels, (2) all orders for quantities of less than 500 units, and (3) all orders for control panels with quantities of less than 500 units in the Purchase Oders database.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
For unemployed persons in the United States, the average number of months ofunemployment at the end of December 2009 was approximately seven months(Bureau of Labor Statistics, January 2010). Suppose the following data are for aparticular region in upstate New York. The values in the first column show thenumber of months unemployed and the values in the second column show thecorresponding number of unemployed persons.MonthsUnemployedNumberUnemployed1 10292 16863 22694 26755 34876 46527 41458 35879 2325
10 1120Let x be a random variable indicating the number of months a person is unemployed.a. Use the data to develop an empirical discrete probability distribution for x.b. Show that your probability distribution satisfies the conditions for a validdiscrete probability distribution.c. What is the probability that a person is unemployed for two months or less?Unemployed for more than two months?d. What is the probability that a person is unemployed for more than sixmonths?
Slamet is a young entrepreneur who started his business by opening 5 “Bebek Mas Slamet” restaurants in different locations, namely in Blok S, Blok M, Blok A, Senayan, and Depok areas. Because it is still in its infancy, Slamet still frequently observes data on the number of sales portions of Fried Duck which is the mainstay of the restaurant "Bebek Mas Slamet". The following data shows the total sales of Bebek Goreng for the last two days for the time of day, afternoon, and evening that Slamet is observing from the four restaurant locations
Penjualan
Siang
Sore
Malam
Blok S
40
41
30
32
43
43
Blok M
36
40
35
33
45
46
Blok A
40
45
39
48
46
50
Senayan
34
37
36
35
45
44
Depok
36
40
37
34
47
48
Help Slamet to analyze the data on the sales of fried duck over the past two days by answering some of the questions in this question. Some of the results of the calculation of the sum of squares…
The sales manager of a large automotive parts distributor wants to estimate the total annual sales for each of the company’s regions. Five factors appear to be related to regional sales: the number of retail outlets in the region, the number of automobiles in the region registered as of April 1, the total personal income recorded in the first quarter of the year, the average age of the automobiles (years), and the number of sales supervisors in the region. The data for each region were gathered for last year. For example, see the following table. In region 1 there were 1,739 retail outlets stocking the company’s automotive parts, there were 9,270,000 registered automobiles in the region as of April 1, and so on. The region’s sales for that year were $37,702,000.
constant
outlet
automobile reg
income
age
bosses
37.702
1,739
9.27
85.4
3.5
9
24.196
1,221
5.86
60.7
5
5
32.055
1,846
8.81
68.1
4.4
7
3.611
120
3.81
20.2
4
5
17.625
1,096
10.31
33.8
3.5
7
45.919
2,290
11.62
95.1…
Chapter 3 Solutions
Business Analytics (2nd Edition)
Ch. 3 - Create a line chart for the closing prices for all...Ch. 3 - Create a pie chart showing the breakdown of...Ch. 3 - The Excel tile Facebook Survey provides data...Ch. 3 - A national homebuilder builds single-family homes...Ch. 3 - Create a bubble chart for the first five colleges...Ch. 3 - Construct a column chart for the data in the Excel...Ch. 3 - The Excel file Internet Usage provides data about...Ch. 3 - Construct an appropriate chart to show the...Ch. 3 - In the Excel file Banking Data, apply the...Ch. 3 - Apply three different colors of data bars to...
Ch. 3 - For the Store and Regional Sales database, apply a...Ch. 3 - For the Excel file Closing Stock Prices, Apply...Ch. 3 - Convert the Store and Regional Sales database to...Ch. 3 - Prob. 14PECh. 3 - Prob. 15PECh. 3 - Prob. 16PECh. 3 - Prob. 17PECh. 3 - In the Purchase Orders database, conduct a Pareto...Ch. 3 - Use Excels filtering capability to (1) extract all...Ch. 3 - Prob. 20PECh. 3 - The Excel file Credit Risk Date Provides...Ch. 3 - Prob. 22PECh. 3 - Prob. 23PECh. 3 - A community health-status survey obtained the...Ch. 3 - Prob. 25PECh. 3 - Prob. 26PECh. 3 - Prob. 27PECh. 3 - Prob. 28PECh. 3 - Prob. 29PECh. 3 - Prob. 30PECh. 3 - Find the 10th and 90th percentiles and 1st, 2nd,...Ch. 3 - Construct cross-tabulations of Gender versus...Ch. 3 - Use PivotTables to construct a cross-tabulation...Ch. 3 - Use PivotTables to construct a cross-tabulation...Ch. 3 - Create a PivotTable to find the average amount of...Ch. 3 - Use PivotTables to find the number of loans by...Ch. 3 - Use PivotTables to find the number of sales...Ch. 3 - Create a PivotTable for the data in the Excel file...Ch. 3 - The Excel File Rins Gym provides sample data on...Ch. 3 - Create useful dashboards for each of the following...Ch. 3 - A marketing researcher surveyed 92 individuals,...
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
- To allocate annual bonuses, a manager must choose his top four employees and rank them first to fourth. In how many ways can he create the ‘Top- Four” list out of the 32 employees?arrow_forwardJohnson Filtration, Inc. provides maintenance service for water-filtration systems. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. Repair Time(hours) Months SinceLast Service Type ofRepair Repairperson 2.9 2 electrical Dave Newton 3.0 6 mechanical Dave Newton 4.8 8 electrical Bob Jones 1.8 3 mechanical Dave Newton 2.9 2 electrical Dave Newton 4.9 7 electrical Bob Jones 4.2 9 mechanical Bob Jones 4.8 8 mechanical Bob Jones 4.4 4 electrical Bob Jones 4.5 6 electrical Dave Newton Ignore for now the months since the last maintenance service (x1 ) and the repairperson who performed the service. Develop the estimated simple linear regression equation to predict the repair time (y) given the…arrow_forward1) scatterplotarrow_forward
- A pet store keeps track of the purchases of customers over a four hour period. The store manager classifies purchases as containing a dog product, a cat product, a fish product, or product for a different kind of pet. She found that 83 purchased a dog product; 101 purchased a cat product; 22 purchased a fish product; 31 purchased a dog and a cat product; 8 purchased a dog and a fish product; 10 purchased a cat and a fish product; 6 purchased a dog, a cat, and a fish product, 34 purchased a product for a pet other than a dog, cat, or fish. How many purchases were for a dog or a fish product?arrow_forwardA freelance computer consultant keeps a database of her clients, which contains the names S = {Aces, Bakers, Crafts, Dion, Energy, Flavour, Globe, Hilbert}. The following clients owe her money: A = {Aces, Crafts, Energy, Globe}. The following clients have done at least $1,000 worth of business with her: B = {Aces, Bakers, Crafts, Dion}. The following clients have employed her in the last year: C = {Aces, Crafts, Dion, Energy, Globe, Hilbert}. A subset of clients is described that the consultant could find using her database. HINT [See Example 4.] The clients who owe her money and have done at least $1,000 worth of business with her. Write the subset in terms of A, B, and C and list the clients in the subsetarrow_forwardFor the Burger Dome single-channel waiting line, assume that the arrival rate is 1 customer per minute and the mean service rate is 1.25 customers per minute. Compute the following operating characteristics for this queuing system: P0, Lq, L, Wq, and W.arrow_forward
- A fleet of 100 taxis is divided into two groups of 50 cars each to see whether premium gasoline reduces maintenance costs. Premium unleaded fuel is used in group A, while regular unleaded fuel is used in group B. The total maintenance cost for each vehicle during a one-year period is recorded. Premium fuel will be used if it is shown to reduce maintenance costs.arrow_forwardA company that sells digital devices has its stores in several cities in Albania. The Marketing Manager plans to transmite an advertisement for the digital camera product on local television and watch sales of that product, to see the link that exists with the number of ads transmitted and product sales. After two days, the results were presented in the following table: City Trasmitted Sales(in 000 Euro) Durrës 4 15 Sarandë 2 8 Fier 5 21 Berat 6 24 Lezhë 3 17 S S = 1.58 S = 6.1 a) What is the dependent variable?b) Construct the scatterdiagram of this connection.c) Calculate the coefficient of variation and the coefficient of determination.d) Interpret the relationship between two variables.e) What is the equation that connects these two variables? Explain the values for a and b.f) What is the expected level of sales if 10 ads are trasmittedarrow_forwardA manager of a large corporation recommends a $10,000 raise be given to keep a valuedsubordinate from moving to another company. What internal and external sources of datamight be used to decide whether such a salary increase is appropriate?arrow_forward
- A Wall Street firm is trying to package nine mortgages for sale. The sizes of the mortgages (in thousands of dollars) are listed in the file P08_27.xlsx. To be sold, each package must consist of at least $1,000,000 in mortgages. What is the largest number of packages that can be created? Number of packages: Mortgage data Mortgage Amount 1 910 2 870 3 810 4 640 5 550 6 250 7 120 8 95 9 55arrow_forwardWorkers in Company XYZ used 200 computers for their daily operation. In that company, the computers are categorized into type A and B. The workers usually complained that they experience performance problems with the computers more than once per week. Based on a survey, the company found that fifty of the Type A computers will encounter problems more than once per week. Meanwhile seventy-five of the Type B computers do not experience problems more than once per week. There are 120 Type B computers in the company. Based on the above scenario determined whether the events “Type A computer” and “experience problems more than once per week” are independent event? Explain.arrow_forwardThe owner of Blackstone Inc. opened 3 stores in different parts of the city and would like to compare the number of sales transactions made after 2 months of operation. The number of sales transactions at the 3 stores are displayed in the chart below: Number of Transactions 250 200 150 100 50 140 180 170 194 SUBMIT QUESTION 2 156 184 Month 1 Month 2 SAVE PROGRESS SUYarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Statistics 4.1 Point Estimators; Author: Dr. Jack L. Jackson II;https://www.youtube.com/watch?v=2MrI0J8XCEE;License: Standard YouTube License, CC-BY
Statistics 101: Point Estimators; Author: Brandon Foltz;https://www.youtube.com/watch?v=4v41z3HwLaM;License: Standard YouTube License, CC-BY
Central limit theorem; Author: 365 Data Science;https://www.youtube.com/watch?v=b5xQmk9veZ4;License: Standard YouTube License, CC-BY
Point Estimate Definition & Example; Author: Prof. Essa;https://www.youtube.com/watch?v=OTVwtvQmSn0;License: Standard Youtube License
Point Estimation; Author: Vamsidhar Ambatipudi;https://www.youtube.com/watch?v=flqhlM2bZWc;License: Standard Youtube License