Business Analytics (2nd Edition)
2nd Edition
ISBN: 9780321997821
Author: James R. Evans
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 3, Problem 40PE
Create useful dashboards for each of the following databases. Use appropriate charts and layouts (for example, Explain why you chose the elements of the dashboards and how a manager might use them.
- President’s Inn
- Restaurant Sales
- Store and Regional Sales
- Peoples Choice Bank
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Could you fill out this chart?
Write a 1-page memo to the CEO. Include each chart (3) and a paragraph per chart. Each paragraph should explain the story of each visualization and explain why visualizations are important.
STEP 2Income CATEGORIES PERCENTAGE NUMBER$100,000 to $124,999 8% 2$125,000 to $149,999 4% 1$20,000 to $24,999 4% 1$25,000 to $34,999 29% 7$35,000 to $49,999 13% 3$50,000 to $74,999 17% 4$75,000 to $99,999 21% 5Decline to answer 4% 1 24STEP 3GENDER PERCENTAGE NUMBERFemale 54% 13Male 46% 11 24STEP 4QUESTION RESPONSES PERCENTAGE NUMBER 0 6% 1 2…
Please analyze these tables one by one . Explain as table 1 and table 2.
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
- Can you fill out this chart?arrow_forwardThe basketball coach at a local college believes that his team scores more points at home games when more people show up. Below is a list of all home games last year with scores and corresponding attendance. Use Excel, SPSS, or work by hand to show your work finding r. Show your work on the attached pages. Score Attendance Score Attendance 54 380 67 410 57 350 78 215 59 320 67 113 80 478 56 250 82 451 85 450 75 250 101 489 73 489 99 472 53 451 What is the obtained t-score for this correlation? What is the critical t-score for a two-tailed test with a = 0.05? Is this correlation significant based on the t-scores?arrow_forwardThe basketball coach at a local college believes that his team scores more points at home games when more people show up. Below is a list of all home games last year with scores and corresponding attendance. Use Excel, SPSS, or work by hand to show your work finding r. Show your work on the attached pages. Score Attendance Score Attendance 54 380 67 410 57 350 78 215 59 320 67 113 80 478 56 250 82 451 85 450 75 250 101 489 73 489 99 472 53 451 g. What is the coefficient of determination for this relationship? h. Interpret for these two variables presuming a causal relationship was expected.arrow_forward
- The basketball coach at a local college believes that his team scores more points at home games when more people show up. Below is a list of all home games last year with scores and corresponding attendance. Use Excel, SPSS, or work by hand to show your work finding r. Show your work on the attached pages. Score Attendance Score Attendance 54 380 67 410 57 350 78 215 59 320 67 113 80 478 56 250 82 451 85 450 75 250 101 489 73 489 99 472 53 451 a. What is the correlation between Score and Attendance rounded to 2 decimals? b. In terms of strength and direction, how would you describe this correlation? c. What is the obtained t-score for this correlation? d. What is the critical t-score for a two-tailed test with a ? e. Is this correlation significant based on the t-scores? f. Based on Table 10.4, approximately how many cases would you expect to need to…arrow_forwardThe following place value chart is partially labeled and represents numbers greater than or equal to 1. Refer to resource place value and large and small number if you need helparrow_forwardApply table to question.arrow_forward
- Answer using MS Excel. The following table shows the values in General Government Consumption Expenditure (in US) for the Philippines from 2007 to 2016. General government final consumption expenditure includes all government current expenditures for purchases of goods and services (including compensation of employees.) It also includes most expenditures on national defense and security but excludes government military expenditures that are part of government capital formation. (Source: World Bank national accounts data, and OECD National Accounts data files.) Year Consumption Expenditure 2007 $13,867,990,000 2008 $15,384,520,000 2009 $16,598,320,000 2010 $19,403,620,000 2011 $21,744,840,000 2012 $27,117,510,000 2013 $29,468,210,000 2014 $30,054,320,000 2015 $31,993,260,000 2016 $33,926,500,000 Use any statistical tool or program to construct a bar graph, a pie chart, and a line graph. Which…arrow_forwardPlease refer to table. Thanks!arrow_forwardSite images for background and question.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
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
what is Research Design, Research Design Types, and Research Design Methods; Author: Educational Hub;https://www.youtube.com/watch?v=LpmGSioXxdo;License: Standard YouTube License, CC-BY