Sheet 1-create a histogram for each year 2016, 2017,218Sheet 2 - create a histogram for each year 2016,2017,2018Need mode, medium, standard deviation, variance, skew, correlation if any

1 answer below »
Sheet 1-create a histogram for each year 2016, 2017,218Sheet 2 - create a histogram for each year 2016,2017,2018Need mode, medium, standard deviation, variance, skew, correlation if any
Answered Same DayJul 30, 2021

Answer To: Sheet 1-create a histogram for each year 2016, 2017,218Sheet 2 - create a histogram for each year...

Pritam answered on Aug 01 2021
155 Votes
Sheet1
                            SPEC ED    2016 Score    2017 Score    2018 Score            Bin    Frequency    Cumulative %
    2016 Score            2017 Score                188    140    267            250    1    11.11%
                                1
82    211    251            266    5    66.67%
    Mean    179.1111111111        Mean    188.5555555556            194    218    255            282    1    77.78%
    Standard Error    5.3474927781        Standard Error    13.8885555516            206    221    250            More    2    100.00%
    Median    182        Median    176            161    262    255
    Mode    182        Mode    140            174    140    261
    Standard Deviation    16.0424783344        Standard Deviation    41.6656666547            155    160    294
    Sample Variance    257.3611111111        Sample Variance    1736.0277777778            182    176    255
    Kurtosis    -0.4003908091        Kurtosis    -0.7352622945            170    169    298
    Skewness    0.1029473316        Skewness    0.4564983303
    Range    51        Range    122
    Minimum    155        Minimum    140
    Maximum    206        Maximum    262
    Sum    1612        Sum    1697
    Count    9        Count    9    Bin    Frequency    Cumulative %                                            Bin    Frequency    Cumulative %
                        155    1    11.11%                                            140    2    22.22%
                        172    2    33.33%                                            180.6666666667    3    55.56%
                        189    4    77.78%                                            221.3333333333    3    88.89%
                        More    2    100.00%                                            More    1    100.00%
    2018 Score
                                                        2016 Score    2017 Score    2018 Score
    Mean    265.1111111111
    Standard Error    6.0906222188                                            Mean    179.1111111111    188.5555555556    265.1111111111
    Median    255                                            Standard Error    5.3474927781    13.8885555516    6.0906222188
    Mode    255                                            Mode    182    140    255
    Standard Deviation    18.2718666565                                            Standard Deviation    16.0424783344    41.6656666547    18.2718666565
    Sample Variance    333.8611111111                                            Sample...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here