Scribd Logo
Upload

Welcome to Scribd!

  • 19 views

    Bb113 t3 Group A

    Uploaded by

    Russell Fernandez
    1. A random sample of 50 students was selected from a dataset of 207 students by assigning each student a random number, sorting the numbers, and selecting the first 50. 2. The random sample consisted of 31 males (62%) and 19 females (38%). Most of the random sample (62%) were male while about two out of five (38%) were female.

    Copyright:

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

    Bb113 t3 Group A

    Uploaded by

    Russell Fernandez
    19 views3 pages
    1. A random sample of 50 students was selected from a dataset of 207 students by assigning each student a random number, sorting the numbers, and selecting the first 50. 2. The random sample consisted of 31 males (62%) and 19 females (38%). Most of the random sample (62%) were male while about two out of five (38%) were female.

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1. A random sample of 50 students was selected from a dataset of 207 students by assigning each student a random number, sorting the numbers, and selecting the first 50. 2. The random sample consisted of 31 males (62%) and 19 females (38%). Most of the random sample (62%) were male while about two out of five (38%) were female.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    19 views3 pages

    Bb113 t3 Group A

    Uploaded by

    Russell Fernandez
    1. A random sample of 50 students was selected from a dataset of 207 students by assigning each student a random number, sorting the numbers, and selecting the first 50. 2. The random sample consisted of 31 males (62%) and 19 females (38%). Most of the random sample (62%) were male while about two out of five (38%) were female.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 3

    1. We added a column (i.e. Student No.

    ) after the C1-C5 columns from the given dataset and


    assigned it for the student number of the respondents. The student numbers are from 1 to
    207.
    Column G then is named Random Sample. We used the formula =RAND() for this
    column to assign a random number for each student. This formula was typed in cell G2, we
    just used Autofill for the rest of the cells in the column.
    Column G (Random Sample) was copied and pasted as Value to replace the functions
    with the actual values to avoid generating new numbers whenever anything changes on the
    page. Then we sorted Random Sample from smallest to largest expanding the selection to all
    columns. This now arranged the rows randomly.
    The first 50 students from the randomly arranged list now become the members of the
    sample.
    b.
    C1 C2 C3 C4 C5 Student No.
    Male 175 6 5 A 36
    Male 169 5 4 B 67
    Female 163 6 3 A 173
    Male 172 5 5 A 58
    Female 166 5 3 A 74
    Male 160 5 4 B 193
    Male 175 5 4 B 23
    Female 160 6 1 A 55
    Female 154 6 5 A 124
    Male 185 4 4 A 20
    Male 179 5 3 A 158
    Male 173 4 4 B 186
    Male 180 6 3 A 153
    Male 169 6 4 A 132
    Female 161 5 4 A 131
    Male 173 6 4 A 112
    Male 183 6 4 A 64
    Male 177 5 2 B 89
    Female 162 6 4 A 24
    Male 173 5 4 A 38
    Male 180 5 5 A 116
    Male 173 6 5 A 45
    Female 153 5 5 B 133
    Female 163 5 4 A 127
    Male 175 3 3 A 204
    Male 168 5 2 B 150
    Male 178 6 3 A 108
    Male 183 6 4 A 170
    Female 160 6 3 B 50
    Male 179 5 4 A 65
    Female 163 3 4 A 54
    Male 174 6 5 A 46
    Male 174 6 4 A 143
    Female 168 5 5 A 190
    Male 175 6 5 A 103
    Female 171 6 4 A 162
    Male 168 5 3 A 176
    Male 165 6 3 A 146
    Male 173 6 3 A 30
    Female 160 4 3 A 7
    Female 162 6 4 A 138
    Female 152 5 5 A 165
    Male 170 6 5 A 29
    Male 183 5 4 B 152
    Male 168 6 5 A 48
    Female 152 6 3 B 42
    Female 153 6 4 B 135
    Female 158 5 3 B 99
    Male 166 5 3 A 174
    Female 163 6 3 A 70

    2.
    a.
    Gende Frequen Percenta
    r cy ge
    Male 31 62%
    Female 19 38%
    Total 50 100%

    b.
    Gender

    38%
    Male

    Female
    62%

    c.
    There are more female students than male ones in the sample. The sample is comprised
    mostly (62%) of female students. Only about two out of five (38%) students in the sample are
    males.

    You might also like