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

I would like detailed solutions for all individual 4 excel sheets and questions on each sheet.

1 answer below »
I would like detailed solutions for all individual 4 excel sheets and questions on each sheet.
projectfiles-0iwrwmbl.xlsx
Answered Same Day Aug 16, 2021

Solution

Komalavalli answered on Aug 18 2021
132 Votes
Q1
            Co
elation Matrix
        FEMALE    AGE    HT    WT    WAIST    PULSE    SYS    DIAS    CHOL    LEG     ELBOW    WRIST    ARM    BMI
    FEMALE    1
    AGE    0.2390765179    1
    HT    -0.2183251828    0.1176516739    1
    WT    -0.0543081142    0.5630032686    0.3644179093    1
    WAIST    0.0332583848    0.6594466172    0.1901557424    0.9211211083    1
    PULSE    0.2681234643    0.30792426    0.2018109811    0.1430541906    0.1327249702    1
    SYS    0.0846214113    0.4185138977    0.1156318155    0.6180460404    0.6754115599    0.1777020833    1
    DIAS    0.3168424666    0.6359416087    0.0505930778    0.4426501681    0.5465136362    0.2962457928    0.7853691538    1
    CHOL    0.1743150137    0.3022396602    0.1162136738    0.4934293283    0.4122944572    0.2659438156    0.2899661661    0.2124760702    1
    LEG     -0.4435771125    -0.2398803095    0.6148174085    0.0269417084    -0.1778269471    -0.263962731    -0.2570773322    -0.4417591297    -0.025335455    1
    ELBOW    -0.0910887238    0.4875268927    0.3626912246    0.8555284135    0.762776557    0.0274240866    0.4671700089    0.2686180786    0.3132134207    0.1367005248    1
    WRIST    -0.1818577383    0.2918522238    0.4208507007    0.6783151811    0.5546253808    0.1140480959    0.2800859431    0.0116836922    0.254953815    0.3100317551    0.7849225324    1
    ARM    0.0189056525    0.58791844    0.039765221    0.888720053    0.8858095152    0.0260449907    0.5110549657    0.3675178754    0.4137337931    -0.1379870885    0.834294384    0.6161582068    1
    BMI    0.0400014298    0.5740365348    0.0243162303    0.9360515816    0.9180666427    0.0988626229    0.6009083916    0.4507061167    0.481804784    -0.2068925838    0.7960528774    0.5869991035    0.9462799835    1
    SUMMARY OUTPUT
    Regression Statistics
    Multiple R    0.9462799835
    R Square    0.8954458071
    Adjusted R Square    0.892694381
    Standard E
or    2.0196889152
    Observations    40
    ANOVA
        df    SS    MS    F    Significance F
    Regression    1    1327.5485540539    1327.5485540539    325.4478824946    3.15791358217233E-20
    Residual    38    155.0074459461    4.0791433144
    Total    39    1482.556
        Coefficients    Standard E
or    t Stat    P-value    Lower 95%    Upper 95%    Lower 95.0%    Upper...
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