3rd Edition

ISBN: 9780135231678

Author: Evans, James R. (james Robert)

Publisher: PEARSON EDUCATION (COLLEGE)

Concept explainers

The method used for finding the corresponding z-critical value in a normal distribution using the known probability is said to be an inverse normal distribution. The inverse normal distribution is a continuous probability distribution with a family of tw…

Mean, Median, Mode

It is a descriptive summary of a data set. It can be defined by using some of the measures. The central tendencies do not provide information regarding individual data from the dataset. However, they give a summary of the data set. The central tendency o…

Z-Scores

A z-score is a unit of measurement used in statistics to describe the position of a raw score in terms of its distance from the mean, measured with reference to standard deviation from the mean. Z-scores are useful in statistics because they allow compar…

Videos

Textbook Question

Chapter 2, Problem 15PE

Use the Excel file Credit Risk Data that was introduced in this chapter to perform the following activities

a. Compute the combined checking and savings account balance for each record in the Base Data worksheet. Then sort the records by the number of months as a customer of the bank. From examining the data, does it appear that customers with a longer association with the bank have more assets?
b. Apply Pareto analysis to draw conclusions about the combined amount of money in checking and savings accounts.
c. Use Excel’s filtering capability to extract all records for new-car loans. How many individuals with new-car loans are single, married, and divorced?
d. Use Excel’s filtering capability to extract all records for individuals employed less than 12 months. Can you draw any conclusions about the credit risk associated with these individuals?

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 2, Problem 14PE

Chapter 2, Problem 16PE

Students have asked these similar questions

NC Current Students - North Ce X | NC Canvas Login Links - North ( X Final Exam Comprehensive x Cengage Learning x WASTAT - Final Exam - STAT → C webassign.net/web/Student/Assignment-Responses/submit?dep=36055360&tags=autosave#question3659890_9 Part (b) Draw a scatter plot of the ordered pairs. N Life Expectancy Life Expectancy 80 70 600 50 40 30 20 10 Year of 1950 1970 1990 2010 Birth O Life Expectancy Part (c) 800 70 60 50 40 30 20 10 1950 1970 1990 W ALT 林 $ # 4 R J7 Year of 2010 Birth F6 4+ 80 70 60 50 40 30 20 10 Year of 1950 1970 1990 2010 Birth Life Expectancy Ox 800 70 60 50 40 30 20 10 Year of 1950 1970 1990 2010 Birth hp P.B. KA & 7 80 % 5 H A B F10 711 N M K 744 PRT SC ALT CTRL

Harvard University California Institute of Technology Massachusetts Institute of Technology Stanford University Princeton University University of Cambridge University of Oxford University of California, Berkeley Imperial College London Yale University University of California, Los Angeles University of Chicago Johns Hopkins University Cornell University ETH Zurich University of Michigan University of Toronto Columbia University University of Pennsylvania Carnegie Mellon University University of Hong Kong University College London University of Washington Duke University Northwestern University University of Tokyo Georgia Institute of Technology Pohang University of Science and Technology University of California, Santa Barbara University of British Columbia University of North Carolina at Chapel Hill University of California, San Diego University of Illinois at Urbana-Champaign National University of Singapore McGill…

Name Harvard University California Institute of Technology Massachusetts Institute of Technology Stanford University Princeton University University of Cambridge University of Oxford University of California, Berkeley Imperial College London Yale University University of California, Los Angeles University of Chicago Johns Hopkins University Cornell University ETH Zurich University of Michigan University of Toronto Columbia University University of Pennsylvania Carnegie Mellon University University of Hong Kong University College London University of Washington Duke University Northwestern University University of Tokyo Georgia Institute of Technology Pohang University of Science and Technology University of California, Santa Barbara University of British Columbia University of North Carolina at Chapel Hill University of California, San Diego University of Illinois at Urbana-Champaign National University of Singapore…

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.4CYU Ch. 2 - Prob. 3.1CYU Ch. 2 - Prob. 3.2CYU Ch. 2 - Prob. 3.3CYU

Ch. 2 - Prob. 4.1CYU Ch. 2 - In the Purchase Orders database, what will =...Ch. 2 - Prob. 4.3CYU Ch. 2 - Prob. 5.1CYU Ch. 2 - Prob. 5.2CYU Ch. 2 - Prob. 5.3CYU Ch. 2 - Prob. 5.4CYU Ch. 2 - Prob. 6.1CYU Ch. 2 - Prob. 6.2CYU Ch. 2 - Prob. 6.3CYU Ch. 2 - The Excel file MBA Motivation and Salary...Ch. 2 - Prob. 2PE Ch. 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. 6PE Ch. 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. 12PE Ch. 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. 17PE Ch. 2 - Prob. 18PE Ch. 2 - Modify the data in the Base Data worksheet in the...Ch. 2 - Prob. 20PE Ch. 2 - Figure 2.41 shows the 2016 U.S. federal income tax...Ch. 2 - For the Bicycle Inventory database, write a...Ch. 2 - Prob. 23PE Ch. 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. 27PE Ch. 2 - For this exercise, use the Purchase Orders...Ch. 2 - Use INDEX and MATCH functions to fill in a table...Ch. 2 - Prob. 30PE Ch. 2 - Prob. 31PE Ch. 2 - Prob. 32PE Ch. 2 - Prob. 33PE Ch. 2 - Prob. 34PE Ch. 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. 38PE Ch. 2 - Prob. 39PE Ch. 2 - Prob. 40PE Ch. 2 - Prob. 2.1C

Knowledge Booster

$Statistics$

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.

Solution Summary: The author explains how to calculate the combined checking and savings account balance for all the records in the Base Data worksheet.

Concept explainers

Videos

Want to see the full answer?

Chapter 2 Solutions