Gen Combo Ll Applied Statistics In Business & Economics; Connect Access Card
6th Edition
ISBN: 9781260260632
Author: David Doane, Lori Seward Senior Instructor of Operations Management
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 4.2, Problem 12SE
a.
a.
To determine
Find the
a.
a.
Expert Solution
Answer to Problem 12SE
The median of the vehicle speed is 68.
The geometric mean of the vehicle speed is 67.37013.
The midrange of the vehicle speed is 68.
Explanation of Solution
The speeds of 9 vehicles on highway I-5 are given.
Measures of center:
- Median is the middle value in an ordered sequence of data.
- Geometric mean is the multiplication all the data values in the sample by taking nth root of the product and will be affected in the case of zeros and negative values in the observation.
- Midrange is the point between the lowest and highest values of X that occurs in halfway.
Median:
Software procedure:
Step-by-step software procedure to obtain Median using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column J in cells J1 to J9.
- In cell A1, enter the formula “=MEDIAN(J1:J9)”.
- Output using EXCEL software is given below:
Thus, the median is 68.
Geometric mean:
Software procedure:
Step-by-step software procedure to obtain Geometric mean using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column J in cells J1 to J9.
- In cell A1, enter the formula “=GEOMEAN(J1:J9)”.
- Output using EXCEL software is given below:
Thus, the geometric mean is 67.37013.
Midrange:
Software procedure:
Step-by-step software procedure to obtain Midrange using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column J in cells J1 to J9.
- In cell A1, enter the formula “=(MIN(J1:J9)+MAX(J1:J9))/2”.
- Output using EXCEL software is given below:
- Thus, the midrange is 68.
b.
To determine
Decide whether the given measures are reasonable measures of
b.
Expert Solution
Answer to Problem 12SE
Yes, the given measures are reasonable measures of central tendency.
Explanation of Solution
From the data, it is observed that there occurs no extreme value. Median and mid-
Hence, the given measures are reasonable measures of central tendency.
b.
a.
To determine
Find the median, midrange and geometric mean of the sodium grams in the canned soup.
b.
a.
Expert Solution
Answer to Problem 12SE
The median of the sodium grams is 303.
The geometric mean of the sodium grams is 300.9403.
The midrange of the sodium grams is 295.5.
Explanation of Solution
The sodium grams in 8 varieties of canned soup are given.
Median:
Software procedure:
Step-by-step software procedure to obtain Median using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column K in cells K1 to K8.
- In cell A1, enter the formula “=MEDIAN(K1:K8)”.
- Output using EXCEL software is given below:
Thus, the median is 303.
Geometric mean:
Software procedure:
Step-by-step software procedure to obtain Geometric mean using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column K in cells K1 to K8.
- In cell A1, enter the formula “=GEOMEAN(K1:K8)”.
- Output using EXCEL software is given below:
Thus, the geometric mean is 300.9403.
Midrange:
Software procedure:
Step-by-step software procedure to obtain Midrange using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column K in cells K1 to K8.
- In cell A1, enter the formula “=(MIN(K1:K8)+MAX(K1:K8))/2”.
- Output using EXCEL software is given below:
- Thus, the midrange is 295.5.
b.
To determine
Decide whether the given measures are reasonable measures of central tendency.
b.
Expert Solution
Answer to Problem 12SE
Yes, the given measures are reasonable measures of central tendency.
Explanation of Solution
From the data, it is observed that there occurs no extreme value. Although the values of median, midrange and geometric mean are not equal, they are still quite close to each other. So, it is assumed to be acceptable.
Hence, the given measures are reasonable measures of central tendency.
c.
a.
To determine
Find the median, midrange and geometric mean of the annual campus health visits of 12 students.
c.
a.
Expert Solution
Answer to Problem 12SE
The median of the annual campus health visit is 1.5.
The Geometric mean of the annual campus health visit is not applicable.
The midrange of the annual campus health visit is 7.5.
Explanation of Solution
The annual campus health center visits of 12 students are given.
Median:
Software procedure:
Step-by-step software procedure to obtain Median using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column L in cells L1 to L12.
- In cell A1, enter the formula “=MEDIAN(L1:L12)”.
- Output using EXCEL software is given below:
Thus, the median is 1.5.
Geometric mean:
Here, the observations contain the value zero. As a result, the product of the values becomes zero and the geometric mean is not applicable.
Midrange:
Software procedure:
Step-by-step software procedure to obtain Midrange using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column L in cells L1 to L12.
- In cell A1, enter the formula “=(MIN(L1:L12)+MAX(L1:L12))/2”.
- Output using EXCEL software is given below:
- Thus, the midrange is 7.5.
b.
To determine
Decide whether the given measures are reasonable measures of central tendency.
b.
Expert Solution
Answer to Problem 12SE
No, the given measures are not all reasonable measures of central tendency
Explanation of Solution
From the data, it is observed that there occurs one extreme value, 15. Median and mid-range have extremely different values. Moreover, the value of the geometric mean is not defined. So, the measures are not all acceptable.
Hence, the given measures are not reasonable measures of central tendency.
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
The details of the clock sales at a supermarket for the past 6 weeks are shown in the table below. The time series appears to be relatively stable, without trend, seasonal, or cyclical effects. The simple moving average value of k is set at 2. Calculate the value of the simple moving average mean absolute percentage error. Round to two decimal places.
Week
Units sold
1
88
2
44
3
54
4
65
5
72
6
85
Part 1
A.
14.39
B.
25.56
C.
23.45
D.
20.90
The accompanying data shows the fossil fuels production, fossil fuels consumption, and total energy consumption in quadrillions of BTUs of a certain region for the years 1986 to 2015. Complete parts a and b.
Year Fossil Fuels Production Fossil Fuels Consumption Total Energy Consumption1949 28.748 29.002 31.9821950 32.563 31.632 34.6161951 35.792 34.008 36.9741952 34.977 33.800 36.7481953 35.349 34.826 37.6641954 33.764 33.877 36.6391955 37.364 37.410 40.2081956 39.771 38.888 41.7541957 40.133 38.926 41.7871958 37.216 38.717 41.6451959 39.045 40.550 43.4661960 39.869 42.137 45.0861961 40.307 42.758 45.7381962 41.732 44.681 47.8261963 44.037 46.509 49.6441964 45.789 48.543 51.8151965 47.235 50.577 54.0151966 50.035 53.514 57.0141967 52.597 55.127 58.9051968 54.306 58.502 62.4151969 56.286…
The accompanying data shows the fossil fuels production, fossil fuels consumption, and total energy consumption in quadrillions of BTUs of a certain region for the years 1986 to 2015. Complete parts a and b.
Year Fossil Fuels Production Fossil Fuels Consumption Total Energy Consumption1949 28.748 29.002 31.9821950 32.563 31.632 34.6161951 35.792 34.008 36.9741952 34.977 33.800 36.7481953 35.349 34.826 37.6641954 33.764 33.877 36.6391955 37.364 37.410 40.2081956 39.771 38.888 41.7541957 40.133 38.926 41.7871958 37.216 38.717 41.6451959 39.045 40.550 43.4661960 39.869 42.137 45.0861961 40.307 42.758 45.7381962 41.732 44.681 47.8261963 44.037 46.509 49.6441964 45.789 48.543 51.8151965 47.235 50.577 54.0151966 50.035 53.514 57.0141967 52.597 55.127 58.9051968 54.306 58.502 62.4151969 56.286…
Chapter 4 Solutions
Gen Combo Ll Applied Statistics In Business & Economics; Connect Access Card
Ch. 4.2 - (a) For each data set, find the mean, median, and...Ch. 4.2 - For each data set, is the mode a good measure of...Ch. 4.2 - For each data set, is the mode a good measure of...Ch. 4.2 - For each data set, which best indicates a typical...Ch. 4.2 - For each data set, which best indicates a typical...Ch. 4.2 - Days on the market are shown for the 36 most...Ch. 4.2 - Scores are shown for the most recent state civil...Ch. 4.2 - A vehicle emissions testing facility can process...Ch. 4.2 - CitiBank recorded the number of customers to use a...Ch. 4.2 - Prob. 10SE
Ch. 4.2 - Prob. 11SECh. 4.2 - Prob. 12SECh. 4.2 - (a) Write the Excel function for the 10 percent...Ch. 4.2 - Prob. 14SECh. 4.2 - Prob. 15SECh. 4.2 - Spirit Airlines kept track of the number of empty...Ch. 4.2 - CitiBank recorded the number of customers to use a...Ch. 4.2 - On Friday night, the owner of Chez Pierre in...Ch. 4.2 - Prob. 19SECh. 4.2 - The number of internet users in Latin America grew...Ch. 4.3 - (a) Find the mean and standard deviation for each...Ch. 4.3 - For each data set: (a) Find the mean. (b) Find the...Ch. 4.3 - In fuel economy tests in city driving conditions,...Ch. 4.3 - Over the past month, Bobs bowling score mean was...Ch. 4.3 - Prob. 25SECh. 4.3 - Prob. 26SECh. 4.3 - (a) Find the coefficient of variation for prices...Ch. 4.3 - Prob. 28SECh. 4.3 - Noodles and Company tested consumer reaction to...Ch. 4.4 - (a) By Chebyshevs Theorem, at least how many...Ch. 4.4 - An exam has a mean of 70 with a standard deviation...Ch. 4.4 - Prob. 32SECh. 4.4 - The mean collection period for accounts receivable...Ch. 4.4 - Convert each individual data value to a...Ch. 4.4 - Prob. 35SECh. 4.4 - Prob. 36SECh. 4.4 - Find the original data value corresponding to each...Ch. 4.4 - CitiBank recorded the number of customers to use a...Ch. 4.4 - Prob. 39SECh. 4.5 - Scores on an accounting exam ranged from 42 to 96,...Ch. 4.5 - In 2007, total compensation (in thousands of...Ch. 4.5 - Waiting times (minutes) for a table at Joeys BBQ...Ch. 4.5 - Coffee temperatures (degrees Fahrenheit) at a...Ch. 4.5 - Prob. 44SECh. 4.5 - On San Martin Boulevard, embedded sensors kept...Ch. 4.5 - Prob. 46SECh. 4.5 - Prob. 47SECh. 4.6 - For each X-Y data set (n = 12): (a) Make a scatter...Ch. 4.6 - Closing prices of two stocks are recorded for 50...Ch. 4.6 - Prob. 50SECh. 4.6 - Prob. 51SECh. 4.7 - Estimate the mean from this table of grouped data...Ch. 4.7 - Estimate the mean from the following table of...Ch. 4 - What are descriptive statistics? How do they...Ch. 4 - Explain each concept: (a) center, (b) variability,...Ch. 4 - Prob. 3CRCh. 4 - List strengths and weaknesses of each measure of...Ch. 4 - Prob. 5CRCh. 4 - (a) What is a bimodal distribution? (b) Explain...Ch. 4 - Prob. 7CRCh. 4 - Prob. 8CRCh. 4 - (a) Which standard deviation formula (population,...Ch. 4 - (a) To what kind of data does Chebyshevs Theorem...Ch. 4 - Prob. 11CRCh. 4 - Prob. 12CRCh. 4 - Prob. 13CRCh. 4 - Prob. 14CRCh. 4 - (a) Explain the method of medians for calculating...Ch. 4 - (a) What is a box plot? What does it tell us? (b)...Ch. 4 - Prob. 17CRCh. 4 - Prob. 18CRCh. 4 - Prob. 19CRCh. 4 - (a) What is kurtosis? (b) Sketch a platykurtic...Ch. 4 - Prob. 54CECh. 4 - If the mean asset turnover for retail firms is...Ch. 4 - Prob. 56CECh. 4 - During a rock concert, the noise level (in...Ch. 4 - Bags of jelly beans have a mean weight of 396 gm...Ch. 4 - Based on experience, the Ball Corporations...Ch. 4 - SAT scores for the entering class of 2010 at...Ch. 4 - Prob. 61CECh. 4 - The average time a Boulder High varsity lacrosse...Ch. 4 - Prob. 63CECh. 4 - Below are monthly rents paid by 30 students who...Ch. 4 - How many days in advance do travelers purchase...Ch. 4 - The durations (minutes) of 26 electric power...Ch. 4 - The U.S. Postal Service will ship a Priority Mail...Ch. 4 - Prob. 68CECh. 4 - Prob. 69CECh. 4 - Prob. 70CECh. 4 - Prob. 71CECh. 4 - A plumbing suppliers mean monthly demand for vinyl...Ch. 4 - Prob. 73CECh. 4 - Analysis of investment portfolio returns over a...Ch. 4 - Prob. 75CECh. 4 - Caffeine content in a 5-ounce cup of brewed coffee...Ch. 4 - Prob. 77CECh. 4 - Prob. 78CECh. 4 - Prob. 79CECh. 4 - Prob. 80CECh. 4 - Prob. 81CECh. 4 - Prob. 82CECh. 4 - Prob. 83CECh. 4 - The median waiting time for a liver transplant in...Ch. 4 - A small suburban community agreed to purchase...Ch. 4 - A companys contractual trigger point for a union...Ch. 4 - Prob. 87CECh. 4 - (a) Enter the Excel function...Ch. 4 - Note: In each of the following tables, the upper...Ch. 4 - This table shows the distribution of winning times...Ch. 4 - The self-reported number of hours worked per week...Ch. 4 - How long does it take to fly from Denver to...Ch. 4 - (a) Make an Excel scatter plot of X = 1990 assault...Ch. 4 - (a) Make an Excel scatter plot of X = airspeed...Ch. 4 - Prob. 97CECh. 4 - (a) Make an Excel scatter plot of X = weekly...Ch. 4 - Prob. 99CECh. 4 - Prob. 1ERQCh. 4 - Which is not an ethical obligation of a...Ch. 4 - Prob. 3ERQCh. 4 - Prob. 4ERQCh. 4 - Give the type of measurement (nominal, ordinal,...Ch. 4 - Prob. 6ERQCh. 4 - To choose a sample of 12 students from a...Ch. 4 - Which of the following is not a reason for...Ch. 4 - Which statement is correct? Why not the others? a....Ch. 4 - Prob. 10ERQCh. 4 - The management of a theme park obtained a random...Ch. 4 - Which one of the following is true? Why not the...Ch. 4 - Prob. 13ERQCh. 4 - Prob. 14ERQCh. 4 - Here are the ages of a random sample of 20 CEOs...Ch. 4 - Prob. 16ERQCh. 4 - Prob. 17ERQCh. 4 - Prob. 18ERQCh. 4 - Which is not a characteristic of using a log scale...
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 accompanying data shows the fossil fuels production, fossil fuels consumption, and total energy consumption in quadrillions of BTUs of a certain region for the years 1986 to 2015. Complete parts a and b. Develop line charts for each variable and identify the characteristics of the time series (that is, random, stationary, trend, seasonal, or cyclical). What is the line chart for the variable Fossil Fuels Production?arrow_forwardThe accompanying data shows the fossil fuels production, fossil fuels consumption, and total energy consumption in quadrillions of BTUs of a certain region for the years 1986 to 2015. Complete parts a and b. Year Fossil Fuels Production Fossil Fuels Consumption Total Energy Consumption1949 28.748 29.002 31.9821950 32.563 31.632 34.6161951 35.792 34.008 36.9741952 34.977 33.800 36.7481953 35.349 34.826 37.6641954 33.764 33.877 36.6391955 37.364 37.410 40.2081956 39.771 38.888 41.7541957 40.133 38.926 41.7871958 37.216 38.717 41.6451959 39.045 40.550 43.4661960 39.869 42.137 45.0861961 40.307 42.758 45.7381962 41.732 44.681 47.8261963 44.037 46.509 49.6441964 45.789 48.543 51.8151965 47.235 50.577 54.0151966 50.035 53.514 57.0141967 52.597 55.127 58.9051968 54.306 58.502 62.4151969 56.286…arrow_forwardFor each of the time series, construct a line chart of the data and identify the characteristics of the time series (that is, random, stationary, trend, seasonal, or cyclical). Month PercentApr 1972 4.97May 1972 5.00Jun 1972 5.04Jul 1972 5.25Aug 1972 5.27Sep 1972 5.50Oct 1972 5.73Nov 1972 5.75Dec 1972 5.79Jan 1973 6.00Feb 1973 6.02Mar 1973 6.30Apr 1973 6.61May 1973 7.01Jun 1973 7.49Jul 1973 8.30Aug 1973 9.23Sep 1973 9.86Oct 1973 9.94Nov 1973 9.75Dec 1973 9.75Jan 1974 9.73Feb 1974 9.21Mar 1974 8.85Apr 1974 10.02May 1974 11.25Jun 1974 11.54Jul 1974 11.97Aug 1974 12.00Sep 1974 12.00Oct 1974 11.68Nov 1974 10.83Dec 1974 10.50Jan 1975 10.05Feb 1975 8.96Mar 1975 7.93Apr 1975 7.50May 1975 7.40Jun 1975 7.07Jul 1975 7.15Aug 1975 7.66Sep 1975 7.88Oct 1975 7.96Nov 1975 7.53Dec 1975 7.26Jan 1976 7.00Feb 1976 6.75Mar 1976 6.75Apr 1976 6.75May 1976…arrow_forward
- Hi, I need to make sure I have drafted a thorough analysis, so please answer the following questions. Based on the data in the attached image, develop a regression model to forecast the average sales of football magazines for each of the seven home games in the upcoming season (Year 10). That is, you should construct a single regression model and use it to estimate the average demand for the seven home games in Year 10. In addition to the variables provided, you may create new variables based on these variables or based on observations of your analysis. Be sure to provide a thorough analysis of your final model (residual diagnostics) and provide assessments of its accuracy. What insights are available based on your regression model?arrow_forwardI want to make sure that I included all possible variables and observations. There is a considerable amount of data in the images below, but not all of it may be useful for your purposes. Are there variables contained in the file that you would exclude from a forecast model to determine football magazine sales in Year 10? If so, why? Are there particular observations of football magazine sales from previous years that you would exclude from your forecasting model? If so, why?arrow_forwardStat questionsarrow_forward
- 1) and let Xt is stochastic process with WSS and Rxlt t+t) 1) E (X5) = \ 1 2 Show that E (X5 = X 3 = 2 (= = =) Since X is WSSEL 2 3) find E(X5+ X3)² 4) sind E(X5+X2) J=1 ***arrow_forwardProve that 1) | RxX (T) | << = (R₁ " + R$) 2) find Laplalse trans. of Normal dis: 3) Prove thy t /Rx (z) | < | Rx (0)\ 4) show that evary algebra is algebra or not.arrow_forwardFor each of the time series, construct a line chart of the data and identify the characteristics of the time series (that is, random, stationary, trend, seasonal, or cyclical). Month Number (Thousands)Dec 1991 65.60Jan 1992 71.60Feb 1992 78.80Mar 1992 111.60Apr 1992 107.60May 1992 115.20Jun 1992 117.80Jul 1992 106.20Aug 1992 109.90Sep 1992 106.00Oct 1992 111.80Nov 1992 84.50Dec 1992 78.60Jan 1993 70.50Feb 1993 74.60Mar 1993 95.50Apr 1993 117.80May 1993 120.90Jun 1993 128.50Jul 1993 115.30Aug 1993 121.80Sep 1993 118.50Oct 1993 123.30Nov 1993 102.30Dec 1993 98.70Jan 1994 76.20Feb 1994 83.50Mar 1994 134.30Apr 1994 137.60May 1994 148.80Jun 1994 136.40Jul 1994 127.80Aug 1994 139.80Sep 1994 130.10Oct 1994 130.60Nov 1994 113.40Dec 1994 98.50Jan 1995 84.50Feb 1995 81.60Mar 1995 103.80Apr 1995 116.90May 1995 130.50Jun 1995 123.40Jul 1995 129.10Aug 1995…arrow_forward
- For each of the time series, construct a line chart of the data and identify the characteristics of the time series (that is, random, stationary, trend, seasonal, or cyclical). Year Month Units1 Nov 42,1611 Dec 44,1862 Jan 42,2272 Feb 45,4222 Mar 54,0752 Apr 50,9262 May 53,5722 Jun 54,9202 Jul 54,4492 Aug 56,0792 Sep 52,1772 Oct 50,0872 Nov 48,5132 Dec 49,2783 Jan 48,1343 Feb 54,8873 Mar 61,0643 Apr 53,3503 May 59,4673 Jun 59,3703 Jul 55,0883 Aug 59,3493 Sep 54,4723 Oct 53,164arrow_forwardHigh Cholesterol: A group of eight individuals with high cholesterol levels were given a new drug that was designed to lower cholesterol levels. Cholesterol levels, in milligrams per deciliter, were measured before and after treatment for each individual, with the following results: Individual Before 1 2 3 4 5 6 7 8 237 282 278 297 243 228 298 269 After 200 208 178 212 174 201 189 185 Part: 0/2 Part 1 of 2 (a) Construct a 99.9% confidence interval for the mean reduction in cholesterol level. Let a represent the cholesterol level before treatment minus the cholesterol level after. Use tables to find the critical value and round the answers to at least one decimal place.arrow_forwardI worked out the answers for most of this, and provided the answers in the tables that follow. But for the total cost table, I need help working out the values for 10%, 11%, and 12%. A pharmaceutical company produces the drug NasaMist from four chemicals. Today, the company must produce 1000 pounds of the drug. The three active ingredients in NasaMist are A, B, and C. By weight, at least 8% of NasaMist must consist of A, at least 4% of B, and at least 2% of C. The cost per pound of each chemical and the amount of each active ingredient in one pound of each chemical are given in the data at the bottom. It is necessary that at least 100 pounds of chemical 2 and at least 450 pounds of chemical 3 be used. a. Determine the cheapest way of producing today’s batch of NasaMist. If needed, round your answers to one decimal digit. Production plan Weight (lbs) Chemical 1 257.1 Chemical 2 100 Chemical 3 450 Chemical 4 192.9 b. Use SolverTable to see how much the percentage of…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
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
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
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
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