11 - Table o Presents organized data without a graph...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
2/1/11 Frequency Histograms in Excel o Determine range (max-min) o Determine bin size o Insert number for bins- the number will be the bin-max o Highlight cells to the right of the bin column o =frequency(cell array, bin array) ctrl+shift+enter An array is a 1” X group member Column Chart o Insert “Column” Line Chart o Trends over time o Learning data Proportions correct over time Pie Chart o Qualitative Data Favorite type of ice cream
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Table o Presents organized data without a graph Scatter plots o Often used to show relationships between variables- or correlations o Positive 0-1 as scores for one variable become higher socres for the other variable also become higher More education more income o Negative 0 to -1 as scores for one variable become higher scores for another variable become lower More education less smoking...
View Full Document

Ask a homework question - tutors are online