Instruction for Excel

Please do not remove from class

Column Graph

1.     Go to (in ribbon) File > New Workbook > enter data in column A (class adjusted calf size)

2.     Highlight data > go to (in ribbon) Data > Sort > asending

3.     In column B, determine the frequency for each calf size measurement.

4.     In columns C and D, record represenatative calf size (C) and frequency (D).

5.     Highlight the columns C and D

6.     Go to Insert > Chart > scatter > first chart-sub type > Next

7.     Click Title > Give a Chart title, X axis name and units, Y axis name and units > Next

8.     Click Gridlines> check Major gridlines and Minor gridlines (as needed) for X and Y axis

9.     Click Legend > uncheck Show legend > Next

10.  Mark As new sheet > finish

11.  Click on the grey Plot Area and select the color white

12.  Go to (in ribbon) Chart > Chart Type > column (See Figure 1)

13.  To change the scale double click on any number on the X or Y axis and select proper scale

14.  Note: In the Tool bar > Chart options can be used for any corrections.

 

Figure 1

Scatter Plot Graph with Linear Trendline and R2

1.     The first column is the X axis and the second column is the Y axis.

2.     Highlight the columns X and Y

3.     Go to Insert > Chart > scatter > first chart-sub type > Next

4.     Click Title > Give a Chart title, X axis name and units, Y axis name and units > Next

5.     Click Gridlines> check Major gridlines and Minor gridlines (as needed) for X and Y axis

6.     Click Legend > uncheck Show legend > Next

7.     Mark As new sheet > finish

8.     Click on the grey Plot Area and select the color white (See Figure 2)

9.     In the Tool bar > Chart options can be use for any corrections

10.  To change the scale double click on any number on the X or Y axis and select proper scale

11.  Note: In the Tool bar > Chart options can be used for any corrections.

 

 trend line

Figure 2

 

12.  In the Ribbon go to Chart > Add Trendline > Linear (See Figure 3)> Options > check Display equation on chart and Display R-squared value on chart (See Fighre 4)

2008 Trend line 1

fig 4

Figure 3

Figure 4

Mean (average), Mode, Median, and Standard Deviation

  1. In the Ribbon go to ¦x > Statistical > AVERAGE (mean) > Highlight the values > OK (See Figure 5)

FIG 5

Figure 5

 

  1. In the Ribbon go to ¦x > Statistical > MODE  > Highlight the values > OK (same as step #1)
  2. In the Ribbon go to ¦x > Statistical > MEDIAN  > Highlight the values > OK (same as step #1)
  3. In the Ribbon go to ¦x > Statistical > STDEV  > Highlight the values > OK (same as step #1)

Range Graph with Standard Deviation

 

1.     Input data following the example spreadsheet in Figure 6

2.     The ones correspond to the range of the boys, and the twos correspond to the range of the girls

3.   Graph  columns E and F. Insert > Chart > scatter > first chart-sub type > Next

4.   Click Title > Give a Chart title, X axis name and units, Y axis name and units > Next

5.   Click Gridlines> check Major gridlines and Minor gridlines (as needed) for X and Y axis

6.   Click Legend > uncheck Show legend > Next

7.   Mark As new sheet > finish

8.   Click on the grey Plot Area and select the color white (See Figure 6)

9.   In the Tool bar > Chart options can be use for any corrections

10. To change the scale double click on any number on the X or Y axis and select proper scale

Note: In the Tool bar > Chart options can be used for any corrections.

 

Figure 6