Please use the attached SPSS outputs (2 cross tab tables--one has the row percen
ID: 3261265 • Letter: P
Question
Please use the attached SPSS outputs (2 cross tab tables--one has the row percentage and the other one has the column percentage--and 1 linear regression table), interpret the results of each table. Please include at least one reference.
Diabetes * Do you exercise regularly? Crosstabulation
Do you exercise regularly?
Total
Yes
No
Diabetes Yes Count
% within Diabetes
37
11.5%
284
88.5%
321
100%
No Count
% within Diabetes
125
92.6%
10
7.4%
135
100%
Total Count
% within Diabetes
162
35.5.5%
294
64.5%
456
100%
Diabetes * Do you exercise regularly? Crosstabulation
Do you exercise regularly?
Total
Yes
No
Diabetes Yes Count
% within Diabetes
37
22.8%
284
96.6%
321
70.4%
No Count
% within Diabetes
125
77.2%
10
3.4%
135
29.6%
Total Count
% within Diabetes
162
100%
294
100%
456
100%
Coefficientsa
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
B
Std. Error
Beta
1 (Constant)
BMI
Weight
Age
18.131
1.265
1.308
.164
6.346
.044
.050
.056
1.472
1.522
.251
2.857
5.965
6.163
2.953
.006
.000
.000
.005
Dependent Variable: The Amount of total Cholesterol
Do you exercise regularly?
Total
Yes
No
Diabetes Yes Count
% within Diabetes
37
11.5%
284
88.5%
321
100%
No Count
% within Diabetes
125
92.6%
10
7.4%
135
100%
Total Count
% within Diabetes
162
35.5.5%
294
64.5%
456
100%
Explanation / Answer
Sol:
Diabetes * Do you exercise regularly? Crosstabulation
Perform chi sq test
Null hypothesis:
H0:Dianbetes and exercise regularly are independeny
Alternative Hypothesis:
H1:diabetes and exercise regularly are dependent
ALPHA=0.05
The chi-square statistic is 272.6591. The p-value is . This result is significant at p < .05
Reject Null hypothesis
Accept Alternative Hypothesis
There is significant evidence at 5% level of sigmificance to conclude that
Exercise and diabetes are dependent
SOlution2:
regression equation i s
Dependent Variable: The Amount of total Cholesterol
: The Amount of total Cholesterol =18.131+1.265(BMI)+1.308(WEIGHT)+0.164(AGE)
as all varoable p values are <0.05
BMI,WEIGHT,AGE ARE SIGNIFCANT VARKABLES CAN BE INCLUDED IN REGRESSION
Y intercept=18.131
slope values are 1.265,1.308 and 0.164
O E 0-E (O-E)^2 (O-E)^2/E 37 114.04 -77.04 5935.162 52.0445598 284 206.96 77.04 5935.162 28.67781987 125 47.96 77.04 5935.162 123.7523269 10 87.04 -77.04 5935.162 68.18889706 CHISQ TEST STATISTIC 272.6636037