Scribd Logo
Upload

Welcome to Scribd!

  • 171 views

    Discriminant Analysis in Excel

    Uploaded by

    Sangita
    This document contains seed variety trial data including seed variety, field, grade, measurements (X1, X2), and estimated Y values. It includes tables with raw data, sorted data by grade, calculations for simultaneous equations to estimate variables, and estimated functions. The data is analyzed to evaluate seed varieties and estimate crop yield based on measurements and grade.

    Copyright:

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

    Discriminant Analysis in Excel

    Uploaded by

    Sangita
    171 views6 pages
    This document contains seed variety trial data including seed variety, field, grade, measurements (X1, X2), and estimated Y values. It includes tables with raw data, sorted data by grade, calculations for simultaneous equations to estimate variables, and estimated functions. The data is analyzed to evaluate seed varieties and estimate crop yield based on measurements and grade.

    Original Description:

    Discriminant analysis for qualitative data analysis work

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains seed variety trial data including seed variety, field, grade, measurements (X1, X2), and estimated Y values. It includes tables with raw data, sorted data by grade, calculations for simultaneous equations to estimate variables, and estimated functions. The data is analyzed to evaluate seed varieties and estimate crop yield based on measurements and grade.

    Copyright:

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

    Discriminant Analysis in Excel

    Uploaded by

    Sangita
    This document contains seed variety trial data including seed variety, field, grade, measurements (X1, X2), and estimated Y values. It includes tables with raw data, sorted data by grade, calculations for simultaneous equations to estimate variables, and estimated functions. The data is analyzed to evaluate seed varieties and estimate crop yield based on measurements and grade.

    Copyright:

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

    Data

    Seed
    Seed
    Variety Variety
    X1
    X2
    3
    4
    4
    5
    10
    7

    Field

    Grade

    1
    2
    3

    Medium
    Medium
    Good

    Medium

    5
    6
    7
    8
    9
    10
    11
    12

    Medium
    Good
    Medium
    Good
    Medium
    Medium
    Good
    Good

    6
    11
    7
    12
    8
    9
    13
    14

    6
    4
    4
    5
    7
    5
    6
    8

    Note: 1)If any

    Sorted data
    Grade
    Medium
    Medium
    Medium
    Medium
    Medium
    Medium
    Medium

    Seed
    Seed
    X1X2
    Variety Variety X1 sqr X2 sqr
    sqr
    X1
    X2

    Sum
    Mean
    Count
    Sum sqr
    Sum sq dev

    3
    4
    5
    6
    7
    8
    9
    42
    6
    7
    28
    7

    4
    5
    4
    6
    4
    7
    5
    35
    5

    Total of medium and good


    mean difference

    38
    1

    18

    Simulteneous equation

    X1 =
    X2 =

    18
    18
    0.19
    -0.06

    16
    25
    16
    36
    16
    49
    25
    183

    12
    20
    20
    36
    28
    56
    45
    217

    x2-x2
    bar

    -3
    -2
    -1
    0
    1
    2
    3
    0

    -1
    0
    -1
    1
    -1
    2
    0
    0

    Grand Mean15.144
    X
    Y

    11
    6

    38a+11b=6
    11a+18b=1
    38
    11

    Estimation

    9
    16
    25
    36
    49
    64
    81
    280

    x1-x1
    bar

    6
    1

    Estimated Function

    Y =0.19X1-0.06X2
    Variablity between groups
    Variablity within groups

    3.237
    1.128

    Discriminant Ratio

    2.869

    Note: 1)If any doubt in calculation, contact Dr Sangita Warade on 986047059

    Seed
    Seed
    Y bar Grade Variety Variety X1 sqr X2 sqr
    Estimat Y mean
    X1
    X2
    ed Y
    0.325
    0.248
    Good
    10
    7
    100
    49
    0.453
    0.137
    Good
    11
    4
    121
    16
    0.695
    0.016
    Good
    12
    5
    144
    25
    0.765
    0.003
    Good
    13
    6
    169
    36
    1.066
    0.059
    Good
    14
    8
    196
    64
    1.078
    0.065
    1.379
    0.309
    5.761
    0.837
    60
    30
    730
    190
    0.823
    0.120
    12
    6
    1.262
    5
    10
    10
    4

    X1X2
    sqr

    x1-x1
    bar

    x2-x2
    bar

    70
    44
    60
    78
    112

    -2
    -1
    0
    1
    2

    1
    -2
    -1
    0
    2

    364

    de on 9860470598

    Y bar Estimat Y mean


    ed Y
    1.449
    0.183
    1.807
    0.005
    1.934
    0.003
    2.062
    0.034
    2.132
    0.065

    9.383
    1.877

    0.291
    0.058

    You might also like