Stat Activity #4
(Numerical Description) 80pts
NAME: CRYSTAL ANN M. TADIAMON, RN
MISAMIS UNIVERSITY
NR 202-SUMMER CLASS
1. Compute the following using the data on gpa, age, finc (financial income) in SAMPLE DATA 1(Excel File)
(Sheet4). Follow the steps below.
Age GPA-Grade Point Finc-family income
Average
1. Mean 17.34 2.39 19210
2. Median 17.00 2.23 15500
3. Mode 17 1.77 20000
4. Range 4.00 2.88 82500
5. Variance 0.60 0.42 249653980
6. Coefficient of variation 4.45 27.04 82.25
7. Standard Deviation 0.77 0.65 15800
8. First Quartile 17 1.90 10000
9. Third Quartile 18 2.83 20000
10. Kurtosis 1.58 0.08 9.13
11. Skewness 0.43 0.72 2.72
Total
Variable Count Mean StDev Variance CoefVar Q1 Median Q3 Range Mode
age 50 17.340 0.772 0.596 4.45 17.000 17.000 18.000 4.000 17
gpa 50 2.3946 0.6475 0.4192 27.04 1.8975 2.2300 2.8325 2.8800 1.77
finc 50 19210 15800 249653980 82.25 10000 15500 20000 82500 20000
N for
Variable Mode Skewness Kurtosis
age 23 0.43 1.58
gpa 3 0.72 0.08
finc 12 2.72 9.13
Steps:
Note: for items 8-11, write its meaning or interpretation.
AGE:
A score of 17 represents the first quartile and is the 25 th percentile.
A score of 18 represents the third quartile and is the 75 th percentile.
The kurtosis according to the graph shows it has a platykurtic kurtosis.
The skewness according to the result shows negative skewness.
GPA
A score of 1.8975 represents the first quartile and is the 25 th percentile.
A score of 2.8325 represents the third quartile and is the 75 th percentile.
The kurtosis according to the graph shows it has a mesokurtic kurtosis
The skewness according to the result shows negative skewness.
FINC
A score of 10000 represents the first quartile and is the 25 th percentile.
A score of 20000 represents the third quartile and is the 75 th percentile.
The kurtosis according to the graph shows it has a leptokurtic kurtosis
The skewness according to the result shows positive skewness.
2. Construct a graph of the ff:
1. Sex-bar graph 2. Place of origin (porg)-pie chart.
Sex of Respondents Place of Origin of the Respondents
40 Category
URBAN
RURAL
2
11, 22.0%
30
Count
20
10
1
39, 78.0%
0
Female Male
sex
Steps
3. Complete the following. Use the data on Sample Data 1 (Sheet4). Note: Same steps in no. 1)
Profile Mean StDev Min Max
Age (in years) 17.34 0.77 16 20
GPA 2.39 0.65 1.31 4.19
Profile of the Respondents
(n=50)
Profile Counts/ Frequency Percent
Sex
Male 38 76.00
Female 12 24.00
Place of origin
Urban 39 78.00
Rural 11 22.00
Residence
House 34 68.00
Profile Counts/ Frequency Percent
Boarding House 16 32.00
Father’s Occupation(faoc)
Employee 24 48.00
Retired 3 6.00
Business 8 16.00
OFW 14 28.00
Others 1 2
Mother’s Occupation (mooc)
Teacher 19 38.00
Employee 10 20.00
Housewife 16 32.00
Nurse 5 10.00
Tally for Discrete Variables: sex, porg, resd, faoc, mooc
sex Count Percent porg Count Percent resd Count Percent faoc Count Percent
1 38 76.00 1 39 78.00 1 34 68.00 1 24 48.00
2 12 24.00 2 11 22.00 2 16 32.00 2 3 6.00
N= 50 N= 50 N= 50 3 8 16.00
4 14 28.00
5 1 2.00
N= 50
mooc Count Percent
1 19 38.00
2 10 20.00
3 16 32.00
4 5 10.00
N= 50
code:
Steps: