{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["回归","相关","方差","练习题"],"not_rendered":{"charts":4},"read":"whole","date_system":"1900"}

{"sheet":"回归","index":0,"n_rows":32,"n_cols":14,"rows_kept":32}
["年份","销售额","广告费用",null,null,"SUMMARY OUTPUT"]
[2012,600,18.2]
[2013,610,18.61,null,null,"回归统计"]
[2014,630,20.25,null,null,"Multiple R",0.9529612977495142]
[2015,640,20.66,null,null,"R Square",0.9081352350084383]
[2016,620,19.43,null,null,"Adjusted R Square",0.892824440843178]
[2017,650,20.25,null,null,"标准误差",7.372470365262516]
[2018,640,21.07,null,null,"观测值",8]
[2019,670,22.45]
[{"$nulls":5},"方差分析"]
[null,null,"单位：万元",{"$nulls":3},"df","SS","MS","F","Significance F"]
[{"$nulls":5},"回归分析",1,3223.880084279956,3223.880084279956,59.31339845642813,2.5110601124332134E-4]
[{"$nulls":5},"残差",6,326.1199157200441,54.353319286674015]
[{"$nulls":5},"总计",7,3550]
[]
[{"$nulls":6},"Coefficients","标准误差","t Stat","P-value","Lower 95%","Upper 95%","下限 95.0%","上限 95.0%"]
[{"$nulls":5},"Intercept",316.936263283254,41.05704324071443,7.719412755202073,2.4791122557002269E-4,216.4732976045784,417.39922896192957,216.4732976045784,417.39922896192957]
[{"$nulls":5},"广告费用",15.687980945401245,2.0369982176307646,7.701519230413445,2.5110601124332178E-4,10.703625865919346,20.672336024883144,10.703625865919346,20.672336024883144]
[]
[]
[]
[{"$nulls":5},"RESIDUAL OUTPUT"]
[]
[{"$nulls":5},"观测值","预测 销售额","残差"]
[{"$nulls":5},1,602.4575164895566,-2.4575164895566104]
[{"$nulls":5},2,608.8895886771711,1.1104113228288952]
[{"$nulls":5},3,634.6178774276292,-4.617877427629196]
[{"$nulls":5},4,641.0499496152437,-1.0499496152436905]
[{"$nulls":5},5,621.7537330524001,-1.7537330524000936]
[{"$nulls":5},6,634.6178774276292,15.382122572370804]
[{"$nulls":5},7,647.4820218028583,-7.4820218028582985]
[{"$nulls":5},8,669.1314355075119,0.8685644924880762]

{"sheet":"相关","index":1,"n_rows":15,"n_cols":8,"rows_kept":15}
["顾客","月收入","月支出-护肤化妆品"]
[1,4500,{"$f":"B2*0.067","v":301.5},{"$nulls":3},"月收入","月支出-护肤化妆品"]
[2,5600,{"$f":"B3*0.067","v":375.20000000000005},null,null,"月收入",1]
[3,7200,{"$f":"B4*0.077","v":554.4},null,null,"月支出-护肤化妆品",0.971771467852909,1]
[4,3800,254.60000000000002]
[5,6400,{"$f":"B6*0.073","v":467.2},{"$f":"PEARSON(B2:B13,C2:C13)","v":0.9717714678529089},null,{"$f":"PEARSON(B2:B13,C2:C13 )","v":0.9717714678529089}]
[6,8200,{"$f":"B7*0.092","v":754.4}]
[7,5800,388.6]
[8,6700,{"$f":"B9*0.075","v":502.5}]
[9,4000,268]
[10,4400,294.8]
[11,5200,348.40000000000003]
[12,6900,{"$f":"B13*0.074","v":510.59999999999997}]
[]
[null,null,"单位：元"]

{"sheet":"方差","index":2,"n_rows":16,"n_cols":14,"rows_kept":16}
[null,"2014年","2015年","2016年","2017年","2018年"]
["网店",203,232,278,315,352,null,"方差分析：单因素方差分析"]
["实体店",234,245,267,284,277]
["经销商",115,124,109,138,147,null,"SUMMARY"]
[{"$nulls":5},"单位：万元",null,"组","观测数","求和","平均","方差"]
[{"$nulls":7},"网店",5,1380,276,3641.5]
[{"$nulls":7},"实体店",5,1307,261.4,451.29999999999995]
[{"$nulls":7},"经销商",5,633,126.6,249.29999999999927]
[]
[]
[{"$nulls":7},"方差分析"]
[{"$nulls":7},"差异源","SS","df","MS","F","P-value","F crit"]
[{"$nulls":7},"组间",67840.93333333335,2,33920.466666666674,23.435987195136,7.1719271633430886E-5,3.885293834652394]
[{"$nulls":7},"组内",17368.4,12,1447.3666666666668]
[]
[{"$nulls":7},"总计",85209.33333333334,14]

{"sheet":"练习题","index":3,"n_rows":18,"n_cols":14,"rows_kept":18}
["月份","销售额","直播次数",null,null,"SUMMARY OUTPUT"]
["1月",89,23]
["2月",124,34,null,null,"回归统计"]
["3月",92,24,null,null,"Multiple R",0.9162269816847594]
["4月",100,28,null,null,"R Square",0.8394718819671643]
["5月",106,30,null,null,"Adjusted R Square",0.8073662583605972]
["6月",113,36,null,null,"标准误差",5.449138952019535]
["7月",112,35,null,null,"观测值",7]
[]
[null,null,"单位：万元",null,null,"方差分析"]
[{"$nulls":6},"df","SS","MS","F","Significance F"]
[{"$nulls":5},"回归分析",1,776.3915662650602,776.3915662650602,26.147191291293005,0.003727692194078234]
[{"$nulls":5},"残差",5,148.46557659208275,29.693115318416552]
[{"$nulls":5},"总计",6,924.8571428571429]
[]
[{"$nulls":6},"Coefficients","标准误差","t Stat","P-value","Lower 95%","Upper 95%","下限 95.0%","上限 95.0%"]
[{"$nulls":5},"Intercept",40.26333907056798,12.854129430481109,3.1323271862418918,0.02588936703224765,7.220747443655071,73.30593069748089,7.220747443655071,73.30593069748089]
[{"$nulls":5},"直播次数",2.162650602409639,0.42293520622568176,5.113432437345097,3.7276921940782304E-3,1.0754610436348024,3.2498401611844754,1.0754610436348024,3.2498401611844754]