Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Attached the question.

1 answer below »
Observation No
    Age at death
    Mother's age at death
    Father's age at death
    No of years of employment
    Gende
    6
    71
    72
    67
    40
    Female
    7
    72
    77
    64
    33
    Male
    8
    72
    76
    71
    33
    Male
    9
    69
    73
    60
    30
    Female
    10
    77
    81
    78
    30
    Male
    11
    71
    76
    67
    40
    Female
    12
    69
    75
    67
    30
    Female
    13
    69
    73
    69
    33
    Female
    14
    72
    69
    72
    35
    Male
    15
    80
    84
    73
    15
    Male
    16
    81
    82
    77
    30
    Female
    17
    66
    80
    63
    35
    Female
    18
    68
    72
    71
    33
    Female
    19
    72
    71
    66
    30
    Male
    20
    71
    76
    61
    35
    Female
    21
    62
    65
    57
    36
    Female
    22
    71
    71
    71
    41
    Female
    23
    67
    68
    68
    25
    Female
    24
    67
    69
    66
    37
    Female
    25
    79
    88
    73
    20
    Male
    26
    67
    73
    62
    30
    Male
    27
    71
    76
    67
    25
    Male
    28
    73
    79
    71
    40
    Male
    29
    72
    66
    75
    40
    Male
    30
    74
    78
    68
    25
    Female
    31
    74
    82
    66
    20
    Male
    32
    89
    86
    77
    20
    Male
    33
    83
    90
    72
    20
    Female
    34
    78
    82
    72
    33
    Male
    35
    71
    78
    64
    40
    Female
    36
    73
    69
    80
    35
    Male
    37
    74
    79
    71
    35
    Female
    38
    71
    73
    72
    41
    Female
    39
    77
    72
    72
    20
    Male
    40
    77
    79
    74
    25
    Male
    41
    74
    77
    64
    15
    Male
    42
    72
    78
    64
    33
    Male
    43
    77
    85
    77
    18
    Male
    44
    66
    74
    64
    38
    Female
    45
    70
    67
    65
    38
    Female
    46
    63
    71
    56
    38
    Female
    47
    82
    83
    78
    25
    Female
    48
    66
    64
    66
    36
    Male
    49
    74
    76
    66
    35
    Male
    50
    74
    82
    71
    41
    Male
    51
    77
    85
    69
    31
    Male
    52
    69
    72
    63
    32
    Female
    53
    72
    77
    69
    40
    Male
    54
    67
    68
    69
    38
    Female
    55
    74
    71
    76
    45
    Male
    56
    67
    76
    62
    25
    Male
    57
    68
    74
    62
    30
    Female
    58
    68
    74
    79
    30
    Female
    59
    71
    71
    60
    28
    Male
    60
    84
    80
    90
    15
    Male
    61
    78
    82
    70
    40
    Male
    62
    76
    82
    65
    22
    Female
    63
    68
    71
    61
    35
    Female
    64
    70
    66
    75
    36
    Female
    65
    77
    82
    76
    30
    Male
    66
    73
    67
    71
    25
    Male
    67
    72
    78
    70
    30
    Male
    68
    77
    75
    66
    25
    Male
    69
    75
    73
    69
    30
    Female
    70
    71
    77
    70
    30
    Male
    71
    70
    77
    60
    41
    Female
    72
    65
    75
    60
    25
    Female
    73
    68
    72
    66
    31
    Female
    74
    71
    70
    70
    43
    Female
    75
    68
    75
    63
    32
    Female
    76
    59
    59
    62
    35
    Female
    77
    83
    82
    82
    30
    Male
    78
    66
    69
    68
    38
    Male
    79
    76
    80
    70
    31
    Male
    80
    65
    66
    63
    33
    Male
    81
    70
    66
    68
    25
    Female
    82
    76
    88
    69
    30
    Male
    83
    74
    79
    70
    25
    Male
    84
    73
    80
    75
    41
    Male
    85
    75
    76
    72
    25
    Male
statistics-question-jkiasf5f.docx
Answered Same Day Sep 22, 2022

Solution

Rajeswari answered on Sep 22 2022
73 Votes
Sheet4
    Age at death         Mother's age at death        Father's age at death         No of years of employment         Qno.1
    Mean    72.2625    Mean    75.4    Mean    68.8125    Mean    31.3625
    Standard E
or    0.5883208647    Standard E
or    0.6925462101    Standard E
or    0.6748402882    Standard E
or    0.7944116026
    Median    72    Median    76    Median    69    Median    31.5
    Mode    71    Mode    82    Mode    71    Mode    30
    Standard Deviation    5.2621017844    Standard Deviation    6.1943216136    Standard Deviation    6.0359550333    Standard Deviation    7.1054333819
    Sample Variance    27.6897151899    Sample Variance    38.3696202532    Sample Variance    36.4327531646    Sample Variance    50.4871835443
    Kurtosis    0.7743324094    Kurtosis    -0.2242485456    Kurtosis    0.9217246204    Kurtosis    -0.4042577474
    Skewness    0.4587811553    Skewness    -0.0018878208    Skewness    0.5392814197    Skewness    -0.4122945979
    Range    30    Range    31    Range    34    Range    30
    Minimum    59    Minimum    59    Minimum    56    Minimum    15
    Maximum    89    Maximum    90    Maximum    90    Maximum    45
    Sum    5781    Sum    6032    Sum    5505    Sum    2509
    Count    80    Count    80    Count    80    Count    80
    Confidence Level(95.0%)    1.171023369    Confidence Level(95.0%)    1.3784787262    Confidence Level(95.0%)    1.3432359707    Confidence Level(95.0%)    1.5812367146
    Qno.2
    When mean, median, and mode coincide the distribution is symmetrical.
    Here we find that age of death is slightly right skewed with slight difference between 3 and mean > median.
    Whereas mother's age at death is left skewed very slightly, with mode being higher. Mean < median here.
    Father's age of death has positive skewness less than 1, and mean, median mode almost near each other.
    No of years of employment is left skewed with mean median mode almost practically near to each other.
    To conclude age at death, mother age, no of years of employment are practically almost symmetrical while
    father age at death is slightly having a higher mode.
    Qno.3
    Dependent variable is age of death but independent variables are three as mother age, father age and years of employment.
Sheet5
    SUMMARY OUTPUT                                                            Qno 3 contd.
    Regression Statistics
    Multiple R    0.8828279962
    R Square    0.7793852709
    Adjusted R Square    0.7706767948
    Standard E
or    2.5198996485
    Observations    80
    ANOVA
        df    SS    MS    F    Significance F
    Regression    3    1704.8955378824    568.2985126275    89.4973193714    7.11459842313773E-25
    Residual    76    482.5919621176    6.3498942384
    Total    79    2187.4875
        Coefficients    Standard E
or    t Stat    P-value    Lower 95%    Upper 95%    Lower 95.0%    Upper 95.0%
    Intercept    14.4404752622    5.1033743274    2.8295935857    0.0059584794    4.2762245562    24.6047259682    4.2762245562    24.6047259682
    Mother's age at death    0.4322897842    0.052186444    8.2835646721    0    0.3283514746    0.5362280937    0.3283514746    0.5362280937
    Father's age at death     0.4201391934    0.0501228542    8.3821881343    0    0.3203108792    0.5199675075    0.3203108792    0.5199675075
    No of years of employment     -0.1174476917    0.0436610304    -2.6899890058    0.0087801874    -0.2044061687    -0.0304892148    -0.2044061687    -0.0304892148
                            Qno.5
    RESIDUAL OUTPUT
                        a to e    Coefficient of 0.43229 for mother age is significant with p value less than 0.05
    Observation    Predicted Age at death     Residuals            a)    Without intercept all coefficients are highly signficant showing linear co
elation is there
    1    69.0167580085    1.9832419915                for all independent variables with dependent variables. TO make more effective, we
    2    70.7399231914    1.2600768086                can make intercept 0, and use only slopes. No of years of employment is negatively
    3    73.2486077608    -1.2486077608                associated with a person's age of death.
    4    67.6825503564    1.3174496436
    5    78.7033741104    -1.7033741104                Co
elation of all variables with adjustment is 0.779 which shows a strong co
elation.
    6    70.7459171452    0.2540828548                Without adjustments R is more 0.8828.
    7    71.4881042783    -2.4881042783
    8    71.1114600215    -2.1114600215            b)    coeff of det R^2 is 0.779385. Adjted R^2 is 0.770677, showing positive strong co
elation.
    9    70.4078230815    1.5921769185
    10    79.6612628721    0.3387371279            c)    At 5% level of significance, overall F is 89.497. p value is less than 5%.
    11    78.7155247012    2.2844752988
    12    71.381757967    -5.381757967            d)    slopes are having p value less than 5% showing slopes are significant.
    13    71.5194486241    -3.5194486241
    14    69.3388059483    2.6611940517            e)
    15    68.8123204436    2.1876795564
    16    62.2591283526    -0.2591283526
    17    70.1475773061    0.8524226939
    18    69.4694534412    -2.4694534412
    19    67.6520925378    -0.6520925378
    20    80.8031835501    -1.8031835501
    21    68.5228287432    -1.5228287432
    22    72.5076325212    -1.5076325212
    23    73.7233432711    -0.7233432711
    24    69.7841328504    2.2158671496
    25    73.7923512829    0.2076487171
    26    75.2684704915    -1.2684704915
    27    81.6191607552    7.3808392448
    28    81.247623925    1.752376075
    29    76.2624856591    1.7375143409
    30    70.3500791334    0.6499208666
    31    73.7689366285    -0.7689366285
    32    74.3105817298    -0.3105817298
    33    71.4322960678    -0.4322960678
    34    73.46640781    3.53359219
    35    76.7454762273    0.2545237727
    36    72.8539816426    1.1460183574
    37    71.1722129755    0.8277870245
    38    81.4217663545    -4.4217663545
    39    68.8558153802    -2.8558153802
    40    66.2499260844    3.7500739156
    41    64.1978324808    -1.1978324808
    42    80.1551921374    1.8448078626
    43    65.6080913087    0.3919086913
    44    70.9130164105    3.0869835895
    45    74.9027649319    -0.9027649319
    46    76.533832815    0.466167185
    47    68.2757827689    0.7242172311
    48    72.0184853161    -0.0184853161
    49    68.362772642    -1.362772642
    50    71.778482506    2.221517494
    51    70.4069365543    -3.4069365543
    52    68.9551185273    -0.9551185273
    53    76.0974848146    -8.0974848146
    54    67.0528661716    3.9471338284
    55    85.0744700226    -1.0744700226
    56    74.6000734303    3.3999265697
    57    74.6134359146    1.3865640854
    58    66.6508715228    1.3491284772
    59    70.2539236174    -0.2539236174
    60    78.2953855078    -1.2953855078
    61    70.2975812371    2.7024187629
    62    74.0453912109    -2.0453912109
    63    71.6552035436    5.3447964564
    64    71.4638030967    3.5361969033
    65    73.6131014268    -2.6131014268
    66    68.119784884    1.880215116
    67    69.1343683834    -4.1343683834
    68    69.6536480407    -1.6536480407
    69    69.0602529451    1.9397470549
    70    69.5726521214    -1.5726521214
    71    61.8835333062    -2.8835333062
    72    80.816220668    2.183779332
    73    68.3749232328    -2.3749232328
    74    74.7925230875    1.2074769125
    75    65.5645963722    -0.5645963722
    76    68.6048738729    1.3951261271
    77    77.9481498592    -1.9481498592
    78    75.0649194538    -1.0649194538
    79    75.718742137    -2.718742137
    80    74.608328488    0.391671512
Mother's age at death Line Fit Plot
Age at death     72    77    76    73    81    76    75    73    69    84    82    80    72    71    76    65    71    68    69    88    73    76    79    66    78    82    86    90    82    78    69    79    73    72    79    77    78    85    74    67    71    83    64    76    82    85    72    77    68    71    76    74    74    71    80    82    82    71    66    82    67    78    75    73    77    77    75    72    70    75    59    82    69    80    66    66    88    79    80    76    71    72    72    69    77    71    69    69    72    80    81    66    68    72    71    62    71    67    67    79    67    71    73    72    74    74    89    83    78    71    73    74    71    77    77    74    72    77    66    70    63    82    66    74    74    77    69    72    67    74    67    68    68    71    84    78    76    68    70    77    73    72    77    75    71    70    65    68    71    68    59    83    66    76    65    70    76    74    73    75    Predicted Age at death...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Attach File