Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
6th Edition
ISBN: 9780357228708
Author: David R. Anderson; Dennis J. Sweeney; Thomas A. Williams
Publisher: Cengage Learning US
bartleby

Videos

Question
Book Icon
Chapter 9.4, Problem 26E

a.

To determine

Find the p-value and state the conclusion.

a.

Expert Solution
Check Mark

Answer to Problem 26E

The p-value is 0.039.

The conclusion is “reject the null hypothesis”.

Explanation of Solution

Calculation:

The given information is the sample size is n=65, the sample mean is x¯=103, and the sample standard deviation is s=11.5.

The hypotheses are given below:

Null hypothesis: H0:μ=100

Alternative hypothesis: Ha:μ100

Test statistic:

The formula for finding test statistic is as follows:

t=x¯μ0sn

Here, x¯ represents the sample mean, μ0 represents the hypothesized value of the population mean, s represents the sample standard deviation, and n represents the sample size.

Substitute x¯=103, μ0=100, s=11.5 and n=65 in t formula.

t=10310011.565=311.58.0623=31.4264=2.10

Thus, the value of the test statistic is 2.10.

The degrees of freedom is,

df=n1=651=64

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(2.10,64) 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), Chapter 9.4, Problem 26E , additional homework tip  1

From the output, the exact p-value is approximately 0.040.

Rejection rule:

If p-valueα, reject the null hypothesis.

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

Conclusion:

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

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

By the rejection rule, the null hypothesis is rejected.

b.

To determine

Calculate the p-value and draw the conclusion.

b.

Expert Solution
Check Mark

Answer to Problem 26E

The p-value is 0.013.

The conclusion is “reject the null hypothesis”.

Explanation of Solution

Calculation:

The given information is that the sample size is n=65, the sample mean is x¯=96.5, and the sample standard deviation is s=11.

Test statistic:

Substitute x¯=96.5, μ0=100, s=11, and n=65 in t formula.

t=96.51001165=3.5118.0623=3.51.3644=2.57

Thus, the value of the test statistic is –2.57.

From part (a), the degrees of freedom is 64.

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(2.57,64) 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), Chapter 9.4, Problem 26E , additional homework tip  2

From the output, the exact p-value is approximately 0.0125.

Conclusion:

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

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

By the rejection rule, the null hypothesis is rejected.

c.

To determine

Obtain the p-value and claim the conclusion.

c.

Expert Solution
Check Mark

Answer to Problem 26E

The p-value is 0.130.

The conclusion is “do not reject the null hypothesis”.

Explanation of Solution

Calculation:

The given information is that the sample size is n=65, the sample mean is x¯=102, and the sample standard deviation is s=10.5.

Test statistic:

Substitute x¯=102, μ0=100, s=10.5 and n=65 in t formula.

t=10210010.565=210.58.0623=21.3024=1.54

Thus, the value of the test statistic is 1.54.

From part (a), the degrees of freedom is 64.

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.54,64) 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), Chapter 9.4, Problem 26E , additional homework tip  3

From the output, the exact p-value is approximately 0.01285.

Conclusion:

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

That is, p-value(=0.1285)>α(=0.05).

By the rejection rule, the null hypothesis is not rejected.

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
NC Current Students - North Ce X | NC Canvas Login Links - North ( X Final Exam Comprehensive x Cengage Learning x WASTAT - Final Exam - STAT → C webassign.net/web/Student/Assignment-Responses/submit?dep=36055360&tags=autosave#question3659890_9 Part (b) Draw a scatter plot of the ordered pairs. N Life Expectancy Life Expectancy 80 70 600 50 40 30 20 10 Year of 1950 1970 1990 2010 Birth O Life Expectancy Part (c) 800 70 60 50 40 30 20 10 1950 1970 1990 W ALT 林 $ # 4 R J7 Year of 2010 Birth F6 4+ 80 70 60 50 40 30 20 10 Year of 1950 1970 1990 2010 Birth Life Expectancy Ox 800 70 60 50 40 30 20 10 Year of 1950 1970 1990 2010 Birth hp P.B. KA & 7 80 % 5 H A B F10 711 N M K 744 PRT SC ALT CTRL
Harvard University California Institute of Technology Massachusetts Institute of Technology Stanford University Princeton University University of Cambridge University of Oxford University of California, Berkeley Imperial College London Yale University University of California, Los Angeles University of Chicago Johns Hopkins University Cornell University ETH Zurich University of Michigan University of Toronto Columbia University University of Pennsylvania Carnegie Mellon University University of Hong Kong University College London University of Washington Duke University Northwestern University University of Tokyo Georgia Institute of Technology Pohang University of Science and Technology University of California, Santa Barbara University of British Columbia University of North Carolina at Chapel Hill University of California, San Diego University of Illinois at Urbana-Champaign National University of Singapore McGill…
Name Harvard University California Institute of Technology Massachusetts Institute of Technology Stanford University Princeton University University of Cambridge University of Oxford University of California, Berkeley Imperial College London Yale University University of California, Los Angeles University of Chicago Johns Hopkins University Cornell University ETH Zurich University of Michigan University of Toronto Columbia University University of Pennsylvania Carnegie Mellon University University of Hong Kong University College London University of Washington Duke University Northwestern University University of Tokyo Georgia Institute of Technology Pohang University of Science and Technology University of California, Santa Barbara University of British Columbia University of North Carolina at Chapel Hill University of California, San Diego University of Illinois at Urbana-Champaign National University of Singapore…

Chapter 9 Solutions

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

Ch. 9.3 - Consider the following hypothesis test: A sample...Ch. 9.3 - Prob. 12ECh. 9.3 - Prob. 13ECh. 9.3 - Prob. 14ECh. 9.3 - Federal Tax Returns. According to the IRS,...Ch. 9.3 - In a study entitled How Undergraduate Students Use...Ch. 9.3 - The mean hourly wage for employees in...Ch. 9.3 - Young millennials, adults aged 18 to 34, are...Ch. 9.3 - The Internal Revenue Service (IRS) provides a...Ch. 9.3 - Prescription Drug Costs. Annual expenditure for...Ch. 9.3 - Cost of Telephone Surveys. Fowle Marketing...Ch. 9.3 - Time in Supermarket Checkout Lines. CCN and...Ch. 9.4 - Consider the following hypothesis test: A sample...Ch. 9.4 - Consider the following hypothesis test: A sample...Ch. 9.4 - Consider the following hypothesis test: A sample...Ch. 9.4 - Prob. 26ECh. 9.4 - Which is cheaper: eating out or dining in? The...Ch. 9.4 - CEO Tenure. A shareholders’ group, in lodging a...Ch. 9.4 - The national mean annual salary for a school...Ch. 9.4 - Time in Child Care. The time married men with...Ch. 9.4 - Chocolate Consumption. The United States ranks...Ch. 9.4 - Used Car Prices. According to the National...Ch. 9.4 - Automobile Insurance Premiums. The Onsure.com...Ch. 9.4 - Prob. 34ECh. 9.5 - Consider the following hypothesis test: A sample...Ch. 9.5 - Prob. 36ECh. 9.5 - The U.S. Bureau of Labor Statistics reports that...Ch. 9.5 - Attitudes toward Supermarket Brands. A study by...Ch. 9.5 - Prob. 39ECh. 9.5 - Prob. 40ECh. 9.5 - Ten years ago 53% of American families owned...Ch. 9.5 - Returned Merchandise. According to the University...Ch. 9.5 - Prob. 43ECh. 9.5 - Prob. 44ECh. 9.5 - The American Association of Individual Investors...Ch. 9.6 - A large department of the Federal Government wants...Ch. 9.6 - CEOs who belong to a popular business-oriented...Ch. 9.6 - Prob. 48ECh. 9.6 - Prob. 49ECh. 9 - Production Line Fill Weights. A production line...Ch. 9 - Scholarship Examination Scores. At Western...Ch. 9 - Exposure to Background Television. CNN reports...Ch. 9 - The Wall Street Journal reported that bachelor’s...Ch. 9 - Data from the Office for National Statistics show...Ch. 9 - The mean time to earn a bachelor’s degree is 5.8...Ch. 9 - Prob. 56SECh. 9 - In Hamilton County, Ohio, the mean number of days...Ch. 9 - Fifty-two percent of Americans report that they...Ch. 9 - Prob. 59SECh. 9 - Prob. 60SECh. 9 - The unemployment rate for 18- to 34-year-olds was...Ch. 9 - Prob. 62SECh. 9 - In recent years more people have been working past...Ch. 9 - Case Problem 1 Quality Associates, Inc. Quality...Ch. 9 - Case problem 2 Ethical Behavior of Business...
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.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Type I and II Errors, Power, Effect Size, Significance and Power Analysis in Quantitative Research; Author: NurseKillam;https://www.youtube.com/watch?v=OWn3Ko1WYTA;License: Standard YouTube License, CC-BY