Changes

Jump to navigation Jump to search
Line 69: Line 69:  
|}
 
|}
 
*=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==
writer
6,694

edits

Navigation menu