Trình Công Tường – 31221026186

21.
Means:
Case Processing Summary

Cases

Included Excluded Total

N Percent N Percent N Percent

Avg_ACT * College 44 2,0% 2152 98,0% 2196 100,0%

Avg_SAT * College 44 2,0% 2152 98,0% 2196 100,0%
HS_GPA * College 44 2,0% 2152 98,0% 2196 100,0%
Top10 * College 44 2,0% 2152 98,0% 2196 100,0%
Top20 * College 44 2,0% 2152 98,0% 2196 100,0%
First_year_retention_rat 44 2,0% 2152 98,0% 2196 100,0%
e * College
Report

College First_year_ret
Avg_ACT Avg_SAT HS_GPA Top10 Top20 ention_rate

Architecture Mean 26,1625 1199,9440 3,6071 ,3655 ,6596 ,8891

N 4 4 4 4 4 4

Std. Deviation ,13769 8,35164 ,02664 ,02902 ,02512 ,02400

Business Mean 22,8190 1071,0375 3,2445 4,6939 ,2510 ,7426
N 4 4 4 4 4 4

Std. Deviation ,13742 6,60242 ,07003 5,26874 ,06081 ,06708

Education Mean 21,0700 991,9792 3,0959 2,6091 ,2295 ,7014
N 4 4 4 4 4 4
Std. Deviation ,37833 17,68421 ,11051 3,94113 ,05869 ,04083
Engineering Mean 26,4000 1200,5275 3,5546 ,3518 ,6067 ,8179
N 4 4 4 4 4 4
Std. Deviation ,16713 4,33188 ,03796 ,04705 ,03150 ,05215
Health Sciences Mean 21,4453 975,8924 3,2053 4,1903 ,3242 ,6824
N 4 4 4 4 4 4
Std. Deviation ,45506 16,81226 ,10456 4,63617 ,09350 ,10579
Liberal Arts Mean 21,9050 1044,1775 3,1535 ,1307 ,2682 ,6889

N 4 4 4 4 4 4
Std. Deviation ,08583 11,61830 ,05297 ,01634 ,04911 ,02193
Music Mean 24,3670 1145,0050 3,4133 ,2498 ,4663 ,8238
N 4 4 4 4 4 4
Std. Deviation ,79239 13,40474 ,09695 ,08199 ,08141 ,05606
North Central Branch Mean 19,0705 917,2598 2,6098 2,4200 3,8283 ,6347
Campus
N 4 4 4 4 4 4
Std. Deviation ,10489 10,97775 ,05323 ,71866 4,38628 ,02621
Nursing Mean 22,0798 1014,7258 3,3390 ,1843 ,3438 ,7561
N 4 4 4 4 4 4
Std. Deviation ,46486 9,67203 ,05119 ,02954 ,08596 ,03353
South Central Branch Mean 19,3863 928,7775 2,7121 4,3600 ,1411 ,6304
Campus
N 4 4 4 4 4 4
Std. Deviation ,26856 26,22737 ,02108 1,31987 ,00808 ,02986
Vocational Technology Mean 20,5374 994,3738 2,7817 4,5139 1,4093 ,6852
N 4 4 4 4 4 4
Std. Deviation 1,03243 38,88677 ,17222 3,04377 2,50714 ,03103
Total Mean 22,2948 1043,9727 3,1561 2,1881 ,7753 ,7321

N 44 44 44 44 44 44

Std. Deviation 2,41231 97,57455 ,32990 2,99743 1,68858 ,09118

Conclusion:
The analysis shows clear differences among colleges in terms of high school performance and
first-year retention. Colleges with stronger student profiles, such as Architecture (HS GPA 3.61;
ACT 26.16) and Engineering (HS GPA 3.55; ACT 26.40), achieved high retention rates (88.9%
and 81.8%). In contrast, North Central Branch (HS GPA 2.61; retention 63.5%) and South
Central Branch (HS GPA 2.71; retention 63.0%) reported the lowest academic input and
retention. Interestingly, Music maintained a relatively high retention rate (82.4%) despite not
having the highest admission scores. Across the university system, the average retention rate was
73.2%. These findings suggest that while student quality is positively associated with retention,
the learning environment also plays an important role.
22.
a.
Signal_strength

Carrier Mean N Std. Deviation

AT&T 3,4615 26 1,02882

Other 2,6667 9 1,22474
Sprint 2,8000 5 ,44721
T-mobile 3,0000 2 ,00000
Verizon 3,8000 10 ,63246
Total 3,3077 52 1,00075

Verizon has the highest average signal strength (3.8000), while "Other" carriers have the lowest
(2.6667). AT&T and T-mobile fall in the middle range, suggesting Verizon may offer better
signal reliability.
b.
Value_for_the_Dollar * Carrier
Value_for_the_Dollar

Carrier Mean N Std. Deviation

AT&T 3,2308 26 ,95111

Other 3,0000 9 ,50000
Sprint 4,8000 5 ,44721
T-mobile 4,0000 2 ,00000
Verizon 3,5000 10 ,97183
Total 3,4231 52 ,95684

Value_for_the_Dollar * Usage
Value_for_the_Dollar

Usage Mean N Std. Deviation

Average 3,3913 23 ,89133

High 4,0000 2 ,00000
Low 3,2000 5 ,83666
Very high 3,4545 22 1,10096
Total 3,4231 52 ,95684

Sprint and T-mobile show the highest average value for the dollar (4.8000 and 4.0000,
respectively), indicating better perceived cost-effectiveness. Usage level impacts perception,
with "High" usage users rating value higher (4.0000) compared to "Low" usage users (3.2000).
c.
Customer_Service * Carrier
Customer_Service

Carrier Mean N Std. Deviation Variance

AT&T 3,1154 26 ,99305 ,986

Other 3,4444 9 ,88192 ,778
Sprint 3,8000 5 ,44721 ,200
T-mobile 3,5000 2 ,70711 ,500
Verizon 3,0000 10 1,15470 1,333
Total 3,2308 52 ,96234 ,926

Customer_Service * Gender
Customer_Service

Gender Mean N Std. Deviation Variance

F 2,9444 18 ,87260 ,761

dimension1 M 3,3824 34 ,98518 ,971

Total 3,2308 52 ,96234 ,926

The variance in customer service perception is relatively low across carriers and genders, with
Sprint showing the least variability (0.200) and Verizon the most (1.333). Males (M) exhibit
slightly higher variance (0.971) in customer service perception compared to females (F) at 0.761,
suggesting more consistent opinions among females.
Overall Conclusion:
Verizon delivers the strongest signal strength, while Sprint and T-Mobile provide the best value
for the dollar. Sprint also leads in customer service satisfaction with consistent ratings. Usage
level influences value perception, with heavy users rating value higher. Males generally rate
customer service slightly better than females.
23.
a.
Report
Length_of_Service_years

Gender Mean N Std. Deviation

Female 2,0132 37 1,27559

Male 1,7608 33 ,85743
Total 1,8942 70 1,09818

On average, female employees (2.01 years) stay slightly longer than male employees (1.76
years). The higher standard deviation for females indicates greater variability in their length of
service compared to males.
b.
Report
Length_of_Service_years

College_Degree Mean N Std. Deviation

No 2,0643 48 1,24038
dimensio
Yes 1,5232 22 ,55573
n1
Total 1,8942 70 1,09818

Employees without a college degree tend to stay longer (2.06 years) compared to those with a
degree (1.52 years).
c. Average Length of Service by Gender and Prior Call Center Experience

By Prior Call Center Experience:

Prior_Call_Center
_Experience Mean N Std. Deviation

No 1,9867 43 1,20394

dimension1 Yes 1,7468 27 ,90684

Total 1,8942 70 1,09818

By Gender:

Gender Mean N Std. Deviation

Female 2,0132 37 1,27559

Male 1,7608 33 ,85743
Total 1,8942 70 1,09818

Employees without prior call center experience stay slightly longer (1.99 years) than those with
prior experience (1.75 years).
By gender, females still tend to have a longer length of service than males.
Overall Conclusion:
- Females generally stay longer in the company compared to males.
- Employees without a college degree or without prior call center experience tend to have
longer tenure.
- The higher variability in the female group and the no-degree group suggests a wider
range of length of service within these groups.