Excel Data Analysis
mlyubchenko
Example.rtf
FREQUENCIES VARIABLES=x1 x2 x3 x4 x5 x6 x7 x8 x9 x10 x11 x12 x13 x14 x15 x16 x17 x18 x19 x20 x21
x22 x23 x24 x25 x26 x27 x28 x29
/STATISTICS=MEAN MEDIAN MODE
/ORDER=ANALYSIS.
Frequencies
Statistics
X1 -- Try New and Different Things
X2 -- Party Person
X3 -- People Come to Me
X4 -- Avoid Fried Foods
X5 -- Likes to Go Out Socially
N
Valid
377
377
377
377
377
Missing
0
0
0
0
0
Mean
5.44
4.30
5.27
4.07
4.44
Median
7.00
4.00
5.00
4.00
4.00
Mode
7
4
5
3
4
Statistics
X6 -- Friends Come to Me
X7 -- Self-Confident
X8 -- Eat Balanced, Nutritious Meals
X9 -- Buy New Products
X10 -- Careful about What I Eat
N
Valid
377
377
377
377
377
Missing
0
0
0
0
0
Mean
5.31
4.68
4.53
5.66
4.42
Median
5.00
5.00
5.00
6.00
4.00
Mode
5
5
5
7
4
Statistics
X11 -- Try New Brands
X12 -- Friendly Employees
X13 -- Fun Place to Eat
X14 -- Large Size Portions
X15 -- Fresh Food
N
Valid
377
377
377
377
377
Missing
0
0
0
0
0
Mean
5.47
3.69
4.59
4.50
5.79
Median
7.00
4.00
5.00
5.00
6.00
Mode
7
5
5
6
7
Statistics
X16 -- Reasonable Prices
X17 -- Attractive Interior
X18 -- Excellent Food Taste
X19 -- Knowledgeable Employees
X20 -- Proper Food Temperature
N
Valid
377
377
377
377
377
Missing
0
0
0
0
0
Mean
4.33
4.67
5.34
3.59
4.53
Median
4.00
5.00
5.00
4.00
5.00
Mode
4
5
5
4
5
Statistics
X21 -- Speed of Service
X22 -- Satisfaction
X23 -- Likely to Return
X24 -- Likely to Recommend
X25 -- Frequency of Eating at . . . ??
N
Valid
377
377
377
377
377
Missing
0
0
0
0
0
Mean
5.25
4.84
4.48
3.78
3.26
Median
7.00
5.00
4.00
4.00
3.00
Mode
7
4
4
4
3
Statistics
X26 -- Price
X27 -- Food Quality
X28 -- Atmosphere
X29 -- Service
N
Valid
377
377
377
377
Missing
0
0
0
0
Mean
2.31
1.63
3.32
2.76
Median
2.00
1.00
3.00
3.00
Mode
1
1
3
2
Frequency Table
X1 -- Try New and Different Things
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
2
6
1.6
1.6
1.6
3
96
25.5
25.5
27.1
4
58
15.4
15.4
42.4
Strongly Agree
217
57.6
57.6
100.0
Total
377
100.0
100.0
X2 -- Party Person
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
2
10
2.7
2.7
2.7
3
65
17.2
17.2
19.9
4
156
41.4
41.4
61.3
5
107
28.4
28.4
89.7
6
27
7.2
7.2
96.8
Strongly Agree
12
3.2
3.2
100.0
Total
377
100.0
100.0
X3 -- People Come to Me
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
2
1
.3
.3
.3
3
35
9.3
9.3
9.5
4
62
16.4
16.4
26.0
5
109
28.9
28.9
54.9
6
104
27.6
27.6
82.5
Strongly Agree
66
17.5
17.5
100.0
Total
377
100.0
100.0
X4 -- Avoid Fried Foods
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
2
42
11.1
11.1
11.1
3
113
30.0
30.0
41.1
4
65
17.2
17.2
58.4
5
89
23.6
23.6
82.0
6
68
18.0
18.0
100.0
Total
377
100.0
100.0
X5 -- Likes to Go Out Socially
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
2
17
4.5
4.5
4.5
3
46
12.2
12.2
16.7
4
146
38.7
38.7
55.4
5
110
29.2
29.2
84.6
6
39
10.3
10.3
95.0
Strongly Agree
19
5.0
5.0
100.0
Total
377
100.0
100.0
X6 -- Friends Come to Me
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
3
32
8.5
8.5
8.5
4
52
13.8
13.8
22.3
5
124
32.9
32.9
55.2
6
106
28.1
28.1
83.3
Strongly Agree
63
16.7
16.7
100.0
Total
377
100.0
100.0
X7 -- Self-Confident
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
2
17
4.5
4.5
4.5
3
55
14.6
14.6
19.1
4
78
20.7
20.7
39.8
5
126
33.4
33.4
73.2
6
85
22.5
22.5
95.8
Strongly Agree
16
4.2
4.2
100.0
Total
377
100.0
100.0
X8 -- Eat Balanced, Nutritious Meals
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
2
17
4.5
4.5
4.5
3
73
19.4
19.4
23.9
4
84
22.3
22.3
46.2
5
109
28.9
28.9
75.1
6
83
22.0
22.0
97.1
Strongly Agree
11
2.9
2.9
100.0
Total
377
100.0
100.0
X9 -- Buy New Products
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
Strongly Disagree
1
.3
.3
.3
2
2
.5
.5
.8
3
50
13.3
13.3
14.1
4
77
20.4
20.4
34.5
6
60
15.9
15.9
50.4
Strongly Agree
187
49.6
49.6
100.0
Total
377
100.0
100.0
X10 -- Careful about What I Eat
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
2
11
2.9
2.9
2.9
3
64
17.0
17.0
19.9
4
134
35.5
35.5
55.4
5
103
27.3
27.3
82.8
6
54
14.3
14.3
97.1
Strongly Agree
11
2.9
2.9
100.0
Total
377
100.0
100.0
X11 -- Try New Brands
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
3
77
20.4
20.4
20.4
4
90
23.9
23.9
44.3
Strongly Agree
210
55.7
55.7
100.0
Total
377
100.0
100.0
X12 -- Friendly Employees
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
Strongly Disagree
6
1.6
1.6
1.6
2
90
23.9
23.9
25.5
3
46
12.2
12.2
37.7
4
107
28.4
28.4
66.0
5
128
34.0
34.0
100.0
Total
377
100.0
100.0
X13 -- Fun Place to Eat
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
2
6
1.6
1.6
1.6
3
33
8.8
8.8
10.3
4
126
33.4
33.4
43.8
5
158
41.9
41.9
85.7
6
54
14.3
14.3
100.0
Total
377
100.0
100.0
X14 -- Large Size Portions
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
2
32
8.5
8.5
8.5
3
61
16.2
16.2
24.7
4
91
24.1
24.1
48.8
5
73
19.4
19.4
68.2
6
120
31.8
31.8
100.0
Total
377
100.0
100.0
X15 -- Fresh Food
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
4
76
20.2
20.2
20.2
5
84
22.3
22.3
42.4
6
59
15.6
15.6
58.1
Strongly Agree
158
41.9
41.9
100.0
Total
377
100.0
100.0
X16 -- Reasonable Prices
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
2
32
8.5
8.5
8.5
3
61
16.2
16.2
24.7
4
119
31.6
31.6
56.2
5
79
21.0
21.0
77.2
6
86
22.8
22.8
100.0
Total
377
100.0
100.0
X17 -- Attractive Interior
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
2
6
1.6
1.6
1.6
3
49
13.0
13.0
14.6
4
90
23.9
23.9
38.5
5
156
41.4
41.4
79.8
6
71
18.8
18.8
98.7
Strongly Agree
5
1.3
1.3
100.0
Total
377
100.0
100.0
X18 -- Excellent Food Taste
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
3
11
2.9
2.9
2.9
4
79
21.0
21.0
23.9
5
126
33.4
33.4
57.3
6
92
24.4
24.4
81.7
Strongly Agree
69
18.3
18.3
100.0
Total
377
100.0
100.0
X19 -- Knowledgeable Employees
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
Strongly Disagree
30
8.0
8.0
8.0
2
63
16.7
16.7
24.7
3
76
20.2
20.2
44.8
4
151
40.1
40.1
84.9
6
34
9.0
9.0
93.9
Strongly Agree
23
6.1
6.1
100.0
Total
377
100.0
100.0
X20 -- Proper Food Temperature
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
2
12
3.2
3.2
3.2
3
77
20.4
20.4
23.6
4
76
20.2
20.2
43.8
5
137
36.3
36.3
80.1
6
63
16.7
16.7
96.8
Strongly Agree
12
3.2
3.2
100.0
Total
377
100.0
100.0
X21 -- Speed of Service
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
Strongly Disagree
14
3.7
3.7
3.7
2
28
7.4
7.4
11.1
3
55
14.6
14.6
25.7
4
71
18.8
18.8
44.6
6
1
.3
.3
44.8
Strongly Agree
208
55.2
55.2
100.0
Total
377
100.0
100.0
X22 -- Satisfaction
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
3
35
9.3
9.3
9.3
4
137
36.3
36.3
45.6
5
89
23.6
23.6
69.2
6
85
22.5
22.5
91.8
7 = Highly Satisfied
31
8.2
8.2
100.0
Total
377
100.0
100.0
X23 -- Likely to Return
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
2
5
1.3
1.3
1.3
3
71
18.8
18.8
20.2
4
131
34.7
34.7
54.9
5
89
23.6
23.6
78.5
6
71
18.8
18.8
97.3
Highly Likely
10
2.7
2.7
100.0
Total
377
100.0
100.0
X24 -- Likely to Recommend
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
2
57
15.1
15.1
15.1
3
108
28.6
28.6
43.8
4
111
29.4
29.4
73.2
5
68
18.0
18.0
91.2
6
27
7.2
7.2
98.4
Definitely Will Recommend
6
1.6
1.6
100.0
Total
377
100.0
100.0
X25 -- Frequency of Eating at . . . ??
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
Very Infrequently
46
12.2
12.2
12.2
Somewhat Infrequently
64
17.0
17.0
29.2
Occasionally
98
26.0
26.0
55.2
Somewhat Frequently
84
22.3
22.3
77.5
Very Frequently
85
22.5
22.5
100.0
Total
377
100.0
100.0
X26 -- Price
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
Most Important
127
33.7
33.7
33.7
2
88
23.3
23.3
57.0
3
80
21.2
21.2
78.2
Least Important
82
21.8
21.8
100.0
Total
377
100.0
100.0
X27 -- Food Quality
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
Most Important
201
53.3
53.3
53.3
2
118
31.3
31.3
84.6
3
56
14.9
14.9
99.5
Least Important
2
.5
.5
100.0
Total
377
100.0
100.0
X28 -- Atmosphere
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
Most Important
12
3.2
3.2
3.2
2
20
5.3
5.3
8.5
3
180
47.7
47.7
56.2
Least Important
165
43.8
43.8
100.0
Total
377
100.0
100.0
X29 -- Service
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
Most Important
37
9.8
9.8
9.8
2
148
39.3
39.3
49.1
3
62
16.4
16.4
65.5
Least Important
130
34.5
34.5
100.0
Total
377
100.0
100.0
DESCRIPTIVES VARIABLES=x1 x2 x3 x4 x5 x6 x7 x8 x9 x10 x11 x12 x13 x14 x15 x16 x17 x18 x19 x20 x21
x22 x23 x24 x25 x26 x27 x28 x29
/STATISTICS=MEAN STDDEV VARIANCE MIN MAX.
Descriptives
Descriptive Statistics
N
Minimum
Maximum
Mean
Std. Deviation
Variance
X1 -- Try New and Different Things
377
2
7
5.44
1.853
3.433
X2 -- Party Person
377
2
7
4.30
1.025
1.050
X3 -- People Come to Me
377
2
7
5.27
1.212
1.468
X4 -- Avoid Fried Foods
377
2
6
4.07
1.305
1.702
X5 -- Likes to Go Out Socially
377
2
7
4.44
1.128
1.273
X6 -- Friends Come to Me
377
3
7
5.31
1.156
1.336
X7 -- Self-Confident
377
2
7
4.68
1.221
1.491
X8 -- Eat Balanced, Nutritious Meals
377
2
7
4.53
1.235
1.526
X9 -- Buy New Products
377
1
7
5.66
1.596
2.546
X10 -- Careful about What I Eat
377
2
7
4.42
1.106
1.223
X11 -- Try New Brands
377
3
7
5.47
1.753
3.074
X12 -- Friendly Employees
377
1
5
3.69
1.212
1.469
X13 -- Fun Place to Eat
377
2
6
4.59
.895
.802
X14 -- Large Size Portions
377
2
6
4.50
1.313
1.724
X15 -- Fresh Food
377
4
7
5.79
1.187
1.409
X16 -- Reasonable Prices
377
2
6
4.33
1.231
1.516
X17 -- Attractive Interior
377
2
7
4.67
1.018
1.036
X18 -- Excellent Food Taste
377
3
7
5.34
1.090
1.188
X19 -- Knowledgeable Employees
377
1
7
3.59
1.527
2.333
X20 -- Proper Food Temperature
377
2
7
4.53
1.174
1.378
X21 -- Speed of Service
377
1
7
5.25
2.047
4.190
X22 -- Satisfaction
377
3
7
4.84
1.126
1.267
X23 -- Likely to Return
377
2
7
4.48
1.116
1.245
X24 -- Likely to Recommend
377
2
7
3.78
1.207
1.458
X25 -- Frequency of Eating at . . . ??
377
1
5
3.26
1.311
1.719
X26 -- Price
377
1
4
2.31
1.152
1.326
X27 -- Food Quality
377
1
4
1.63
.751
.565
X28 -- Atmosphere
377
1
4
3.32
.719
.516
X29 -- Service
377
1
4
2.76
1.036
1.073
Valid N (listwise)
377
CROSSTABS
/TABLES=x5 BY x32
/FORMAT=AVALUE TABLES
/CELLS=COUNT
/COUNT ROUND CELL.
Crosstabs
Case Processing Summary
Cases
Valid
Missing
Total
N
Percent
N
Percent
N
Percent
X5 -- Likes to Go Out Socially * X32 -- Gender
377
100.0%
0
0.0%
377
100.0%
X5 -- Likes to Go Out Socially * X32 -- Gender Crosstabulation
Count
X32 -- Gender
Total
Male
Female
X5 -- Likes to Go Out Socially
2
16
1
17
3
31
15
46
4
102
44
146
5
59
51
110
6
22
17
39
Strongly Agree
15
4
19
Total
245
132
377
CROSSTABS
/TABLES=x10 BY x32
/FORMAT=AVALUE TABLES
/CELLS=COUNT
/COUNT ROUND CELL.
Crosstabs
Case Processing Summary
Cases
Valid
Missing
Total
N
Percent
N
Percent
N
Percent
X10 -- Careful about What I Eat * X32 -- Gender
377
100.0%
0
0.0%
377
100.0%
X10 -- Careful about What I Eat * X32 -- Gender Crosstabulation
Count
X32 -- Gender
Total
Male
Female
X10 -- Careful about What I Eat
2
6
5
11
3
30
34
64
4
94
40
134
5
73
30
103
6
42
12
54
Strongly Agree
0
11
11
Total
245
132
377
CROSSTABS
/TABLES=x10 BY x26
/FORMAT=AVALUE TABLES
/CELLS=COUNT
/COUNT ROUND CELL.
Crosstabs
Case Processing Summary
Cases
Valid
Missing
Total
N
Percent
N
Percent
N
Percent
X10 -- Careful about What I Eat * X26 -- Price
377
100.0%
0
0.0%
377
100.0%
X10 -- Careful about What I Eat * X26 -- Price Crosstabulation
Count
X26 -- Price
Most Important
2
3
Least Important
X10 -- Careful about What I Eat
2
4
2
1
4
3
36
5
15
8
4
31
32
36
35
5
46
33
16
8
6
10
16
10
18
Strongly Agree
0
0
2
9
Total
127
88
80
82
X10 -- Careful about What I Eat * X26 -- Price Crosstabulation
Count
Total
X10 -- Careful about What I Eat
2
11
3
64
4
134
5
103
6
54
Strongly Agree
11
Total
377
CORRELATIONS
/VARIABLES=x1 x2 x3 x4 x5 x6 x7 x8 x9 x10
/PRINT=TWOTAIL NOSIG
/MISSING=PAIRWISE.
Correlations
Correlations
X1 -- Try New and Different Things
X2 -- Party Person
X3 -- People Come to Me
X4 -- Avoid Fried Foods
X1 -- Try New and Different Things
Pearson Correlation
1
.369**
.121*
-.274**
Sig. (2-tailed)
.000
.018
.000
N
377
377
377
377
X2 -- Party Person
Pearson Correlation
.369**
1
.208**
-.405**
Sig. (2-tailed)
.000
.000
.000
N
377
377
377
377
X3 -- People Come to Me
Pearson Correlation
.121*
.208**
1
-.152**
Sig. (2-tailed)
.018
.000
.003
N
377
377
377
377
X4 -- Avoid Fried Foods
Pearson Correlation
-.274**
-.405**
-.152**
1
Sig. (2-tailed)
.000
.000
.003
N
377
377
377
377
X5 -- Likes to Go Out Socially
Pearson Correlation
.302**
.711**
.066
-.309**
Sig. (2-tailed)
.000
.000
.203
.000
N
377
377
377
377
X6 -- Friends Come to Me
Pearson Correlation
.104*
.179**
.794**
-.139**
Sig. (2-tailed)
.043
.000
.000
.007
N
377
377
377
377
X7 -- Self-Confident
Pearson Correlation
.204**
.215**
.458**
-.160**
Sig. (2-tailed)
.000
.000
.000
.002
N
377
377
377
377
X8 -- Eat Balanced, Nutritious Meals
Pearson Correlation
-.157**
-.403**
-.131*
.791**
Sig. (2-tailed)
.002
.000
.011
.000
N
377
377
377
377
X9 -- Buy New Products
Pearson Correlation
.688**
.304**
.144**
-.310**
Sig. (2-tailed)
.000
.000
.005
.000
N
377
377
377
377
X10 -- Careful about What I Eat
Pearson Correlation
-.041
-.235**
-.084
.666**
Sig. (2-tailed)
.428
.000
.103
.000
N
377
377
377
377
Correlations
X5 -- Likes to Go Out Socially
X6 -- Friends Come to Me
X7 -- Self-Confident
X8 -- Eat Balanced, Nutritious Meals
X1 -- Try New and Different Things
Pearson Correlation
.302**
.104*
.204**
-.157**
Sig. (2-tailed)
.000
.043
.000
.002
N
377
377
377
377
X2 -- Party Person
Pearson Correlation
.711**
.179**
.215**
-.403**
Sig. (2-tailed)
.000
.000
.000
.000
N
377
377
377
377
X3 -- People Come to Me
Pearson Correlation
.066
.794**
.458**
-.131*
Sig. (2-tailed)
.203
.000
.000
.011
N
377
377
377
377
X4 -- Avoid Fried Foods
Pearson Correlation
-.309**
-.139**
-.160**
.791**
Sig. (2-tailed)
.000
.007
.002
.000
N
377
377
377
377
X5 -- Likes to Go Out Socially
Pearson Correlation
1
.013
.101*
-.362**
Sig. (2-tailed)
.806
.050
.000
N
377
377
377
377
X6 -- Friends Come to Me
Pearson Correlation
.013
1
.342**
-.152**
Sig. (2-tailed)
.806
.000
.003
N
377
377
377
377
X7 -- Self-Confident
Pearson Correlation
.101*
.342**
1
-.102*
Sig. (2-tailed)
.050
.000
.047
N
377
377
377
377
X8 -- Eat Balanced, Nutritious Meals
Pearson Correlation
-.362**
-.152**
-.102*
1
Sig. (2-tailed)
.000
.003
.047
N
377
377
377
377
X9 -- Buy New Products
Pearson Correlation
.239**
.172**
.187**
-.327**
Sig. (2-tailed)
.000
.001
.000
.000
N
377
377
377
377
X10 -- Careful about What I Eat
Pearson Correlation
-.171**
-.095
-.067
.732**
Sig. (2-tailed)
.001
.066
.196
.000
N
377
377
377
377
Correlations
X9 -- Buy New Products
X10 -- Careful about What I Eat
X1 -- Try New and Different Things
Pearson Correlation
.688**
-.041
Sig. (2-tailed)
.000
.428
N
377
377
X2 -- Party Person
Pearson Correlation
.304**
-.235**
Sig. (2-tailed)
.000
.000
N
377
377
X3 -- People Come to Me
Pearson Correlation
.144**
-.084
Sig. (2-tailed)
.005
.103
N
377
377
X4 -- Avoid Fried Foods
Pearson Correlation
-.310**
.666**
Sig. (2-tailed)
.000
.000
N
377
377
X5 -- Likes to Go Out Socially
Pearson Correlation
.239**
-.171**
Sig. (2-tailed)
.000
.001
N
377
377
X6 -- Friends Come to Me
Pearson Correlation
.172**
-.095
Sig. (2-tailed)
.001
.066
N
377
377
X7 -- Self-Confident
Pearson Correlation
.187**
-.067
Sig. (2-tailed)
.000
.196
N
377
377
X8 -- Eat Balanced, Nutritious Meals
Pearson Correlation
-.327**
.732**
Sig. (2-tailed)
.000
.000
N
377
377
X9 -- Buy New Products
Pearson Correlation
1
-.189**
Sig. (2-tailed)
.000
N
377
377
X10 -- Careful about What I Eat
Pearson Correlation
-.189**
1
Sig. (2-tailed)
.000
N
377
377
**. Correlation is significant at the 0.01 level (2-tailed).
*. Correlation is significant at the 0.05 level (2-tailed).
CORRELATIONS
/VARIABLES=x11 x12 x13 x14 x15 x16 x17 x18 x19 x20
/PRINT=TWOTAIL NOSIG
/MISSING=PAIRWISE.
Correlations
Correlations
X11 -- Try New Brands
X12 -- Friendly Employees
X13 -- Fun Place to Eat
X14 -- Large Size Portions
X11 -- Try New Brands
Pearson Correlation
1
.804**
-.048
.011
Sig. (2-tailed)
.000
.355
.836
N
377
377
377
377
X12 -- Friendly Employees
Pearson Correlation
.804**
1
-.130*
-.040
Sig. (2-tailed)
.000
.012
.435
N
377
377
377
377
X13 -- Fun Place to Eat
Pearson Correlation
-.048
-.130*
1
.395**
Sig. (2-tailed)
.355
.012
.000
N
377
377
377
377
X14 -- Large Size Portions
Pearson Correlation
.011
-.040
.395**
1
Sig. (2-tailed)
.836
.435
.000
N
377
377
377
377
X15 -- Fresh Food
Pearson Correlation
.101*
.392**
-.028
.112*
Sig. (2-tailed)
.049
.000
.585
.029
N
377
377
377
377
X16 -- Reasonable Prices
Pearson Correlation
-.027
-.049
.386**
.959**
Sig. (2-tailed)
.603
.347
.000
.000
N
377
377
377
377
X17 -- Attractive Interior
Pearson Correlation
-.044
-.109*
.675**
.287**
Sig. (2-tailed)
.392
.035
.000
.000
N
377
377
377
377
X18 -- Excellent Food Taste
Pearson Correlation
.147**
.382**
.036
.022
Sig. (2-tailed)
.004
.000
.480
.675
N
377
377
377
377
X19 -- Knowledgeable Employees
Pearson Correlation
.474**
.622**
.146**
.085
Sig. (2-tailed)
.000
.000
.005
.098
N
377
377
377
377
X20 -- Proper Food Temperature
Pearson Correlation
.055
.037
.083
.064
Sig. (2-tailed)
.287
.471
.106
.213
N
377
377
377
377
Correlations
X15 -- Fresh Food
X16 -- Reasonable Prices
X17 -- Attractive Interior
X18 -- Excellent Food Taste
X11 -- Try New Brands
Pearson Correlation
.101*
-.027
-.044
.147**
Sig. (2-tailed)
.049
.603
.392
.004
N
377
377
377
377
X12 -- Friendly Employees
Pearson Correlation
.392**
-.049
-.109*
.382**
Sig. (2-tailed)
.000
.347
.035
.000
N
377
377
377
377
X13 -- Fun Place to Eat
Pearson Correlation
-.028
.386**
.675**
.036
Sig. (2-tailed)
.585
.000
.000
.480
N
377
377
377
377
X14 -- Large Size Portions
Pearson Correlation
.112*
.959**
.287**
.022
Sig. (2-tailed)
.029
.000
.000
.675
N
377
377
377
377
X15 -- Fresh Food
Pearson Correlation
1
.135**
-.011
.784**
Sig. (2-tailed)
.009
.836
.000
N
377
377
377
377
X16 -- Reasonable Prices
Pearson Correlation
.135**
1
.265**
.089
Sig. (2-tailed)
.009
.000
.085
N
377
377
377
377
X17 -- Attractive Interior
Pearson Correlation
-.011
.265**
1
-.084
Sig. (2-tailed)
.836
.000
.102
N
377
377
377
377
X18 -- Excellent Food Taste
Pearson Correlation
.784**
.089
-.084
1
Sig. (2-tailed)
.000
.085
.102
N
377
377
377
377
X19 -- Knowledgeable Employees
Pearson Correlation
.409**
.120*
.107*
.391**
Sig. (2-tailed)
.000
.020
.038
.000
N
377
377
377
377
X20 -- Proper Food Temperature
Pearson Correlation
.489**
.095
.182**
.587**
Sig. (2-tailed)
.000
.064
.000
.000
N
377
377
377
377
Correlations
X19 -- Knowledgeable Employees
X20 -- Proper Food Temperature
X11 -- Try New Brands
Pearson Correlation
.474**
.055
Sig. (2-tailed)
.000
.287
N
377
377
X12 -- Friendly Employees
Pearson Correlation
.622**
.037
Sig. (2-tailed)
.000
.471
N
377
377
X13 -- Fun Place to Eat
Pearson Correlation
.146**
.083
Sig. (2-tailed)
.005
.106
N
377
377
X14 -- Large Size Portions
Pearson Correlation
.085
.064
Sig. (2-tailed)
.098
.213
N
377
377
X15 -- Fresh Food
Pearson Correlation
.409**
.489**
Sig. (2-tailed)
.000
.000
N
377
377
X16 -- Reasonable Prices
Pearson Correlation
.120*
.095
Sig. (2-tailed)
.020
.064
N
377
377
X17 -- Attractive Interior
Pearson Correlation
.107*
.182**
Sig. (2-tailed)
.038
.000
N
377
377
X18 -- Excellent Food Taste
Pearson Correlation
.391**
.587**
Sig. (2-tailed)
.000
.000
N
377
377
X19 -- Knowledgeable Employees
Pearson Correlation
1
.185**
Sig. (2-tailed)
.000
N
377
377
X20 -- Proper Food Temperature
Pearson Correlation
.185**
1
Sig. (2-tailed)
.000
N
377
377
**. Correlation is significant at the 0.01 level (2-tailed).
*. Correlation is significant at the 0.05 level (2-tailed).
CORRELATIONS
/VARIABLES=x16 x17 x18 x19 x20
/PRINT=TWOTAIL NOSIG
/MISSING=PAIRWISE.
Correlations
Correlations
X16 -- Reasonable Prices
X17 -- Attractive Interior
X18 -- Excellent Food Taste
X16 -- Reasonable Prices
Pearson Correlation
1
.265**
.089
Sig. (2-tailed)
.000
.085
N
377
377
377
X17 -- Attractive Interior
Pearson Correlation
.265**
1
-.084
Sig. (2-tailed)
.000
.102
N
377
377
377
X18 -- Excellent Food Taste
Pearson Correlation
.089
-.084
1
Sig. (2-tailed)
.085
.102
N
377
377
377
X19 -- Knowledgeable Employees
Pearson Correlation
.120*
.107*
.391**
Sig. (2-tailed)
.020
.038
.000
N
377
377
377
X20 -- Proper Food Temperature
Pearson Correlation
.095
.182**
.587**
Sig. (2-tailed)
.064
.000
.000
N
377
377
377
Correlations
X19 -- Knowledgeable Employees
X20 -- Proper Food Temperature
X16 -- Reasonable Prices
Pearson Correlation
.120*
.095
Sig. (2-tailed)
.020
.064
N
377
377
X17 -- Attractive Interior
Pearson Correlation
.107*
.182**
Sig. (2-tailed)
.038
.000
N
377
377
X18 -- Excellent Food Taste
Pearson Correlation
.391**
.587**
Sig. (2-tailed)
.000
.000
N
377
377
X19 -- Knowledgeable Employees
Pearson Correlation
1
.185**
Sig. (2-tailed)
.000
N
377
377
X20 -- Proper Food Temperature
Pearson Correlation
.185**
1
Sig. (2-tailed)
.000
N
377
377
**. Correlation is significant at the 0.01 level (2-tailed).
*. Correlation is significant at the 0.05 level (2-tailed).
REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT x22
/METHOD=ENTER x1 x2 x3 x4 x5 x6 x7 x8 x9 x10.
Regression
Variables Entered/Removed a
Model
Variables Entered
Variables Removed
Method
1
X10 -- Careful about What I Eat, X1 -- Try New and Different Things , X6 -- Friends Come to Me, X5 -- Likes to Go Out Socially, X7 -- Self-Confident, X9 -- Buy New Products, X4 -- Avoid Fried Foods, X2 -- Party Person, X3 -- People Come to Me, X8 -- Eat Balanced, Nutritious Mealsb
.
Enter
a. Dependent Variable: X22 -- Satisfaction
b. All requested variables entered.
Model Summary
Model
R
R Square
Adjusted R Square
Std. Error of the Estimate
1
.718a
.516
.503
.794
a. Predictors: (Constant), X10 -- Careful about What I Eat, X1 -- Try New and Different Things , X6 -- Friends Come to Me, X5 -- Likes to Go Out Socially, X7 -- Self-Confident, X9 -- Buy New Products, X4 -- Avoid Fried Foods, X2 -- Party Person, X3 -- People Come to Me, X8 -- Eat Balanced, Nutritious Meals
ANOVA a
Model
Sum of Squares
df
Mean Square
F
Sig.
1
Regression
245.943
10
24.594
39.051
.000b
Residual
230.508
366
.630
Total
476.451
376
a. Dependent Variable: X22 -- Satisfaction
b. Predictors: (Constant), X10 -- Careful about What I Eat, X1 -- Try New and Different Things , X6 -- Friends Come to Me, X5 -- Likes to Go Out Socially, X7 -- Self-Confident, X9 -- Buy New Products, X4 -- Avoid Fried Foods, X2 -- Party Person, X3 -- People Come to Me, X8 -- Eat Balanced, Nutritious Meals
Coefficients a
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
B
Std. Error
Beta
1
(Constant)
4.825
.406
11.873
.000
X1 -- Try New and Different Things
.209
.033
.344
6.301
.000
X2 -- Party Person
.060
.062
.055
.974
.331
X3 -- People Come to Me
.023
.059
.024
.385
.700
X4 -- Avoid Fried Foods
-.260
.056
-.302
-4.684
.000
X5 -- Likes to Go Out Socially
-.054
.053
-.054
-1.016
.310
X6 -- Friends Come to Me
.186
.059
.191
3.129
.002
X7 -- Self-Confident
-.033
.039
-.036
-.857
.392
X8 -- Eat Balanced, Nutritious Meals
.214
.065
.235
3.290
.001
X9 -- Buy New Products
.006
.038
.009
.172
.863
X10 -- Careful about What I Eat
-.461
.057
-.453
-8.116
.000
a. Dependent Variable: X22 -- Satisfaction
REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT x22
/METHOD=ENTER x11 x12 x13 x14 x15 x16 x17 x18 x19 x20.
Regression
Variables Entered/Removed a
Model
Variables Entered
Variables Removed
Method
1
X20 -- Proper Food Temperature, X12 -- Friendly Employees, X14 -- Large Size Portions, X17 -- Attractive Interior, X15 -- Fresh Food, X19 -- Knowledgeable Employees, X13 -- Fun Place to Eat, X11 -- Try New Brands, X18 -- Excellent Food Taste, X16 -- Reasonable Pricesb
.
Enter
a. Dependent Variable: X22 -- Satisfaction
b. All requested variables entered.
Model Summary
Model
R
R Square
Adjusted R Square
Std. Error of the Estimate
1
.769a
.591
.580
.730
a. Predictors: (Constant), X20 -- Proper Food Temperature, X12 -- Friendly Employees, X14 -- Large Size Portions, X17 -- Attractive Interior, X15 -- Fresh Food, X19 -- Knowledgeable Employees, X13 -- Fun Place to Eat, X11 -- Try New Brands, X18 -- Excellent Food Taste, X16 -- Reasonable Prices
ANOVA a
Model
Sum of Squares
df
Mean Square
F
Sig.
1
Regression
281.595
10
28.160
52.892
.000b
Residual
194.856
366
.532
Total
476.451
376
a. Dependent Variable: X22 -- Satisfaction
b. Predictors: (Constant), X20 -- Proper Food Temperature, X12 -- Friendly Employees, X14 -- Large Size Portions, X17 -- Attractive Interior, X15 -- Fresh Food, X19 -- Knowledgeable Employees, X13 -- Fun Place to Eat, X11 -- Try New Brands, X18 -- Excellent Food Taste, X16 -- Reasonable Prices
Coefficients a
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
B
Std. Error
Beta
1
(Constant)
-.871
.319
-2.728
.007
X11 -- Try New Brands
.093
.043
.144
2.171
.031
X12 -- Friendly Employees
.268
.074
.289
3.615
.000
X13 -- Fun Place to Eat
.322
.065
.256
4.959
.000
X14 -- Large Size Portions
.083
.111
.097
.749
.454
X15 -- Fresh Food
.445
.058
.469
7.619
.000
X16 -- Reasonable Prices
.050
.117
.055
.425
.671
X17 -- Attractive Interior
-.091
.055
-.082
-1.651
.099
X18 -- Excellent Food Taste
-.352
.070
-.340
-5.006
.000
X19 -- Knowledgeable Employees
-.012
.035
-.017
-.354
.724
X20 -- Proper Food Temperature
.423
.047
.441
9.099
.000
a. Dependent Variable: X22 -- Satisfaction
REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT x22
/METHOD=ENTER x16 x17 x18 x19 x20.
Regression
Variables Entered/Removed a
Model
Variables Entered
Variables Removed
Method
1
X20 -- Proper Food Temperature, X16 -- Reasonable Prices, X19 -- Knowledgeable Employees, X17 -- Attractive Interior, X18 -- Excellent Food Tasteb
.
Enter
a. Dependent Variable: X22 -- Satisfaction
b. All requested variables entered.
Model Summary
Model
R
R Square
Adjusted R Square
Std. Error of the Estimate
1
.639a
.408
.400
.872
a. Predictors: (Constant), X20 -- Proper Food Temperature, X16 -- Reasonable Prices, X19 -- Knowledgeable Employees, X17 -- Attractive Interior, X18 -- Excellent Food Taste
ANOVA a
Model
Sum of Squares
df
Mean Square
F
Sig.
1
Regression
194.360
5
38.872
51.123
.000b
Residual
282.091
371
.760
Total
476.451
376
a. Dependent Variable: X22 -- Satisfaction
b. Predictors: (Constant), X20 -- Proper Food Temperature, X16 -- Reasonable Prices, X19 -- Knowledgeable Employees, X17 -- Attractive Interior, X18 -- Excellent Food Taste
Coefficients a
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
B
Std. Error
Beta
1
(Constant)
.917
.329
2.785
.006
X16 -- Reasonable Prices
.171
.038
.187
4.480
.000
X17 -- Attractive Interior
.066
.049
.060
1.359
.175
X18 -- Excellent Food Taste
.102
.057
.099
1.786
.075
X19 -- Knowledgeable Employees
.206
.033
.280
6.328
.000
X20 -- Proper Food Temperature
.351
.050
.366
7.062
.000
a. Dependent Variable: X22 -- Satisfaction
