Arab academy for science Technology & Maritime Transport
Master of Business administration
program (MBA)
Applied Statistics Assignment Sheet
Name: Alaa Eman Hussien Attia
ID number: 24127370
Group:1Y
Assignment number: 4
Prof. Dr. Mamdouh Abd Al-Alim
coFFcit
Coefficients
Coe Ffrients const -
mod
|model
Ceus
model B Censto8
con sb -|429 6-3 y = atbx y= -l-76+7-!39Z
l·82 x
- L827 t
y
y o-8+6-3x ANoVA
ANo A
ANo A
ANovA
Siyn
Sign o-00locs
o\S0-oS
o-lc3o56
not Si gh = -l827+I-92 xlo y = 19.63|
A
y o t63 x|G - \6.973
Estimate"y whch L:|0 63-8
NO estimati model Sumnary
model Sa mmary model sumnag
R2 r2
Hocdel Swmmary o-B41 o924o-8S
R
rao%99 r= o- 924
oBo2 o-643
+ve tVe
r: o.2 STron strong
Strohg
r'o-ZS3
G o r mo r
r2
direct 8SY. o F the
strong totl aritey totd Vuriit;
yariation in yiS In y is explancd
o-l43 the by the variaten
vuriuien
bythe erda
A4 of he fotal
by the otlerisc
laned by the by fheo
Variution in x and 367,
the other wise
by
2)
Model model
Cons t 199-18
cUn st o-23
G-639
6223 ool6
the rege ssten equ
X -6-ol6 X2
y= -o-23 + o.639
A NovA
A NovA
o-ol3|
-ocS
o-ol32oGs
eshaate
149- Z132901 xlo -6-273 x\S
y = b-633
modtl Swmmary melel Summavy
r r2
o117| G-995
G-713o-937
ra o-993
strong Strong
o-99
42. P the tot-l varitiyin
REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT y
/METHOD=ENTER x.
Regression
[DataSet0]
Variables Entered/Removeda
Variables Variables
Model Entered Removed Method
b
1 x . Enter
a. Dependent Variable: y
b. All requested variables entered.
Model Summary
Adjusted R Std. Error of
Model R R Square Square the Estimate
1 .802 a .643 .524 .690
a. Predictors: (Constant), x
ANOVAa
Sum of
Model Squares df Mean Square F Sig.
1 Regression 2.571 1 2.571 5.400 .103 b
Residual 1.429 3 .476
Total 4.000 4
a. Dependent Variable: y
b. Predictors: (Constant), x
a
Coefficients
Standardized
Unstandardized Coefficients Coefficients
Model B Std. Error Beta t Sig.
1 (Constant) -1.429 1.507 -.948 .413
x .429 .184 .802 2.324 .103
a. Dependent Variable: y
Page 1
REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT Y
/METHOD=ENTER X.
Regression
[DataSet1]
Variables Entered/Removeda
Variables Variables
Model Entered Removed Method
b
1 X . Enter
a. Dependent Variable: Y
b. All requested variables entered.
Model Summary
Adjusted R Std. Error of
Model R R Square Square the Estimate
1 .945 a .894 .859 3.962
a. Predictors: (Constant), X
ANOVAa
Sum of
Model Squares df Mean Square F Sig.
1 Regression 396.900 1 396.900 25.280 .015 b
Residual 47.100 3 15.700
Total 444.000 4
a. Dependent Variable: Y
b. Predictors: (Constant), X
a
Coefficients
Standardized
Unstandardized Coefficients Coefficients
Model B Std. Error Beta t Sig.
1 (Constant) .800 5.316 .150 .890
X 6.300 1.253 .945 5.028 .015
a. Dependent Variable: Y
Page 1
REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT Y
/METHOD=ENTER X.
Page 1
REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT Y
/METHOD=ENTER X.
Regression
[DataSet1]
Variables Entered/Removeda
Variables Variables
Model Entered Removed Method
b
1 X . Enter
a. Dependent Variable: Y
b. All requested variables entered.
Model Summary
Adjusted R Std. Error of
Model R R Square Square the Estimate
1 .924 a .853 .835 8.412
a. Predictors: (Constant), X
ANOVAa
Sum of
Model Squares df Mean Square F Sig.
1 Regression 3297.472 1 3297.472 46.597 .000 b
Residual 566.128 8 70.766
Total 3863.600 9
a. Dependent Variable: Y
b. Predictors: (Constant), X
a
Coefficients
Standardized
Unstandardized Coefficients Coefficients
Model B Std. Error Beta t Sig.
1 (Constant) -1.760 6.779 -.260 .802
X 2.139 .313 .924 6.826 .000
a. Dependent Variable: Y
Page 1
REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT Y
/METHOD=ENTER X1 X2.
Regression
[DataSet2]
Variables Entered/Removeda
Variables Variables
Model Entered Removed Method
b
1 X2, X1 . Enter
a. Dependent Variable: Y
b. All requested variables entered.
Model Summary
Adjusted R Std. Error of
Model R R Square Square the Estimate
1 .997 a .995 .990 1.243
a. Predictors: (Constant), X2, X1
ANOVAa
Sum of
Model Squares df Mean Square F Sig.
1 Regression 586.909 2 293.455 189.882 .005 b
Residual 3.091 2 1.545
Total 590.000 4
a. Dependent Variable: Y
b. Predictors: (Constant), X2, X1
a
Coefficients
Standardized
Unstandardized Coefficients Coefficients
Model B Std. Error Beta t Sig.
1 (Constant) 149.818 23.451 6.389 .024
X1 -2.909 1.185 -.656 -2.454 .134
X2 -6.273 1.027 -1.633 -6.111 .026
a. Dependent Variable: Y
Page 1
REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT Y
/METHOD=ENTER X1 X2.
Regression
[DataSet2]
Variables Entered/Removeda
Variables Variables
Model Entered Removed Method
b
1 X2, X1 . Enter
a. Dependent Variable: Y
b. All requested variables entered.
Model Summary
Adjusted R Std. Error of
Model R R Square Square the Estimate
1 .993 a .987 .974 .256
a. Predictors: (Constant), X2, X1
ANOVAa
Sum of
Model Squares df Mean Square F Sig.
1 Regression 9.869 2 4.934 75.250 .013 b
Residual .131 2 .066
Total 10.000 4
a. Dependent Variable: Y
b. Predictors: (Constant), X2, X1
a
Coefficients
Standardized
Unstandardized Coefficients Coefficients
Model B Std. Error Beta t Sig.
1 (Constant) -.230 2.381 -.096 .932
X1 .639 .235 .965 2.722 .113
X2 -.016 .202 -.029 -.081 .943
a. Dependent Variable: Y
Page 1
REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT Y
/METHOD=ENTER X.
Regression
[DataSet0]
Variables Entered/Removed
Variables Variables
Model Entered Removed Method
1 x Enter
a. Dependent Variable: Y
b. Allrequested variables entered.
Model Summary
Adjusted R Std. Error of
Model R RSquare Square the Estimate
1 9432 .890 .874 5.741
a. Predictors: (Constant), X
ANOVA
Sum of
Squares df Mean Square F Sig.
Model
1 Regression 1859.267 1 1859.267 56.407 .0005
Residual 230.733 7 32.962
Total 2090.000
a. Dependent Variable: Y
b. Predictors: (Constant), X
Coefficients
Standardized
Unstandardized Coefficients Coefficients
B Std. Error Beta Sig.
Model
1
(Constant) 75.000 1.914 39.190 .000
X 5.567 741 .943 7.510 .000
a. Dependent Variable: Y
Page 1
yeer
NEW FILE.
DATASET NAME DataSetl WINDOW=FRONT.
REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT Y
/METHOD=ENTER X.
Regression
[ DataSeti)
Variables Entered/Removed
Variables Variables
Model Entered Removed Method
1
Enter
a. Deperndent Variable: Y
b. All requested variables entered.
Model Summary
Adjusted R Std. Error of
Model R RSquare Square the Estimate
1 .778 .605 .539 7.641
a. Predictors: (Constant), X
ANOVA
Sum of
Model Squares df Mean Square F Sig.
1 Regression 535.714 535.714 9.176 .023
Residual 350.286 6 58.381
Total 886.000
a. Dependent Variable: Y
b. Predictors: (Constant), X
Coefficients
Standardized
Unstandardized Coefficients Coefficients
B Std. Error Beta
Model t Sig.
1 (Constant) 70.000 2.701 25.912 .000
X 3.571 1.179 .778 3.029 .023
a. Dependent Variable: Y
Page 1
8-S 121.72s2
year 2el9 y = Z0 +3-s 7| x