
Concept explainers
a.
Find the
a.

Answer to Problem 12SE
The median of the Exam scores of 9 students is 68.
The geometric mean of the Exam scores of 9 students is 67.37013.
The midrange of the Exam scores of 9 students is 68.
Explanation of Solution
The Exam scores of 9 students is 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 center tendency.
b.

Answer to Problem 12SE
Yes, the given measures are reasonable measures of center tendency.
Explanation of Solution
From the data, it is observed that there occurs one extreme value. Median and mid-
Hence, the given measures are reasonable measures of center tendency.
A (b).
Find the median, midrange and geometric mean of the GPAs of 8 students.
A (b).

Answer to Problem 12SE
The median of the GPAs of 8 students is 3.03.
The geometric mean of the GPAs of 8 students is 3.009403.
The midrange of the GPAs of 8 students is 2.955.
Explanation of Solution
The GPAs of 8 students is 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 3.03.
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 3.009403.
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 2.955.
b.
Decide whether the given measures are reasonable measures of center tendency.
b.

Answer to Problem 12SE
Yes, the given measures are reasonable measures of center tendency.
Explanation of Solution
From the data, it is observed that there occurs no extreme value. Median and mid-range has similar values. In this context, all the measures like median, midrange and geometric mean have values nearer to each other. So, it is assumed to be acceptable.
Hence, the given measures are reasonable measures of center tendency.
a.
Find the median, midrange and geometric mean of the class absences of 12 students.
a.

Answer to Problem 12SE
The median of the class absences of 12 students is 1.5.
The Geometric mean of the class absences of 12 students is not applicable.
The midrange of the class absences of 12 students is 7.5.
Explanation of Solution
The class absence of 12 students is 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 zero. As a result, 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 center tendency.
b.

Answer to Problem 12SE
No, the given measures are not all reasonable measures of center 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. The value of the geometric mean is not defined. So, the measures are not acceptable.
Hence, the given measures are not reasonable measures of center tendency.
Want to see more full solutions like this?
Chapter 4 Solutions
Applied Statistics in Business and Economics
- 1. If a firm spends more on advertising, is it likely to increase sales? Data on annual sales (in $100,000s) and advertising expenditures (in $10,000s) were collected for 20 firms in order to estimate the model Sales = Po + B₁Advertising + ε. A portion of the regression results is shown in the accompanying table. Intercept Advertising Standard Coefficients Error t Stat p-value -7.42 1.46 -5.09 7.66E-05 0.42 0.05 8.70 7.26E-08 a. Interpret the estimated slope coefficient. b. What is the sample regression equation? C. Predict the sales for a firm that spends $500,000 annually on advertising.arrow_forwardCan you help me solve problem 38 with steps im stuck.arrow_forwardHow do the samples hold up to the efficiency test? What percentages of the samples pass or fail the test? What would be the likelihood of having the following specific number of efficiency test failures in the next 300 processors tested? 1 failures, 5 failures, 10 failures and 20 failures.arrow_forward
- The battery temperatures are a major concern for us. Can you analyze and describe the sample data? What are the average and median temperatures? How much variability is there in the temperatures? Is there anything that stands out? Our engineers’ assumption is that the temperature data is normally distributed. If that is the case, what would be the likelihood that the Safety Zone temperature will exceed 5.15 degrees? What is the probability that the Safety Zone temperature will be less than 4.65 degrees? What is the actual percentage of samples that exceed 5.25 degrees or are less than 4.75 degrees? Is the manufacturing process producing units with stable Safety Zone temperatures? Can you check if there are any apparent changes in the temperature pattern? Are there any outliers? A closer look at the Z-scores should help you in this regard.arrow_forwardNeed help pleasearrow_forwardPlease conduct a step by step of these statistical tests on separate sheets of Microsoft Excel. If the calculations in Microsoft Excel are incorrect, the null and alternative hypotheses, as well as the conclusions drawn from them, will be meaningless and will not receive any points. 4. One-Way ANOVA: Analyze the customer satisfaction scores across four different product categories to determine if there is a significant difference in means. (Hints: The null can be about maintaining status-quo or no difference among groups) H0 = H1=arrow_forward
- Please conduct a step by step of these statistical tests on separate sheets of Microsoft Excel. If the calculations in Microsoft Excel are incorrect, the null and alternative hypotheses, as well as the conclusions drawn from them, will be meaningless and will not receive any points 2. Two-Sample T-Test: Compare the average sales revenue of two different regions to determine if there is a significant difference. (Hints: The null can be about maintaining status-quo or no difference among groups; if alternative hypothesis is non-directional use the two-tailed p-value from excel file to make a decision about rejecting or not rejecting null) H0 = H1=arrow_forwardPlease conduct a step by step of these statistical tests on separate sheets of Microsoft Excel. If the calculations in Microsoft Excel are incorrect, the null and alternative hypotheses, as well as the conclusions drawn from them, will be meaningless and will not receive any points 3. Paired T-Test: A company implemented a training program to improve employee performance. To evaluate the effectiveness of the program, the company recorded the test scores of 25 employees before and after the training. Determine if the training program is effective in terms of scores of participants before and after the training. (Hints: The null can be about maintaining status-quo or no difference among groups; if alternative hypothesis is non-directional, use the two-tailed p-value from excel file to make a decision about rejecting or not rejecting the null) H0 = H1= Conclusion:arrow_forwardPlease conduct a step by step of these statistical tests on separate sheets of Microsoft Excel. If the calculations in Microsoft Excel are incorrect, the null and alternative hypotheses, as well as the conclusions drawn from them, will be meaningless and will not receive any points. The data for the following questions is provided in Microsoft Excel file on 4 separate sheets. Please conduct these statistical tests on separate sheets of Microsoft Excel. If the calculations in Microsoft Excel are incorrect, the null and alternative hypotheses, as well as the conclusions drawn from them, will be meaningless and will not receive any points. 1. One Sample T-Test: Determine whether the average satisfaction rating of customers for a product is significantly different from a hypothetical mean of 75. (Hints: The null can be about maintaining status-quo or no difference; If your alternative hypothesis is non-directional (e.g., μ≠75), you should use the two-tailed p-value from excel file to…arrow_forward
- Please conduct a step by step of these statistical tests on separate sheets of Microsoft Excel. If the calculations in Microsoft Excel are incorrect, the null and alternative hypotheses, as well as the conclusions drawn from them, will be meaningless and will not receive any points. 1. One Sample T-Test: Determine whether the average satisfaction rating of customers for a product is significantly different from a hypothetical mean of 75. (Hints: The null can be about maintaining status-quo or no difference; If your alternative hypothesis is non-directional (e.g., μ≠75), you should use the two-tailed p-value from excel file to make a decision about rejecting or not rejecting null. If alternative is directional (e.g., μ < 75), you should use the lower-tailed p-value. For alternative hypothesis μ > 75, you should use the upper-tailed p-value.) H0 = H1= Conclusion: The p value from one sample t-test is _______. Since the two-tailed p-value is _______ 2. Two-Sample T-Test:…arrow_forwardPlease conduct a step by step of these statistical tests on separate sheets of Microsoft Excel. If the calculations in Microsoft Excel are incorrect, the null and alternative hypotheses, as well as the conclusions drawn from them, will be meaningless and will not receive any points. What is one sample T-test? Give an example of business application of this test? What is Two-Sample T-Test. Give an example of business application of this test? .What is paired T-test. Give an example of business application of this test? What is one way ANOVA test. Give an example of business application of this test? 1. One Sample T-Test: Determine whether the average satisfaction rating of customers for a product is significantly different from a hypothetical mean of 75. (Hints: The null can be about maintaining status-quo or no difference; If your alternative hypothesis is non-directional (e.g., μ≠75), you should use the two-tailed p-value from excel file to make a decision about rejecting or not…arrow_forwardThe data for the following questions is provided in Microsoft Excel file on 4 separate sheets. Please conduct a step by step of these statistical tests on separate sheets of Microsoft Excel. If the calculations in Microsoft Excel are incorrect, the null and alternative hypotheses, as well as the conclusions drawn from them, will be meaningless and will not receive any points. What is one sample T-test? Give an example of business application of this test? What is Two-Sample T-Test. Give an example of business application of this test? .What is paired T-test. Give an example of business application of this test? What is one way ANOVA test. Give an example of business application of this test? 1. One Sample T-Test: Determine whether the average satisfaction rating of customers for a product is significantly different from a hypothetical mean of 75. (Hints: The null can be about maintaining status-quo or no difference; If your alternative hypothesis is non-directional (e.g., μ≠75), you…arrow_forward
- 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





