Analysis of Variance (ANOVA)

Produces the analysis of variance (ANOVA) of a given data set

แƒ‘แƒ แƒซแƒแƒœแƒ”แƒ‘แƒแƒ–แƒ” แƒฌแƒ•แƒ“แƒแƒ›แƒ˜แƒกแƒแƒ—แƒ•แƒ˜แƒก...

From the menu bar:

Choose Data - Statistics - Analysis of Variance (ANOVA)

From the tabbed interface:

Choose Data - Statistics - Analysis of Variance (ANOVA).

On the Data menu of the Data tab, choose Statistics - Analysis of Variance (ANOVA).


ANOVA is the acronym for ANalysis Of VAriance. This tool produces the analysis of variance of a given data set

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

For more information on ANOVA, refer to the corresponding Wikipedia article.


แƒ›แƒแƒœแƒแƒชแƒ”แƒ›แƒ”แƒ‘แƒ˜

Input Range: The reference of the range of the data to analyze.

Results to: The reference of the top left cell of the range where the results will be displayed.

Grouped By

Select whether the input data has columns or rows layout.

แƒขแƒ˜แƒžแƒ˜

Select if the analysis is for a single factor or for two factor ANOVA.

แƒžแƒแƒ แƒแƒ›แƒ”แƒขแƒ แƒ”แƒ‘แƒ˜

Alpha: the level of significance of the test.

Rows per sample: Define how many rows a sample has.

Open file with example:

แƒ›แƒแƒ’แƒแƒšแƒ˜แƒ—แƒ˜

The following data will be used as example

ย 

A

B

C

1

แƒ›แƒแƒ—แƒ”แƒ›แƒแƒขแƒ˜แƒ™แƒ

แƒคแƒ˜แƒ–แƒ˜แƒ™แƒ

แƒ‘แƒ˜แƒแƒšแƒแƒ’แƒ˜แƒ

2

47

67

33

3

36

68

42

4

40

65

44

5

39

64

60

6

ย 

38

43

7

47

84

62

8

29

80

51

9

27

49

40

10

57

49

12

11

56

33

60

12

57

ย 

ย 

13

26

ย 

ย 


The following table displays the results of the analysis of variance (ANOVA) of the sample data above.

ANOVA - Single Factor

แƒแƒšแƒคแƒ

0.05

ย 

แƒฏแƒ’แƒฃแƒคแƒ”แƒ‘แƒ˜

แƒ แƒแƒแƒ“แƒ”แƒœแƒแƒ‘แƒ

แƒฏแƒแƒ›แƒ˜

แƒกแƒแƒจแƒฃแƒแƒšแƒ

แƒ“แƒ˜แƒกแƒžแƒ”แƒ แƒกแƒ˜แƒ

Column 1

11

461

41.9090909091

139.4909090909

Column 2

10

597

59.7

287.1222222222

Column 3

10

447

44.7

227.3444444444

ย 

Source of Variation

SS

df

MS

F

P-แƒ›แƒœแƒ˜แƒจแƒ•แƒœแƒ”แƒšแƒแƒ‘แƒ

F-แƒ™แƒ แƒ˜แƒขแƒ˜แƒ™แƒฃแƒšแƒ˜

Between Groups

1876.5683284457

2

938.2841642229

4.3604117704

0.0224614952

3.340385558

Within Groups

6025.1090909091

28

215.1824675325

แƒฏแƒแƒ›แƒ˜

7901.6774193548

30


Please support us!

Please support us!