APPLIED STAT.IN BUS.+ECONOMICS
6th Edition
ISBN: 9781259957598
Author: DOANE
Publisher: RENT MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
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
SCIE 211 Lab 3: Graphing and DataWorksheetPre-lab Questions:1. When should you use each of the following types of graphs? Fill answers in the table below.Type of Graph Used to showLine graphScatter plotBar graphHistogramPie Chart2. Several ways in which we can be fooled or misled by a graph were identified in the Lab 3Introduction. Find two examples of misleading graphs on the Internet and paste them below. Besure to identify why each graph is misleading.
Data Charts:Circumference vs. Diameter for circular objectsDiameter Can 1 (cm) Can 2 (cm) Can 3 (cm)Trial 1Trial 2Trial 3MeanCircumference Can 1 (cm) Can 2 (cm) Can 3 (cm)Trial 1Trial 2Trial 3MeanScatter Plot Graph – Circumference Vs. DiameterIdentify 2 points of the Trendline.Y1 = ________ Y2 = _________X1 = ________ X2 = _________Calculate the Slope of the Trendline =
Post-lab Questions:1. Answer the questions below. You will need to use the following equation to answer…
The U.S. Bureau of Labor Statistics reports that 11.3% of U.S. workers belong to unions (BLS website, January 2014). Suppose a sample of 400 U.S. workers is collected in 2014 to determine whether union efforts to organize have increased union membership.
a. Formulate the hypotheses that can be used to determine whether union membership increased in 2014.H 0: p H a: p
b. If the sample results show that 52 of the workers belonged to unions, what is the p-value for your hypothesis test (to 4 decimals)?
A company manages an electronic equipment store and has ordered
200200
LCD TVs for a special sale. The list price for each TV is
$200200
with a trade discount series of
6 divided by 10 divided by 2.6/10/2.
Find the net price of the order by using the net decimal equivalent.
Chapter 3 Solutions
APPLIED STAT.IN BUS.+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 - (a) Make a stacked dot plot to compare the lengths...Ch. 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 - The table shows the number of TVs sold by a major...Ch. 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 - An executives telephone log showed the following...Ch. 3 - Below are batting averages of the New York Yankees...Ch. 3 - Prob. 31CECh. 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 - (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. 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
- According to flightstats.com, American Airlines flights from Dallas to Chicago are on time 80% of the time. Suppose 10 flights are randomly selected, and the number of on-time flights is recorded. (a) Explain why this is a binomial experiment. (b) Determine the values of n and p. (c) Find and interpret the probability that exactly 6 flights are on time. (d) Find and interpret the probability that fewer than 6 flights are on time. (e) Find and interpret the probability that at least 6 flights are on time. (f) Find and interpret the probability that between 4 and 6 flights, inclusive, are on time.arrow_forwardShow how you get critical values of 1.65, -1.65, and $1.96 for a right-tailed, left- tailed, and two-tailed hypothesis test (use a = 0.05 and assume a large sample size).arrow_forwardSuppose that a sports reporter claims the average football game lasts 3 hours, and you believe it's more than that. Your random sample of 35 games has an average time of 3.25 hours. Assume that the population standard deviation is 1 hour. Use a = 0.05. What do you conclude?arrow_forward
- Suppose that a pizza place claims its average pizza delivery time is 30 minutes, but you believe it takes longer than that. Your sample of 10 pizzas has an average delivery time of 40 minutes. Assume that the population standard deviation is 15 minutes and the times have a normal distribution. Use a = 0.05. a. What are your null and alternative hypotheses? b. What is the critical value? c. What is the test statistic? d. What is the conclusion?arrow_forwardTable 5: Measurement Data for Question 9 Part Number Op-1, M-1 Op-1, M-2 | Op-2, M-1 Op-2, M-2 | Op-3, M-1 Op-3, M-2 1 21 20 20 20 19 21 2 24 23 24 24 23 24 3 4 5 6 7 8 9 10 11 21 12 8222332 201 21 20 22 20 22 27 27 28 26 27 28 19 18 19 21 24 21 22 19 17 18 24 23 25 25 23 26 20 20 18 19 17 13 23 25 25 2 3 3 3 3 2 3 18 18 21 21 23 22 24 22 20 19 23 24 25 24 20 21 19 18 25 25 14 24 24 23 25 24 15 29 30 30 28 31 16 26 26 25 26 25 17 20 20 19 20 20 843882388 20 18 25 20 19 25 25 30 27 20 18 19 21 19 19 21 23 19 25 26 25 24 25 25 20 19 19 18 17 19 17 Question 9 A measurement systems experiment involving 20 parts, three operators (Op-1, Op-2, Op-3), and two measure- ments (M-1, M-2) per part is shown in Table 5. (a) Estimate the repeatability and reproducibility of the gauge. (b) What is the estimate of total gauge variability?" (c) If the product specifications are at LSL = 6 and USL 60, what can you say about gauge capability?arrow_forwardQuestion 5 A fraction nonconforming control chart with center line 0.10, UCL = 0.19, and LCL = 0.01 is used to control a process. (a) If three-sigma limits are used, find the sample size for the control charte 2 (b) Use the Poisson approximation to the binomial to find the probability of type I error. (c) Use the Poisson approximation to the binomial to find the probability of type II error if the process fraction defective is actually p = 0.20.arrow_forward
- Question 8 Ten parts are measured three times by the same operator in a gauge capability study. The data are shown in Table 4. (a) Describe the measurement error that results from the use of this gauge. I (b) Estimate total variability and product variability. (c) What percentage of total variability is due to the gauge? (d) If specifications on the part are at 100±15, find the P/T ratio for this gauge. Comment on the adequacy of the gauge. 3 Table 4: Measurement Data for Question 8 Part Number Measurement 1 Measurement 2 Measurement 3 1 2 100 95 101 100 93 97 3 101 103 100 4 96 95 97 5 98 98 96 6 99 98 98 7889 95 97 98 100 99 98 100 100 97 10 100 98 98 99arrow_forwardQuestion 6 The data shown in Table 3 are and R values for 24 samples of size n = 5 taken from a process producing bearings. The measurements are made on the inside diameter of the bearing, with only the last three decimals recorded (i.e., 34.5 should be 0.50345). Perform a process capability analysis using and R charts for the data from Table 3. Table 3: Data for Question 6 Sample Number R | Sample Number I Ꭱ 1 34.5 3 13 35.4 8 2 34.2 4 14 34.0 6 ∞∞ 31.6 15 37.1 5 4 31.5 4 16 34.9 7 56789 35.0 5 17 33.5 4 34.1 6 18 31.7 3 32.6 4 19 34.0 8 33.8 3 20 35.1 4 34.8 7 10 33.6 8 11 31.9 3 12 38.6 9 2232 21 33.7 2 32.8 1 33.5 24 34.2 2 32 3arrow_forwardQuestion 1 The commercial loan operation of a financial institution has a standard for processing new loan applications in 24 hours. Table 1 shows the number of applications processed each day for the last 20 days and the number of applications that required more than 24 hours to complete. Table 1: Loan Application Data for Question 1 Day Applications Late Day Applications Late 1 200 3 11 219 0 2 250 4 12 238 10 3 240 2 13 250 4 4 300 5 14 302 6 5 200 2 15 219 20 6 250 4 16 246 3 7 246 3 17 251 6 8 258 5 18 273 7 9 275 2 19 245 3 10 274 1 20 260 (a) Set up the fraction nonconforming control chart for this process. Use the variable-width control limit approach. Plot the preliminary data in Table 1 on the chart. Is the process in statistical control? (b) Assume that assignable causes can be found for any out-of-control points on this chart. What center line should be used for process monitoring in the next period, and how should the control limits be calculated?arrow_forward
- help me with ab please. please handwrite if possible. please don't use AI tools to answerarrow_forwardhelp me with ab please. please handwrite if possible. please don't use AI tools to answerarrow_forwardhelp me with abcd please. please handwrite if possible. please don't use AI tools to answerarrow_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
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
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
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