
Applied Statistics in Business and Economics
5th Edition
ISBN: 9780077837303
Author: David Doane, Lori Seward Senior Instructor of Operations Management
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 3.5, Problem 15SE
a.
To determine
Construct a line chart to display the gasoline price data using excel.
b.
To determine
Change the chart obtained in part (a) to a 2-D column chart.
c.
To determine
Explain whether the line chart or the 2-D column chart is preferred.
Expert Solution & Answer

Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Using the accompanying Home Market Value data and associated regression line,
Market ValueMarket Valueequals=$28,416+$37.066×Square
Feet, compute the errors associated with each observation using the formula
e Subscript ieiequals=Upper Y Subscript iYiminus−ModifyingAbove Upper Y with caret Subscript iYi
and construct a frequency distribution and histogram.
LOADING...
Click the icon to view the Home Market Value data.
Question content area bottom
Part 1
Construct a frequency distribution of the errors,
e Subscript iei.
(Type whole numbers.)
Error
Frequency
minus−15 comma 00015,000less than<
e Subscript iei
less than or equals≤minus−10 comma 00010,000
0
minus−10 comma 00010,000less than<
e Subscript iei
less than or equals≤minus−50005000
5
minus−50005000less than<
e Subscript iei
less than or equals≤0
21
0less than<
e Subscript iei
less than or equals≤50005000
9…
The managing director of a consulting group has the accompanying monthly data on total overhead costs and professional labor hours to bill to clients. Complete parts a through c
Overhead Costs Billable Hours345000 3000385000 4000410000 5000462000 6000530000 7000545000 8000
Using the accompanying Home Market Value data and associated regression line,
Market ValueMarket Valueequals=$28,416plus+$37.066×Square
Feet, compute the errors associated with each observation using the formula
e Subscript ieiequals=Upper Y Subscript iYiminus−ModifyingAbove Upper Y with caret Subscript iYi
and construct a frequency distribution and histogram.
Square Feet Market Value1813 911001916 1043001842 934001814 909001836 1020002030 1085001731 877001852 960001793 893001665 884001852 1009001619 967001690 876002370 1139002373 1131001666 875002122 1161001619 946001729 863001667 871001522 833001484 798001589 814001600 871001484 825001483 787001522 877001703 942001485 820001468 881001519 882001518 885001483 765001522 844001668 909001587 810001782 912001483 812001519 1007001522 872001684 966001581 86200
Chapter 3 Solutions
Applied Statistics in Business and Economics
Ch. 3.1 - (a) Make a stem-and-leaf plot for these 24...Ch. 3.1 - (a) Make a stem-and-leaf plot for the number of...Ch. 3.1 - Prob. 3SECh. 3.2 - (a) The table shows the number of days on the...Ch. 3.2 - (a) The table shows raw scores on a state civil...Ch. 3.2 - (a) Make a frequency distribution and histogram...Ch. 3.2 - (a) Make a frequency distribution and histogram...Ch. 3.2 - (a) Make a frequency distribution and histogram...Ch. 3.2 - For each frequency distribution, suggest nice...Ch. 3.2 - Below are sorted data showing average spending per...
Ch. 3.4 - (a) Use Excel to prepare a line chart to display...Ch. 3.4 - Prob. 12SECh. 3.4 - Prob. 13SECh. 3.4 - (a) Use Excel to prepare a line chart to display...Ch. 3.5 - Prob. 15SECh. 3.5 - Prob. 16SECh. 3.6 - (a) Use Excel to prepare a 2-D pie chart for these...Ch. 3.6 - Prob. 19SECh. 3.6 - Prob. 20SECh. 3.7 - (a) Use Excel to make a scatter plot of the data...Ch. 3.7 - Prob. 22SECh. 3.7 - Prob. 23SECh. 3.7 - (a) Use Excel to make a scatter plot of the data,...Ch. 3 - Name two attractive features and two limitations...Ch. 3 - (a) What is a frequency distribution? (b) What are...Ch. 3 - (a) What is a histogram? (b) What does it show?Ch. 3 - (a) What is a bimodal histogram? (b) Explain the...Ch. 3 - (a) What is a scatter plot? (b) What do scatter...Ch. 3 - For what kind of data would we use a bar chart?...Ch. 3 - For what kind of data would we use a line chart?...Ch. 3 - (a) List the three most common types of charts in...Ch. 3 - (a) For what kind of data would we use a pie...Ch. 3 - Which types of charts can be used for time series...Ch. 3 - (a) When might we need a log scale? (b) What do...Ch. 3 - When might we use a stacked column chart? An area...Ch. 3 - List five deceptive graphical techniques.Ch. 3 - What is a pivot table? Why is it useful?Ch. 3 - The durations (minutes) of 26 electric power...Ch. 3 - The U.S. Postal Service will ship a Priority Mail,...Ch. 3 - A study of 40 U.S. cardiac care centers showed the...Ch. 3 - Prob. 28CECh. 3 - Prob. 29CECh. 3 - Below are batting averages of the New York Yankees...Ch. 3 - Download the full data set of measurements of...Ch. 3 - Prob. 32CECh. 3 - Download the full data set from the McGraw-Hill...Ch. 3 - (a) What kind of display is this? (b) Identify its...Ch. 3 - (a) What kind of display is this? (b) Identify its...Ch. 3 - Prob. 36CECh. 3 - (a) What kind of display is this? (b) Identify its...Ch. 3 - Prob. 38CECh. 3 - (a) What kind of display is this? (b) Identify its...Ch. 3 - (a) What kind of display is this? (b) Identify its...Ch. 3 - Prob. 41CECh. 3 - Prob. 42CECh. 3 - (a) Use Excel to prepare an appropriate type of...Ch. 3 - Prob. 44CECh. 3 - Prob. 45CECh. 3 - (a) Use Excel to prepare an appropriate type of...Ch. 3 - Prob. 47CECh. 3 - (a) Use Excel to prepare an appropriate type of...
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
- For a binary asymmetric channel with Py|X(0|1) = 0.1 and Py|X(1|0) = 0.2; PX(0) = 0.4 isthe probability of a bit of “0” being transmitted. X is the transmitted digit, and Y is the received digit.a. Find the values of Py(0) and Py(1).b. What is the probability that only 0s will be received for a sequence of 10 digits transmitted?c. What is the probability that 8 1s and 2 0s will be received for the same sequence of 10 digits?d. What is the probability that at least 5 0s will be received for the same sequence of 10 digits?arrow_forwardV2 360 Step down + I₁ = I2 10KVA 120V 10KVA 1₂ = 360-120 or 2nd Ratio's V₂ m 120 Ratio= 360 √2 H I2 I, + I2 120arrow_forwardQ2. [20 points] An amplitude X of a Gaussian signal x(t) has a mean value of 2 and an RMS value of √(10), i.e. square root of 10. Determine the PDF of x(t).arrow_forward
- In a network with 12 links, one of the links has failed. The failed link is randomlylocated. An electrical engineer tests the links one by one until the failed link is found.a. What is the probability that the engineer will find the failed link in the first test?b. What is the probability that the engineer will find the failed link in five tests?Note: You should assume that for Part b, the five tests are done consecutively.arrow_forwardProblem 3. Pricing a multi-stock option the Margrabe formula The purpose of this problem is to price a swap option in a 2-stock model, similarly as what we did in the example in the lectures. We consider a two-dimensional Brownian motion given by W₁ = (W(¹), W(2)) on a probability space (Q, F,P). Two stock prices are modeled by the following equations: dX = dY₁ = X₁ (rdt+ rdt+0₁dW!) (²)), Y₁ (rdt+dW+0zdW!"), with Xo xo and Yo =yo. This corresponds to the multi-stock model studied in class, but with notation (X+, Y₁) instead of (S(1), S(2)). Given the model above, the measure P is already the risk-neutral measure (Both stocks have rate of return r). We write σ = 0₁+0%. We consider a swap option, which gives you the right, at time T, to exchange one share of X for one share of Y. That is, the option has payoff F=(Yr-XT). (a) We first assume that r = 0 (for questions (a)-(f)). Write an explicit expression for the process Xt. Reminder before proceeding to question (b): Girsanov's theorem…arrow_forwardProblem 1. Multi-stock model We consider a 2-stock model similar to the one studied in class. Namely, we consider = S(1) S(2) = S(¹) exp (σ1B(1) + (M1 - 0/1 ) S(²) exp (02B(2) + (H₂- M2 where (B(¹) ) +20 and (B(2) ) +≥o are two Brownian motions, with t≥0 Cov (B(¹), B(2)) = p min{t, s}. " The purpose of this problem is to prove that there indeed exists a 2-dimensional Brownian motion (W+)+20 (W(1), W(2))+20 such that = S(1) S(2) = = S(¹) exp (011W(¹) + (μ₁ - 01/1) t) 롱) S(²) exp (021W (1) + 022W(2) + (112 - 03/01/12) t). where σ11, 21, 22 are constants to be determined (as functions of σ1, σ2, p). Hint: The constants will follow the formulas developed in the lectures. (a) To show existence of (Ŵ+), first write the expression for both W. (¹) and W (2) functions of (B(1), B(²)). as (b) Using the formulas obtained in (a), show that the process (WA) is actually a 2- dimensional standard Brownian motion (i.e. show that each component is normal, with mean 0, variance t, and that their…arrow_forward
- The scores of 8 students on the midterm exam and final exam were as follows. Student Midterm Final Anderson 98 89 Bailey 88 74 Cruz 87 97 DeSana 85 79 Erickson 85 94 Francis 83 71 Gray 74 98 Harris 70 91 Find the value of the (Spearman's) rank correlation coefficient test statistic that would be used to test the claim of no correlation between midterm score and final exam score. Round your answer to 3 places after the decimal point, if necessary. Test statistic: rs =arrow_forwardBusiness discussarrow_forwardBusiness discussarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman

MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc

Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning

Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning

Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON

The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman

Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
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