Scatter散布图教学案例

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.7913330000.714011.7711015012.831501101501151532602182382152202182362202432452652432382332102502102502152533153373153183113353203403503363503386SQ统计-图表-散点图.(用于分析数据的相关性)1，选择X数据范围 选择Y数据范围2，数据是否有分组,如有则选择相应的数据3,选择标志位于第一行.(计算软件会自动忽略第一行的标题）4，选择回归方程5，选择是否显示回归线等6,确认，生成结果Page 1dd0609c8bde479c71de174867d2bd851.xls31037531038531335035835844841246341046341342843546341344549420418435420438450470440521519510533516555325235305455335255125535365556354352557354565269630Page 2dd0609c8bde479c71de174867d2bd851.xls622656615645Page 3dd0609c8bde479c71de174867d2bd851.xlsLab20.25612.521.215.5392138.255.681.939.556.440.514.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统计-图表-散点图.(用于分析数据的相关性)1，选择X数据范围 选择Y数据范围2，数据是否有分组,如有则选择相应的数据3,选择标志位于第一行.(计算软件会自动忽略第一行的标题）4，选择回归方程5，选择是否显示回归线等6,确认，生成结果Page 4dd0609c8bde479c71de174867d2bd851.xls1281.711.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原原始始数数据据分分组组图图表表参参数数XY组1全部唯一15000 AAAX参考线23000.2 AAY参考线34000.9 AA回归线类型1、线性22000.2 AA阶数或周期225000.3 AA16000 AA统统计计量量14000 AAX数据个数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相关系数平方R2=0.9403A回归方程y=0.0005x-0.7546相关系数平方R2=0.940345004000350030002500200015001000500000.20.40.60.811.2Y 6SQ.Net45004000350030002500200015001000500000.20.40.60.811.2Y原原始始数数据据分分组组图图表表参参数数XY组1全部唯一1021 AAAX参考线2013 AAY参考线3010 AA回归线类型1、线性408 AA阶数或周期2507 AA605.39 AA统统计计量量706.3 AAX数据个数15806.95 AAX最小值10907.57 AAX最大值1501008.27 AAX极差1401109.03 AAY最小值5.391209.87 AAY最大值2113010.79 AAY极差15.6114011.77 AA15012.83 AA回回归归线线回归方程y=-0.0143x+10.995相关系数平方R2=0.0274A回归方程y=-0.0143x+10.995相关系数平方R2=0.02741601401201008060402000510152025y=-0.0143x+10.9948R2=0.0274YLinear(Y)1601401201008060402000510152025y=-0.0143x+10.9948R2=0.0274YLinear(Y)原原始始数数据据分分组组图图表表参参数数XY组1全部唯一1820.2111X参考线3856112Y参考线1512.5113回归线类型1、线性2021.2114阶数或周期21815.51153639116统统计计量量202111X数据个数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相关系数平方R2=0.89411520.51153561116080.722回归方程y=1.3468x-3.6867182022相关系数平方R2=0.85213856.52221512.122回归方程y=1.3634x-4.81532019.622相关系数平方R2=0.86931815.52233638.822回归方程y=1.1023x+0.9672019.522相关系数平方R2=0.91694338224455522回归方程y=1.24x-2.1158658022相关系数平方R2=0.95514338.52253855.822回归方程y=1.1904x-2.44243338.822相关系数平方R2=0.90221012.52265080.422回归方程y=1.131x-3.50081012.722相关系数平方R2=0.99565080.9221520.5225355221519333755.5331512.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)90807060504030201009080706050403020100L 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.5551923.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 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 的的散散点点图图