EBK BUSINESS ANALYTICS
3rd Edition
ISBN: 9780135231906
Author: Evans
Publisher: VST
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter A3, Problem 5PE
Use PivotCharts to create a useful dashboard for the data in the Excel file President’s Inn Guest Database. Explain why you chose the elements of the dashboard and how a manager might use them.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A clinic compared healthy dogs it owned with healthy pets brought to clinic to be neutered. The summary statistics for blood cholesterol levels (milligrams deciliter of blood) appear in the following table:
Types
n
Average
Standard deviation
Pets (P)
51
196
68.1
Clinic (C)
51
185
40.7
Difference (d = P - C)
51
11.0
44.0
(a) Find a 99% confidence interval for the difference in mean blood cholesterol levels dogs brought to the clinic (P) and dogs owned by the clinic (C).(Round your answers to 4 decimal places, if needed.)
( , )
b) Based on this confidence interval, can we conclude there is some differences in mean blood cholesterol levels between the two groups?
Yes, since the interval is completely above 0.
No, since the interval is completely above 0.
Yes, since the interval contains 0.
No, since the interval contains 0.
It is believed that animals living in northern regions have shorter appendages than animals living in southern regions. Random samples of birds were selected from each group and wing lengths for birds (in millimeters) were measured. The following table gives summary statistics.
Region
n
Average
Standard deviation
Northern (N)
30
118.2
1.7
Southern (S)
30
119.5
3.6
Difference (d = N - S)
30
-1.3
1.5
(a) Find a 98% confidence interval for the mean difference of wing lengths of birds between the northern regions and the southern regions. (Round your answers to 4 decimal places, if needed.)( , )
(b) Based on this confidence interval, is there enough evidence to support the belief?
Yes, since the interval contains 0.
No, since the interval is completely below 0.
No, since the interval contains 0.
Yes, since the interval is completely below 0.
Your investment advisor proposes a monthly income investment scheme which promises a variable income each month. You will invest in it only if you are assured an average monthly income of at least 780 dollars. Your advisor also tells you that, for the past 41 months, the scheme had incomes with an average value of 816 dollars and a standard deviation of 92 dollars.(a) Create a 95% confidence interval for the average monthly income of this scheme. (Round your answers to 4 decimal places, if needed.)
Chapter A3 Solutions
EBK BUSINESS ANALYTICS
Ch. A3 - Create a treemap for the regions, items, and units...Ch. A3 - Create a sunburst chart for the regions, items,...Ch. A3 - Use PivotTables to find the number of loans by...Ch. A3 - Use PivotCharts to create a useful dashboard for...Ch. A3 - Prob. 6PECh. A3 - Use PivotCharts to create a useful dashboard for...Ch. A3 - Prob. 9PE
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, subject and related others by exploring similar questions and additional content below.Similar questions
- A game at the local annual Apple Festival has players reach into a covered tub to pull out an apple. In the tub are 10 red apples, 3 green apples, and 1 yellow apple. Let R be the event of drawing a red apple, G be the event of drawing a green apple, and Y be the event of drawing a yellow apple. If a player draws a green apple, then the player has the choice of taking a $2 prize or (leaving the green apple out) reaching back into the tub for a chance to draw the yellow apple (which gives a prize of $20). There is no prize for drawing a red apple. First, find P(Rc). What does this mean regarding winning a prize on the first draw? Then, if on the first draw Deion pulls out a green apple, then decides to make a second draw instead of taking the $2 prize, what is the probability Deion will win at least $2?arrow_forwardThe table describes the distribution of a random sample S of 200 individuals, arranged by education level and income. Let events be defined as follows: A = the event the subject makes 0-25,000 dollars per year B = the event the subject makes 25,000-50,000 dollars per year C = the event the subject makes 50,000-75,000 dollars per year D = the event the subject makes 75,000-100,000 dollars per year E = the event the subject makes 100,000-125,000 dollars per year F = the event the subject makes 125,000-150,000 dollars per year G = the event the subject makes more than 150,000 dollars per year H = the event the subject has not graduated high school I = the event the subject has only graduated high school J = the event the subject has some college (but not a Bachelor’s degree) K = the event the subject’s highest level of education is a Bachelor’s degree L = the event the subject’s highest level of education is a graduate degree M = the event the subject has earned a post-graduate degree…arrow_forwardThe Graduate Record Examination (GRE) is an exam taken by students who are attempting to get into graduate schools. The exam has three sections, including a math section titled "Quantitative Reasoning. The scores on this section of the exam follow an approximately normal distribution with a mean of 150 and a standard deviation of 9. a. Label the values for the mean, along with the values for 1, 2, and 3 standard deviations away from the mean. b. What percent of GRE test takers score between 141 and 168? c. What proportion of GRE test takers score above 135? d. In order to get into Harvard graduate school, a GRE test taker would need to be in the top 9% of all test takers. What is the minimum score needed to achieve this?arrow_forward
- Date Participant numb Student November 3, 2024 School(in minute Non-school(in n WIFI/mobile data Yes/No 1 Berico, Luthze P. 2 Bertillo, shaina venus C. 5 510 Wifi Yes 10 360 Data Yes 3 Magdaluyo, john gabriel D. 10 300 Wifi Yes 4 Olayres, john christopher A. 10 360 Data Yes 5 Macuja, Hannah 10 360 wifi Yes November 4, 2024 1 Berico, Luthze P. 240 660 Wifi Yes 2 Bertillo, shaina venus C. 10 300 Data Yes 3 Magdaluyo, john gabriel D. 5 300 Wifi Yes 4 Olayres, john christopher A. 10 300 Data Yes 5 Macuja, Hannah 10 300 wifi Yes November 5, 2024 1 Berico, Luthze P. 300 600 Wifi Yes 2 Bertillo, shaina venus C. 20 70 Data Yes 3 Magdaluyo, john gabriel D. 5 300 Wifi No 4 Olayres, john christopher A. 15 240 Data Yes 5 Macuja, Hannah 20 70 Wifi Yes November 6, 2024 1 Berico, Luthze P. 480 180 Wifi Yes 2 Bertillo, shaina venus C. 60 150 Wifi No 3 Magdaluyo, john gabriel D. 5 360 Data No 4 Olayres, john christopher A. 30 240 wifi Yes 5 Macuja, Hannah 60 150 Data No November 7, 2024 1 Berico,…arrow_forwardWhat is the critical value? x^2? does the psychology reject or not?can the psychologist conclude or not?arrow_forwardStatisticsarrow_forward
- Use the data in the following table, which lists drive-thru order accuracy at popular fast food chains. Assume that orders are randomly selected from those included in the table. Drive-thru Restaurant A B C D Order Accurate 326 269 234 125 Order Not Accurate 31 59 32 10 If two orders are selected, find the probability that they are both accurate. Complete parts (a) and (b) below. a. Assume that the selections are made with replacement. Are the events independent? The probability is The events independent. (Do not round until the final answer. Round to four decimal places as needed.)arrow_forward2. (5 Points) (A) Design a double-sampling plan using Grubb's Tables with my-2m. -0.05, and p-0.10 where p-0.01 and p-0.10. Holding the stipulated consumer's risk is of primary concern if there are alternatives. (B) Under the above double sampling plan, find the probability of accepting l with 5% defective units.arrow_forwardStatisticsarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
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
Elementary AlgebraAlgebraISBN:9780998625713Author:Lynn Marecek, MaryAnne Anthony-SmithPublisher:OpenStax - Rice University
Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
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
Elementary Algebra
Algebra
ISBN:9780998625713
Author:Lynn Marecek, MaryAnne Anthony-Smith
Publisher:OpenStax - Rice University
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Matrix Operations Full Length; Author: ProfRobBob;https://www.youtube.com/watch?v=K5BLNZw7UeU;License: Standard YouTube License, CC-BY
Intro to Matrices; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=yRwQ7A6jVLk;License: Standard YouTube License, CC-BY