Scribd Logo
Upload

Welcome to Scribd!

  • 42 views

    Excel Calculation (T-Test and Toolpak)

    Uploaded by

    Benmark Jabay
    1) The document contains survey results comparing online and face-to-face classes. It shows that students found face-to-face classes (mean=11.6) more impactful than online classes (mean=8.4) with similar variances. 2) Additional surveys asked about the role of online classes in the pandemic. Students saw them as most useful for learning and preventing virus spread but less so as a requirement for all. 3) A t-test showed the difference in perceived impact between online and face-to-face was not statistically significant at the 5% level.

    Copyright:

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

    Excel Calculation (T-Test and Toolpak)

    Uploaded by

    Benmark Jabay
    42 views6 pages
    1) The document contains survey results comparing online and face-to-face classes. It shows that students found face-to-face classes (mean=11.6) more impactful than online classes (mean=8.4) with similar variances. 2) Additional surveys asked about the role of online classes in the pandemic. Students saw them as most useful for learning and preventing virus spread but less so as a requirement for all. 3) A t-test showed the difference in perceived impact between online and face-to-face was not statistically significant at the 5% level.

    Original Title

    Excel Calculation (T-test and toolpak)

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1) The document contains survey results comparing online and face-to-face classes. It shows that students found face-to-face classes (mean=11.6) more impactful than online classes (mean=8.4) with similar variances. 2) Additional surveys asked about the role of online classes in the pandemic. Students saw them as most useful for learning and preventing virus spread but less so as a requirement for all. 3) A t-test showed the difference in perceived impact between online and face-to-face was not statistically significant at the 5% level.

    Copyright:

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

    Excel Calculation (T-Test and Toolpak)

    Uploaded by

    Benmark Jabay
    1) The document contains survey results comparing online and face-to-face classes. It shows that students found face-to-face classes (mean=11.6) more impactful than online classes (mean=8.4) with similar variances. 2) Additional surveys asked about the role of online classes in the pandemic. Students saw them as most useful for learning and preventing virus spread but less so as a requirement for all. 3) A t-test showed the difference in perceived impact between online and face-to-face was not statistically significant at the 5% level.

    Copyright:

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

    Category I: (Impact) Number of Responses

    Question Online Class (x) Face-face Class (y)


    1 3 17
    2 8 12
    3 7 13
    4 9 11
    5 2 18
    6 14 6
    7 9 11
    8 15 5
    9 6 14
    10 11 9
    mean 8.4 11.6
    variance 17.82222222222 17.8222222222222
    n 10 10

    Category II: (Role)


    1. Online class as an alternative learning process for students during this pandemic
    x number of responses P(x) xP(x) u-x
    1 14 0.7 0.7 0.4
    2 4 0.2 0.4 -2
    3 2 0.1 0.3 -3
    20 1 1.4

    variance= 0.068889 mean= 1.4


    std.v= 0.262467

    2. Implementing Online Class to prevent spreading of coronavirus.


    x number of responses P(x) xP(x) u-x
    1 18 0.9 0.90 0.15
    2 1 0.1 0.1 -2.00
    3 1 0.1 0.2 -3.00
    20 1.15

    variance= 0.160556
    std.v= 0.400694 mean= 1.15
    3. Online class must be require to all students from different school.
    x number of responses P(x) xP(x) u-x
    1 13 0.7 0.65 0.5
    2 4 0.2 0.4 -2
    3 3 0.2 0.45 -3
    20 1 1.5

    variance= 0.050556
    std.v= 0.224846 mean= 3
    t-Test: Two-Sample Assuming Equal Variances

    X-Y Variable 1 Variable 2


    Mean 8.4 11.6
    Variance 17.8222222 17.82222222222
    Observations 10 10
    Pooled Variance 17.8222222
    Hypothesized Mean Di0
    df 18
    t Stat -1.6949389
    P(T<=t) one-tail 0.05365837
    t Critical one-tail 1.73406361
    P(T<=t) two-tail 0.10731673

    Probability Histogram
    (u-x)2 0.8
    0.16 0.7
    4
    0.6
    9
    0.5
    13.16
    0.4 VERY
    0.3 USEFUL
    0.2
    0.1 USEFUL
    NOT USEFUL
    0
    1 2 3

    (u-x)2
    0.0225 Probability Histogram
    4 20
    9 18
    13.0225 16
    14
    12
    10
    8
    6
    4
    2
    0
    1 2 3
    10
    8
    6
    4
    2
    0
    1 2 3

    (u-x)2
    0.25 Probability Histogram
    4 0.7
    9
    13.25 0.6

    0.5

    0.4

    0.3

    0.2

    0.1

    0.0
    1 2 3

    You might also like