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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

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