Обзор бухгалтерских программ
Модель
Model Sum of Mean Prob Power
Analysis of Variance Detail Section
Sum of Mean Prob Power
Analysis of Variance Section
Multiple Regression Report
Variable Coefficient Error 95,0% C.L. 95,0% C.L. Coefficient
Independent Regression Standard Lower Upper Standardized
Regression Coefficient Section
Estimated Model
Independent Coefficient Error to test Prob H0 at of Test
Regression Standard T-Value Reject Power
Regression Equation Section
Variable Count Mean Deviation Minimum Maximum
Standard
Descriptive Statistics Section
Parameter Value Parameter Value
Run Summary Section
Multiple Regression Report
Page/Date/Time 1 13.12.2005 16:28:45
Database
Dependent Y
Dependent Variable Y Rows Processed 30
Number Ind. Variables 5 Rows Filtered Out 0
Weight Variable None Rows with X's Missing 0
R2 0,19 Rows with Weight Missing 0
Adj R2 0,02 Rows with Y Missing 0
Coefficient of Variation 0,42 Rows Used in Estimation 30
Mean Square Error 32,76 Sum of Weights 30,00
Square Root of MSE 5,72 Completion Status Normal Completion
Ave Abs Pct Error 36,25
X1 30 0,74 0,05 0,62 0,81
X2 30 0,28 0,14 0,02 0,54
X3 30 1,32 0,11 1,1 1,49
X4 30 15321,43 9626,87 3557 49727
X5 30 94,22 93,88 32,61 512,6
Y 30 13,50 5,78 5,02 25,83
Variable b(i) Sb(i) H0:B(i)=0 Level 5,0%? at 5,0%
Intercept -6,52 18,56 -0,35 0,73 No 0,06
X1 30,00 25,50 1,18 0,25 No 0,20
X2 7,89 8,51 0,93 0,36 No 0,14
X3 -5,04 11,93 -0,42 0,68 No 0,07
X4 0,00 0,00 1,15 0,26 No 0,20
X5 -0,03 0,03 -0,97 0,34 No 0,15
-6.51757324242446+ 30.0030134781668*X1+ 7.89479437491242*X2-5.03739438502802*X3+
3.12359142056359E-04*X4-2.72569392544667E-02*X5
Intercept -6,52 18,56 -44,83 31,79 0,00
X1 30,00 25,50 -22,63 82,63 0,25
X2 7,89 8,51 -9,67 25,46 0,20
X3 -5,04 11,93 -29,66 19,58 -0,10
X4 0,00 0,00 0,00 0,00 0,52
X5 -0,03 0,03 -0,09 0,03 -0,44
Note: The T-Value used to calculate these confidence limits was 2,06.
Page/Date/Time 2 13.12.2005 16:28:45
Database
Dependent Y
Source DF R2 Squares Square F-Ratio Level (5,0%)
Intercept 1 5471,01 5471,01
Model 5 0,19 183,23 36,65 1,12 0,38 0,33
Error 24 0,81 786,31 32,76
Total(Adjusted) 29 1,00 969,54 33,43
Term DF R2 Squares Square F-Ratio Level (5,0%)
Intercept 1 5471,01 5471,01
Model 5 0,19 183,23 36,65 1,12 0,38 0,33
C2 1 0,05 45,35 45,35 1,38 0,25 0,20
C3 1 0,03 28,18 28,18 0,86 0,36 0,14
C4 1 0,01 5,84 5,84 0,18 0,68 0,07
C5 1 0,05 43,63 43,63 1,33 0,26 0,20
C6 1 0,03 30,55 30,55 0,93 0,34 0,15
Error 24 0,81 786,31 32,76
Total(Adjusted) 29 1,00 969,54 33,43
MICROSOFT EXCEL
Статистика
Корреляция
Ковариация
Дисперсия