
Concept explainers
a.
a.
Find the
a.
a.

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.
Decide whether the given measures are reasonable measures of
b.

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.
Find the median, midrange and geometric mean of the sodium grams in the canned soup.
b.
a.

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.
Decide whether the given measures are reasonable measures of central tendency.
b.

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.
Find the median, midrange and geometric mean of the annual campus health visits of 12 students.
c.
a.

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.
Decide whether the given measures are reasonable measures of central tendency.
b.

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?
Chapter 4 Solutions
APPLIED STAT.IN BUS.+ECONOMICS
- help me with abc please. please handwrite if possible. please don't use AI tools to answerarrow_forwardhelp me with abc please. please handwrite if possible. please don't use AI tools to answerarrow_forwardhelp me with abc please. please handwrite if possible. please don't use AI tools to answer.arrow_forward
- Please help me with this statistics questionarrow_forwardPlease help me with the following statistic questionarrow_forwardTo evaluate the success of a 1-year experimental program designed to increase the mathematical achievement of underprivileged high school seniors, a random sample of participants in the program will be selected and their mathematics scores will be compared with the previous year’s statewide average of 525 for underprivileged seniors. The researchers want to determine whether the experimental program has increased the mean achievement level over the previous year’s statewide average. If alpha=.05, what sample size is needed to have a probability of Type II error of at most .025 if the actual mean is increased to 550? From previous results, sigma=80.arrow_forward
- Please help me answer the following questions from this problem.arrow_forwardPlease help me find the sample variance for this question.arrow_forwardCrumbs Cookies was interested in seeing if there was an association between cookie flavor and whether or not there was frosting. Given are the results of the last week's orders. Frosting No Frosting Total Sugar Cookie 50 Red Velvet 66 136 Chocolate Chip 58 Total 220 400 Which category has the greatest joint frequency? Chocolate chip cookies with frosting Sugar cookies with no frosting Chocolate chip cookies Cookies with frostingarrow_forward
- The table given shows the length, in feet, of dolphins at an aquarium. 7 15 10 18 18 15 9 22 Are there any outliers in the data? There is an outlier at 22 feet. There is an outlier at 7 feet. There are outliers at 7 and 22 feet. There are no outliers.arrow_forwardStart by summarizing the key events in a clear and persuasive manner on the article Endrikat, J., Guenther, T. W., & Titus, R. (2020). Consequences of Strategic Performance Measurement Systems: A Meta-Analytic Review. Journal of Management Accounting Research?arrow_forwardThe table below was compiled for a middle school from the 2003 English/Language Arts PACT exam. Grade 6 7 8 Below Basic 60 62 76 Basic 87 134 140 Proficient 87 102 100 Advanced 42 24 21 Partition the likelihood ratio test statistic into 6 independent 1 df components. What conclusions can you draw from these components?arrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin HarcourtHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL


