(25 points) Part 2 – Descriptive Statistics (Week 3): This week you will calculate descriptive statistics for the first question, age. Your instructor will send you the “data sheet” with all the class...

Week 3
    Age    Gender                For the following questions, use only the "age" column:
    48    M
    22    F        GRADING    Points    Age Frequency Distribution:                Class Width    12
    26    M
    28    M                Class Limits        Midpoint    Freq.    Relative Frequency    Cumulative Relative Freq
    34    M                Low    High
    27    M        Limits    1    13    25    19    42    0.4330    0.4330
    50    M        Freq.    1    25    37    31    32    0.3299    0.7629
    24    F        Mid.    1    37    49    43    15    0.1546    0.9175
    45    F        RF    1    49    61    55    6    0.0619    0.9794
    23    M        CF    1    61    73    67    2    0.0206    1.0000
    19    F                            97
    28    M            2    Mean    29.89    *Round to two decimals
    25    F            2    Median    27.4    *Round to one decimal
    22    F            2    Sample Standard deviation:            12.03    *Round to two decimals
    20    F            2    Q1    19.9    *Round to one decimal
    21    F            2    Q3    36.5    *Round to one decimal
    25    M
    19    F
    22    F        Ogive    5            Ogive:                        Polygon:
    24    M        Polygon    5    High    Less than cummulative
    36    M                25    42
    34    F                37    74
    45    F                49    89
    21    M        Total:    25    61    95
    30    M                73    97
    35    M
    58    F
    27    F
    31    F
    43    F
    22    M
    32    M
    44    F
    19    F
    36    M
    21    M
    21    M
    14    M
    22    M
    26    M
    68    M
    29    F
    32    M
    25    M
    46    M
    29    F
    53    F
    37    F
    25    M
    18    F
    22    F
    35    M
    42    F
    31    F
    19    F
    23    M
    19    F
    72    F
    24    M
    23    M
    47    M
    24    M
    26    M
    42    F
    31    M
    20    M
    20    M
    38    F
    34    F
    28    M
    20    M
    38    M
    36    F
    35    M
    21    M
    48    M
    59    F
    19    M
    25    M
    45    F
    30    F
    23    M
    31    M
    21    F
    20    M
    23    F
    42    F
    46    M
    26    M
    24    F
    26    M
    59    F
    52    F
    30    M
    31    F
    24    M
    20    F
Help for this spreadsheet
• Review 2.2, 3.1 – 3.3 of your text.
• Your data is already copied into columns A and B.
• Only cells in yellow need to be completed.
• Choose a class width according to the following equation:
CLASS WIDTH = (MAX VALUE - MIN VALUE)/# of Classes (5)
• The ogive and polygon graphs need to be included on this page under the headers below. Please do not put them on a separate page.
• View Part 2 Video Walk Thru for step by step instructions.
https://watch.liberty.edu/media/t/1_qvisc8z5Ogive Curve
Less than cummulative    25    37    49    61    73    42    74    89    95    97    Upper Limit
Less than type cummulative frequeuncy
Frequency Polygon
19    31    43    55    67    42    32    15    6    2    MIdpoints
Frequency
Sheet2
Week 5
    Age    Gender    Grading:    Points    95% Confidence Interval for Average Age of Online College Students:
    48    M
    22    F            Sample Mean:        29.89
    26    M            Sample St. Dev:        12.03                            Normal Distribution
    28    M        1    Sample Size:                                    T-Distribution
    34    M
    27    M        2    Distribution:
    50    M
    24    F        2    Critical Value:            *2 decimals
    45    F
    23    M        2    Margin of Error:            *2 decimals    Show Your Calculation:
    19    F        1    Lower Bound:            *2 decimals    Show Your Calculation:
    28    M        1    Upper Bound:             *2 decimals    Show Your Calculation:
    25    F
    22    F            Interpret
    20    F        2
    21    F
    25    M            95% Confidence Interval for Proportion of Male Online College Students:
    19    F
    22    F        1    Sample Size:
    24    M        1    Number of...