In excel Enter the data with each column representing one group

profiletutor4helpyou
 (Not rated)
 (Not rated)
Chat

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
In excel Enter the data with each column representing one group
NOT RATED

Purchase the answer to view it

blurred-text
  • attachment
    answer.docx
  • attachment
    data.xlsx