1!
MKT!352!Sanghak!Lee!
SPSS#Tutorial#(1)#-#Univariate#Analysis#Exercise#
[Q1]!Using!the!SPSS!data!file!for!AFC!survey!(“Avery!Fitness!Center!MR!(SPSS).sav”),!
conduct!a!“Frequency#Analysis”!for!“What!event!led!you!to!AFC?![event]”.!!Based!on!the!
result,!answer!the!following!questions.!
Statistics
What event led you to AFC?
N
Valid
224
Missing
7
Mode
3
What event led you to AFC?
Frequency
Percent
Valid Percent
Cumulative
Percent
Valid
general health / exercise
70
30.3
31.3
31.3
pool / facilities
28
12.1
12.5
43.8
rehab / specific medical
needs
95
41.1
42.4
86.2
social considerations
20
8.7
8.9
95.1
transfer from another center
8
3.5
3.6
98.7
other
3
1.3
1.3
100.0
Total
224
97.0
100.0
Missing
System
7
3.0
Total
231
100.0
(1) How!many!missing!data!do!we!have!for!this!variable?!7
(2) What!is!the!mode!(=most!frequently!observed!answer)!as!an!event!that!led!a!customer
to!AFC?!rehab!/!specific!medical!(42.4%)
(3) What!valid!percent!of!the!sample!chose!“pool/facilities”!as!the!event!that!led!them!to
AFC?!12.5%
2!
[Q2]!We!want!to!summarize!the!categorical!variable(s)!that!is(are)!based!on!the!question!
below.!
Find!the!appropriate!variable(s)!from!the!SPSS!data!file!for!AFC!survey!(“Avery!Fitness!
Center!MR!(SPSS).sav”),!and!conduct!“Frequency#Analyses”.!Rank!order!the!services!
from!the!most!utilized!one!to!the!least!utilized!one.!
Statistics
Utilized weight
training?
Utilized
classes?
Utilized exercise
circuit?
Utilized
circulation
station?
Utilized therapy
pool?
N
Valid
231
231
231
231
231
Missing
0
0
0
0
0
Mode
0
0
0
0
0
Utilized weight training?
Frequency
Percent
Valid Percent
Cumulative
Percent
Valid
no
157
68.0
68.0
68.0
yes
74
32.0
32.0
100.0
Total
231
100.0
100.0
Utilized classes?
Frequency
Percent
Valid Percent
Cumulative
Percent
Valid
no
170
73.6
73.6
73.6
yes
61
26.4
26.4
100.0
Total
231
100.0
100.0
Utilized exercise circuit?
Frequency
Percent
Valid Percent
Cumulative
Percent
Valid
no
180
77.9
77.9
77.9
yes
51
22.1
22.1
100.0
3!
Total
231
100.0
100.0
Utilized circulation station?
Frequency
Percent
Valid Percent
Cumulative
Percent
Valid
no
203
87.9
87.9
87.9
yes
28
12.1
12.1
100.0
Total
231
100.0
100.0
Utilized therapy pool?
Frequency
Percent
Valid Percent
Cumulative
Percent
Valid
no
127
55.0
55.0
55.0
yes
104
45.0
45.0
100.0
Total
231
100.0
100.0
Therapy!Pool(45.0%)!>!Weight!Training(32.0%)!>!Classes(26.4%)!>!Exercise!
Circuit(22.1%)!>!Circulation!Station(12.1%)!
4!
[Q3]#We!want!to!summarize!the!continuous!variable(s)!that!is(are)!based!on!the!question!
below.!
Find!the!appropriate!variable(s)!from!the!SPSS!data!file!for!AFC!survey!(“Avery!Fitness!
Center!MR!(SPSS).sav”),!and!produce!the!“Descriptive#Statistics”.!
Descriptive Statistics
N
Minimum
Maximum
Mean
Std. Deviation
Importance: General Health
and Fitness
229
1
5
4.74
.738
Importance: Social Aspects
203
1
5
3.15
1.270
Importance: Physical
Enjoyment
202
1
5
3.94
1.065
Importance: Specific
Medical Concerns
209
1
5
4.05
1.214
Valid N (listwise)
190
(1) On!average,!what!is!the!most!important!reason!for!participating!in!AFC!program?
General!Health!and!Fitness!(mean=4.74)
(2) On!average,!what!is!the!least!important!reason!for!participating!in!AFC!program?
Social!Aspects!(mean=3.15)
(3) Among!the!four!reasons!for!participating!in!AFC!programs,!which!one!do!people!hold
the!most!diverse!(or!scattered)!opinions!as!for!its!importance?!Social!Aspects!(sd=1.270)
5!
[Q4]!Conduct!a!“Chi-square#Goodness-of-Fit#test”!with!the!“normal!time!to!visit!AFC!
[daypart]”!variable!for!the!hypotheses!below.!
- H0:!! Morning,!afternoon,!and!evening!are!equally!preferred!as!a!normal!visit!time!to!the
fitness!center!by!AFC!members.!
- HA:!!Morning,!afternoon,!and!evening!are!NOT!equally!preferred!as!a!normal!visit!time
to!the!fitness!center!by!AFC!members.!
(1) With!alpha=0.05,!what!is!your!conclusion!about!the!hypothesis!testing?
normal time to visit AFC
Observed N
Expected N
Residual
morning
160
71.7
88.3
afternoon
45
71.7
-26.7
evening
10
71.7
-61.7
Total
215
Test Statistics
normal time to
visit AFC
Chi-Square
171.860a
df
2
Asymp. Sig.
.000
a. 0 cells (0.0%) have expected
frequencies less than 5. The
minimum expected cell
frequency is 71.7.
Since!the!p-value(=Asymp.!Sig.=.000)!is!smaller!than!the!alpha!(=.05),!we!reject!the!null!
hypothesis!(=H0).!Therefore,!with!95%!confidence!level,!we!conclude!that!morning,!
afternoon,!and!evening!are!NOT!equally!preferred!as!a!normal!visit!time!to!the!fitness!
center!by!AFC!members.!
Powered by TCPDF (www.tcpdf.org)
