BUS310_L2_1.13.11

# BUS310_L2_1.13.11 - Tables and Charts Lecture 2: Lecture 2:...

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

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

View Full Document
Lecture 2: Tables and Charts
Lecture 2: Outline 1. Questions on syllabus, Excel Add-Ins or PHStat2 2. Review Types of Data Categorical versus Numerical Some examples 1. New Material Chapter 2, Section 1: Tables and Charts for single categorical variable Summary table, Pie chart, Bar chart, Pareto chart Chapter 2, Section 2: Sort and filter data on Excel Chapter 2, Section 3: Time Series, Stem and Leaf display Lecture 2.Fall2010.doc, Chapter2.ppt, Annotated Excel Files

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

View Full Document
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 In the textbook, spend some time on Chapter 1, section 1.6, page 9
More examples Number of telephones in a household Numerical, discrete (outcome is a count) Length of the longest long-distance call made in a month Numerical, continuous (any value within a range of values can occur) Whether somebody in the household owns a telephone Categorical (yes or no answer) Whether there is a high-speed Internet connection Categorical (yes or no answer)

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

View Full Document
Amount of time surfing the Internet in a week Numerical, discrete (outcome is a count) Number of emails received in a week Numerical, continuous (any value within a range of values can occur) Number of online purchases made in a month Categorical Favorite department store Most likely time for shopping (weekday, weeknight) Monthly payments: \$1,427 Number of jobs in the past 10 years Annual Family Income: \$86,000 Numerical, discrete (outcome is a count) Categorical Numerical, continuous (any value within a range of values can occur) Numerical, discrete (outcome is a count)
Review the Nature of Different Variables CUSTOMER FEEDBACK.xls Complaint Staff Exper Type Volume Cvol RespTime 1 5 Yes E 114 5 97 2 8 Yes E 54 3 39 3 6 Yes F 36 2 54 4 9 Yes F 66 3 55 Time from customer complaint email to first contact (in minutes) Number of personnel scheduled for that day Whether the type of problem or complaint had been experienced before Complaint from email (E) or fax (F) Number of issues (complaints/ problems) received that day Coded volume level 1=<25, 2=26-50, 3=51-75, 4=76-100, 5=>100 Numerical Discrete Categorical Categorical Numerical Discrete Numerical Continuous But based on numerical data, then coded

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

View Full Document
Data, Single Variable
This is the end of the preview. Sign up to access the rest of the document.

## BUS310_L2_1.13.11 - Tables and Charts Lecture 2: Lecture 2:...

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

View Full Document
Ask a homework question - tutors are online