Scribd Logo
Upload

Welcome to Scribd!

  • 10 views

    Food Processing Excel

    Uploaded by

    Jon Mark
    excel

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Food Processing Excel

    Uploaded by

    Jon Mark
    10 views4 pages
    excel

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    excel

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    10 views4 pages

    Food Processing Excel

    Uploaded by

    Jon Mark
    excel

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 4

    No. of panelist color aroma taste texture G.

    A
    1 6 7 8 7 7 Anova: Single Factor
    2 8 8 7 7 8
    3 9 8 7 5 7 SUMMARY
    4 8 8 8 8 8 Groups Count
    5 8 7 8 7 8 color 24
    6 8 8 7 7 8 aroma 24
    7 8 7 8 8 8 taste 24
    8 8 8 8 8 8 texture 24
    9 8 8 7 7 8 G.A 24
    10 9 9 8 9 9
    11 9 8 7 6 8
    12 8 8 9 8 8 ANOVA
    13 8 8 7 7 8 Source of Variation SS
    14 7 8 7 8 7 Between Groups 4.616667
    15 7 8 8 8 8 Within Groups 65.70833
    16 9 8 8 9 9
    17 8 9 7 8 8 Total 70.325
    18 8 8 8 8 8
    19 8 8 7 7 8
    20 7 8 7 8 8
    21 6 6 6 6 6
    22 7 8 8 8 8
    23 8 9 7 7 8
    24 7 7 7 7 7

    Anova: Single Factor

    SUMMARY
    Groups Count Sum Average Variance
    color 24 187 7.791667 0.693841
    aroma 24 189 7.875 0.461957
    taste 24 179 7.458333 0.432971
    texture 24 178 7.416667 0.862319

    ANOVA
    Source of Variation SS df MS F P-value F crit
    Between Grou 3.864583 3 1.288194 2.102242 0.105326 2.703594
    Within Groups 56.375 92 0.612772

    Total 60.23958 95
    Sum Average Variance
    187 7.791667 0.693841
    189 7.875 0.461957
    179 7.458333 0.432971
    178 7.416667 0.862319
    188 7.833333 0.405797

    df MS F P-value F crit
    4 1.154167 2.019975 0.096231 2.450571
    115 0.571377

    119
    No. of panelist color aroma taste texture G.A
    1 8 8 9 8 8 Anova: Single Factor
    2 8 8 8 8 8
    3 8 8 9 8 8 SUMMARY
    4 8 8 8 8 8 Groups
    5 8 8 8 8 8 color
    6 7 8 8 8 8 aroma
    7 9 8 7 7 8 taste
    8 8 8 8 8 8 texture
    9 7 7 8 8 8 G.A
    10 9 9 9 9 9
    11 8 7 8 9 8
    12 8 8 9 8 8 ANOVA
    13 8 8 8 7 8 Source of Variation
    14 8 8 8 8 8 Between Groups
    15 8 7 7 8 8 Within Groups
    16 8 9 8 8 8
    17 8 8 9 9 9 Total
    18 8 8 8 8 8
    19 8 9 9 9 9
    20 8 8 7 8 8
    21 7 7 7 7 7
    22 8 9 8 8 8
    23 8 8 9 8 8
    24 8 8 8 8 8

    Anova: Single Factor

    SUMMARY
    Groups Count Sum Average Variance
    color 24 191 7.958333 0.21558
    aroma 24 192 8 0.347826
    taste 24 195 8.125 0.461957
    texture 24 193 8.041667 0.302536

    ANOVA
    Source of Variation SS df MS F P-value F crit
    Between Groups 0.364583 3 0.121528 0.366075 0.777648 2.703594
    Within Groups 30.54167 92 0.331975

    Total 30.90625 95
    Count Sum Average Variance
    24 191 7.958333 0.21558
    24 192 8 0.347826
    24 195 8.125 0.461957
    24 193 8.041667 0.302536
    24 194 8.083333 0.166667

    SS df MS F P-value F crit
    0.416667 4 0.104167 0.348485 0.844622 2.450571
    34.375 115 0.298913

    34.79167 119

    You might also like