Good afternoon,

I'm taking a statistics class at university, one of our homeworks assignments _must_ be done in excel using the Data Analysis Plus plugin in Excel.

Having never used excel, the math is simple, but the charting is not. No matter what chart type I try, or the data I select the chart does not look right.

I've got two questions I have not been able to figure out how to accomplish in excel.
1. Use a graphical technique to depict the relationship between gender and education. Gender is in the spreadsheet as 1 for female, 2 for male, and education is 1: No high school, 2: HighSchool 3: College 4: University

2. The same thing but between salary and experience. Salary is $ figure, and experience is a number from 0 - 35 for years of experience.

Your excel columns are: (with 100 entries)
Salary Experience Gender Diploma
45000 5 1 3
34000 6 2 1
etc...


Anyone able to point me in the right direction?

Thanks!
Chris Ross