You are to run the requested analyses using Microsoft Excel and the MegaStat add

Question

You are to run the requested analyses using Microsoft Excel and the MegaStat add-in. The use of any other softwar and/or manual calculations will receive O credit. For each question: Run the analysis in Excel and print out the resulting output. Write your complete answer directly in the space provided in this booklet. There are 2 questions in this exercise. .For any hypothesis tests, you must use the p-value approach and 5-step procedure discussed in class. In ord to receive credit, you must separately list each step in the hypothesis test: Step 1: State the null and alternative hypotheses Step 2: State the decision rule for rejecting the null hypothesis Step 3: Report the value of the test statistic and p-value directly from the Excel output Step 4: Evaluate the null hypothesis Step 5: State the practical conclusion to be drawn from the hypothesis test, in the context of the problem, in plain English. All requested confidence intervals must be in the correct final format (as discussed in class) and be fully interpreted in the context of the problem (i.e, in plain English). Use the closest tabled values from the statistical tables, as necessary. Staple your 2 pages of Excel output to the back of this assignment, and make sur that your name and CSU ID # appears at the top of this sheet. You will not receiv credit for this assignment if the Excel output is not provided! Double-check your data entry. Points will be deducted for incorrect answers based on inaccurate data!

Explanation / Answer

Excel output:

a)

H0: Population mean stress leves for all systems are equal.

Ha: altleast on mean stress levels of the system is different.

b)

If the p - value is less than 0.05, reject Ho. Or else fail to reject Ho

If test statistic F > 3.68 reject Ho

c)

Test statistic F = 2.11

P - value is 0.1555>0.05

d)

We fail to reject H0

e)

We have enough evidence to support that the means are equal for all the systems

Anova: Single Factor SUMMARY Groups Count Sum Average Variance System A 6 83 13.83333 2.966667 System B 6 95 15.83333 2.166667 System C 6 88 14.66667 3.466667 ANOVA Source of Variation SS df MS F P-value F crit Between Groups 12.11111 2 6.055556 2.112403 0.155496 3.68232 Within Groups 43 15 2.866667 Total 55.11111 17

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.