数学建模高手快来救命,求详细解答过程

2.为了确定广告费用与销售额的关系,今做出统计,得资料如下表:
广告费X(万元) 40 25 20 30 40 40 25 20 50 20 50 50
销售额Y(万元)490 395 420 475 385 525 480 400 560 365 510 540
(1) 求销售额Y对广告费X的回归分析。
(2) 以显著性水平α=0.05,检验假设H0:b=0.
(3) 求当广告费X=35时,销售额的点预测与区间预测。
不要那种计算机用的程序语言嘛 就直接书面语言 这是卷子上的题目 谢谢

第1个回答  2010-12-22
var00001=Y var00002=X
Model Summary
Model R R Square Adjusted R Square Std. Error of the Estimate
1 .769a .591 .550 44.62797
a. Predictors: (Constant), VAR00002

ANOVA(b)
Model Sum of Squares df Mean Square F Sig.
1 Regression 28756.356 1 28756.356 14.438 .003a
Residual 19916.561 10 1991.656
Total 48672.917 11
a. Predictors: (Constant), VAR00002
b. Dependent Variable: VAR00001

Coefficients(a)
Unstandardized Coefficients Standardized Coefficients
Model B Std. Error Beta t Sig.
1 (Constant) 319.086 39.777 8.022 .000
VAR00002 4.185 1.101 .769 3.800 .003
a. Dependent Variable: VAR00001

Coefficients(a)
Unstandardized Coefficients Standardized Coefficients
Model B Std. Error Beta t Sig.
1 (Constant) 319.086 39.777 8.022 .000
VAR00002 4.185 1.101 .769 3.800 .003
a. Dependent Variable: VAR00001

Coefficients(a)
Unstandardized Coefficients Standardized Coefficients
Model B Std. Error Beta t Sig.
1 (Constant) 319.086 39.777 8.022 .000
VAR00002 4.185 1.101 .769 3.800 .003
a. Dependent Variable: VAR00001

Coefficients(a)
Unstandardized Coefficients Standardized Coefficients
Model B Std. Error Beta t Sig.
1 (Constant) 319.086 39.777 8.022 .000
VAR00002 4.185 1.101 .769 3.800 .003
a. Dependent Variable: VAR00001
第2个回答  2010-12-22
var00001=Y var00002=X
Model Summary
Model R R Square Adjusted R Square Std. Error of the Estimate
1 .769a .591 .550 44.62797
a. Predictors: (Constant), VAR00002

ANOVA(b)
Model Sum of Squares df Mean Square F Sig.
1 Regression 28756.356 1 28756.356 14.438 .003a
Residual 19916.561 10 1991.656
Total 48672.917 11
a. Predictors: (Constant), VAR00002
b. Dependent Variable: VAR00001

Coefficients(a)
Unstandardized Coefficients Standardized Coefficients
Model B Std. Error Beta t Sig.
1 (Constant) 319.086 39.777 8.022 .000
VAR00002 4.185 1.101 .769 3.800 .003
a. Dependent Variable: VAR00001

Coefficients(a)
Unstandardized Coefficients Standardized Coefficients
Model B Std. Error Beta t Sig.
1 (Constant) 319.086 39.777 8.022 .000
VAR00002 4.185 1.101 .769 3.800 .003
a. Dependent Variable: VAR00001

Coefficients(a)
Unstandardized Coefficients Standardized Coefficients
Model B Std. Error Beta t Sig.
1 (Constant) 319.086 39.777 8.022 .000
VAR00002 4.185 1.101 .769 3.800 .003

Coefficients(a)
Unstandardized Coefficients Standardized Coefficients
Model B Std. Error Beta t Sig.
1 (Constant) 319.086 39.777 8.022 .000
VAR00002 4.185 1.101 .769 3.800 .003
a. Dependent Variable: VAR00001本回答被提问者采纳