Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
bartleby

Videos

Textbook Question
Book Icon
Chapter 10.2, Problem 17E

Comparing Financial Consultant Ratings. Periodically, Merrill Lynch customers are asked to evaluate Merrill Lynch financial consultants and services. Higher ratings on the client satisfaction survey indicate better service, with 7 the maximum service rating. Independent samples of service ratings for two financial consultants are summarized here. Consultant A has 10 years of experience, whereas consultant B has 1 year of experience. Use α = .05 and test to see whether the consultant with more experience has the higher population mean service rating.

Chapter 10.2, Problem 17E, Comparing Financial Consultant Ratings. Periodically, Merrill Lynch customers are asked to evaluate

  1. a. State the null and alternative hypotheses.
  2. b. Compute the value of the test statistic.
  3. c. What is the p-value?
  4. d. What is your conclusion?

a.

Expert Solution
Check Mark
To determine

State the null and alternative hypotheses.

Answer to Problem 17E

Null hypothesis:H0:μ1μ20

Alternative hypothesis:Ha:μ1μ2>0

Explanation of Solution

Calculation:

The results from two independent samples of service ratings for financial consultant A and financial consultant B are as follows:

Consultant AConsultant B
n1=16n2=10
x¯1=6.82x¯2=6.25
s1=0.64s2=0.75

Furthermore, it is given that consultant A has 10 years of experience and consultant B has 1 year experience and α=0.05.

State the hypotheses:

The test hypotheses are as follows:

Null hypothesis:

H0:μ1μ20

That is, the consultant with more experience has the lower population mean service rating.

Alternative hypothesis:

Ha:μ1μ2>0

That is, the consultant with more experience has the higher population mean service rating.

b.

Expert Solution
Check Mark
To determine

Find the value of test statistic.

Answer to Problem 17E

The value of the test statistic is 1.99.

Explanation of Solution

Calculation:

Test statistic:

The test statistic for hypothesis test of μ1μ2 when σ1 and σ2 are unknown is as follows:

t=(x¯1x¯2)D0s12n1+s22n2

Substitute x¯1 as 6.82, x¯2 as 6.25, s1 as 0.64, s2 as 0.75, n1 as 16, and n2 as 10 in the above formula.

t=(6.826.25)00.64216+0.75210=0.570.409616+0.562510=0.570.0256+0.05625=0.570.2861

  =1.99

Thus, the test statistic is 1.99.

c.

Expert Solution
Check Mark
To determine

Find the p-value.

Answer to Problem 17E

The p-value is 0.032.

Explanation of Solution

Degrees of freedom:

For t distribution with two independent random sample, the degrees of freedom is obtained as follows:

df=(s12n1+s22n2)21n11(s12n1)2+1n21(s22n2)2

Substitute s1 as 0.64, s2 as 0.75, n1 as 16, and n2 as 10 in the above formula.

df=(0.64216+0.75210)21161(0.64216)2+1101(0.75210)2=(0.0256+0.05625)2115(0.0256)2+19(0.05625)2=0.00670.00004+0.0004=0.00670.00044

     =15.215

Software procedure:

Step-by-step procedure to obtain the probability value using Excel:

  • Open an EXCEL sheet and select the cell A1.
  • Enter the formula =T.DIST.2T(1.99,15) in the cell A1.
  • Press Enter.

Output using the EXCEL software is given below:

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List), Chapter 10.2, Problem 17E

Thus, the p-value is 0.032.

d.

Expert Solution
Check Mark
To determine

Obtain the conclusion whether the consultant with more experience has a higher population mean service rating or not.

Answer to Problem 17E

There is sufficient evidence to conclude that the consultant with more experience has the higher population mean service rating.

Explanation of Solution

Rejection rule:

If p-valueα, reject the null hypothesis.

If p-value>α, do not reject the null hypothesis.

Conclusion:

From part (c), the p-value is 0.032.

Here, the p-value is less than the level of significance.

That is, p-value(=0.032)<α(=0.05).

From the rejection rule, the null hypothesis is rejected.

Therefore, the null hypothesis H0 is rejected.

Therefore, there is sufficient evidence to conclude that the consultant with more experience has the higher population mean service rating.

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!

Chapter 10 Solutions

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)

Ch. 10.2 - Consider the following data for two independent...Ch. 10.2 - Prob. 12ECh. 10.2 - Annual Cost of College. The increasing annual cost...Ch. 10.2 - Are nursing salaries in Tampa, Florida, lower than...Ch. 10.2 - Hotel prices worldwide are projected to increase...Ch. 10.2 - Effect of Parents’ Education on Student SAT...Ch. 10.2 - Comparing Financial Consultant Ratings....Ch. 10.2 - Researchers at Purdue University and Wichita State...Ch. 10.3 - Consider the following hypothesis test. The...Ch. 10.3 - The following data are from matched samples taken...Ch. 10.3 - Prob. 21ECh. 10.3 - The price per share of stock for a sample of 25...Ch. 10.3 - Credit Card Expenditures. Bank of America’s...Ch. 10.3 - Domestic Airfare. The Global Business Travel...Ch. 10.3 - Prob. 25ECh. 10.3 - PGA Tour Scores. Scores in the first and fourth...Ch. 10.3 - Price Comparison of Smoothie Blenders. A personal...Ch. 10.4 - Consider the following results for independent...Ch. 10.4 - Prob. 29ECh. 10.4 - Corporate Hiring Outlook. A Businessweek/Harris...Ch. 10.4 - Impact of Pinterest on Purchase Decisions. Forbes...Ch. 10.4 - Mislabeled Fish. Researchers with Oceana, a group...Ch. 10.4 - Minnesota had the highest turnout rate of any...Ch. 10.4 - Oil wells are expensive to drill, and dry wells...Ch. 10.4 - In a test of the quality of two television...Ch. 10.4 - Winter visitors are extremely important to the...Ch. 10.4 - Prob. 37ECh. 10 - Prob. 38SECh. 10 - SUV Lease Payments. Statista reports that the...Ch. 10 - Prob. 40SECh. 10 - Kitchen Versus Bedroom Remodeling Costs. The...Ch. 10 - Effect of Siblings on SAT Scores. In Born...Ch. 10 - Country Financial, a financial services company,...Ch. 10 - Prob. 44SECh. 10 - Prob. 45SECh. 10 - News Access Via Computer. The American Press...Ch. 10 - For the week ended January 15, 2009, the bullish...
Knowledge Booster
Background pattern image
Statistics
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.
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Hypothesis Testing using Confidence Interval Approach; Author: BUM2413 Applied Statistics UMP;https://www.youtube.com/watch?v=Hq1l3e9pLyY;License: Standard YouTube License, CC-BY
Hypothesis Testing - Difference of Two Means - Student's -Distribution & Normal Distribution; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=UcZwyzwWU7o;License: Standard Youtube License