Business Analytics
3rd Edition
ISBN: 9780135231678
Author: Evans, James R. (james Robert)
Publisher: PEARSON EDUCATION (COLLEGE)
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 4, Problem 1.65PE
For the Excel file Credit Risk Data, compute the
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
In the early 2000s interest rates were low so many homeowners refinanced their home mortgages. Linda is a mortgage officer at Maybank Savings and Loan. Below is the amount refinanced for twenty loans she processed last week. The data are reported in thousands of dollars and arranged from smallest to largest.
59.2 59.5 61.6 65.5 66.6 72.9 74.8 77.3 79.2
83.7 85.6 85.8 86.6 87.0 87.1 90.2 93.3 98.6
100.2 100.7
a. Find the mean, median, 1stquartile and 3rd quartile
b. Draw a stem and leaf plot of the data using class width of 10
In recent years, due to low interest rates, many homeowners refinanced their home mortgages. Linda Lahey is a mortgage officer at
Down River Federal Savings and Loan. Below is the amount refinanced for 20 loans she processed last week. The data are reported in
thousands of dollars and arranged from smallest to largest.
59.2 59.5 61.6 65.5 66.6 72.9 74.8 77.3 79.2
83.7 85.6 85.8 86.6 87.0 87.1 90.2 93.3 98.6
100.2 100.7
Click here for the Excel Data File
a. Find the median, first quartile, and third quartile. (Enter your answers in thousands and round your answers to 2 decimal places.)
Median
First quartile
Third quartile
b. Find the 26th
26th Percentile
83rd Percentile
and 83rd
percentiles. (Enter your answers in thousands and round your answers to 2 decimal places.)
List one possible confounding variable for this analysis and explain what impact it might have on the variables of interest.
Chapter 4 Solutions
Business Analytics
Ch. 4 - Explain the science of statistics.Ch. 4 - What is a metric? How does it differ from a...Ch. 4 - Explain the difference between a discrete and a...Ch. 4 - Describe the four types of measurement scales and...Ch. 4 - What is a frequency distribution?Ch. 4 - Explain how to calculate a relative frequency.Ch. 4 - State how to use Excel for constructing frequency...Ch. 4 - State the features and limitations of the Excel...Ch. 4 - What does an ogive display?Ch. 4 - Prob. 2.6CYU
Ch. 4 - Prob. 3.1CYUCh. 4 - Prob. 3.2CYUCh. 4 - Prob. 3.3CYUCh. 4 - What is a cross-tabulation?Ch. 4 - Prob. 4.2CYUCh. 4 - Explain the difference between a population and a...Ch. 4 - List and explain the common measures of location...Ch. 4 - Prob. 5.3CYUCh. 4 - Prob. 5.4CYUCh. 4 - Prob. 5.5CYUCh. 4 - Prob. 5.6CYUCh. 4 - Prob. 5.7CYUCh. 4 - Prob. 5.8CYUCh. 4 - Prob. 6.1CYUCh. 4 - Use Excel to find the mean and variance for the...Ch. 4 - Prob. 7.1CYUCh. 4 - Prob. 7.2CYUCh. 4 - Prob. 8.1CYUCh. 4 - Prob. 8.2CYUCh. 4 - Prob. 9.1CYUCh. 4 - Prob. 9.2CYUCh. 4 - Prob. 9.3CYUCh. 4 - What rules are typically used to identify...Ch. 4 - Prob. 10.2CYUCh. 4 - Summarize statistical tools that are typically...Ch. 4 - Prob. 11.2CYUCh. 4 - What are the principles of statistical thinking?Ch. 4 - Prob. 12.2CYUCh. 4 - Prob. 12.3CYUCh. 4 - A survey handed out to individuals at a major...Ch. 4 - Prob. 1.2PECh. 4 - Identify each of the variables in the Excel file...Ch. 4 - Prob. 1.4PECh. 4 - Prob. 1.5PECh. 4 - Prob. 1.6PECh. 4 - Prob. 1.7PECh. 4 - Prob. 1.8PECh. 4 - Prob. 1.9PECh. 4 - Prob. 1.10PECh. 4 - Prob. 1.11PECh. 4 - Prob. 1.12PECh. 4 - Use a PivotTable to construct a frequency...Ch. 4 - Prob. 1.14PECh. 4 - Prob. 1.15PECh. 4 - Prob. 1.16PECh. 4 - Prob. 1.17PECh. 4 - Prob. 1.18PECh. 4 - Prob. 1.19PECh. 4 - Prob. 1.20PECh. 4 - Use a PivotTable to construct a cross-tabulation...Ch. 4 - Use PivotTables to construct cross-tabulations for...Ch. 4 - Prob. 1.23PECh. 4 - Prob. 1.24PECh. 4 - Prob. 1.25PECh. 4 - Compute the mean, median, midrange, and mode for...Ch. 4 - Considering the data in the Excel file Home Market...Ch. 4 - Considering the data in the Excel file Home Market...Ch. 4 - In the Excel file Facebook Survey, find the range,...Ch. 4 - Prob. 1.30PECh. 4 - For the Excel file Tablet Computer Sales, find the...Ch. 4 - The Excel file Atlanta Airline Data provides...Ch. 4 - Prob. 1.33PECh. 4 - Prob. 1.34PECh. 4 - Apply the Descriptive Statistics tool for subsets...Ch. 4 - Use the Descriptive Statistics tool to summarize...Ch. 4 - Prob. 1.38PECh. 4 - The Data worksheet in the Excel file Airport...Ch. 4 - Prob. 1.40PECh. 4 - Prob. 1.41PECh. 4 - Prob. 1.42PECh. 4 - Prob. 1.43PECh. 4 - Prob. 1.44PECh. 4 - Prob. 1.45PECh. 4 - Prob. 1.46PECh. 4 - Prob. 1.47PECh. 4 - Prob. 1.48PECh. 4 - Prob. 1.49PECh. 4 - Prob. 1.50PECh. 4 - Prob. 1.51PECh. 4 - Prob. 1.52PECh. 4 - Prob. 1.53PECh. 4 - In the Excel file Debt and Retirement Savings, use...Ch. 4 - Prob. 1.55PECh. 4 - Prob. 1.56PECh. 4 - Prob. 1.57PECh. 4 - Prob. 1.58PECh. 4 - Prob. 1.59PECh. 4 - In the Excel file Weddings, determine the...Ch. 4 - Prob. 1.61PECh. 4 - The Excel file Beverage Sales lists a sample of...Ch. 4 - For the Presidents Inn Guest Database, find the...Ch. 4 - Prob. 1.64PECh. 4 - For the Excel file Credit Risk Data, compute the...Ch. 4 - Compute the z-scores for the data in the Excel...Ch. 4 - Prob. 1.67PECh. 4 - In the Excel file Weddings, find the mean, median,...Ch. 4 - Use the following approaches to analyze the survey...Ch. 4 - Prob. 1.70PECh. 4 - A producer of computer-aided design software for...Ch. 4 - Prob. 1.72PECh. 4 - Prob. 1.73PECh. 4 - A Midwest pharmaceutical company manufactures...Ch. 4 - Find the mean and variance of a deck of 52 cards,...Ch. 4 - Elizabeth Burke has received several questions...
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
- The comparative income statement of Lawn Products, Inc. showed sales of $325,000 in 2004 and $494,450 in 2005. Compute the percentage of net change in sales. (Round answer to one decimal place.)arrow_forwardWhat was discharge rate for January 2, 2017? Admissions and discharges in hospital Jan. 1, 2017 Jan. 2, 2017 Jan. 3, 2017 Admissions 896 649 1,503 Discharges 764 543 672arrow_forwardSuppose that the Producer Price Index and the sales of Hoskin’s Wholesale Distributors for 2006 and 2018 are: What are Hoskin's real sales (also called deflated sales) for the 2 years? (Round your answers to the nearest whole dollar.)arrow_forward
- the following table provides the average price of regular grade gasoline for 4 years. Use 2015 as the reference value, complete the table by calculating the price index for each year. Show all your calculationarrow_forwardSales last year for a department were $124,560. This year planned sales are forecast to increase by 4.2%. What are planned sales for this year?arrow_forwardJohnson Outdoors Inc. had the following quarterly net incomes during its 2014 fiscal year. (Source: Johnsonoutdoors.com) Quarter of Fiscal 2014 Net Income (in millions) First $7.4 Second $4.7 Third -$0.8 Fourth -$2.2 What was the total net income for fiscal year 2014?arrow_forward
- In 2014, the median salary nationwide for a high school teacher was $56,310 per year. The median annual wage for all workers was $35,540.SOURCE: United States. Department of Labor. "High School Teachers." Occupational Outlook Handbook. 17 Dec. 2015. Web. 7 March 2016. Suppose a worker makes $29,000 in wages per year. Find the percent increase in salary the worker can expect if he/she trains to be a teacher and can expect to earn a salary of $40,000. Enter your response to the nearest 0.1% %arrow_forwardIf the average hourly earnings in mining in 1998 was $7.67 and for the most recent month it was $14.90, what is the index of hourly earnings for the most recent month based on 1998? 100.0 186.9 151.5 194.3 (Don't hand writing solution)arrow_forwardPlease show steps in Excel. The 32 teams in the National Football League (NFL) are worth, on average, $1.17 billion, 5% more than last year. The datafile NFLTEAMVALUE shows the annual revenue ($millions) and the estimated team value ($ millions) for the 32 NFL teams (Forbes website, February 28, 2014). a.Develop a scatter diagram with Revenue on the horizontal axis and Value on the vertical axis. Does there appear that there is any relationship between the two variables? b. What is the sample correlation coefficient? What can you say about the strength of the relationship between Revenue and Value? Team Revenue ($ millions) Current Value ($ millions) Arizona Cardinals 253 961 Atlanta Falcons 252 933 Baltimore Ravens 292 1,227 Buffalo Bills 256 870 Carolina Panthers 271 1,057 Chicago Bears 298 1,252 Cincinnati Bengals 250 924 Cleveland Browns 264 1,005 Dallas Cowboys 539 2,300 Denver Broncos 283 1,161 Detroit Lions 248 900 Green Bay Packers 282 1,183 Houston…arrow_forward
- Total revenue for a soda in January 2011 was $4,342,262, and total revenue in January 2013 was $4,429,964. See the data below. The soda company is requesting your help as manager to understand how price increases are affecting the quantity of sodas sold. Create a table with the descriptive statistics of the number of sodas sold in the two years, as well as an explanation of the descriptive statistics: What are some of the key aspects of the descriptive statistics that help you tell a story about the 2 years in sodas sold. Run a regression where you explain how price changes are affecting the quantity of sodas sold. Include an explanation of the coefficients as well as an explanation of the t-statistics, the intercept, the R-Squared, and the F-Statistic. Explain managerial recommendations to the soda company on how can you increase the revenue.arrow_forwardIf .99 cents is 80% off of the original price, how do I find the original price?arrow_forwardIf the markup on an item is 25.00% of its selling price, calculate the markup as a percentage of the cost of the item.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Elementary AlgebraAlgebraISBN:9780998625713Author:Lynn Marecek, MaryAnne Anthony-SmithPublisher:OpenStax - Rice University
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
Elementary Algebra
Algebra
ISBN:9780998625713
Author:Lynn Marecek, MaryAnne Anthony-Smith
Publisher:OpenStax - Rice University
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
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
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY