[go: up one dir, main page]
Scribd
Upload
104 views10 pages

Lampiran Modul 2

The document describes a regression analysis with biaya promosi as the dependent variable and jumlah jam promosi and jumlah tenaga sales as independent variables. Descriptive statistics, correlations, regression model output, coefficients, collinearity diagnostics and residuals statistics are reported.

Uploaded by

Ria
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
104 views10 pages

Lampiran Modul 2

The document describes a regression analysis with biaya promosi as the dependent variable and jumlah jam promosi and jumlah tenaga sales as independent variables. Descriptive statistics, correlations, regression model output, coefficients, collinearity diagnostics and residuals statistics are reported.

Uploaded by

Ria
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 10

NEW FILE.

DATASET NAME DataSet1 WINDOW=FRONT.


REGRESSION
/DESCRIPTIVES MEAN STDDEV CORR SIG N
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA COLLIN TOL ZPP
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT BP
/METHOD=ENTER JJP JTS
/SCATTERPLOT=(*SDRESID ,*ZPRED)
/RESIDUALS NORMPROB(ZRESID)
/SAVE RESID ZRESID SRESID DRESID SDRESID.

Regression

Notes
Output Created 02-NOV-2018 13:14:47
Comments
Input Active Dataset DataSet1
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data 12
File
Missing Value Handling Definition of Missing User-defined missing
values are treated as
missing.
Cases Used Statistics are based on
cases with no missing
values for any variable
used.

Page 1
Notes
Syntax REGRESSION
/DESCRIPTIVES MEAN
STDDEV CORR SIG N
/MISSING LISTWISE
/STATISTICS COEFF
OUTS R ANOVA COLLIN
TOL ZPP
/CRITERIA=PIN(.05)
POUT(.10)
/NOORIGIN
/DEPENDENT BP
/METHOD=ENTER JJP
JTS
/SCATTERPLOT=
(*SDRESID ,*ZPRED)
/RESIDUALS
NORMPROB(ZRESID)
/SAVE RESID ZRESID
SRESID DRESID
SDRESID.
Resources Processor Time 00:00:08,14
Elapsed Time 00:00:09,28
Memory Required 2944 bytes
Additional Memory 320 bytes
Required for Residual Plots

Variables Created or RES_1 Unstandardized Residual


Modified
DRE_1 Deleted Residual
ZRE_1 Standardized Residual
SRE_1 Studentized Residual
SDR_1 Studentized Deleted
Residual

[DataSet1]

Descriptive Statistics
Mean Std. Deviation N
Biaya Promosi 121,5000 49,40280 12
Jumlah Jam Promosi 140,2500 21,99225 12
Jumlah Tenaga Sales 12,7500 3,27872 12

Page 2
Correlations
Jumlah Jam Jumlah Tenaga
Biaya Promosi Promosi Sales
Pearson Correlation Biaya Promosi 1,000 ,358 -,059
Jumlah Jam Promosi ,358 1,000 ,587
Jumlah Tenaga Sales -,059 ,587 1,000
Sig. (1-tailed) Biaya Promosi . ,126 ,428
Jumlah Jam Promosi ,126 . ,022
Jumlah Tenaga Sales ,428 ,022 .
N Biaya Promosi 12 12 12
Jumlah Jam Promosi 12 12 12
Jumlah Tenaga Sales 12 12 12

a
Variables Entered/Removed
Variables Variables
Model Entered Removed Method
1 Jumlah . Enter
Tenaga
Sales, Jumlah
Jam Promosi b

a. Dependent Variable: Biaya Promosi


b. All requested variables entered.

b
Model Summary
Adjusted R Std. Error of the
Model R R Square Square Estimate
1 ,489a ,239 ,070 47,65481

a. Predictors: (Constant), Jumlah Tenaga Sales, Jumlah Jam Promosi


b. Dependent Variable: Biaya Promosi

a
ANOVA
Sum of
Model Squares df Mean Square F Sig.
1 Regression 6408,174 2 3204,087 1,411 ,293b
Residual 20438,826 9 2270,981
Total 26847,000 11
a. Dependent Variable: Biaya Promosi
b. Predictors: (Constant), Jumlah Tenaga Sales, Jumlah Jam Promosi

Page 3
a
Coefficients
Standardized
Unstandardized Coefficients Coefficients
Model B Std. Error Beta t Sig.
1 (Constant) 11,580 92,693 ,125 ,903
Jumlah Jam Promosi 1,346 ,807 ,599 1,668 ,130 ,358
Jumlah Tenaga Sales -6,185 5,414 -,411 -1,142 ,283 -,059

a
Coefficients

Correlations Collinearity Statistics


Model Zero-order Partial Part Tolerance VIF
1 (Constant)
Jumlah Jam Promosi ,358 ,486 ,485 ,655 1,526
Jumlah Tenaga Sales -,059 -,356 -,332 ,655 1,526
a. Dependent Variable: Biaya Promosi

a
Collinearity Diagnostics
Variance Proportions
Jumlah Jam Jumlah Tenaga
Model Dimension Eigenvalue Condition Index (Constant) Promosi Sales
1 1 2,961 1,000 ,00 ,00 ,00
2 ,030 9,930 ,26 ,02 ,76
3 ,009 17,857 ,74 ,98 ,23
a. Dependent Variable: Biaya Promosi

Page 4
a
Residuals Statistics
Minimum Maximum Mean Std. Deviation N
Predicted Value 85,1645 161,0886 121,5000 24,13631 12
Std. Predicted Value -1,505 1,640 ,000 1,000 12
Standard Error of Predicted 17,717 30,854 23,468 4,306 12
Value
Adjusted Predicted Value 68,6499 160,6679 118,6737 27,69873 12
Residual -56,90368 88,91143 ,00000 43,10540 12
Std. Residual -1,194 1,866 ,000 ,905 12
Stud. Residual -1,349 2,408 ,025 1,084 12
Deleted Residual -72,66788 148,14752 2,82630 62,38538 12
Stud. Deleted Residual -1,424 3,808 ,150 1,404 12
Mahal. Distance ,604 3,695 1,833 1,013 12
Cook's Distance ,001 1,288 ,166 ,359 12
Centered Leverage Value ,055 ,336 ,167 ,092 12
a. Dependent Variable: Biaya Promosi

Charts

Normal P-P Plot of Regression Standardized Residual


Dependent Variable: Biaya Promosi
1,0

0,8
Expected Cum Prob

0,6

0,4

0,2

0,0
0,0 0,2 0,4 0,6 0,8 1,0

Observed Cum Prob

Page 5
Scatterplot
Dependent Variable: Biaya Promosi
4
Regression Studentized Deleted (Press)

2
Residual

-1

-2

-2 -1 0 1 2

Regression Standardized Predicted Value

REGRESSION
/DESCRIPTIVES MEAN STDDEV CORR SIG N
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA COLLIN TOL ZPP
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT TP
/METHOD=ENTER BP
/SCATTERPLOT=(*SDRESID ,*ZPRED)
/RESIDUALS NORMPROB(ZRESID)
/SAVE RESID ZRESID SRESID DRESID SDRESID.

Regression

Page 6
Notes
Output Created 02-NOV-2018 13:18:39
Comments
Input Active Dataset DataSet1
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data 12
File
Missing Value Handling Definition of Missing User-defined missing
values are treated as
missing.
Cases Used Statistics are based on
cases with no missing
values for any variable
used.
Syntax REGRESSION
/DESCRIPTIVES MEAN
STDDEV CORR SIG N
/MISSING LISTWISE
/STATISTICS COEFF
OUTS R ANOVA COLLIN
TOL ZPP
/CRITERIA=PIN(.05)
POUT(.10)
/NOORIGIN
/DEPENDENT TP
/METHOD=ENTER BP
/SCATTERPLOT=
(*SDRESID ,*ZPRED)
/RESIDUALS
NORMPROB(ZRESID)
/SAVE RESID ZRESID
SRESID DRESID
SDRESID.
Resources Processor Time 00:00:03,31
Elapsed Time 00:00:02,31
Memory Required 2688 bytes
Additional Memory 336 bytes
Required for Residual Plots

Variables Created or RES_2 Unstandardized Residual


Modified
DRE_2 Deleted Residual
ZRE_2 Standardized Residual
SRE_2 Studentized Residual
SDR_2 Studentized Deleted
Residual

Page 7
Descriptive Statistics
Mean Std. Deviation N
Tingkat Penjualan 34,7500 9,95558 12
Biaya Promosi 121,5000 49,40280 12

Correlations
Tingkat
Penjualan Biaya Promosi
Pearson Correlation Tingkat Penjualan 1,000 ,933
Biaya Promosi ,933 1,000
Sig. (1-tailed) Tingkat Penjualan . ,000
Biaya Promosi ,000 .
N Tingkat Penjualan 12 12
Biaya Promosi 12 12

a
Variables Entered/Removed
Variables Variables
Model Entered Removed Method
1 Biaya . Enter
Promosi b

a. Dependent Variable: Tingkat Penjualan


b. All requested variables entered.

b
Model Summary
Adjusted R Std. Error of the
Model R R Square Square Estimate
1 ,933a ,871 ,858 3,75359

a. Predictors: (Constant), Biaya Promosi


b. Dependent Variable: Tingkat Penjualan

a
ANOVA
Sum of
Model Squares df Mean Square F Sig.
1 Regression 949,356 1 949,356 67,381 ,000b
Residual 140,894 10 14,089
Total 1090,250 11
a. Dependent Variable: Tingkat Penjualan
b. Predictors: (Constant), Biaya Promosi

Page 8
a
Coefficients
Standardized
Unstandardized Coefficients Coefficients
Model B Std. Error Beta t Sig.
1 (Constant) 11,902 2,987 3,985 ,003
Biaya Promosi ,188 ,023 ,933 8,209 ,000 ,933

a
Coefficients

Correlations Collinearity Statistics


Model Zero-order Partial Part Tolerance VIF
1 (Constant)
Biaya Promosi ,933 ,933 ,933 1,000 1,000
a. Dependent Variable: Tingkat Penjualan

a
Collinearity Diagnostics
Variance Proportions

Model Dimension Eigenvalue Condition Index (Constant) Biaya Promosi


1 1 1,932 1,000 ,03 ,03
2 ,068 5,325 ,97 ,97
a. Dependent Variable: Tingkat Penjualan

a
Residuals Statistics
Minimum Maximum Mean Std. Deviation N
Predicted Value 27,8863 58,9141 34,7500 9,29005 12
Std. Predicted Value -,739 2,601 ,000 1,000 12
Standard Error of Predicted 1,084 3,137 1,427 ,582 12
Value
Adjusted Predicted Value 27,7155 54,0841 34,4929 8,47012 12
Residual -7,70699 4,59184 ,00000 3,57891 12
Std. Residual -2,053 1,223 ,000 ,953 12
Stud. Residual -2,165 1,278 ,020 1,057 12
Deleted Residual -8,56857 6,91590 ,25710 4,60157 12
Stud. Deleted Residual -2,818 1,326 -,053 1,222 12
Mahal. Distance ,001 6,766 ,917 1,913 12
Cook's Distance ,000 1,185 ,179 ,354 12
Centered Leverage Value ,000 ,615 ,083 ,174 12
a. Dependent Variable: Tingkat Penjualan

Page 9
Charts

Normal P-P Plot of Regression Standardized Residual


Dependent Variable: Tingkat Penjualan
1,0

0,8

Expected Cum Prob

0,6

0,4

0,2

0,0
0,0 0,2 0,4 0,6 0,8 1,0

Observed Cum Prob

Scatterplot
Dependent Variable: Tingkat Penjualan
2
Regression Studentized Deleted (Press)

0
Residual

-1

-2

-3

-1 0 1 2 3

Regression Standardized Predicted Value

Page 10

You might also like