《Scatter散布圖教學案例》由會員分享，可在線閱讀，更多相關《Scatter散布圖教學案例（14頁珍藏版）》請在裝配圖網上搜索。

1、dd0609c8bde479c71de174867d2bd851.xlsCalories ConsumedWeight gainedSpeed(Kms/hour)Fuel ConsumptionBatchField15000102111823000.2201313834000.9301011522000.240812025000.350711816000605.3913614000706.312019000.01806.9514328000.6907.5714539001.11008.2716516700.11109.0314319000.151209.8713827000.3513010.7

2、913330000.714011.7711015012.831501101501151532602182382152202182362202432452652432382332102502102502152533153373153183113353203403503363503386SQ統(tǒng)計-圖表-散點圖.(用于分析數(shù)據(jù)的相關性)1，選擇X數(shù)據(jù)范圍 選擇Y數(shù)據(jù)范圍2，數(shù)據(jù)是否有分組,如有則選擇相應的數(shù)據(jù)3,選擇標志位于第一行.(計算軟件會自動忽略第一行的標題）4，選擇回歸方程5，選擇是否顯示回歸線等6,確認，生成結果Page 1dd0609c8bde479c71de174867d2bd851.

3、xls31037531038531335035835844841246341046341342843546341344549420418435420438450470440521519510533516555325235305455335255125535365556354352557354565269630Page 2dd0609c8bde479c71de174867d2bd851.xls622656615645Page 3dd0609c8bde479c71de174867d2bd851.xlsLab20.25612.521.215.5392138.255.681.939.556.440.5

4、14.381.513.781.520.55680.72056.512.119.615.538.819.538558038.555.838.812.580.412.780.920.5551955.512.318.411.53818.53855.338.754.5386SQ統(tǒng)計-圖表-散點圖.(用于分析數(shù)據(jù)的相關性)1，選擇X數(shù)據(jù)范圍 選擇Y數(shù)據(jù)范圍2，數(shù)據(jù)是否有分組,如有則選擇相應的數(shù)據(jù)3,選擇標志位于第一行.(計算軟件會自動忽略第一行的標題）4，選擇回歸方程5，選擇是否顯示回歸線等6,確認，生成結果Page 4dd0609c8bde479c71de174867d2bd851.xls1281.7

5、11.58018.355.380.280.755.815811281.412.538.254.279.318.255.511.419.515.537.519.537.555.58037.515.523.79.840.817.54.336.526.330.450.230.125.513.858.940672.538.819.481.577.454.66.832.6Page 5dd0609c8bde479c71de174867d2bd851.xls19.858.812.949Page 6原原始始數(shù)數(shù)據(jù)據(jù)分分組組圖圖表表參參數(shù)數(shù)XY組1全部唯一15000 AAAX參考線23000.2 AAY參考線3

6、4000.9 AA回歸線類型1、線性22000.2 AA階數(shù)或周期225000.3 AA16000 AA統(tǒng)統(tǒng)計計量量14000 AAX數(shù)據(jù)個數(shù)1419000.01 AAX最小值140028000.6 AAX最大值390039001.1 AAX極差250016700.1 AAY最小值019000.15 AAY最大值1.127000.35 AAY極差1.130000.7 AA回回歸歸線線回歸方程y=0.0005x-0.7546相關系數(shù)平方R2=0.9403A回歸方程y=0.0005x-0.7546相關系數(shù)平方R2=0.9403450040003500300025002000150010005000

7、00.20.40.60.811.2Y 6SQ.Net45004000350030002500200015001000500000.20.40.60.811.2Y原原始始數(shù)數(shù)據(jù)據(jù)分分組組圖圖表表參參數(shù)數(shù)XY組1全部唯一1021 AAAX參考線2013 AAY參考線3010 AA回歸線類型1、線性408 AA階數(shù)或周期2507 AA605.39 AA統(tǒng)統(tǒng)計計量量706.3 AAX數(shù)據(jù)個數(shù)15806.95 AAX最小值10907.57 AAX最大值1501008.27 AAX極差1401109.03 AAY最小值5.391209.87 AAY最大值2113010.79 AAY極差15.6114011

8、.77 AA15012.83 AA回回歸歸線線回歸方程y=-0.0143x+10.995相關系數(shù)平方R2=0.0274A回歸方程y=-0.0143x+10.995相關系數(shù)平方R2=0.02741601401201008060402000510152025y=-0.0143x+10.9948R2=0.0274YLinear(Y)1601401201008060402000510152025y=-0.0143x+10.9948R2=0.0274YLinear(Y)原原始始數(shù)數(shù)據(jù)據(jù)分分組組圖圖表表參參數(shù)數(shù)XY組1全部唯一1820.2111X參考線3856112Y參考線1512.5113回歸線類型1、

9、線性2021.2114階數(shù)或周期21815.51153639116統(tǒng)統(tǒng)計計量量202111X數(shù)據(jù)個數(shù)1074338.211X最小值54555.611X最大值856581.911X極差804339.511Y最小值4.33856.411Y最大值81.93340.511Y極差77.61014.3115081.511回回歸歸線線1013.711回歸方程y=1.223x-1.96755081.511相關系數(shù)平方R2=0.89411520.51153561116080.722回歸方程y=1.3468x-3.6867182022相關系數(shù)平方R2=0.85213856.52221512.122回歸方程y=1.

10、3634x-4.81532019.622相關系數(shù)平方R2=0.86931815.52233638.822回歸方程y=1.1023x+0.9672019.522相關系數(shù)平方R2=0.91694338224455522回歸方程y=1.24x-2.1158658022相關系數(shù)平方R2=0.95514338.52253855.822回歸方程y=1.1904x-2.44243338.822相關系數(shù)平方R2=0.90221012.52265080.422回歸方程y=1.131x-3.50081012.722相關系數(shù)平方R2=0.99565080.9221520.5225355221519333755.53

11、31512.3331818.4331111.5333538332018.533minitab的輸出結果4038335055.3333638.7335054.5333838331012337581.7331011.53390807060504030201000102030405060708090y=1.223x-1.9675R2=0.8941YLinear(Y)90807060504030201000102030405060708090組1組2組3組4組5組6Linear(組1)Linear(組2)Linear(組3)Linear(組4)Linear(組5)Linear(組6)908070605

12、04030201009080706050403020100L La ab bF Fi ie el ld d123456BatchF Fi ie el ld d 與與 L La ab b 的的散散點點圖圖8580331318.3335055.3335880.2335880.7334855.8441215446381441012446381.4441312.5442838.2443554.2446379.3441318.2444555.544911.4442019.5441815.5443537.5442019.5443837.5445055.5447080444037.5442115.55519

13、23.755109.8553340.8551617.55554.3553236.5552326.3553030.4554550.2553330.1552525.5551213.8555358.95536405556556372.5554338.8552519.4557381.5554577.4555254.66696.8663032.6662219.8665658.8661512.96645496690807060504030201009080706050403020100L La ab bF Fi ie el ld d123456BatchF Fi ie el ld d 與與 L La ab

14、 b 的的散散點點圖圖90807060504030201000102030405060708090y=1.223x-1.9675R2=0.8941YLinear(Y)90807060504030201000102030405060708090組1組2組3組4組5組6Linear(組1)Linear(組2)Linear(組3)Linear(組4)Linear(組5)Linear(組6)90807060504030201009080706050403020100L La ab bF Fi ie el ld d123456BatchF Fi ie el ld d 與與 L La ab b 的的散散點點圖圖90807060504030201009080706050403020100L La ab bF Fi ie el ld d123456BatchF Fi ie el ld d 與與 L La ab b 的的散散點點圖圖