Data+Project+Page+2

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


 * Data Analysis Project **
 * 1) Open "__(your name)____Data Project__" from your directory.
 * 2) See example below similar to what you will create today.
 * 3) See the example below to see the full sheet that was used to create the tables and histograms..
 * 4) In your EXCEL file, click on the "Table and Histogram" tab on the bottom of the page. Write your name and Question.
 * 5) SAVE your work frequently as you work. The only remedy for lost work is to redo the work.

=** Example: **=
 * Data **
 * 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 block files. Take note of the upper left cell that you select. using your left mouse button, select "copy"
 * 3) Go to the "Table and Histogram" tab on 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) Repeat the process to copy the data by gender chart.
 * 7) In the "Tables and Histogram" tab, look at the data in your "By Grade" data.
 * 8) Decide on an interval that makes sense for your data. Your chart should include at least 5 intervals.
 * 9) If you need more lines in your chart, place your cursor in one of the cells in your chart.
 * 10) Select "insert", then "insert entire row"
 * 11) Enter the data in the "by Grade" and "by Gender" charts.
 * 12) Using your cursor, select all of the data and titles in the "by Grade" table.
 * 13) Select "insert" from the ribbon on the top of EXCEL.
 * 14) Select the bar chart icon. Check your chart and adjust as required.
 * 15) Move your bar chart to a location under the "by Grade" table.
 * 16) Repeat process for the "by Gender" data.
 * Experiment! Two Histogram Graphs are required, but you may want to create others. **
 * See the example below. **
 * Print out your work and turn in today! The page print area is pre-set to print out only the tables and histograms. **


 * When done with page 2, move on to page 3 **