+ Reply to Thread
Results 1 to 2 of 2

ANoVA Help!

  1. #1
    Registered User
    Join Date
    07-13-2013
    Location
    canterbury,england
    MS-Off Ver
    Excel 2010
    Posts
    2

    ANoVA Help!

    Hello! i have to make statistical analysis of some data i collected... they suggested me to use anova... is anyone able to explain me what means what in the output sheet?
    Copia di Senza titolo.jpg

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: ANoVA Help!

    ANOVA (Analysis of Variance) is a tool used to test the equality of means using variances.
    See https://people.richland.edu/james/le.../ch13-1wy.html or
    https://statistics.laerd.com/statist...al-guide-3.php or
    any statistics book.

    Just by looking at your data it appears that the last item is an OUTLIER and should be
    removed from the data set. It also appears that the 7th item (sample size of 54) is probably
    also an outlier.

    Each item from your chart comes from a mathematical formula or from a chart in a statistics table.

    SS stands for 'sum of squares'.

    df stands for 'degrees of freedom'

    MS stands for 'mean squares'

    F stands for the calculated 'F' statistic used to test ANOVA

    Fcritical is from a chart in a statistics book indicating the statistical significance that you choose that the means are different (e.g. 10% chance, 5% change, 1% chance etc.)

    If F is greater than Fcritical then it can be said with the % confidence that you chose, that the means are
    SIGNIFICANTLY DIFFERENT.

    Lewis

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Two-Way Anova Analysis,Add-ins
    By Ganivada in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 11-24-2009, 05:35 PM
  2. two-way ANOVA
    By Andy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2006, 11:35 PM
  3. [SOLVED] unbalanced data in ANOVA
    By The student in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM
  4. unbalanced data in ANOVA
    By The student in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  5. [SOLVED] ANOVA
    By Angel in forum Excel General
    Replies: 1
    Last Post: 08-31-2005, 04:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1