GRAPH
/BAR(STACK)=PCT BY quarter BY mode
/TITLE=”Quarter by Travellers’ Mode of Travel”.
Graph
Notes
Output Created
16-MAY-2019 22:33:35
Comments
Input
Data
D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Active Dataset
DataSet1
File Label
Aggregated File
Filter
Weight
Split File
N of Rows in Working Data File
1699
Syntax
GRAPH
/BAR(STACK)=PCT BY quarter BY mode
/TITLE=”Quarter by Travellers’ Mode of Travel”.
Resources
Processor Time
00:00:00.41
Elapsed Time
00:00:00.41
[DataSet1] D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
GRAPH
/BAR(STACK)=PCT BY quarter BY mode
/PANEL COLVAR=package COLOP=CROSS
/TITLE=”Quarter by Travellers’ Mode of Travel, and by Traveller Package Type”.
Graph
Notes
Output Created
16-MAY-2019 22:34:46
Comments
Input
Data
D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Active Dataset
DataSet1
File Label
Aggregated File
Filter
Weight
Split File
N of Rows in Working Data File
1699
Syntax
GRAPH
/BAR(STACK)=PCT BY quarter BY mode
/PANEL COLVAR=package COLOP=CROSS
/TITLE=”Quarter by Travellers’ Mode of Travel, and by Traveller Package Type”.
Resources
Processor Time
00:00:00.39
Elapsed Time
00:00:00.49
[DataSet1] D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
EXAMINE VARIABLES=spend BY purpose
/PLOT=BOXPLOT
/STATISTICS=NONE
/NOTOTAL.
Explore
Notes
Output Created
16-MAY-2019 22:39:22
Comments
Input
Data
D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Active Dataset
DataSet1
File Label
Aggregated File
Filter
Weight
Split File
N of Rows in Working Data File
1699
Missing Value Handling
Definition of Missing
User-defined missing values for dependent variables are treated as missing.
Cases Used
Statistics are based on cases with no missing values for any dependent variable or factor used.
Syntax
EXAMINE VARIABLES=spend BY purpose
/PLOT=BOXPLOT
/STATISTICS=NONE
/NOTOTAL.
Resources
Processor Time
00:00:00.50
Elapsed Time
00:00:01.11
[DataSet1] D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Main purpose of visit
Case Processing Summary
Main purpose of visit
Cases
Valid
Missing
Total
N
Percent
N
Percent
N
Percent
Spending £UK
Holiday
708
100.0%
0
0.0%
708
100.0%
Business
292
100.0%
0
0.0%
292
100.0%
Study
14
100.0%
0
0.0%
14
100.0%
VFR
482
100.0%
0
0.0%
482
100.0%
Miscellaneous
203
100.0%
0
0.0%
203
100.0%
Spending £UK
EXAMINE VARIABLES=spend BY purpose BY package
/PLOT=BOXPLOT
/STATISTICS=NONE
/NOTOTAL.
Explore
Notes
Output Created
16-MAY-2019 22:44:21
Comments
Input
Data
D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Active Dataset
DataSet1
File Label
Aggregated File
Filter
Weight
Split File
N of Rows in Working Data File
1699
Missing Value Handling
Definition of Missing
User-defined missing values for dependent variables are treated as missing.
Cases Used
Statistics are based on cases with no missing values for any dependent variable or factor used.
Syntax
EXAMINE VARIABLES=spend BY purpose BY package
/PLOT=BOXPLOT
/STATISTICS=NONE
/NOTOTAL.
Resources
Processor Time
00:00:00.62
Elapsed Time
00:00:00.63
[DataSet1] D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Main purpose of visit * Package tour or independent
Case Processing Summary
Main purpose of visit
Package tour or independent
Cases
Valid
Missing
Total
N
Percent
N
Percent
N
Percent
Spending £UK
Holiday
Independent
431
100.0%
0
0.0%
431
100.0%
Non-Independent
277
100.0%
0
0.0%
277
100.0%
Business
Independent
260
100.0%
0
0.0%
260
100.0%
Non-Independent
32
100.0%
0
0.0%
32
100.0%
Study
Independent
10
100.0%
0
0.0%
10
100.0%
Non-Independent
4
100.0%
0
0.0%
4
100.0%
VFR
Independent
457
100.0%
0
0.0%
457
100.0%
Non-Independent
25
100.0%
0
0.0%
25
100.0%
Miscellaneous
Independent
186
100.0%
0
0.0%
186
100.0%
Non-Independent
17
100.0%
0
0.0%
17
100.0%
Spending £UK
Explore
Notes
Output Created
17-MAY-2019 17:03:06
Comments
Input
Data
D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Active Dataset
DataSet1
File Label
Aggregated File
Filter
Weight
Split File
N of Rows in Working Data File
1078248
Missing Value Handling
Definition of Missing
User-defined missing values for dependent variables are treated as missing.
Cases Used
Statistics are based on cases with no missing values for any dependent variable or factor used.
Syntax
EXAMINE VARIABLES=spend BY package
/PLOT NPPLOT
/STATISTICS DESCRIPTIVES
/CINTERVAL 95
/MISSING LISTWISE
/NOTOTAL.
Resources
Processor Time
00:03:08.11
Elapsed Time
00:03:18.78
[DataSet1] D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Package tour or independent
Case Processing Summary
Package tour or independent
Cases
Valid
Missing
Total
N
Percent
N
Percent
N
Percent
Spending £UK
Independent
1344
100.0%
0
0.0%
1344
100.0%
Non-Independent
355
100.0%
0
0.0%
355
100.0%
Descriptives
Package tour or independent
Statistic
Std. Error
Bootstrap
Bias
Std. Error
95% Confidence Interval
Lower
Upper
Spending £UK
Independent
Mean
226848.30945
4871.104859
-131.69396
4980.17079
217177.53136
236746.38603
95% Confidence Interval for Mean
Lower Bound
217292.50742
Upper Bound
236404.11147
5% Trimmed Mean
216662.30191
-109.70591
5334.39498
206385.72159
227147.44169
Median
188400.73750
-152.03735
6192.54101
177690.70800
200805.85000
Variance
31889978466.038
-67998866.717
1095498147.838
29647905100.822
33961605743.335
Std. Deviation
178577.653882
-216.934799
3072.935159
172185.670398
184286.748461
Minimum
.000
Maximum
694044.600
Range
694044.600
Interquartile Range
260454.994
-1497.234
9310.473
241564.666
277964.425
Skewness
.711
.067
.000
.046
.621
.802
Kurtosis
-.381
.133
.005
.099
-.554
-.185
Non-Independent
Mean
299170.03008
8787.897859
117.00702
8611.14792
282177.08145
316322.70596
95% Confidence Interval for Mean
Lower Bound
281886.97773
Upper Bound
316453.08244
5% Trimmed Mean
294567.05390
165.65488
9093.49196
276893.09782
312525.31124
Median
280563.51300
-933.38073
10736.10819
254453.95791
301590.99600
Variance
27415637814.812
-69604539.980
1746525951.356
24182966268.356
30919196616.832
Std. Deviation
165576.682582
-294.771012
5286.864244
155508.733735
175838.552505
Minimum
314.585
Maximum
699722.188
Range
699407.603
Interquartile Range
237537.127
2467.855
15495.928
211100.979
272714.546
Skewness
.374
.129
.000
.077
.221
.526
Kurtosis
-.576
.258
.005
.125
-.798
-.309
Tests of Normality
Package tour or independent
Kolmogorov-Smirnov
Shapiro-Wilk
Statistic
df
Sig.
Statistic
df
Sig.
Spending £UK
Independent
.102
1344
.000
.930
1344
.000
Non-Independent
.058
355
.007
.976
355
.000
EXAMINE VARIABLES=spend BY package
/PLOT NPPLOT
/STATISTICS DESCRIPTIVES
/CINTERVAL 95
/MISSING LISTWISE
/NOTOTAL.
Explore
Notes
Output Created
17-MAY-2019 17:06:25
Comments
Input
Data
D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Active Dataset
DataSet1
File Label
Aggregated File
Filter
Weight
Split File
N of Rows in Working Data File
1699
Missing Value Handling
Definition of Missing
User-defined missing values for dependent variables are treated as missing.
Cases Used
Statistics are based on cases with no missing values for any dependent variable or factor used.
Syntax
EXAMINE VARIABLES=spend BY package
/PLOT NPPLOT
/STATISTICS DESCRIPTIVES
/CINTERVAL 95
/MISSING LISTWISE
/NOTOTAL.
Resources
Processor Time
00:00:02.87
Elapsed Time
00:00:09.49
[DataSet1] D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Package tour or independent
Case Processing Summary
Package tour or independent
Cases
Valid
Missing
Total
N
Percent
N
Percent
N
Percent
Spending £UK
Independent
1344
100.0%
0
0.0%
1344
100.0%
Non-Independent
355
100.0%
0
0.0%
355
100.0%
Descriptives
Package tour or independent
Statistic
Std. Error
Spending £UK
Independent
Mean
226848.30945
4871.104859
95% Confidence Interval for Mean
Lower Bound
217292.50742
Upper Bound
236404.11147
5% Trimmed Mean
216662.30191
Median
188400.73750
Variance
31889978466.038
Std. Deviation
178577.653882
Minimum
.000
Maximum
694044.600
Range
694044.600
Interquartile Range
260454.994
Skewness
.711
.067
Kurtosis
-.381
.133
Non-Independent
Mean
299170.03008
8787.897859
95% Confidence Interval for Mean
Lower Bound
281886.97773
Upper Bound
316453.08244
5% Trimmed Mean
294567.05390
Median
280563.51300
Variance
27415637814.812
Std. Deviation
165576.682582
Minimum
314.585
Maximum
699722.188
Range
699407.603
Interquartile Range
237537.127
Skewness
.374
.129
Kurtosis
-.576
.258
Tests of Normality
Package tour or independent
Kolmogorov-Smirnov
Shapiro-Wilk
Statistic
df
Sig.
Statistic
df
Sig.
Spending £UK
Independent
.102
1344
.000
.930
1344
.000
Non-Independent
.058
355
.007
.976
355
.000
Spending £UK
Normal Q-Q Plots
Detrended Normal Q-Q Plots
EXAMINE VARIABLES=spend
/PLOT NPPLOT
/STATISTICS DESCRIPTIVES
/CINTERVAL 95
/MISSING LISTWISE
/NOTOTAL.
Explore
Notes
Output Created
17-MAY-2019 17:21:29
Comments
Input
Data
D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Active Dataset
DataSet1
File Label
Aggregated File
Filter
Weight
Split File
N of Rows in Working Data File
1699
Missing Value Handling
Definition of Missing
User-defined missing values for dependent variables are treated as missing.
Cases Used
Statistics are based on cases with no missing values for any dependent variable or factor used.
Syntax
EXAMINE VARIABLES=spend
/PLOT NPPLOT
/STATISTICS DESCRIPTIVES
/CINTERVAL 95
/MISSING LISTWISE
/NOTOTAL.
Resources
Processor Time
00:00:01.05
Elapsed Time
00:00:01.63
[DataSet1] D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Case Processing Summary
Cases
Valid
Missing
Total
N
Percent
N
Percent
N
Percent
Spending £UK
1699
100.0%
0
0.0%
1699
100.0%
Descriptives
Statistic
Std. Error
Spending £UK
Mean
241959.67544
4326.535032
95% Confidence Interval for Mean
Lower Bound
233473.77377
Upper Bound
250445.57711
5% Trimmed Mean
233231.78329
Median
211278.25300
Variance
31803420243.159
Std. Deviation
178335.134629
Minimum
.000
Maximum
699722.188
Range
699722.188
Interquartile Range
265112.878
Skewness
.604
.059
Kurtosis
-.508
.119
Tests of Normality
Kolmogorov-Smirnov
Shapiro-Wilk
Statistic
df
Sig.
Statistic
df
Sig.
Spending £UK
.087
1699
.000
.944
1699
.000
Spending £UK
T-TEST GROUPS=package(1 2)
/MISSING=ANALYSIS
/VARIABLES=spend
/CRITERIA=CI(.95).
T-Test
Notes
Output Created
17-MAY-2019 17:31:13
Comments
Input
Data
D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Active Dataset
DataSet1
File Label
Aggregated File
Filter
Weight
Split File
N of Rows in Working Data File
1699
Missing Value Handling
Definition of Missing
User defined missing values are treated as missing.
Cases Used
Statistics for each analysis are based on the cases with no missing or out-of-range data for any variable in the analysis.
Syntax
T-TEST GROUPS=package(1 2)
/MISSING=ANALYSIS
/VARIABLES=spend
/CRITERIA=CI(.95).
Resources
Processor Time
00:00:00.03
Elapsed Time
00:00:00.65
[DataSet1] D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Group Statistics
Package tour or independent
N
Mean
Std. Deviation
Std. Error Mean
Spending £UK
Independent
1344
226848.30945
178577.653882
4871.104859
Non-Independent
355
299170.03008
165576.682582
8787.897859
Independent Samples Test
Levene’s Test for Equality of Variances
t-test for Equality of Means
F
Sig.
t
df
Sig. (2-tailed)
Mean Difference
Std. Error Difference
95% Confidence Interval of the Difference
Lower
Upper
Spending £UK
Equal variances assumed
4.012
.045
-6.888
1697
.000
-72321.720638
10499.282386
-92914.623437
-51728.817839
Equal variances not assumed
-7.198
590.260
.000
-72321.720638
10047.627149
-92055.171212
-52588.270064
Notes
Output Created
17-MAY-2019 17:34:38
Comments
Input
Data
D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Active Dataset
DataSet1
File Label
Aggregated File
Filter
Weight
Split File
N of Rows in Working Data File
1699
Missing Value Handling
Definition of Missing
User-defined missing values are treated as missing.
Cases Used
Statistics are based on all cases with valid data.
Syntax
FREQUENCIES VARIABLES=spend
/FORMAT=NOTABLE
/HISTOGRAM NORMAL
/ORDER=ANALYSIS.
Resources
Processor Time
00:00:00.42
Elapsed Time
00:00:01.66
CROSSTABS
/TABLES=mode BY purpose
/FORMAT=AVALUE TABLES
/STATISTICS=CHISQ
/CELLS=COUNT EXPECTED
/COUNT ROUND CELL
/METHOD=MC CIN(95) SAMPLES(10000).
Crosstabs
Notes
Output Created
17-MAY-2019 18:18:48
Comments
Input
Data
D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Active Dataset
DataSet1
File Label
Aggregated File
Filter
Weight
Split File
N of Rows in Working Data File
1699
Missing Value Handling
Definition of Missing
User-defined missing values are treated as missing.
Cases Used
Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax
CROSSTABS
/TABLES=mode BY purpose
/FORMAT=AVALUE TABLES
/STATISTICS=CHISQ
/CELLS=COUNT EXPECTED
/COUNT ROUND CELL
/METHOD=MC CIN(95) SAMPLES(10000).
Resources
Processor Time
00:00:00.22
Elapsed Time
00:00:00.94
Dimensions Requested
2
Cells Available
174762
Time for Exact Statistics
0:00:00.30
[DataSet1] D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Case Processing Summary
Cases
Valid
Missing
Total
N
Percent
N
Percent
N
Percent
Mode of travel * Main purpose of visit
1699
100.0%
0
0.0%
1699
100.0%
Mode of travel * Main purpose of visit Crosstabulation
Main purpose of visit
Total
Holiday
Business
Study
VFR
Miscellaneous
Mode of travel
Air
Count
243
141
14
171
85
654
Expected Count
272.5
112.4
5.4
185.5
78.1
654.0
Sea
Count
316
96
0
183
80
675
Expected Count
281.3
116.0
5.6
191.5
80.7
675.0
Tunnel
Count
149
55
0
128
38
370
Expected Count
154.2
63.6
3.0
105.0
44.2
370.0
Total
Count
708
292
14
482
203
1699
Expected Count
708.0
292.0
14.0
482.0
203.0
1699.0
Chi-Square Tests
Value
df
Asymp. Sig. (2-sided)
Monte Carlo Sig. (2-sided)
Monte Carlo Sig. (1-sided)
Sig.
95% Confidence Interval
Sig.
95% Confidence Interval
Lower Bound
Upper Bound
Lower Bound
Upper Bound
Pearson Chi-Square
49.967
8
.000
.000
.000
.000
Likelihood Ratio
53.741
8
.000
.000
.000
.000
Fisher’s Exact Test
48.062
.000
.000
.000
Linear-by-Linear Association
.000
1
.999
1.000
1.000
1.000
.503
.493
.512
N of Valid Cases
1699
REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA COLLIN TOL
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT spend
/METHOD=ENTER quarter Age Sex duration visits nights
/SCATTERPLOT=(*ZRESID ,*ZPRED)
/RESIDUALS DURBIN NORMPROB(ZRESID).
Regression
Notes
Output Created
17-MAY-2019 20:28:42
Comments
Input
Data
D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Active Dataset
DataSet1
File Label
Aggregated File
Filter
Weight
Split File
N of Rows in Working Data File
1699
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 spend
/METHOD=ENTER quarter Age Sex duration visits nights
/SCATTERPLOT=(*ZRESID ,*ZPRED)
/RESIDUALS DURBIN NORMPROB(ZRESID).
Resources
Processor Time
00:00:03.98
Elapsed Time
00:00:06.81
Memory Required
3220 bytes
Additional Memory Required for Residual Plots
528 bytes
[DataSet1] D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Variables Entered/Removed
Model
Variables Entered
Variables Removed
Method
1
Number of nights , Quarter , Gender , Number of visits , Age range , Duration of stay
.
Enter
Model Summary
Model
R
R Square
Adjusted R Square
Std. Error of the Estimate
Durbin-Watson
1
.343
.117
.114
167829.627249
1.775
ANOVA
Model
Sum of Squares
df
Mean Square
F
Sig.
1
Regression
6344009412891.912
6
1057334902148.652
37.538
.000
Residual
47658198159991.410
1692
28166783782.501
Total
54002207572883.320
1698
Coefficients
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
Collinearity Statistics
B
Std. Error
Beta
Tolerance
VIF
1
(Constant)
-37698.648
24720.090
-1.525
.127
Quarter
1133.778
3606.346
.007
.314
.753
.988
1.012
Age range
7145.917
2116.328
.079
3.377
.001
.962
1.040
Gender
5681.616
4416.142
.030
1.287
.198
.974
1.026
Duration of stay
61699.153
4952.597
.374
12.458
.000
.578
1.729
Number of visits
153.289
16.588
.226
9.241
.000
.875
1.143
Number of nights
-1.166
.292
-.118
-3.990
.000
.594
1.682
Collinearity Diagnostics
Model
Dimension
Eigenvalue
Condition Index
Variance Proportions
(Constant)
Quarter
Age range
Gender
Duration of stay
Number of visits
Number of nights
1
1
5.424
1.000
.00
.01
.00
.01
.00
.00
.00
2
.863
2.508
.00
.01
.00
.01
.01
.00
.46
3
.239
4.768
.00
.18
.00
.77
.00
.01
.01
4
.162
5.788
.00
.00
.03
.00
.64
.08
.32
5
.155
5.909
.00
.37
.58
.14
.02
.00
.02
6
.138
6.268
.01
.31
.24
.03
.05
.21
.06
7
.020
16.438
.98
.12
.14
.05
.27
.70
.11
Residuals Statistics
Minimum
Maximum
Mean
Std. Deviation
N
Predicted Value
63711.46484
410391.09375
241959.67544
61124.182874
1699
Residual
-391187.531250
510683.062500
.000000
167532.846067
1699
Std. Predicted Value
-2.916
2.756
.000
1.000
1699
Std. Residual
-2.331
3.043
.000
.998
1699
Charts
REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA COLLIN TOL
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT spend
/METHOD=ENTER Age duration visits nights
/SCATTERPLOT=(*ZRESID ,*ZPRED)
/RESIDUALS DURBIN NORMPROB(ZRESID).
Regression
Notes
Output Created
17-MAY-2019 20:34:04
Comments
Input
Data
D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Active Dataset
DataSet1
File Label
Aggregated File
Filter
Weight
Split File
N of Rows in Working Data File
1699
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 spend
/METHOD=ENTER Age duration visits nights
/SCATTERPLOT=(*ZRESID ,*ZPRED)
/RESIDUALS DURBIN NORMPROB(ZRESID).
Resources
Processor Time
00:00:01.25
Elapsed Time
00:00:01.25
Memory Required
2468 bytes
Additional Memory Required for Residual Plots
544 bytes
[DataSet1] D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Variables Entered/Removed
Model
Variables Entered
Variables Removed
Method
1
Number of nights , Age range , Number of visits , Duration of stay
.
Enter
Model Summary
Model
R
R Square
Adjusted R Square
Std. Error of the Estimate
Durbin-Watson
1
.341
.117
.114
167815.964611
1.774
ANOVA
Model
Sum of Squares
df
Mean Square
F
Sig.
1
Regression
6295444197811.411
4
1573861049452.853
55.886
.000
Residual
47706763375071.910
1694
28162197978.201
Total
54002207572883.320
1698
Coefficients
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
Collinearity Statistics
B
Std. Error
Beta
Tolerance
VIF
1
(Constant)
-26590.476
21769.433
-1.221
.222
Age range
7542.749
2094.258
.083
3.602
.000
.982
1.018
Duration of stay
61728.835
4951.941
.374
12.466
.000
.578
1.729
Number of visits
151.963
16.511
.224
9.204
.000
.883
1.133
Number of nights
-1.178
.292
-.119
-4.036
.000
.595
1.680
Collinearity Diagnostics
Model
Dimension
Eigenvalue
Condition Index
Variance Proportions
(Constant)
Age range
Duration of stay
Number of visits
Number of nights
1
1
3.876
1.000
.00
.01
.01
.00
.01
2
.793
2.211
.00
.01
.01
.00
.49
3
.162
4.893
.00
.03
.66
.08
.34
4
.145
5.165
.01
.74
.01
.14
.02
5
.023
12.850
.99
.21
.32
.77
.15
Residuals Statistics
Minimum
Maximum
Mean
Std. Deviation
N
Predicted Value
67896.51563
414457.25000
241959.67544
60889.771798
1699
Residual
-389706.468750
506635.468750
.000000
167618.184973
1699
Std. Predicted Value
-2.859
2.833
.000
1.000
1699
Std. Residual
-2.322
3.019
.000
.999
1699
Charts
REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA COLLIN TOL
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT spend
/METHOD=ENTER Age duration visits nights
/SCATTERPLOT=(*ZRESID ,*ZPRED)
/RESIDUALS DURBIN NORMPROB(ZRESID)
/SAVE ZRESID.
Regression
Notes
Output Created
17-MAY-2019 20:58:55
Comments
Input
Data
D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Active Dataset
DataSet1
File Label
Aggregated File
Filter
Weight
Split File
N of Rows in Working Data File
1699
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 spend
/METHOD=ENTER Age duration visits nights
/SCATTERPLOT=(*ZRESID ,*ZPRED)
/RESIDUALS DURBIN NORMPROB(ZRESID)
/SAVE ZRESID.
Resources
Processor Time
00:00:01.22
Elapsed Time
00:00:01.82
Memory Required
2468 bytes
Additional Memory Required for Residual Plots
544 bytes
Variables Created or Modified
ZRE_1
Standardized Residual
[DataSet1] D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Variables Entered/Removed
Model
Variables Entered
Variables Removed
Method
1
Number of nights , Age range , Number of visits , Duration of stay
.
Enter
Model Summary
Model
R
R Square
Adjusted R Square
Std. Error of the Estimate
Durbin-Watson
1
.341
.117
.114
167815.964611
1.774
ANOVA
Model
Sum of Squares
df
Mean Square
F
Sig.
1
Regression
6295444197811.411
4
1573861049452.853
55.886
.000
Residual
47706763375071.910
1694
28162197978.201
Total
54002207572883.320
1698
Coefficients
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
Collinearity Statistics
B
Std. Error
Beta
Tolerance
VIF
1
(Constant)
-26590.476
21769.433
-1.221
.222
Age range
7542.749
2094.258
.083
3.602
.000
.982
1.018
Duration of stay
61728.835
4951.941
.374
12.466
.000
.578
1.729
Number of visits
151.963
16.511
.224
9.204
.000
.883
1.133
Number of nights
-1.178
.292
-.119
-4.036
.000
.595
1.680
Collinearity Diagnostics
Model
Dimension
Eigenvalue
Condition Index
Variance Proportions
(Constant)
Age range
Duration of stay
Number of visits
Number of nights
1
1
3.876
1.000
.00
.01
.01
.00
.01
2
.793
2.211
.00
.01
.01
.00
.49
3
.162
4.893
.00
.03
.66
.08
.34
4
.145
5.165
.01
.74
.01
.14
.02
5
.023
12.850
.99
.21
.32
.77
.15
Residuals Statistics
Minimum
Maximum
Mean
Std. Deviation
N
Predicted Value
67896.51563
414457.25000
241959.67544
60889.771798
1699
Residual
-389706.468750
506635.468750
.000000
167618.184973
1699
Std. Predicted Value
-2.859
2.833
.000
1.000
1699
Std. Residual
-2.322
3.019
.000
.999
1699
Charts
EXAMINE VARIABLES=ZRE_1
/PLOT HISTOGRAM NPPLOT
/STATISTICS DESCRIPTIVES
/CINTERVAL 95
/MISSING LISTWISE
/NOTOTAL.
Explore
Notes
Output Created
17-MAY-2019 21:00:00
Comments
Input
Data
D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Active Dataset
DataSet1
File Label
Aggregated File
Filter
Weight
Split File
N of Rows in Working Data File
1699
Missing Value Handling
Definition of Missing
User-defined missing values for dependent variables are treated as missing.
Cases Used
Statistics are based on cases with no missing values for any dependent variable or factor used.
Syntax
EXAMINE VARIABLES=ZRE_1
/PLOT HISTOGRAM NPPLOT
/STATISTICS DESCRIPTIVES
/CINTERVAL 95
/MISSING LISTWISE
/NOTOTAL.
Resources
Processor Time
00:00:01.53
Elapsed Time
00:00:02.43
[DataSet1] D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Case Processing Summary
Cases
Valid
Missing
Total
N
Percent
N
Percent
N
Percent
Standardized Residual
1699
100.0%
0
0.0%
1699
100.0%
Descriptives
Statistic
Std. Error
Standardized Residual
Mean
0E-7
.02423211
95% Confidence Interval for Mean
Lower Bound
-.0475279
Upper Bound
.0475279
5% Trimmed Mean
-.0338469
Median
-.1573709
Variance
.998
Std. Deviation
.99882145
Minimum
-2.32223
Maximum
3.01899
Range
5.34122
Interquartile Range
1.37262
Skewness
.538
.059
Kurtosis
-.208
.119
Tests of Normality
Kolmogorov-Smirnov
Shapiro-Wilk
Statistic
df
Sig.
Statistic
df
Sig.
Standardized Residual
.070
1699
.000
.974
1699
.000
Standardized Residual
FREQUENCIES VARIABLES=ZRE_1
/FORMAT=NOTABLE
/HISTOGRAM NORMAL
/ORDER=ANALYSIS.
Frequencies
Notes
Output Created
17-MAY-2019 21:01:19
Comments
Input
Data
D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Active Dataset
DataSet1
File Label
Aggregated File
Filter
Weight
Split File
N of Rows in Working Data File
1699
Missing Value Handling
Definition of Missing
User-defined missing values are treated as missing.
Cases Used
Statistics are based on all cases with valid data.
Syntax
FREQUENCIES VARIABLES=ZRE_1
/FORMAT=NOTABLE
/HISTOGRAM NORMAL
/ORDER=ANALYSIS.
Resources
Processor Time
00:00:00.44
Elapsed Time
00:00:00.43
[DataSet1] D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Statistics
Standardized Residual
N
Valid
1699
Missing
0
REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA COLLIN TOL
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT spend
/METHOD=ENTER Age duration visits nights
/SCATTERPLOT=(*ZRESID ,*ZPRED)
/RESIDUALS DURBIN NORMPROB(ZRESID)
/SAVE PRED.
Regression
Notes
Output Created
17-MAY-2019 21:08:37
Comments
Input
Data
D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Active Dataset
DataSet1
File Label
Aggregated File
Filter
Weight
Split File
N of Rows in Working Data File
1699
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 spend
/METHOD=ENTER Age duration visits nights
/SCATTERPLOT=(*ZRESID ,*ZPRED)
/RESIDUALS DURBIN NORMPROB(ZRESID)
/SAVE PRED.
Resources
Processor Time
00:00:00.98
Elapsed Time
00:00:01.04
Memory Required
2484 bytes
Additional Memory Required for Residual Plots
544 bytes
Variables Created or Modified
PRE_1
Unstandardized Predicted Value
[DataSet1] D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Variables Entered/Removed
Model
Variables Entered
Variables Removed
Method
1
Number of nights , Age range , Number of visits , Duration of stay
.
Enter
Model Summary
Model
R
R Square
Adjusted R Square
Std. Error of the Estimate
Durbin-Watson
1
.341
.117
.114
167815.964611
1.774
ANOVA
Model
Sum of Squares
df
Mean Square
F
Sig.
1
Regression
6295444197811.411
4
1573861049452.853
55.886
.000
Residual
47706763375071.910
1694
28162197978.201
Total
54002207572883.320
1698
Coefficients
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
Collinearity Statistics
B
Std. Error
Beta
Tolerance
VIF
1
(Constant)
-26590.476
21769.433
-1.221
.222
Age range
7542.749
2094.258
.083
3.602
.000
.982
1.018
Duration of stay
61728.835
4951.941
.374
12.466
.000
.578
1.729
Number of visits
151.963
16.511
.224
9.204
.000
.883
1.133
Number of nights
-1.178
.292
-.119
-4.036
.000
.595
1.680
Collinearity Diagnostics
Model
Dimension
Eigenvalue
Condition Index
Variance Proportions
(Constant)
Age range
Duration of stay
Number of visits
Number of nights
1
1
3.876
1.000
.00
.01
.01
.00
.01
2
.793
2.211
.00
.01
.01
.00
.49
3
.162
4.893
.00
.03
.66
.08
.34
4
.145
5.165
.01
.74
.01
.14
.02
5
.023
12.850
.99
.21
.32
.77
.15
Residuals Statistics
Minimum
Maximum
Mean
Std. Deviation
N
Predicted Value
67896.51563
414457.25000
241959.67544
60889.771798
1699
Residual
-389706.468750
506635.468750
.000000
167618.184973
1699
Std. Predicted Value
-2.859
2.833
.000
1.000
1699
Std. Residual
-2.322
3.019
.000
.999
1699
Charts
Graph
Notes
Output Created
17-MAY-2019 21:10:17
Comments
Input
Data
D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Active Dataset
DataSet1
File Label
Aggregated File
Filter
Weight
Split File
N of Rows in Working Data File
1699
Syntax
GRAPH
/SCATTERPLOT(BIVAR)=spend WITH PRE_1
/MISSING=LISTWISE.
Resources
Processor Time
00:00:00.55
Elapsed Time
00:00:00.55
[DataSet1] D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Graph
Notes
Output Created
17-MAY-2019 21:12:52
Comments
Input
Data
D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Active Dataset
DataSet1
File Label
Aggregated File
Filter
Weight
Split File
N of Rows in Working Data File
1699
Syntax
GRAPH
/SCATTERPLOT(BIVAR)=PRE_1 WITH spend
/MISSING=LISTWISE.
Resources
Processor Time
00:00:00.53
Elapsed Time
00:00:00.51
[DataSet1] D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Notes
Output Created
17-MAY-2019 21:17:04
Comments
Input
Data
D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Active Dataset
DataSet1
File Label
Aggregated File
Filter
Weight
Split File
N of Rows in Working Data File
1699
Syntax
GRAPH
/SCATTERPLOT(BIVAR)=PRE_1 WITH spend
/MISSING=LISTWISE.
Resources
Processor Time
00:00:00.56
Elapsed Time
00:00:00.70
GRAPH
/SCATTERPLOT(BIVAR)=PRE_1 WITH spend
/MISSING=LISTWISE.
Graph
Notes
Output Created
17-MAY-2019 21:46:04
Comments
Input
Data
D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav
Active Dataset
DataSet1
File Label
Aggregated File
Filter
Weight
Split File
N of Rows in Working Data File
1699
Syntax
GRAPH
/SCATTERPLOT(BIVAR)=PRE_1 WITH spend
/MISSING=LISTWISE.
Resources
Processor Time
00:00:00.52
Elapsed Time
00:00:00.64
[DataSet1] D:\JAN 2019 -JUNE 2019\Talented\SPSS0514-0518 Quantitative SPSS\Top10Travelpac2017.sav