The picture is what the task is and the excel file is the data that should be used

1 answer below »
The picture is what the task is and the excel file is the data that should be used
Answered Same DayApr 16, 2021

Answer To: The picture is what the task is and the excel file is the data that should be used

Subhanbasha answered on Apr 16 2021
132 Votes
Sheet2
    
Sheet1
    
                                    creating random sample size of 80 with respect to before and after
    YEAR    MONTH    FIXED_RATE%    STARTS in $100    # Houses SOLD                random_ FISED RATE% - before    random_ FISED RATE% - af
ter
    1990    1    9.81    1551    45                7.47    6.98            creating Boxplot
    1990    2    9.97    1437    50                8.28    8.27
    1990    3    10.03    1289    58                7.87    5.9
    1990    4    10.14    1248    52                7.09    6.98                summary
    1990    5    10.22    1212    50                9.97    6.23                before    after
    1990    6    10.21    1177    50                8.17    5.71            minimum    6.82    5.5
    1990    7    10.2    1171    46                7.87    5.9            25th percentail    7.2075    6.015
    1990    8    9.99    1115    46                8.68    6.2            median    7.84    6.25
    1990    9    9.99    1110    38                6.92    6.98            75th percentail    8.73    7.1425
    1990    10    10.06    1014    37                7.24    5.85            maximum    10.22    8.35
    1990    11    10.11    1145    34                7.48    7.06
    1990    12    9.87    969    29                7.2    6.02                Data for chart
    1991    1    9.75    798    30                7.24    7.68                before    after
    1991    2    9.62    965    40                7.69    8.08            series1    6.82    5.5
    1991    3    9.45    921    51                7.86    7.11            series2    0.3875    0.515
    1991    4    9.47    1001    50                7.87    5.72            series3    0.6325    0.235
    1991    5    9.52    996    47                6.88    8.35            series4    0.89    0.8925
    1991    6    9.49    1036    47                7.79    6.76            series5    1.49    1.2075
    1991    7    9.49    1063    43                6.89    6.23
    1991    8    9.52    1049    46                7.09    5.53
    1991    9    9.33    1015    37                7.05    5.9
    1991    10    9.1    1079    41                7.5    5.5
    1991    11    8.77    1103    39                10.22    8.27
    1991    12    8.58    1079    36                7.19    6.98
    1992    1    8.35    1176    48                8.58    8.29
    1992    2    8.46    1250    55                7.87    6.72
    1992    3    8.65    1297    56                6.97    6.97
    1992    4    8.71    1099    53                7.91    6.06
    1992    5    8.68    1214    52                7.2    6.23
    1992    6    8.52    1145    53                7.82    6.05
    1992    7    8.28    1139    52                8.06    6.87
    1992    8    8.09    1226    56                8.82    6
    1992    9    7.92    1186    51                8.96    6.02
    1992    10    7.92    1244    48                7.24    6.1
    1992    11    8.06    1214    42                10.22    5.9
    1992    12    8.18    1227    42                10.21    5.89
    1993    1    8.08    1210    44                8.79    5.85
    1993    2    7.86    1210    50                10.22    5.5
    1993    3    7.67    1083    60                7.69    6.19        From the above out put there is no outliers
    1993    4    7.56    1258    66                7.19    7.21
    1993    5    7.48    1260    58                7.77    6.25
    1993    6    7.48    1280    59                7.08    6.19
    1993    7    7.34    1254    55                7.21    7.95            Discriptive...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here