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 33PE
Use PivotTables to construct a cross-tabulation for the purpose of the loan and credit risk in the Excel file Credit Risk Data. Illustrate the results on a PivotChart.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
What would be a suitable chart type to show the proportions of the sales by products?
Describe the three primary charts and graphs used to organize and display data.
Draw a scatter diagram with square feet of living space as the independent variable and selling price as the dependent variable and describe variable and describe the relationship between the size of a house and the selling price.
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
- Explain the term Linearity?arrow_forwardThe data in the picture contains purchase data for golf purchases. Create a doughnut chart in Excel to compare the purchases by gender each year with the US population. Below the chart, explain what it illustrates.arrow_forwardBlock: _ Date. Five year-old Susie's parents are concerned that she seems short for her age. Their doctor has the followng rer of Susie' height: Age (months): 20 30 45 50 57 60 Height (cm): 80 86 87 90 91 94 (a) Make a scatterplot of these data:arrow_forward
- How does one do a trend analysis?arrow_forwardComplete the chase production plan, using the following information. The only costs you need to consider here are layoff, hiring, and inventory costs. If you complete the plan correctly, your hiring, layoff, and inventory costs should match those given here. Click the icon to view the costs table. Click the icon to view the forecasted sales. Fill in the production plan table below (enter your responses as whole numbers). More Info Totals Costs Cost of plan Month March Planning values Starting inventory Starting and ending workforce Hours worked per month per worker Hours per unit Hiring cost per worker Layoff cost per worker Monthly per-unit holding cost Print Forecasted sales 1,917 Sales in to meet worker sales hours average = 253 Layoff 256 $256,000 Done Hiring Inventory 256 18,000 $18,000 $1,024,000 $1,298,000 1,500 209 315 35 $4,000 $1,000 $1 Actual workers 209 Actual production Layoffs Hiring More Info Ending inventory 1,500 Month March April May June July August September October…arrow_forwardOver the years the U.S. grocery distribution and sales industry has grown. Today, the total industry sales are in the billions of dollars. Major retailers, such as Walmart and Target, added food to complement their merchandise sales and Amazon recently purchased Whole Foods. For many companies, forecasts of industry sales are necessary information to plan for short- and long-term decisions. Using the total U.S. grocery store annual sales in millions of dollars (https://www.census.gov/retail/index.html#mrts) in the following table, respond to the following items.arrow_forward
- The following table provides monthly revenue values for Tedstar, Inc., a company thatsells valves to large industrial firms. The monthly revenue data have been graphed usinga line chart in the following figure. a. What are the problems with the layout and display of this line chart?b. Create a new line chart for the monthly revenue data at Tedstar, Inc. Format the chartto make it easy to read and interpret.arrow_forwardUse Excel to construct a boxplot for the Presidential Heights data. Select the data in the worksheet and click the Insert tab in the top menu. Click Chart and then Box and Whisker. Click on the boxplot, click the Design tab in the top menu, click Add Chart Element, and choose the appropriate element that allows you to add a vertical axis label. PRESIDENT HEIGHT Washington 188 J. Adams 170 Jefferson 189 Madison 163 Monroe 183 J. Q. Adams 171 Jackson 185 Van Buren 168 Harrison 173 Polk 173 Taylor 173 Pierce 178 Buchanan 183 Lincoln 193 Grant 173 Hayes 173 Garfield 183 Cleveland 180 Harrison 168 McKinley 170 T. Roosevelt 178 Taft 182 Wilson 180 Harding 183 Coolidge 178 Hoover 182 F. Roosevelt 188 Truman 175 Eisenhower 179 J. Kennedy 183 Johnson 192 Nixon 182 Carter 177 Reagan 185 G. H. W. Bush 188 Clinton 188 G. W. Bush 183 Obama 188arrow_forwardIf you are performing a break-even analysis for a business and their cost and revenue equations are dependent, explain what this means for the company's profit margins.arrow_forward
- Please do help me with this one. It doesn't need calculation but understanding only. Classify each variable as a discrete or continuous variable. *The weight of baggage on an airplane. *Heights of basketball players on a local high school team. *The highest wind speed of a typhoon. *The number of pages in a statistics book. *The amount of money a person spends per year for online purchases. Please do help me. Please...arrow_forwardPLEASE USE THE TABLE PROVIDED TO ANSWER THE QUESTION: John Doe Films is producing the next Batman movie. With the information available for Public Opinion and money Collected on Opening Day, what is the projected amount of money that will be collected if surveys indicate a public opinion of 8.5 for the new Batman movie? Can this projected amount of money be considered an accurate amount? Construct any plot(s)/graph(s) to support your answer.arrow_forwardThe Quality Manager at SodaPop Inc. thinks that there is a relationship between the temperature of the productand the percent foam for a soda. Create a scatter diagram with the following data, from the last 20 days. Is theQuality Manager correct, is there a relationship between the variables? If so, how would you describe therelationship?Turn in your scatter diagram and a short answer to the questions above. Be sure to use good graphing techniques. DayProduct Temperature inDegress Celsius % Foam1 2.2222 152 3.3333 193 2.7778 214 6.6667 305 7.7778 366 3.8889 207 5.0000 258 8.3333 369 3.8889 2210 4.4444 2311 6.6667 3212 5.5556 3313 3.3333 2014 5.0000 2715 7.2222 3516 9.4444 3817 10.0000 4018 8.8889 4219 7.7778 4020 5.0000 30arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin HarcourtGlencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
- Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Time Series Analysis Theory & Uni-variate Forecasting Techniques; Author: Analytics University;https://www.youtube.com/watch?v=_X5q9FYLGxM;License: Standard YouTube License, CC-BY
Operations management 101: Time-series, forecasting introduction; Author: Brandoz Foltz;https://www.youtube.com/watch?v=EaqZP36ool8;License: Standard YouTube License, CC-BY