Data+Project+Page+1

=**Data Analysis Page 1**= =DUE at the end of class on Tuesday, December 10= =__Print out your work at the end of the class period and turn in__=
 * Print and turn in two pages**
 * 1) DATA tab and**
 * 2) ANALYSIS tab with the first 7 queations filled in**


 * Data Analysis Project **
 * 1) Go to Pages and Files" on the right menu. Open the "__Copy of Data Template 2013__" in Microsoft EXCEL.
 * 2) See the example below to see a file similar to the file you will create today.
 * 3) Write your name and Question. Note the location of the UNDO and REDO arrows.
 * 4) SAVE to your directory. Name the file __"(Your name) Data Project"__ Close the file.
 * 5) Reopen the file to make sure that you have saved your work to a place where you can find it later.
 * 6) SAVE your work frequently as you work. The only remedy for lost work is to redo the work.


 * Data by Block **
 * 1) 1. Input all data for Grades A, B, C, D and F
 * 2) Separate the data for Female and Male as you input the data.
 * 3) Sort the data within each section using the “Filter and Sort” tap on the upper right toolbar.
 * 4) Be sure to check “continue with current selection" as you sort the data.
 * 5) The sum formulas have been set in the table, but If you want to Sum (add up) the data in each section yourself:
 * 6) Put your curser in the spot where the sum will be located.
 * 7) Select all of the blocks with data (It is OK to include empty blocks)
 * 8) Select Σ (this is the Greek symbol we use to sum). The sum will appear in the box.
 * 9) Below the data input chart, calculate the MEAN (average) for Grades A, B, C, D and F
 * 10) Count the number of people surveyed.
 * 11) Divide the sum total from the data chart by the number of people.
 * 12) Put the information on the chart.
 * 13) Below the data input chart, calculate the MODE (most frequent data) for Grades A, B, C, D and F
 * 14) Put the information on the chart.
 * 15) Below the data input chart, calculate the MEDIAN (middle data) for Grades A, B, C, D and F
 * 16) Using the number of data entries, find the number in the middle
 * 17) ▪ for an odd number of entries, select the middle number (15 entries, use the data in position number 7)
 * 18) ▪ for an even number of entries, find the middle two data entries and average them (add the numbers together and divide by 2)
 * 19) Put the information on the chart.


 * Data by Gender **
 * 1) Copy the data by gender from your Data by Grades chart.
 * 2) Sort the data within each section using the “Filter and Sort” tap on the upper right toolbar.
 * 3) Be sure to check “continue with current selection" as you sort the data.
 * 4) Sum (add up) the data for females and males below the chart.
 * 5) Put your curser in the spot where the sum will be located.
 * 6) Select all of the blocks with data (It is OK to include empty blocks)
 * 7) Select Σ (this is the Greek symbol we use to sum). The sum will appear in the box.
 * 8) Sum (add up) the data for females and males together in the block to the right of the totals for each.
 * 9) Put your curser in the spot where the sum will be located.
 * 10) Select all of the two blocks with the totals to the right
 * 11) Select Σ (this is the Greek symbol we use to sum). The sum will appear in the box.
 * 12) Below the data input chart, calculate the MEAN (average) for each block.
 * 13) Count the number of females or males surveyed.
 * 14) Divide the sum total from the data chart by the number of females and males
 * 15) Put the information on the chart.
 * 16) Below the data input chart, calculate the MODE (most frequent data) for females and males
 * 17) Put the information on the chart.
 * 18) Below the data input chart, calculate the MEDIAN (middle data) for females and males
 * 19) Using the number of data entries, find the number in the middle
 * 20) ▪ for 15 entries, use the data in position number 7
 * 21) ▪ for an even number of entries, find the middle two data entries and average them (Add the numbers together and divide by 2)
 * 22) Put the information on the chart.


 * Data by Gender **
 * 1) Create a double sided stem-and-leaf plot using the date from your gender (female and male) chart


 * Analysis **
 * 1) Click on the ANALYSIS tiab at the bottom of your worksheet.
 * 2) Answer the first seven questions. See the HOME page for an example.

=Example=