Variance.xlsx

  • Uploaded by: abhishek bhardwaj
  • 0
  • 0
  • August 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Variance.xlsx as PDF for free.

More details

  • Words: 158
  • Pages: 4
A 19 17 22 20

B 18 16 15 14

C 21 20 19 19

D 22 23 21 20

Anova: Single Factor SUMMARY Groups Count A 4 B 4 C 4 D 4

ANOVA Source of VariationSS Between G 70.25 Within Gro 29.5 Total

99.75

Sum 78 63 79 86

df

Average 19.5 15.75 19.75 21.5

Variance 4.333333 2.916667 0.916667 1.666667

MS F P-value F crit 3 23.41667 9.525424 0.001695 5.952545 12 2.458333 15

stress tensile 10 9 7 8 11

6 3 2 4 5

SUMMARY OUTPUT Regression Statistics Multiple R 0.831521841 R Square 0.691428571 Adjusted R Square 0.537142857 Standard Error 0.878310066 Observations 4 ANOVA df Regression Residual Total

Intercept

1 2 3

SS 3.4571428571 1.5428571429 5

Coefficients Standard Error -2 2.634930197 10 0.628571429 0.2969229956

MS 3.4571428571 0.7714285714

t Stat -0.7590333901 2.116950987

F Significance F 4.4814814815 0.168478159

P-value Lower 95% Upper 95% Lower 95.0% 0.5270917927 -13.3371896 9.337189605 -13.3371896 0.1684781594 -0.648985109 1.906127966 -0.648985109

Upper 95.0% 9.3371896047 1.906127966

More Documents from "abhishek bhardwaj"