excel project

# excel project - mens highest political preferences being...

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

Excel Project 1 September 28 2010 Andrew Sims , MATH 1107 Section 20 Categorical and Quantitative Data

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

View Full Document
Introduction This data was gathered through a survey of 31 students in a statistics class. These are all male and female students with ages ranging from 17 to 59 with five different varying majors. The data provided includes eleven quantitative variables and twelve categorical variables. Contingency Table Political Female Male Grand Total Conservative 7 1 8 Don't Know 5 3 8 Liberal 3 1 4 Libertarian 2 1 3 Moderate 5 2 7 Grand Total 22 8 30 Political Female male G r a n d T o t a l Consevative 23.33% 3.33% 2 6 . 6 7 % Don't Know 16.67% 10.00% 2 6 . 6 7 % Liberal 10.00% 3.33% 1 3 . 3 3 % Libertarian 6.67% 3.33% 1 0 . 0 0

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

View Full Document
% Moderate 16.67% 6.67% 2 3 . 3 3 % Grand Total 73.33% 26.67% 1 0 0 . 0 0 % Bar Chart The data above is a representation that women tend to have a conservative mindset as opposed to the
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: mens highest political preferences being that they just Dont Know. Contingency Table Work Female Male Grand Total Full time 2 1 3 not at all 7 4 11 part time 13 3 16 Grand Total 22 8 30 The data above would lead us to believe that women spend most of their time at work whether its part or full-time as opposed to the men spending 50% of their time not working at all. The data both show the two genders have one thing in common, being that when they do work, its usually part-time....
View Full Document

## This note was uploaded on 06/28/2011 for the course MATH 1107 taught by Professor Staff during the Spring '08 term at Fort Valley State University .

### Page1 / 5

excel project - mens highest political preferences being...

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

View Full Document
Ask a homework question - tutors are online