Chapter 1 Data Analysis
Chapter 1 Data Analysis
Chapter 1 Data Analysis
Objectives:
1.
2.
Define and explain statistical terms
Differentiate the different divisions of statistics
3. Identify the scale of measurement of variables
4. Differentiate data sets
5. Present data in three different way
C
H
A OBJECTIVES:
P 1. Define and explain statistical terms
2. Differentiate the different divisionsof statistics
T 3. Identify the scale of measurement of variables
4. Differentiate data sets
E 5. Present data in different ways
6. Learn how to plot/graph data using MS-Excel
R
Jimczyville Publication
1
INTRODUCTION
Two different meanings carry in the word statistics. It is the plural
form of the word statistic which means measure of sample. As such, data
themselves are synonymous with statistics. Statistics refers to the science
that deals with the systematic method of collecting, classifying,
presenting, analyzing and interpreting qualitative and numerical data.
DIVISION OF STATISTICS
1. Descriptive Statistics.
2. Inferential Statistics
Jimczyville Publication
2
Theory of
Probability
STATISTICS
tH
Theory of
DESCRIPTIVE STATISTICS Probability INFERENTIAL STATISTICS
Jimczyville Publication
3
POPULATION AS DIFFERENTIATED FROM SAMPLE
The word population refers to the total collection of actual or potential realizations of the
unit of observations in the research study. This means that there are population of students,
teachers, principals, animals, birds, insects and many others.
The sample is the specific, finite, realized which represent their characteristics or traits.
These members constitute a subset of a population. These measures of the population are called
parameters, while those of the sample are called estimates or statistic.
VARIABLE
The variable is the construct that a researcher is attempting to measure. The term
variable refers to a characteristic of the subject or individuals. For example, course preference is a
variable that can take on values such as education, criminology, nursing, computer and others.
Another example of variables includes gender, age, intelligence, attitude, faculty ranks and so on.
Variables are classified into qualitative and quantitative variable. A qualitative variable
(also called categorical)has values that are described by words rather than numbers. Clearly,
qualitative variables generally have either nominal or ordinal scales. For example: gender, disease
status, occupation, gender, race and others.
Quantitative or numerical variable is a data which arise from counting, measuring
something or from some kind of mathematical operation. These are variable values that are
intrinsically numeric. Number of children in a family, and age are good examples of quantitative
variable.
1. Continuous variables. These are variables whose levels can take continuous
values.
Example. The height of an individual, which can be 5’6’’, 5.5 ft or 5.5341 ft,
depending on accuracy of measurement, is a continuous variable.
1. Nominal Scale. Data classified into various distinct categories in which ordering of label
or assign numbers to things is not implied. It also has two core characteristics: a) they
consist of two or more categories and b) do not have an intrinsic order.
Dichotomous variables are nominal variables that have just two categories. They have a
number of characteristics:
Jimczyville Publication
4
b. Dichotomous variables can either be fixed or designed: Example, sex variable
can only be dichotomous (male or female) therefore they are fixed. In other
cases, dichotomous variables are designed by the researcher. For example, take
the question: Do you like playing basketball? We have determined that the
respondent can only select Yes or No. However, another researcher could
provide the respondent with more than two categories to this question
(e.g. most of the time, sometimes, hardly ever). Where more than two
categories are used, these variables become known as nominal variables rather
than dichotomous ones.
2. Ordinal Scale. Data classified into distinct categories in which ordering of label or
assigning numbers to things is implied.
3. Interval Scale. Ordered scales in which the difference between measurements provides
a meaningful quantity or intervals between scale points. No absolute zero or absence of a
meaningful zero is a key characteristic of interval data.
4. Ratio Scale. Ordered scales in which the difference between the measurements involves
absolute zero which means it possesses a meaningful zero that represents the absence of
the quantity being measured.
COLLECTION OF DATA
In order to ensure the accuracy of data, one must know the right sources of data and
methods of collecting them.
TYPES OF DATA
Advantages of primary source of data: The information you get from a primary
source is more accurate and more likely to be correct.
Jimczyville Publication
5
the help of secondary data, we are able to make out what are the gaps and
deficiencies and what additional information needs to be collected.
PRESENTATION OF DATA
Jimczyville Publication
6
Figure 2: Histogram
Figure 4: Ogive
Jimczyville Publication
7
3. Line Chart. A line chart is used to display time series, to spot trends, or to
compare periods. Line charts can be used to display several variables at once.
4. Pie Chart. A pie chart is a circular graph that shows the relative contribution
that different categories contribute to an overall total. A wedge of the circle
represents each category’s contribution, such that the graph resembles a pie that
has been cut into different sized slices.
Jimczyville Publication
8
Figure 7: Scatter Plot
1. Open a new blank MS-excel workbook then select Insert in the tabs. This selection
will provide the tools in creating different types of presenting data graphically. The
Column, Line, Pie, Bar, Area, Scatter and other charts.
Jimczyville Publication
9
3. Encode the given in the blank MS- Excel workbook.
4. Select and highlight the encoded data then click the Insert tab above the data
window. Then select Column.
5. Select Clustered Column below 2- D column. The resulting graph will be shown.
6. Format the graph using Chart Tools that will appear above the Layout Tab when the
resulting graph was selected or highlighted.
Jimczyville Publication
10
7. Click the Chart Tools and the Design Tab will be the default selection. Click the drop-
down menu of the chart layouts then select Layout 8.
Jimczyville Publication
11
9. To visualize clearly the columns of the graph, format it further using the chart tools.
10. Click the drop-down button under the chart styles. Select style 26.
Jimczyville Publication
12
12. To insert the grades of the students in the graph, click the x-axis where the number
1, 2, 3 …7 were located. Right click the mouse and the dialogue box will appear.
Click Select Data.
13. Another dialogue box will appear. Select 1 on the right side then click edit.
14. A dialogue box for Axis Label Range will appear. Type now the grades of the
students here. = {70, 75, and 80,100}. Then press OK.
Jimczyville Publication
13
15. The resulting graph will be shown below.
16. To edit the Axis titles, click the boxes and replace the text with Grades of Students in
the x-axis and Frequency in the y-axis.
17. Finally, the graph of the given data now will be shown below.
Histogram
800
600
Frequency
400
200
0
70 75 80 85 90 95 100
Grades of Students
18. To use the other types of graphs, just explore the other types of charts, and then the
formatting will be just the same as what we did above.
Jimczyville Publication
14
EXERCISES for Chapter 1
2. Identify the following as nominal level, ordinal level, interval level, or ratio level data.
b. Faculty scores provide the basis for determining if faculty should undergo
seminars on motivations in teaching or not.
Jimczyville Publication
16
4. Classify the data described in the following scenarios as qualitative or quantitative.
a. The students in a school are classified into one of six categories in classroom
performance as follows: excellent, very good, good, satisfactory, passed and
failed.
c. The fasting blood sugar readings are determined for several individuals in a
study involving diabetics.
5. Using the table below which shows a frequency distribution of test scores in entrance
examination of 500 students in Mathematics construct a histogram and frequency
polygon for these data.
Scores in Entrance
Number
Examination
30-39 24
40-49 46
50-59 58
60-69 76
70-79 68
80-89 82
90-99 48
100-109 32
110-119 66
Jimczyville Publication
17
6. Construct a bar graph on social classes of nursing students of Gordon College using
the given data below.
Very Low 27
Low 45
Below Average 52
Above Average 35
High 26
Very High 17
8. Construct a frequency polygon and histogram using the following salaries of a group
of clerks.
Salary Frequency
9,000-9,999 24
10,000-10,999 26
11,000-11,999 30
12,000-12,999 36
13,000-13,999 38
14,000-14,999 50
15,000-15,999 5
16,000-16,999 10
17,000-17,999 15
Jimczyville Publication
18