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
show work in paper
show all work (...or what you entered into your calculator...)
answer
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
- Question 2 The data below provides the battery life of thirty eight (38) motorcycle batteries. 100 83 83 105 110 81 114 99 101 105 78 115 74 96 106 89 94 81 106 91 93 86 79 103 94 108 113 100 117 120 77 93 93 85 76 89 78 88 680 a. Test the hypothesis that mean battery life is greater than 90. Use the 1% level of significance. b. Determine if the mean battery life is different from 80. Use the 10% level of significance. Show all steps for the hypothesis test c. Would your conlcusion in part (b) change at the 5% level of significance? | d. Confirm test results in part (b) using JASP. Note: All JASP input files and output tables should be providedarrow_forwardSuppose that 80% of athletes at a certain college graduate. You randomly select eight athletes. What’s the chance that at most 7 of them graduate?arrow_forwardSuppose that you flip a fair coin four times. What’s the chance of getting at least one head?arrow_forward
- Suppose that the chance that an elementary student eats hot lunch is 30 percent. What’s the chance that, among 20 randomly selected students, between 6 and 8 students eat hot lunch (inclusive)?arrow_forwardBob’s commuting times to work are varied. He makes it to work on time 80 percent of the time. On 12 randomly selected trips to work, what’s the chance that Bob makes it on time at least 10 times?arrow_forwardYour chance of winning a small prize in a scratch-off ticket is 10 percent. You buy five tickets. What’s the chance you will win at least one prize?arrow_forward
- Suppose that 60 percent of families own a pet. You randomly sample four families. What is the chance that two or three of them own a pet?arrow_forwardIf 40 percent of university students purchase their textbooks online, in a random sample of five students, what’s the chance that exactly one of them purchased their textbooks online?arrow_forwardA stoplight is green 40 percent of the time. If you stop at this light eight random times, what is the chance that it’s green exactly five times?arrow_forward
- If 10 percent of the parts made by a certain company are defective and have to be remade, what is the chance that a random sample of four parts has one that is defective?arrow_forwardQuestion 4 Fourteen individuals were given a complex puzzle to complete. The times in seconds was recorded for their first and second attempts and the results provided below: 1 2 3 first attempt 172 255 second attempt 70 4 5 114 248 218 194 270 267 66 6 7 230 219 341 174 8 10 9 210 261 347 218 200 281 199 308 268 243 236 300 11 12 13 14 140 302 a. Calculate a 95% confidence interval for the mean time taken by each individual to complete the (i) first attempt and (ii) second attempt. [la] b. Test the hypothesis that the difference between the two mean times for both is 100 seconds. Use the 5% level of significance. c. Subsequently, it was learnt that the times for the second attempt were incorrecly recorded and that each of the values is 50 seconds too large. What, if any, difference does this make to the results of the test done in part (b)? Show all steps for the hypothesis testarrow_forwardQuestion 3 3200 students were asked about the importance of study groups in successfully completing their courses. They were asked to provide their current majors as well as their opinion. The results are given below: Major Opinion Psychology Sociology Economics Statistics Accounting Total Agree 144 183 201 271 251 1050 Disagree 230 233 254 227 218 1162 Impartial 201 181 196 234 176 988 Total 575 597 651 732 645 3200 a. State both the null and alternative hypotheses. b. Provide the decision rule for making this decision. Use an alpha level of 5%. c. Show all of the work necessary to calculate the appropriate statistic. | d. What conclusion are you allowed to draw? c. Would your conclusion change at the 10% level of significance? f. Confirm test results in part (c) using JASP. Note: All JASP input files and output tables should be providedarrow_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