I basically need the week 3 tab edited, I uploaded my professor's notes on which ones that need correcting. After those changes have been made, I need the week 5 tab completed with the correct...

1 answer below »
I basically need the week 3 tab edited, I uploaded my professor's notes on which ones that need correcting. After those changes have been made, I need the week 5 tab completed with the correct answers.
Answered Same DayApr 25, 2021

Answer To: I basically need the week 3 tab edited, I uploaded my professor's notes on which ones that need...

Atreye answered on Apr 26 2021
144 Votes
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.43
30    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    31.19    *Round to two decimals
    25    F            2    Median    27    *Round to one decimal
    22    F            2    Sample Standard deviation:            11.9    *Round to two decimals
    20    F            2    Q1    22    *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_qvisc8z5The Less than Ogive for the age of 97 people
Less than cummulative    25    37    49    61    73    42    74    89    95    97    Upper Limit
Less than type cummulative frequeuncy
Frequency Polygon of the age distribution
19    31    43    55    67    42    32    15    6    2    MIdpoints
Frequency
Week 5
    Age    Gender    Grading:    Points    95% Confidence Interval for Average Age of Online College Students:
    48    M
    22    F            Sample Mean:        31.19
    26    M            Sample St. Dev:        11.9                            Normal Distribution
    28    M        1    Sample Size:        97                            T-Distribution
    34    M
    27    M        2    Distribution:        T-Distribution
    50    M
    24    F        2    Critical Value:        1.98    *2 decimals
    45    F
    23    M        2    Margin of Error:        2.39    *2 decimals    Show Your Calculation:    M.E=1.98*(11.9/sqrt(97))
    19    F        1    Lower Bound:        28.8    *2 decimals    Show Your Calculation:    LB=31.19-2.39
    28    M        1    Upper Bound:         33.58    *2 decimals    Show Your Calculation:    UB=31.19+2.39
    25    F
    22    F            Interpret    It can be concluded with 95% certainty that the average age of students in online classes is between 28.8 and 33.58.
    20    F        2
    21    F
    25    M            95% Confidence Interval for...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here