# 82610 - Analysis of Data by Groups Comparing groups Excel...

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

1 1 Main Ideas • Comparing groups • Excel pivot table for getting group counts, means, and totals • Bar charts Analysis of Data by Groups 2 1. Comparing groups – Often we want to compare groups according to some characteristic –How do professors’ salaries compare among universities in Kansas? –Are younger age groups more likely to own a cell phone than older age groups? –How does the quality of education compare among major cities in the U.S.? 3 2. How do we compare groups? • Typically we use averages, totals, and percents to compare groups – Compare high schools according to: Average test scores on a standardized exam. Percentage of graduates that go on to college Total number of football championships won 4 3. What is the right way to compare groups? – There is no one right way •One school might rank high in terms of the percentage of students that go to college. •Another might rank high in terms of percentage of

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

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

## This note was uploaded on 09/25/2010 for the course STAT 325 taught by Professor Butts during the Spring '10 term at Katholieke Universiteit Leuven.

### Page1 / 2

82610 - Analysis of Data by Groups Comparing groups Excel...

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

View Full Document
Ask a homework question - tutors are online