a.
Find the p-value and state the conclusion.
a.

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
The hypotheses are given below:
Null hypothesis:
Alternative hypothesis:
Test statistic:
The formula for finding test statistic is as follows:
Here,
Substitute
Thus, the value of the test statistic is 2.10.
The degrees of freedom is,
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:
From the output, the exact p-value is approximately 0.040.
Rejection rule:
If
If
Conclusion:
Here, the p-value is less than the level of significance.
That is,
By the rejection rule, the null hypothesis is rejected.
b.
Calculate the p-value and draw the conclusion.
b.

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
Test statistic:
Substitute
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:
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,
By the rejection rule, the null hypothesis is rejected.
c.
Obtain the p-value and claim the conclusion.
c.

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
Test statistic:
Substitute
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:
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,
By the rejection rule, the null hypothesis is not rejected.
Want to see more full solutions like this?
Chapter 9 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
- A company found that the daily sales revenue of its flagship product follows a normal distribution with a mean of $4500 and a standard deviation of $450. The company defines a "high-sales day" that is, any day with sales exceeding $4800. please provide a step by step on how to get the answers in excel Q: What percentage of days can the company expect to have "high-sales days" or sales greater than $4800? Q: What is the sales revenue threshold for the bottom 10% of days? (please note that 10% refers to the probability/area under bell curve towards the lower tail of bell curve) Provide answers in the yellow cellsarrow_forwardFind the critical value for a left-tailed test using the F distribution with a 0.025, degrees of freedom in the numerator=12, and degrees of freedom in the denominator = 50. A portion of the table of critical values of the F-distribution is provided. Click the icon to view the partial table of critical values of the F-distribution. What is the critical value? (Round to two decimal places as needed.)arrow_forwardA retail store manager claims that the average daily sales of the store are $1,500. You aim to test whether the actual average daily sales differ significantly from this claimed value. You can provide your answer by inserting a text box and the answer must include: Null hypothesis, Alternative hypothesis, Show answer (output table/summary table), and Conclusion based on the P value. Showing the calculation is a must. If calculation is missing,so please provide a step by step on the answers Numerical answers in the yellow cellsarrow_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 Harcourt

