W4 How to Use Excel (2003) for ANOVA

W4 How to Use Excel (2003) for ANOVA - Part C in...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
How to Use Excel for ANOVA Class, using Excel for ANOVA is easy. You are encouraged to use Excel (or Megastat) for Part C in Applications 3, and the ANOVA part in Applications 4. Just follow these simple instructions. Print a copy of these directions for ease of use when you use Excel for these ANOVA applications. When you complete your worksheet for each application, just make a copy of the worksheet and paste it into the Applications.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Part C in Applications 3 is the Single Factor for ANOVA which provides the ANOVA table. You will still need to complete the steps for the hypothesis set up, the decision rule, and making a decision (these steps are included in the applications). The following is how to calculate the ANOVA table. Here is the Excel set up for Single Factor ANOVA 1 2 3 4...
View Full Document

This note was uploaded on 10/10/2010 for the course STATS Stats301 taught by Professor Regis during the Spring '10 term at DeVry Irvine.

Page1 / 4

W4 How to Use Excel (2003) for ANOVA - Part C in...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online