资源描述
,湖南省长沙市一中卫星远程学校,2.3 变量间的相关关系,高二数学,使用Excel,20,25,30,35,40,45,50,55,60,65,5,10,15,20,25,30,35,40,脂肪含量,年龄,0,20,25,30,35,40,45,50,55,60,65,5,10,15,20,25,30,35,40,脂肪含量,年龄,0,20,25,30,35,40,45,50,55,60,65,5,10,15,20,25,30,35,40,脂肪含量,年龄,0,20,25,30,35,40,45,50,55,60,65,5,10,15,20,25,30,35,40,脂肪含量,年龄,0,20,25,30,35,40,45,50,55,60,65,5,10,15,20,25,30,35,40,脂肪含量,年龄,0,50,100,5,10,15,20,25,30,35,售价,0,面积,150,练习,2.,今有一组试验数据如下表所示:,现准备用下列函数中的一个近似地表示,这些数据满足的规律,其中最接近的一,个是,(),x,1.99,3.0,4.0,5.1,6.12,y,1.5,4.04,7.5,12,18.01,A.,y,=log,2,x,B.,y,=2,x,C.D.,y,=2,x,2,练习,2.,今有一组试验数据如下表所示:,现准备用下列函数中的一个近似地表示,这些数据满足的规律,其中最接近的一,个是,(),x,1.99,3.0,4.0,5.1,6.12,y,1.5,4.04,7.5,12,18.01,A.,y,=log,2,x,B.,y,=2,x,C.D.,y,=2,x,2,C,20,25,30,35,40,45,50,55,60,65,5,10,15,20,25,30,35,40,脂肪含量,0,回归直线及其方程,年龄,20,25,30,35,40,45,50,55,60,65,5,10,15,20,25,30,35,40,脂肪含量,0,20,25,30,35,40,45,50,55,60,65,5,10,15,20,25,30,35,40,脂肪含量,0,20,25,30,35,40,45,50,55,60,65,5,10,15,20,25,30,35,40,脂肪含量,0,20,25,30,35,40,45,50,55,60,65,5,10,15,20,25,30,35,40,脂肪含量,0,20,25,30,35,40,45,50,55,60,65,5,10,15,20,25,30,35,40,脂肪含量,0,20,25,30,35,40,45,50,55,60,65,5,10,15,20,25,30,35,40,脂肪含量,0,20,25,30,35,40,45,50,55,60,65,5,10,15,20,25,30,35,40,脂肪含量,0,20,25,30,35,40,45,50,55,60,65,5,10,15,20,25,30,35,40,脂肪含量,0,20,25,30,35,40,45,50,55,60,65,5,10,15,20,25,30,35,40,脂肪含量,0,20,25,30,35,40,45,50,55,60,65,5,10,15,20,25,30,35,40,脂肪含量,0,20,25,30,35,40,45,50,55,60,65,5,10,15,20,25,30,35,40,脂肪含量,0,3.F,表提供了某厂节能降耗技术改造后生产甲产,品过程中记录的产量,x,(,吨,),与相应的生产能耗,y,(,吨,标准煤,),的几组对照数据,x,3,4,5,6,y,2.5,3,4,4.5,(1),请画出上表数据的散点图;,(2),请根据上表提供的数据,崩最小二乘法求出,y,关于,x,的线性回归方程,y,=,bx,+,a,;,(3),已知该厂技改前,100,吨甲产品的生产能耗为,90,吨标准煤试根据,(2),求出的线性同归方程,预测,生产,100,吨甲产品的生产能耗比技改前降低多少,吨标准煤,?,
展开阅读全文