G-SPACE Columban College EDD 103: Advanced Statistics Worksheets

This document presents a comprehensive set of solutions to statistics worksheets, likely for a graduate-level course (EDD 103) at Columban College's G-SPACE program. The worksheets cover a wide range of statistical concepts, including definitions of key terms like descriptive and inferential statistics, nominal and ordinal variables, and the application of statistics in research. Solutions are provided for various exercises involving variable classification, frequency distributions, cumulative frequency, grouped frequency distributions, and the creation of different types of graphs (bar, line, and pie charts). The document also includes calculations for measures of central tendency (mean, median, mode) and measures of dispersion (variance, standard deviation) using both raw and grouped data. Furthermore, it addresses sampling methods, including sampling frames and stratified sampling, which provides a detailed guide to understanding the concepts and applications of statistics in a research context. The student has provided detailed answers to all the worksheets.

GRADUATE SCHOOL FOR PROFESSIONAL
ADVANCEMENT
AND CONTINUING EDUCATION (G-SPACE)
Columban College, Inc.
Olongapo City
EDD 103
ADVANCED STATISTICS FOR RESEARCH
WITH COMPUTER APPLICATION
Submitted by:
EDISON PARBO SAMBILI, MAED
Submitted to:
RAFAEL D. MORA, Ed.D
Professor
September 2022

GRADUATE SCHOOL FOR PROFESSIONAL
ADVANCEMENT
AND CONTINUING EDUCATION (G-SPACE)
Columban College, Inc.
Olongapo City
Worksheet 1
1. Define the following terms:
1.1 Statistics - Statistics is the discipline that concerns the collection, organization,
analysis, interpretation, and presentation of data. In applying statistics to a scientific,
industrial, or social problem, it is conventional to begin with a statistical population or
a statistical model to be studied.
1.2 Descriptive Statistics - Descriptive statistics are used to describe the basic features of
the data in a study. They provide simple summaries about the sample and the measures.
Together with simple graphics analysis, they form the basis of virtually every quantitative
analysis of data.
1.3 Prediction - a thing predicted; a forecast.
1.4 Nominal Variable - A nominal variable is another name for a categorical
variable. Nominal variables have two or more categories without having any kind of
natural order.
1.5 Ordinal Variable - Ordinal variable is a type of measurement variable that takes
values with an order or rank. It is the 2nd level of measurement and is an extension of the
nominal variable.
1.6 Interval Variable - The interval variable is a measurement variable that is used to
define values measured along a scale, with each point placed at an equal distance from
one another. It is one of the 2 types of numerical variables and is an extension of the
ordinal variable.
1.7 Ratio Scale - The ratio variable is one of the 2 types of continuous variables, where
the interval variable is the 2nd. It is an extension of the interval variable and is also the
peak of the measurement variable types.
1.8 Inferential Statistics - Inferential statistics is one of the two main branches
of statistics. Inferential statistics use a random sample of data taken from a population to
describe and make inferences about the population.
1.9 Dependent Variable - is the effect. Its value depends on changes in the independent
variable.
1.10 Independent Variable - is the cause. Its value is independent of other variables in
your study.
2. Statistical knowledge helps you use the proper methods to collect the data, employ the correct
analyses, and effectively present the results. Statistics is a crucial process behind how we make
discoveries in science, make decisions based on data, and make predictions.
3. Independent variable: The type of light the tomato plant is grown under
Dependent Variable: The rate of growth of the tomato plant
4. Examples:
4.1 Tomatoes grow fastest under fluorescent, incandescent, or natural light
4.2 The effect of diet and regular soda on blood sugar levels
4.3 Phone use before bedtime affect sleep
4.4 Different plant species tolerate salt water
5. Independent and dependent variables:
Independent: The type of light the tomato plant is grown under

GRADUATE SCHOOL FOR PROFESSIONAL
ADVANCEMENT
AND CONTINUING EDUCATION (G-SPACE)
Columban College, Inc.
Olongapo CityDependent: The rate of growth of the tomato plant
Independent: The type of soda you drink (diet or regular)
Dependent: Your blood sugar levels
Independent: The amount of phone use before bed
Dependent: Number of hours of sleep and quality of sleep
Independent: The amount of salt added to the plants’ water
Dependent: Plant growth, Plant wilting, Plant survival rate
Worksheet 2
Variables Classification
1. Gender: Male or Female Nominal
2. Skin color Nominal
3. Room temperature Interval
4. Your height in cm Ratio
5. Population of mango tree Interval
6. Social class Ordinal
7. Your blood type Nominal
8. Number of student in this room Ratio
9. Enrollees from elementary to college Interval
10. Level of aggressiveness Ordinal
11. Salary grade Ordinal
12. Academic ranks Ordinal
13. Marital status Nominal
14. Academic performance Ordinal
15. Political affiliation Nominal
16. Attitude toward nuclear plant Ordinal
17. Family size Ordinal
18. Courses offered in college Nominal
19. Perception of leadership style Ordinal
20. Weight of the baby Interval
21. Business classification Nominal
22. Community of crow Ratio
23. Your phone number Ordinal
24. Residents in Olongapo city Ratio
25. Volume of water Ratio

GRADUATE SCHOOL FOR PROFESSIONAL
ADVANCEMENT
AND CONTINUING EDUCATION (G-SPACE)
Columban College, Inc.
Olongapo CityWorksheet 3
Variables Classification
1. The height of a plant between 1995 and 1996 Quantitative Continuous
2. The color of your professor’s shoes Qualitative Discrete
3. Volume of Water Quantitative Discrete
4. Your Height (in centimeters) Quantitative Continuous
5. The marks of a class of students in a course Qualitative Discrete
6. Social Class Qualitative Discrete
7. Your Blood Type Qualitative Discrete
8. The shoe sizes of that child between 5 and 10 Quantitative Continuous
9. Community of Carabao Quantitative Discrete
10. Weight of the Baby Quantitative Discrete
11.Salary Grade Quantitative Continuous
12.Academic Ranks Quantitative Discrete
13.Marital Status Qualitative Discrete
14.Academic Performance Quantitative Continuous
15.Political Affiliation Qualitative Discrete
16.Attitude Toward Nuclear Plant Qualitative Discrete
17. Residents in Olongapo City Quantitative Continuous
18.Courses Offered in the College Qualitative Discrete
19.Perception of Leadership Style Qualitative Discrete
20. Level of Aggressiveness Qualitative Discrete
21.The scent of the flowers of that plant Qualitative Discrete
22. Enrollees from Elementary to College Quantitative Continuous
23.Your phone number Quantitative Discrete
24. Family Size Qualitative Discrete
25. Temperature of the Room Quantitative Continuous
Worksheet 4
1. Frequency Distribution (Gender and Age)
Major Gender Tally Frequency
BSED Male II 2
BSED Female II 2
BSBA Female IIII 4
AB Male III 3
AB Female IIII 4
BSN Male II 2
EDUC Female I 1
ECE Male I 1
ECE Female I 1

GRADUATE SCHOOL FOR PROFESSIONAL
ADVANCEMENT
AND CONTINUING EDUCATION (G-SPACE)
Columban College, Inc.
Olongapo City2. Cumulative Frequency (Number of Siblings)
No. of Siblings Tally Frequency CF
6 III 3 20
5 III 3 17
4 II 2 14
3 IIIII-II 7 12
2 II 2 5
1 III 3 3
3. Grouped Frequency Distribution (Distance to School)
Distance to School Tally Interval Midpoint Frequency
27-30 I 28 1
24-26 25 0
21-23 22 0
18-20 I 19 1
15-17 I 16 1
12-14 I 13 1
9-11 IIIII-II 10 7
6-8 IIII 7 4
3-5 IIIII 4 5
Worksheet 5
Class Interval Tally Interval
Midpoint
Frequency CF
69-78 I 73 1 50
61-68 IIIII 64 5 49
52-60 IIIII-III 55 8 44
43-51 IIIII-IIIII-II 47 12 36
34-42 IIIII-IIIII-II 38 12 24
25-33 IIIII-IIIII-II 29 12 12

GRADUATE SCHOOL FOR PROFESSIONAL
ADVANCEMENT
AND CONTINUING EDUCATION (G-SPACE)
Columban College, Inc.
Olongapo CityWorksheet 6
BAR GRAPH
1. Gender
MALE FEMALE
0
2
4
6
8
10
12
14
2. Major
BSED BSBA AB BSN EDUC ECE
0
1
2
3
4
5
6
7
8
1-10 KM 11-20 KM 21-30 KM
0
2
4
6
8
10
12
14
16
4. Number of Siblings in the family
1 2 3 4 5 6
0
1
2
3
4
5
6
7
8
Siblings

GRADUATE SCHOOL FOR PROFESSIONAL
ADVANCEMENT
AND CONTINUING EDUCATION (G-SPACE)
Columban College, Inc.
Olongapo City
Worksheet 6
LINE GRAPH
1. Gender
MALE FEMALE
0
2
4
6
8
10
12
14
2. Major
BSED BSBA AB BSN EDUC ECE
0
1
2
3
4
5
6
7
8
1-10 KM 11-20 KM 21-30 KM
0
2
4
6
8
10
12
14
16
4. Number of Siblings in the family
1 2 3 4 5 6
0
1
2
3
4
5
6
7
8

GRADUATE SCHOOL FOR PROFESSIONAL
ADVANCEMENT
AND CONTINUING EDUCATION (G-SPACE)
Columban College, Inc.
Olongapo CityWorksheet 6
PIE CHART
1. Gender
MALE FEMALE
2. Major
BSED BSBA AB BSN EDUC ECE
3. Distance
1-10 kM 11-20 KM 21-30 KM
4. Number of Siblings in the family
1 2 3 4 5 6

GRADUATE SCHOOL FOR PROFESSIONAL
ADVANCEMENT
AND CONTINUING EDUCATION (G-SPACE)
Columban College, Inc.
Olongapo City

GRADUATE SCHOOL FOR PROFESSIONAL
ADVANCEMENT
AND CONTINUING EDUCATION (G-SPACE)
Columban College, Inc.
Olongapo City
Worksheet 7
Data Set – Scores of 20 BSBA Students
80 40 76 59 71
76 59 78 81 39
46 72 66 40 72
69 50 46 52 33
Mean = 60.25
Median = 62.5
Mode = 76, 72, 59, 46, and 40
Worksheet 8
13, 11, 17, 14, 20, 6, 15, 12, 6, 13, 24, 22, 19
Mean = 14.77
Median = 14
Mode = 13
Worksheet 9
SES of 25 Junior Students Tally Frequency
6 I 1
5 II 2
4 IIII 4
3 IIIII-I 6
2 IIIII-I 6
1 IIIII-I 6
Mean = 3.08
Median = 3.5
Mode = 3, 2, and 1

GRADUATE SCHOOL FOR PROFESSIONAL
ADVANCEMENT
AND CONTINUING EDUCATION (G-SPACE)
Columban College, Inc.
Olongapo City
Worksheet 10
STATEMENTS Choices WX DR
5 4 3 2 1
1. I tolerate criticisms. 79 62 54 50 45 3.27 Sometimes
2. I like to create and suggest. 83 58 51 45 53 3.25 Sometimes
3. I like to use instructional materials. 79 69 68 29 45 3.37 Sometimes
4. I cooperate with my teachers in doing. 92 64 53 46 35 3.45 Sometimes
5. I study and perform assignments in
Science
76 52 59 41 62 3.13 Sometimes
Worksheet 11
Worksheet for Calculating the Variance for 10 Scores
X X-u (X – u)2
P 6500 -316 99,856
P 7445 629 395,641
P 5445 -1371 1,879,641
P 8330 1514 2,292,196
P 9029 2213 4,897,369
P 6944 128 16,384
P 7056 240 57,600
P 4899 -1917 3,674,889
P 6923 107 11,449
P 5589 -1227 1,505,529
14,830,554
Mean = 6,816
6,816
10
26.10
Worksheet 12
=
Variance by Raw Method
X X2
9 81
7 49
4 16
8 64
6 36
3 9
5 25
4 16
7 49
5 25
58 370

GRADUATE SCHOOL FOR PROFESSIONAL
ADVANCEMENT
AND CONTINUING EDUCATION (G-SPACE)
Columban College, Inc.
Olongapo City
370 –
(58)2
7
7
= 3.35
=