Explore BrainMass
Share

Explore BrainMass

    Proportion Test - Student Data

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    All I need is this one problem completed for me..... Thanks in advance!!

    Use the Student_Data.xls file(posted below) to solve the following. For each problem, be sure to state the direction of the test used, the decision to reject the null or not, and the conclusion in English.:

    Problem #1:

    Given the reasons why people get their Masters, you surmise that men are more likely to declare a major than women. Using the sample of 200 students (in the data file), conduct a hypothesis test of proportions to determine if the proportion of women with "no major" is greater than the proportion of men with "no major". Use a .05 significance level.

    NOTE: You can either copy your output into Word and include findings with your output OR you can type your findings directly onto the Excel spreadsheet, but make sure that what you write is easy to find.

    *************** DATA ***************************

    ID Gender Major Employ Age MBA_GPA BS GPA Hrs_Studying Works FT
    1 1 No Major Unemployed 39 2.82 3.05 3 1
    2 1 No Major Full Time 55 3.49 3.45 7 1
    3 1 No Major Part Time 43 3.28 3.5 7 0
    4 1 No Major Full Time 56 3.25 3.55 7 1
    5 1 No Major Full Time 38 3.26 3.3 6 0
    6 1 No Major Unemployed 54 2.87 3.05 4 1
    7 1 No Major Full Time 30 3.16 3.35 6 1
    8 1 No Major Full Time 37 3.4 3.35 6 0
    9 1 No Major Part Time 38 2.84 3.05 3 0
    10 1 No Major Full Time 42 3.72 3.7 7 1
    11 1 No Major Part Time 52 3.22 3.5 7 1
    12 1 No Major Full Time 35 3.44 3.55 7 1
    13 1 No Major Full Time 37 3.65 3.9 8 0
    14 1 No Major Full Time 53 3.02 3.3 6 0
    15 1 No Major Part Time 51 3.03 3.25 6 1
    16 1 No Major Full Time 40 3.8 3.8 8 1
    17 1 No Major Full Time 33 3.23 3.5 7 1
    18 1 No Major Part Time 53 3.26 3.5 7 1
    19 1 No Major Full Time 43 3.53 3.75 8 0
    20 1 No Major Unemployed 35 3.75 3.9 8 1
    21 1 No Major Full Time 57 3.15 3.2 6 0
    22 1 No Major Part Time 32 3.66 3.75 8 1
    23 1 No Major Full Time 59 3.36 3.45 7 0
    24 1 No Major Full Time 48 3.79 3.85 8 0
    25 1 No Major Part Time 34 2.85 3.05 3 0
    26 1 No Major Full Time 53 3.74 3.9 8 1
    27 1 No Major Part Time 35 3.23 3.25 6 0
    28 1 No Major Unemployed 38 3.52 3.7 7 1
    29 1 No Major Part Time 37 3.32 3.45 7 1
    30 1 No Major Full Time 46 2.89 3.1 4 0
    31 1 No Major Full Time 44 2.83 3.05 3 1
    32 1 No Major Unemployed 31 2.93 3.1 5 1
    33 1 No Major Full Time 51 3.71 3.8 8 1
    34 1 No Major Full Time 47 3.47 3.75 8 1
    35 1 No Major Part Time 56 3.52 3.65 7 1
    36 1 Finance Part Time 42 2.83 3.05 3 0
    37 1 Finance Full Time 44 3.64 3.55 7 1
    38 1 Finance Unemployed 54 2.96 3.1 4 0
    39 1 Finance Full Time 51 3.59 3.8 8 1
    40 1 Finance Part Time 42 3.33 3.55 7 1
    41 1 Finance Full Time 45 3.38 3.6 7 0
    42 1 Finance Full Time 55 3.44 3.35 6 1
    43 1 Finance Full Time 47 3.31 3.45 7 0
    44 1 Finance Unemployed 43 3.03 3.25 6 0
    45 1 Finance Full Time 57 3.26 3.4 7 1
    46 1 Finance Full Time 36 3.04 3.25 6 0
    47 1 Finance Part Time 58 2.98 3.1 5 0
    48 1 Finance Full Time 46 2.8 3.05 2 0
    49 1 Finance Full Time 53 3.75 3.75 8 1
    50 1 Finance Full Time 59 3.64 3.65 7 1
    51 1 Finance Full Time 49 3.65 3.8 8 1
    52 1 Finance Full Time 34 3.18 3.3 6 0
    53 1 Finance Full Time 46 3.44 3.4 7 1
    54 1 Finance Unemployed 46 3.06 3.15 6 1
    55 1 Finance Full Time 33 3.51 3.75 8 0
    56 1 Finance Part Time 56 3.33 3.4 7 1
    57 1 Finance Full Time 39 2.81 3.05 2 0
    58 1 Finance Full Time 51 3.64 3.8 8 1
    59 1 Finance Part Time 55 3.05 3.4 7 0
    60 1 Finance Full Time 38 2.85 3.05 3 1
    61 1 Marketing Full Time 33 3.56 3.6 7 1
    62 1 Marketing Full Time 34 2.92 3.1 5 0
    63 1 Marketing Full Time 31 3.35 3.5 7 1
    64 1 Marketing Full Time 37 3.46 3.35 6 1
    65 1 Marketing Full Time 46 3.59 3.75 8 1
    66 1 Marketing Unemployed 31 3.11 3.2 6 0
    67 1 Marketing Full Time 47 3.65 3.7 8 1
    68 1 Marketing Part Time 54 3.17 3.5 7 0
    69 1 Marketing Full Time 52 2.97 3.1 5 1
    70 1 Marketing Part Time 43 3.77 3.9 8 1
    71 1 Leadership Full Time 44 3.21 3.2 6 1
    72 1 Leadership Part Time 34 3.17 3.15 6 0
    73 1 Leadership Full Time 59 3.65 3.65 7 0
    74 1 Leadership Full Time 45 2.94 3.1 5 0
    75 1 Leadership Full Time 30 3.53 3.7 8 1
    76 1 Leadership Full Time 32 3.65 3.6 7 1
    77 1 Leadership Full Time 32 3.61 3.7 8 1
    78 1 Leadership Full Time 40 3.7 3.9 8 1
    79 1 Leadership Full Time 48 2.91 3.1 5 1
    80 1 Leadership Unemployed 51 3.09 3.25 6 0
    81 1 Leadership Full Time 30 3.77 3.95 9 1
    82 1 Leadership Full Time 31 3.79 3.8 8 1
    83 1 Leadership Full Time 35 3.59 3.6 7 1
    84 1 Leadership Full Time 33 3.38 3.5 7 1
    85 1 Leadership Full Time 35 3.57 3.5 7 1
    86 1 Leadership Full Time 31 2.97 3.1 5 0
    87 1 Leadership Full Time 38 3.44 3.65 7 1
    88 1 Leadership Part Time 46 3.64 3.55 7 1
    89 1 Leadership Full Time 45 3.48 3.4 7 1
    90 1 Leadership Full Time 59 2.99 3.1 5 1
    91 1 Leadership Full Time 58 3.73 3.8 8 0
    92 1 Leadership Full Time 46 2.91 3.05 4 0
    93 1 Leadership Full Time 35 3.78 3.95 9 1
    94 1 Leadership Part Time 53 3.4 3.4 7 0
    95 1 Leadership Full Time 31 3.13 3.15 6 0
    96 1 Leadership Full Time 50 3.14 3.25 6 1
    97 1 Leadership Full Time 38 3.24 3.3 6 0
    98 1 Leadership Full Time 50 3.56 3.5 7 1
    99 1 Leadership Full Time 48 3.16 3.25 6 0
    100 1 Leadership Full Time 53 3.53 3.55 7 1
    101 0 No Major Unemployed 53 3.01 3.15 6 0
    102 0 Leadership Full Time 30 3.3 3.35 6 1
    103 0 No Major Part Time 32 3.62 3.6 7 0
    104 0 Leadership Full Time 42 3.21 3.4 7 0
    105 0 Leadership Full Time 56 3.39 3.4 7 1
    106 0 No Major Full Time 46 3.65 3.8 8 1
    107 0 Leadership Full Time 49 3.47 3.7 8 1
    108 0 No Major Part Time 32 3.44 3.6 7 0
    109 0 No Major Full Time 36 3.88 3.95 9 1
    110 0 Leadership Full Time 42 3.83 3.95 9 1
    111 0 No Major Part Time 37 3.53 3.6 7 1
    112 0 No Major Full Time 31 3.22 3.3 6 0
    113 0 No Major Full Time 31 3.56 3.8 8 1
    114 0 No Major Unemployed 42 3.2 3.25 6 1
    115 0 No Major Full Time 39 3.17 3.3 6 1
    116 0 No Major Full Time 47 3.41 3.6 7 1
    117 0 No Major Part Time 28 3.56 3.7 8 1
    118 0 No Major Unemployed 28 3.34 3.6 7 0
    119 0 No Major Full Time 52 3.44 3.6 7 1
    120 0 No Major Part Time 35 3.76 3.8 8 1
    121 0 Finance Full Time 38 3.55 3.45 7 1
    122 0 Finance Full Time 44 3.88 3.9 8 1
    123 0 Finance Part Time 38 3.31 3.45 7 1
    124 0 Finance Full Time 52 3.09 3.15 6 1
    125 0 Finance Unemployed 53 3.82 4 9 0
    126 0 Finance Part Time 53 3.01 3.2 6 1
    127 0 Finance Full Time 31 3.66 3.85 8 1
    128 0 Finance Part Time 47 3.64 3.7 8 1
    129 0 Finance Full Time 51 3.59 3.65 7 1
    130 0 Finance Unemployed 37 3.49 3.55 7 1
    131 0 Finance Part Time 46 3.13 3.2 6 1
    132 0 Finance Full Time 48 3.83 3.9 8 1
    133 0 Finance Full Time 54 3.04 3.15 6 1
    134 0 Finance Full Time 48 3.91 4 10 1
    135 0 Finance Full Time 36 3.56 3.7 8 1
    136 0 Finance Unemployed 39 3.96 4 9 1
    137 0 Finance Full Time 28 3.46 3.4 7 1
    138 0 Finance Part Time 45 3.22 3.15 6 0
    139 0 Finance Full Time 31 3.27 3.2 6 0
    140 0 Finance Full Time 47 3.43 3.45 7 1
    141 0 Finance Part Time 35 3.85 3.95 9 1
    142 0 Finance Full Time 52 3.89 3.9 8 1
    143 0 Finance Part Time 52 3.37 3.45 7 1
    144 0 Finance Unemployed 55 3.32 3.3 6 0
    145 0 Finance Full Time 52 3.54 3.55 7 1
    146 0 Finance Part Time 46 3.8 3.9 8 1
    147 0 Finance Full Time 31 3.74 3.85 8 1
    148 0 Finance Full Time 33 3.17 3.45 7 1
    149 0 Finance Part Time 45 3.27 3.55 7 1
    150 0 Finance Full Time 50 3.32 3.3 6 1
    151 0 Marketing Part Time 33 3.56 3.45 7 1
    152 0 Marketing Full Time 37 3.95 4 9 1
    153 0 Marketing Unemployed 33 3.56 3.75 8 0
    154 0 Marketing Full Time 46 3.79 3.75 8 1
    155 0 Marketing Part Time 55 3.93 4 9 1
    156 0 Marketing Full Time 30 3.79 3.85 8 1
    157 0 Marketing Full Time 51 3.71 3.85 8 1
    158 0 Marketing Part Time 35 3.05 3.35 6 1
    159 0 Marketing Unemployed 40 3.22 3.2 6 1
    160 0 Marketing Part Time 29 3.85 3.95 9 1
    161 0 Marketing Full Time 52 3.82 3.95 9 1
    162 0 Marketing Full Time 27 3.23 3.95 9 1
    163 0 Marketing Full Time 51 3.56 3.65 7 1
    164 0 Marketing Part Time 56 3.53 3.65 7 1
    165 0 Marketing Full Time 35 3.62 4 9 1
    166 0 Leadership Full Time 46 3.8 3.95 9 1
    167 0 Leadership Part Time 39 3.47 3.35 6 0
    168 0 Leadership Full Time 31 3.64 3.65 7 1
    169 0 Leadership Full Time 52 3.03 3.15 5 1
    170 0 Leadership Unemployed 32 3.17 3.25 6 1
    171 0 Leadership Part Time 32 3.22 3.2 6 1
    172 0 Leadership Full Time 44 3.92 4 10 1
    173 0 Leadership Full Time 43 3.82 3.95 9 1
    174 0 Leadership Part Time 38 3.26 3.55 7 1
    175 0 Leadership Full Time 54 3.8 3.85 8 1
    176 0 Leadership Full Time 27 3.2 3.2 6 0
    177 0 Leadership Part Time 38 3.46 3.35 6 1
    178 0 Leadership Full Time 45 3.67 3.75 8 1
    179 0 Leadership Unemployed 48 3.06 3.4 7 0
    180 0 Leadership Full Time 43 3.66 3.85 8 0
    181 0 Leadership Full Time 34 3.96 4 10 1
    182 0 Leadership Full Time 54 3.75 3.85 8 1
    183 0 Leadership Full Time 36 3.83 3.85 8 1
    184 0 Leadership Full Time 45 3.22 3.2 6 1
    185 0 Leadership Unemployed 28 3.36 3.35 6 1
    186 0 Leadership Full Time 37 3.21 3.25 6 1
    187 0 Leadership Full Time 27 3.02 3.15 5 1
    188 0 Leadership Full Time 31 3.99 4 10 1
    189 0 Leadership Unemployed 45 3.07 3.15 6 1
    190 0 Leadership Full Time 48 3.65 3.65 7 1
    191 0 Leadership Full Time 50 3.67 3.85 8 1
    192 0 Leadership Full Time 32 3.06 3.35 6 0
    193 0 Leadership Unemployed 33 3.98 3.7 8 1
    194 0 Leadership Full Time 49 3.93 4 10 1
    195 0 Leadership Unemployed 27 3.41 3.3 6 0
    196 0 Leadership Part Time 28 3.43 3.5 7 1
    197 0 Leadership Full Time 36 3.7 3.65 7 0
    198 0 Leadership Full Time 35 3.76 3.75 8 1
    199 0 Leadership Part Time 47 3.9 3.9 8 0
    200 0 Leadership Full Time 33 3.23 3.3 6 1

    © BrainMass Inc. brainmass.com October 10, 2019, 8:08 am ad1c9bdddf
    https://brainmass.com/business/managerial-statistics/proportion-test-student-data-609326

    Solution Preview

    See the attached file. Thanks

    Problem #1:
    Given the reasons why people get their Masters, you surmise that men are more likely to declare a major than women. Using the sample of 200 students (in the data file), conduct a hypothesis test of proportions to determine if the proportion of women with "no major" is greater than the proportion of men with "no major". Use a .05 significance ...

    Solution Summary

    The solution shows how to conduct a hypothesis test for proportions.

    $2.19