BUS310_L3_1.18.11 - Tables and Charts Lecture 3 Lecture 3...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Lecture 3: Tables and Charts
Background image of page 2
Lecture 3: Outline 1. Questions on Excel Add-Ins or PHStat2 2. Review Tables and charts for categorical data (Summary table, Pie Chart, Bar Chart, Pareto Chart) 1. New Material: Tables and Charts for Numerical Data Time Series (p.50-51), Stem and Leaf Display (histogram type chart with detail on the values) (p.33), Frequency distribution (p.35-38) Histograms (Column Bar Charts) (p.40-41) Polygons (Line Charts) (p.42-43) See Chapter 2 , Annotated Excel Files folder, HOMES.xls
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Problem Set 1 Thursday we will have a lab class in E102 Bring the following files on a Flash Drive (best), or email them, download them from Laulima in the lab: PS1.pptx ‘AUTOS Fall2010.xls’ ‘Hotelroom_complaints.xls’ ‘PS 1.pptx’, ‘AUTOS Fall2010.xls’, ‘Hotelroom_complaints.xls’
Background image of page 4
Review: Categorical and Numerical Variables Categorical (qualitative) Numerical (quantitative) Discrete Continuous Yes/No/Maybe Day of the week on which purchase was made No view/Some view/Good view Waiting time at a bank: 1 min., 1.1 min. Age of homes Time to get to school Have values that represent quantities Have values that can only be placed in categories Have numerical values that arise from a counting process (values only from a list of specific numbers) Have numerical values that arise from a measuring process (any value within a continuous range of possible values - number line) Number of magazines subscribed to: 0, 1, 2, 3 Chapter 1, section 1.6, page 9
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Data, Single Variable Control Charts Describe Numerical Categorical Time Series Plot Not Time Series or Stable Time Series 1. Frequency Table 2. Percent Table Summary Measures Central Tendency 1. Mean 2. Median 3. Mode Shape 1. 5 Number Summary 2. Skewness 3. Kurtosis 4. Outlier 5. Normal (bell shape) 6. Normal Probability Plot Variability___ 1. Range 2. IQR 3. Standard Deviation 4. Coefficient of Variation SummaryT ables 2. Frequency, Percent, Cumulative Percent Charts, Graphs, Plots 1. Frequency Histogram 2. Percentage Histogram 3. Frequency Polygon 4. Percentage Polygon 5. Cumulative % Polygon 6. Boxplot Numerical Collected over time Categorical Collected over time P-Chart 1. Data collected on whether an item is nonconforming or not (2 categories). 2. Sample of items is collected each time period for a number of time periods. A sample of numerical data each time period Mean and Range Chart 1. Bar Chart 2. Pie Chart 3. Pareto Chart Summary Tables Charts Look for trends or patterns over time Categorical Data
Background image of page 6
Review: Tables and Charts for Categorical Data A. Summary Table Summarizes data by categories (frequency, amount, or percentage of items) (easiest way: PHStat/Descriptive Statistics/One-Way Tables and Charts) or (Excel/Insert PivotTable/add percentage column with formula) Lecture 3.Fall2010.doc ‘CUSTOMER FEEDBACK.xls’ Sorted for Pareto Chart
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Review: Tables and Charts for Categorical Data
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/07/2011 for the course BUS 311 taught by Professor Reardon,j during the Spring '08 term at University of Hawaii, Manoa.

Page1 / 31

BUS310_L3_1.18.11 - Tables and Charts Lecture 3 Lecture 3...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online