Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 16 views

    Excel Statistics Homework

    Uploaded by

    GOKHAN KARA
    The document contains statistical analysis results from multiple tests and studies, including: - An independent samples t-test comparing female and male test scores. - A paired samples t-test comparing test scores from participants before and after an event. - Correlation, one-way ANOVA, and post-hoc tests analyzing relationships between variables like job satisfaction, intelligence and math scores. - A two-way ANOVA analyzing test scores based on time of day and question type.

    Copyright:

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

    Excel Statistics Homework

    Uploaded by

    GOKHAN KARA
    16 views14 pages
    The document contains statistical analysis results from multiple tests and studies, including: - An independent samples t-test comparing female and male test scores. - A paired samples t-test comparing test scores from participants before and after an event. - Correlation, one-way ANOVA, and post-hoc tests analyzing relationships between variables like job satisfaction, intelligence and math scores. - A two-way ANOVA analyzing test scores based on time of day and question type.

    Original Description:

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains statistical analysis results from multiple tests and studies, including: - An independent samples t-test comparing female and male test scores. - A paired samples t-test comparing test scores from participants before and after an event. - Correlation, one-way ANOVA, and post-hoc tests analyzing relationships between variables like job satisfaction, intelligence and math scores. - A two-way ANOVA analyzing test scores based on time of day and question type.

    Copyright:

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

    Excel Statistics Homework

    Uploaded by

    GOKHAN KARA
    The document contains statistical analysis results from multiple tests and studies, including: - An independent samples t-test comparing female and male test scores. - A paired samples t-test comparing test scores from participants before and after an event. - Correlation, one-way ANOVA, and post-hoc tests analyzing relationships between variables like job satisfaction, intelligence and math scores. - A two-way ANOVA analyzing test scores based on time of day and question type.

    Copyright:

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

    Test

    75 Mean: 74.06122
    60 Median: 75
    62 Std. Dev. 16.83301
    54 Range 66
    78
    99
    92
    52
    39
    73
    81
    67
    59
    70
    74
    73
    80
    82
    86
    93
    96
    54
    52
    61
    72
    79
    81
    94
    74
    75
    83
    90
    76
    54
    45
    98
    51
    74
    87
    86
    100
    98
    34
    99
    64
    55
    83
    88
    77
    Reading
    Female Male

    62 58 INDEPENDENT SAMPLES T-TEST


    64 93 t-Test: Two-Sample Assuming Unequal Variances
    59 88
    96 47 Female
    67 35 Mean 70.958333333
    77 61 Variance 383.69384058
    74 66 Observations 24
    89 60 Hypothesized Mean Difference 0
    88 75 df 47
    97 78 t Stat -0.418385558
    51 79 P(T<=t) one-tail 0.3387854394
    67 51 t Critical one-tail 1.6779267216
    72 55 P(T<=t) two-tail 0.6775708788
    86 94 t Critical two-tail 2.0117405137
    74 76
    81 74
    44 77
    41 100
    27 47
    108 60
    56 84
    55 91
    78 100
    90 99
    76
    79
    Male
    73.19231
    325.6015
    26
    Participant FirstTest SecondTest
    1 59 55
    2 68 76
    3 58 68 PAIRED SAMPLES T-TEST
    4 54 81 t-Test: Paired Two Sample for Means
    5 93 84
    6 96 100 FirstTest
    7 98 36 Mean 72.12
    8 47 40 Variance 330.59755102
    9 40 52 Observations 50
    10 68 68 Pearson Correlation 0.2031086608
    11 81 79 Hypothesized Mean Difference 0
    12 57 85 df 49
    13 66 98 t Stat -2.503956737
    14 66 96 P(T<=t) one-tail 0.0078301475
    15 74 78 t Critical one-tail 1.6765508926
    16 81 78 P(T<=t) two-tail 0.015660295
    17 76 85 t Critical two-tail 2.0095752371
    18 77 74
    19 84 88
    20 92 78
    21 97 86
    22 52 99
    23 51 100
    24 63 52
    25 67 50
    26 70 62
    27 86 83
    28 95 92
    29 74 90
    30 76 88
    31 71 69
    32 80 63
    33 79 69
    34 46 79
    35 36 86
    36 100 98
    37 46 97
    38 67 96
    39 78 99
    40 89 75
    41 96 88
    42 99 99
    43 27 75
    44 99 99
    45 54 87
    46 60 78
    47 81 99
    48 70 61
    49 74 94
    50 88 81
    SecondTest
    79.86
    268.0820408
    50
    Intelligence Math Scores
    1 85 68
    2 84 75 CORRELATION
    3 112 81 Intelligence Math Scores
    4 90 69 Intelligence 1
    5 96 68 Math Scores 0.5733943981 1
    6 85 75
    7 92 78
    8 123 100
    9 102 96
    10 99 82
    11 95 74
    12 102 81
    13 95 86
    14 105 74
    15 120 99
    16 115 97 1 Perfect
    17 98 76 .70 Strong
    18 84 92 .50 Medium
    19 118 86 .30 Weak
    20 109 95
    21 93 96
    22 85 75
    23 86 61
    24 94 96
    25 120 91
    26 100 96
    27 108 97
    28 116 84
    29 107 83
    30 97 76
    Job Satisfaction
    Doctors Engineers Educators
    72 97 89 ONE-WAY ANOVA
    91 91 61 Anova: Single Factor
    75 89 63
    90 92 95 SUMMARY
    67 86 93 Groups Count Sum Average Variance
    68 95 99 Doctors 10 769 76.9 75.21111
    74 88 52 Engineers 10 916 91.6 18.93333
    85 86 58 Educators 10 750 75 338
    75 98 57
    72 94 83
    ANOVA
    Source of Variation SS df MS F
    Between Groups 1650.867 2 825.4333 5.73026
    Within Groups 3889.3 27 144.0481

    Total 5540.167 29
    P-value F crit
    0.008428 3.354131
    G H I
    Multiple Open-
    Choice Ended
    Morning 75 84 TWO-WAY ANOVA (with replica
    82 63 Anova: Two-Factor With Replication
    69 69
    83 82 SUMMARY Multiple Choic
    86 64 Morning
    93 67 Count 10
    96 85 Sum 821
    99 93 Average 82.1
    75 82 Variance 138.98888889
    63 66
    Afternoon 67 54 Afternoon
    73 62 Count 10
    72 60 Sum 694
    86 40 Average 69.4
    84 78 Variance 159.37777778
    53 85
    47 45 Total
    77 66 Count 20
    74 62 Sum 1515
    61 50 Average 75.75
    Variance 183.77631579

    ANOVA
    Source of Variation SS
    Sample 1960
    Columns 624.1
    Interaction 16.9
    Within 5485.4

    Total 8086.4
    F P-value
    3.83796296296296 0.0058719719
    5.41565040650406 0.0305733267
    1.17897470641373 0.3593925655
    VA (with replication)

    Open-Ended Total

    10 20
    755 1576
    75.5 78.8
    116.277778 132.3789

    10 20
    602 1296
    60.2 64.8
    194.844444 190.0632

    20
    1357
    67.85
    208.976316

    df MS F P-value F crit
    1 1960 12.86324 0.000988 4.113165
    1 624.1 4.095891 0.050458 4.113165
    1 16.9 0.110913 0.741039 4.113165
    36 152.3722

    39
    F crit
    2.39281411
    4.3512435
    2.39281411

    You might also like