Scribd
Upload
2 views13 pages

Data 1

The document outlines a data analysis process using an Excel file containing material data, focusing on descriptive statistics and regression analysis for various variables. It includes the computation of means, standard deviations, minimums, and maximums for multiple variables, as well as a regression model to analyze the relationship between the dependent variable V_MEAN and other independent variables. The analysis is performed on a dataset with 123 rows, and all non-missing data is utilized.

Uploaded by

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

Data 1

The document outlines a data analysis process using an Excel file containing material data, focusing on descriptive statistics and regression analysis for various variables. It includes the computation of means, standard deviations, minimums, and maximums for multiple variables, as well as a regression model to analyze the relationship between the dependent variable V_MEAN and other independent variables. The analysis is performed on a dataset with 123 rows, and all non-missing data is utilized.

Uploaded by

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

GET DATA

/TYPE=XLSX
/FILE='C:\Users\Admin\Documents\Data 30 Co. [Link]'
/SHEET=name 'Sheet1'
/CELLRANGE=FULL
/READNAMES=ON
/DATATYPEMIN PERCENTAGE=95.0
/HIDDEN IGNORE=YES.
EXECUTE.
DATASET NAME DataSet1 WINDOW=FRONT.
DESCRIPTIVES VARIABLES=V1 V6 V7 V8 V9 V10 V11 V12 V13 V14 V15 V16 V17 V18 V19
V20 V21 V22 V23 V24
/STATISTICS=MEAN STDDEV MIN MAX.

Descriptives

Notes
Output Created 15-JUN-2025 13:24:24
Comments
Input Active Dataset DataSet1
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data 123
File
Missing Value Handling Definition of Missing User defined missing values
are treated as missing.
Cases Used All non-missing data are
used.
Syntax DESCRIPTIVES
VARIABLES=V1 V6 V7 V8
V9 V10 V11 V12 V13 V14
V15 V16 V17 V18 V19 V20
V21 V22 V23 V24
/STATISTICS=MEAN
STDDEV MIN MAX.
Resources Processor Time 00:00:00,02
Elapsed Time 00:00:00,00

[DataSet1]

Descriptive Statistics
N Minimum Maximum Mean Std. Deviation
V1 30 1 30 15,50 8,803
V6 120 2020 2023 2021,50 1,123
V7 120 61294547158,0 1496797899793 1013325428979 2363265150893
45,0 3,291 2,4920
V8 120 50518968264,0 1246458482210 8428889612312, 1948014803016
80,0 038 8,2970
V9 120 - 3447814319746 986296115905,9 3600540429825,
142559903429,0 0,0 66 3726
V10 120 113575070137,0 1877825865638 1244309952042 3242528836169
01,0 7,125 7,7500
V11 120 5137800285,0 8745579684681 5504834288112, 1475821371239
0,0 777 4,9360
V12 120 102034801524,0 1028364192393 6938265232314, 1805589956006
79,0 350 4,5350
V13 120 5932491378,0 4213449393221 2242894512451, 6370283912027,
0,0 876 5560
V14 120 3971534871,0 7199837073787 4563687323727, 1348354193138
1,0 692 7,5840
V15 120 - 2672091330310 934903022105,5 3071147578645,
852102006740,0 8,0 25 1123
V16 120 -13503384927,0 4110840953299 1704364677481, 4700480192549,
2,0 259 6420
V17 120 -15,31% 41,51% 6,1528% 7,64714%
V18 120 -41,46% 51,37% 10,3896% 12,47916%
V19 120 -8,74% 66,31% 8,8739% 11,57862%
V20 120 9,329002804517 699,7172013070 109,4416756802 119,4887832460
652 53500 93490 91600
V21 120 -2,38% 50,45% 16,6153% 11,81547%
V22 120 8,03% 690,00% 105,0796% 106,86486%
V23 120 25,45572986613 32,86630595510 28,67516209374 1,613993301519
0760 1200 6000 722
V24 120 -45,11% 143,72% 9,5208% 34,00475%
Valid N (listwise) 30

DESCRIPTIVES VARIABLES=V6 V7 V8 V9 V10 V11 V12 V13 V14 V15 V16 V17 V18 V19 V20
V21 V22 V23 V24
/STATISTICS=MEAN STDDEV MIN MAX.

Descriptives

Notes
Output Created 15-JUN-2025 13:27:15
Comments
Input Active Dataset DataSet1
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data 123
File
Missing Value Handling Definition of Missing User defined missing values
are treated as missing.
Cases Used All non-missing data are
used.
Syntax DESCRIPTIVES
VARIABLES=V6 V7 V8 V9
V10 V11 V12 V13 V14 V15
V16 V17 V18 V19 V20 V21
V22 V23 V24
/STATISTICS=MEAN
STDDEV MIN MAX.
Resources Processor Time 00:00:00,00
Elapsed Time 00:00:00,00
Descriptive Statistics
N Minimum Maximum Mean Std. Deviation
V6 120 2020 2023 2021,50 1,123
V7 120 61294547158,0 1496797899793 1013325428979 2363265150893
45,0 3,291 2,4920
V8 120 50518968264,0 1246458482210 8428889612312, 1948014803016
80,0 038 8,2970
V9 120 - 3447814319746 986296115905,9 3600540429825,
142559903429,0 0,0 66 3726
V10 120 113575070137,0 1877825865638 1244309952042 3242528836169
01,0 7,125 7,7500
V11 120 5137800285,0 8745579684681 5504834288112, 1475821371239
0,0 777 4,9360
V12 120 102034801524,0 1028364192393 6938265232314, 1805589956006
79,0 350 4,5350
V13 120 5932491378,0 4213449393221 2242894512451, 6370283912027,
0,0 876 5560
V14 120 3971534871,0 7199837073787 4563687323727, 1348354193138
1,0 692 7,5840
V15 120 - 2672091330310 934903022105,5 3071147578645,
852102006740,0 8,0 25 1123
V16 120 -13503384927,0 4110840953299 1704364677481, 4700480192549,
2,0 259 6420
V17 120 -15,31% 41,51% 6,1528% 7,64714%
V18 120 -41,46% 51,37% 10,3896% 12,47916%
V19 120 -8,74% 66,31% 8,8739% 11,57862%
V20 120 9,329002804517 699,7172013070 109,4416756802 119,4887832460
652 53500 93490 91600
V21 120 -2,38% 50,45% 16,6153% 11,81547%
V22 120 8,03% 690,00% 105,0796% 106,86486%
V23 120 25,45572986613 32,86630595510 28,67516209374 1,613993301519
0760 1200 6000 722
V24 120 -45,11% 143,72% 9,5208% 34,00475%
Valid N (listwise) 120

COMPUTE
V_MEAN=MEAN(V6,V7,V8,V9,V10,V11,V12,V13,V14,V15,V16,V17,V18,V19,V20,V21,V22,V2
3,V24).
EXECUTE.
DESCRIPTIVES VARIABLES=V6 V7 V8 V9 V10 V11 V12 V13 V14 V15 V16 V17 V18 V19 V20
V21 V22 V23 V24
V_MEAN
/STATISTICS=MEAN STDDEV MIN MAX.

Descriptives

Notes
Output Created 15-JUN-2025 14:23:49
Comments
Input Active Dataset DataSet1
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data 123
File
Missing Value Handling Definition of Missing User defined missing values
are treated as missing.
Cases Used All non-missing data are
used.
Syntax DESCRIPTIVES
VARIABLES=V6 V7 V8 V9
V10 V11 V12 V13 V14 V15
V16 V17 V18 V19 V20 V21
V22 V23 V24
V_MEAN
/STATISTICS=MEAN
STDDEV MIN MAX.
Resources Processor Time 00:00:00,02
Elapsed Time 00:00:00,00

Descriptive Statistics
N Minimum Maximum Mean Std. Deviation
V6 120 2020 2023 2021,50 1,123
V7 120 61294547158,0 1496797899793 1013325428979 2363265150893
45,0 3,291 2,4920
V8 120 50518968264,0 1246458482210 8428889612312, 1948014803016
80,0 038 8,2970
V9 120 - 3447814319746 986296115905,9 3600540429825,
142559903429,0 0,0 66 3726
V10 120 113575070137,0 1877825865638 1244309952042 3242528836169
01,0 7,125 7,7500
V11 120 5137800285,0 8745579684681 5504834288112, 1475821371239
0,0 777 4,9360
V12 120 102034801524,0 1028364192393 6938265232314, 1805589956006
79,0 350 4,5350
V13 120 5932491378,0 4213449393221 2242894512451, 6370283912027,
0,0 876 5560
V14 120 3971534871,0 7199837073787 4563687323727, 1348354193138
1,0 692 7,5840
V15 120 - 2672091330310 934903022105,5 3071147578645,
852102006740,0 8,0 25 1123
V16 120 -13503384927,0 4110840953299 1704364677481, 4700480192549,
2,0 259 6420
V17 120 -15,31% 41,51% 6,1528% 7,64714%
V18 120 -41,46% 51,37% 10,3896% 12,47916%
V19 120 -8,74% 66,31% 8,8739% 11,57862%
V20 120 9,329002804517 699,7172013070 109,4416756802 119,4887832460
652 53500 93490 91600
V21 120 -2,38% 50,45% 16,6153% 11,81547%
V22 120 8,03% 690,00% 105,0796% 106,86486%
V23 120 25,45572986613 32,86630595510 28,67516209374 1,613993301519
0760 1200 6000 722
V24 120 -45,11% 143,72% 9,5208% 34,00475%
V_MEAN 120 22279790199,38 4360246404707 2835815189313, 7104350353973,
4,90 0596 39550
Valid N (listwise) 120

REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA COLLIN TOL
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT V_MEAN
/METHOD=ENTER V6 V7 V8 V9 V10 V11 V12 V13 V14 V15 V16 V17 V18 V19 V20 V21
V22 V23 V24
/SCATTERPLOT=(*ZRESID ,*ZPRED)
/RESIDUALS DURBIN HISTOGRAM(ZRESID) NORMPROB(ZRESID).

Regression

Notes
Output Created 15-JUN-2025 14:28:28
Comments
Input Active Dataset DataSet1
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data 123
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
/MISSING LISTWISE
/STATISTICS COEFF OUTS
R ANOVA COLLIN TOL
/CRITERIA=PIN(.05)
POUT(.10)
/NOORIGIN
/DEPENDENT V_MEAN
/METHOD=ENTER V6 V7
V8 V9 V10 V11 V12 V13 V14
V15 V16 V17 V18 V19 V20
V21 V22 V23 V24
/SCATTERPLOT=(*ZRESID
,*ZPRED)
/RESIDUALS DURBIN
HISTOGRAM(ZRESID)
NORMPROB(ZRESID).
Resources Processor Time 00:00:00,56
Elapsed Time 00:00:00,46
Memory Required 23472 bytes
Additional Memory Required 392 bytes
for Residual Plots

Variables Entered/Removeda
Variables Variables
Model Entered Removed Method
1 V24, V21, V20, . Enter
V14, V6, V19,
V23, V18, V9,
V22, V8, V17,
V15, V12, V13,
V11, V16b

a. Dependent Variable: V_MEAN


b. Tolerance = ,000 limit reached.

Model Summaryb
Adjusted R Std. Error of the
Model R R Square Square Estimate Durbin-Watson
a
1 1,000 1,000 1,000 114345,18415 1,091

a. Predictors: (Constant), V24, V21, V20, V14, V6, V19, V23, V18, V9, V22, V8, V17, V15,
V12, V13, V11, V16
b. Dependent Variable: V_MEAN

ANOVAa
Model Sum of Squares df Mean Square F Sig.
1 Regression 6006143480288 17 3533025576640 . .b
2300000000000 1350000000000
00,000 0,000
Residual 1333631756203, 102 13074821139,25
653 2
Total 6006143480288 119
2310000000000
00,000

a. Dependent Variable: V_MEAN


b. Predictors: (Constant), V24, V21, V20, V14, V6, V19, V23, V18, V9, V22, V8, V17, V15, V12,
V13, V11, V16

Coefficientsa
Unstandardized Standardized
Coefficients Coefficients
Model B Std. Error Beta t Sig.
1 (Constant ,439 20617260,43 ,000 1,000
) 7
V6 ,053 10218,779 ,000 ,000 1,000
V8 ,105 ,000 ,289 21639820,73 ,000
9
V9 ,053 ,000 ,027 1550534,307 ,000
V11 ,105 ,000 ,219 12722123,97 ,000
4
V12 ,105 ,000 ,268 30257970,32 ,000
8
V13 ,053 ,000 ,047 3644048,858 ,000
V14 ,053 ,000 ,100 6512372,707 ,000
V15 ,053 ,000 ,023 3171711,485 ,000
V16 ,105 ,000 ,070 3529899,721 ,000
V17 ,051 4038,968 ,000 ,000 1,000
V18 ,054 2107,090 ,000 ,000 1,000
V19 ,052 1801,971 ,000 ,000 1,000
V20 ,053 96,247 ,000 ,001 1,000
V21 ,053 1776,523 ,000 ,000 1,000
V22 ,053 204,915 ,000 ,000 1,000
V23 ,016 11507,255 ,000 ,000 1,000
V24 ,052 359,661 ,000 ,000 1,000

Excluded Variablesa
Partial Collinearity Statistics
Model Beta In t Sig. Correlation Tolerance VIF
b
1 V7 . . . . ,000 .
b
V10 . . . . ,000 .

Collinearity Diagnosticsa
Variance
M Proportions
o Dim Eig Cond (Co
d ensi env ition nst
el on alue Index ant) V6 V8 V9
1 1 9,70 1,000 ,00 ,00 ,00 ,00
9
2 4,27 1,507 ,00 ,00 ,00 ,00
7
3 1,33 2,698 ,00 ,00 ,00 ,00
4
4 ,962 3,177 ,00 ,00 ,00 ,00
5 ,483 4,483 ,00 ,00 ,00 ,00
6 ,436 4,717 ,00 ,00 ,00 ,00
7 ,331 5,417 ,00 ,00 ,00 ,00
8 ,150 8,051 ,00 ,00 ,00 ,00
9 ,125 8,817 ,00 ,00 ,02 ,00
10 ,071 11,72 ,00 ,00 ,00 ,00
4
11 ,050 13,96 ,00 ,00 ,01 ,00
7
12 ,029 18,21 ,00 ,00 ,02 ,02
0
13 ,027 19,11 ,00 ,00 ,02 ,01
8
14 ,009 32,52 ,00 ,00 ,10 ,02
1
15 ,004 47,83 ,00 ,00 ,14 ,03
4
16 ,002 65,33 ,00 ,00 ,69 ,74
2
17 ,001 129,1 ,00 ,00 ,00 ,17
01
18 1,15 9185, 1,0 1,0 ,00 ,00
1E- 773 0 0
7

Residuals Statisticsa
Minimum Maximum Mean Std. Deviation N
Predicted Value 22279790592,00 4360246604595 2835815189313, 7104350353973, 120
00 2,0000 0580 39550
Residual -,26953 ,24609 ,00086 ,07898 120
Std. Predicted Value -,396 5,738 ,000 1,000 120
Std. Residual ,000 ,000 ,000 ,000 120

a. Dependent Variable: V_MEAN

Charts

You might also like