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
Question
Chapter 4, Problem 1.16PE
To determine
Find the 20th percentile of home price by using formula.
Find the 80th percentile of home price by using formula.
Find the 20th percentile of home price by using Excel
Find the 80th percentile of home price by using Excel function.
Find the 20th percentile of home price by using Excel tool.
Find the 80th percentile of home price by using Excel tool.
Compare the results.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Find the percentage of data that lies below -2.40, above 1.73, and between -2.40 and 1.73
Find the z-score that corresponds to the 63rd percentile
Find the percentage of data points that lie between -2.31 and 1.85.
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
- Find the percent of 16/20 and 4/20. What are the relationships between the answers?arrow_forwardDraw anything that represents the position, Be in decile, quartile, and percentile.arrow_forwardI finished first in the high jump and third in the pole vault. determine whether the data described are nominal or ordinal?arrow_forward
- Mean, median, mode comparisonarrow_forwardWrite the equation for the line of best fit for the data in item 1 round values to the nearest whole number. The data is below.arrow_forwardName 1.8- Percentiles and cumulative relative frequency Exit Ticket 1. According to a 2019 article at Insider.com, the state of Pennsylvania was at the 82nd percentile for Pre-K to 12th grade education and was at the 0th percentile for higher education. Explain what these values mean. 2. The graph displays the cumulative relative frequency of the cost of in-state public college education for each of the 50 states. a b. Cumulative relative frequency (%) 120 100 80 60 40 20 0 0 2000 4000 6000 8000 10000 12000 14000 In-State Public College Tuition (S) AP Stats 16000 Estimate Q₁, Q₁, and the IQR of the distribution of phone in-state public tuition. About what percent of states have in-state public college tuition less than or equal to $8000? More than $8000?arrow_forward
- Find the 45th-Percentile: Pu5 =arrow_forwardHelparrow_forwardA professor grades students on 5 tests, a project, and a final examination. Each test counts as 10% of the course grade. The project counts as 20% of the course grade. The final examination counts as 30% of the course grade. Vanessa has test scores of 70, 65, 82, 94, and 85. Vanessa’s project score is 92. Her final examination score is 80. Use the weighted mean formula to find Vanessa’s average for the course.arrow_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
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
The Shape of Data: Distributions: Crash Course Statistics #7; Author: CrashCourse;https://www.youtube.com/watch?v=bPFNxD3Yg6U;License: Standard YouTube License, CC-BY
Shape, Center, and Spread - Module 20.2 (Part 1); Author: Mrmathblog;https://www.youtube.com/watch?v=COaid7O_Gag;License: Standard YouTube License, CC-BY
Shape, Center and Spread; Author: Emily Murdock;https://www.youtube.com/watch?v=_YyW0DSCzpM;License: Standard Youtube License