Data+Project+Page+4

DUE at the end of class __Print out your work at the end of the class period and turn in today__
 * Data Analysis Page 4**


 * Data Analysis Project **
 * 1) Open "__(your name)____Data Project__" from your directory.
 * 2) See the example below to view a file similar to what you will create today.
 * 3) In your file, click on the "Male Female Charts" tab on the bottom of the page. Write your name and Question.
 * 4) SAVE your work frequently as you work. The only remedy for lost work is to redo the work.

3. Make scatter plots and compare the data for females and males. =** Example: **=
 * Compare male and female data using scatter plots **
 * 1) Click on the "Data" tab at the bottom of your file.
 * 2) Use your cursor to select all of the cells in your data by gender files. Take note of the upper left cell that you select. using your left mouse button, select "copy"
 * 3) Go to the "Male Female Charts" tab at the bottom of the page.
 * 4) Place your cursor in the "same" spot of the upper left corner cell. Using your left mouse button. select "paste"
 * 5) Your data chart should be duplicated.
 * 6) Copy and paste the data in sections that will allow you to use the gender data to create a scatter plot. See the example below
 * 1) Using your cursor, select all of the female data.
 * 2) Select "insert" from the ribbon on the top of EXCEL.
 * 3) Select the scatter plot icon.
 * 4) Check your chart and adjust as required.
 * 5) Move your bar chart to a location to the right of your data Repeat process for the male data.
 * Print out your work and turn in today! **