Transcript Lecture 05 Introduction to MS-Excel.pptx

MTH 161: Introduction To Statistics
Lecture 05
Dr. MUMTAZ AHMED
Review of Previous Lecture
Graphical Methods of Data Presentations
 Graphs for quantitative data
 Histograms
 Frequency Polygon
 Cumulative Frequency Polygon (Frequency Ogive)
 Frequency Distributions in Practice


Symmetric Distributions
Asymmetric Distributions
 Identifying distribution by a smooth curve
2
Objectives
In this lecture, we will study:
 Introduction to MS-Excel
 Constructing Frequency Tables in MS-Excel
 Constructing Graphs using MS Excel
 Bar Chart
 Simple Bar Chart
 Multiple Bar Chart
 Component Bar Chart
 Pie Chart
 Histogram
3
Objectives
In this lecture, we will study:
 Use of Excel Add-ins
 Activating Excel Add-ins
 Using Data Analysis Excel Add-in
4
Introduction to MS-Excel
 Introduction to MS-Excel
 Basic Overview of MS-Excel
 Basic Arithmetic operations
 Entering a sequence of numbers using Auto List
 Copying and Moving Lists
 Using Cell References (Absolute and relative Cell References)
 Built-in Excel Functions
 Sum, Min, Max functions
5
Introduction to MS-Excel
 Constructing Frequency Tables in MS-Excel
 Frequency Distribution for Quantitative Data
 Discrete Frequency Distribution
 Continuous or Grouped Frequency Distribution
 Frequency Distribution for Qualitative Data
 Creating Charts in MS-Excel
 Bar Chart
 Simple Bar Chart
 Multiple Bar Chart
 Component Bar Chart
 Pie Chart
 Histogram
6
Discrete Frequency Distribution
Example: Number of children in 20 families.
2 3 1 3 2 5 4 1 4 2 3 5 2 5 2 13 1 2 0
Construct un-grouped or discrete frequency distribution.
Interpretation: There is
1 family with no children.
4 families with 1 children
6 families with 2 children
4 families with 3 children
2 families with 4 children and
3 families with 1 children.
7
No of
Children
Tally
No of Families
(f)
0
|
1
1
||||
4
2
|||||
6
3
||||
4
4
||
2
5
|||
3
Total
20
Grouped Frequency Distribution
Example (Temperature Data):
Temperature of 20 winter days in Pakistan is recorded below:
24, 35, 17, 21, 24, 37, 26, 46, 58, 30, 32, 13, 12, 38, 41, 43, 44,
27, 53, 27
Construct frequency distribution.
8
Review
Let’s review the main concepts:
 Introduction To MS-Excel
 Constructing Frequency Tables in MS-Excel
9
Next Lecture
In next lecture, we will study:
 Constructing Graphs using MS Excel
 Bar Chart
 Simple Bar Chart
 Multiple Bar Chart
 Component Bar Chart
 Pie Chart
 Histogram
 Use of Excel Add-ins
 Activating Excel Add-ins
 Using Data Analysis Excel Add-in
10