MTH 161 Introduction To Statistics Lecture 05 Dr

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 �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 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