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

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 2: Tables and Charts
Background image of page 2
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
Background image of page 3

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

View Full DocumentRight Arrow Icon
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
Background image of page 4
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)
Background image of page 5

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

View Full DocumentRight Arrow Icon
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)
Background image of page 6
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
Background image of page 7

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

View Full DocumentRight Arrow Icon
Data, Single Variable
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.

Page1 / 29

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 Right Arrow Icon
Ask a homework question - tutors are online