writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 69:
Line 69: + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Manuals/calci/MULTIPLEREGRESSIONANALYSIS (view source)
Revision as of 20:47, 16 January 2017
, 20:47, 16 January 2017→Examples
|}
|}
*=MULTIPLEREGRESSIONANALYSIS(A1:A8,B1:C8,0.05,TRUE)
*=MULTIPLEREGRESSIONANALYSIS(A1:A8,B1:C8,0.05,TRUE)
'''REGRESSION ANALYSIS OUTPUT'''
{| class="wikitable"
|+Summary Output
|-
! Regression Statistics !!
|-
| Multiple R || 0.6049214629315475
|-
| R Square ||0.3659299763152436
|-
|ADJUSTEDRSQUARE || 0.11230196684134108
|-
|STANDARDERROR ||12.010450881972837
|-
|OBSERVATIONS || 8
|}
{| class="wikitable"
|+ANOVA
|-
! !!DF !!SS!! MS!!F !!SIGNIFICANCE F
|-
| REGRESSION ||2 ||416.24534805858957||208.12267402929479||1.442782195366701|| 0.3201422956953145
|-
|RESIDUAL ||5 || 721.2546519414104||144.2509303882821
|-
|TOTAL ||7||1137.5
|}
{| class="wikitable"
|-
! !!COEFFICIENTS !!STANDARD ERROR !!T STAT!!P-VALUE!!LOWER 95%!!UPPER 95%
|-
|INTERCEPT || -38.43476486203053||57.61581647557267||-0.6670870468064214||0.5342620628633192||-186.54092751432788 ||109.67139779026681
|-
|INDEP1 ||0.19650498774518788|| 0.15890296267754417|| 1.2366351415608787|| 0.2711383732149726||-0.211968057954515|| 0.6049780334448908
|-
|INDEP2 ||0.3566329761773446|| 0.3665155982273022|| 0.973036285228361|| 0.3752244119102771|| -0.5855253082352574|| 1.2987912605899465
|}
{| class="wikitable"
|+RESIDUAL OUTPUT
|-
! OBSERVATION!! PREDICTED Y!! RESIDUALS!! STANDARD RESIDUALS
|-
| 1 || -11.710086528684982||69.71008652868498|| 5.838810706001409
|-
| 2 ||-9.155521687997542||78.15552168799755||6.546187495797013
|-
| 3 || -6.011441884074536||49.011441884074536||4.1051237466409525
|-
| 4 ||-10.924066577704231|| 49.92406657770423||4.181563801403094
|-
|5|| -6.600956847310098||69.6009568473101||5.829670170051966
|-
|6||-8.566006724761976||60.566006724761976||5.072916504540229
|-
|7||-10.531056602213855 ||57.53105660221385|| 4.8187137033369565
|-
|8||-13.0856214429013|| 44.0856214429013|| 3.692544526617634
|}
==Related Videos==
==Related Videos==