In excel Enter the data with each column representing one group
In excel Enter the data with each column representing one group. Select Data Analysis from the Tools menu. Select Analysis of Variance, Single Factor. Enter the data range**If you don't see Data Analysis on your Excel, you can add it to your Tools pull-down menu by going to Tools, clicking on Add-Ins, and checking the first box for Analysis ToolPak. Now Data Analysis should show up as an option on the Tools pull-down menu.The summary table along with the F value and corresponding P value are printed. The mean and variance of each group are also included.
Site I Site II Site III IV
17 18 32 13
23 4 19 19
6 33 18 14
19 8 43 34
11 16 12
15
I II III
49.1 55.6 39.0
43.4 25.0 37.3
32.9 41.3 10.8
27.8 29.9 32.5
38.3 39.5 15.8
36.1 42.6
20.2
11 years ago
Purchase the answer to view it

- answer.docx
- data.xlsx