Introduction to Microsoft Excel 2007

In Excel 2007, menus and toolbars have been replaced by the Ribbon. The Ribbon utilizes buttons and tabs with commands on the top of the screen instead of hiding them in the menu.

Inserting Data

x	y
0	-5.8
1	21.1
2	25
3	38.8
4	42.6
5	55
6	68
7	75
8	90.5
9	95
10	105

From the Windows start button, go to programs and run Excel.

Starting with column A, insert the following data. Label the columns as x and y. Data to be plotted on the x axis on the chart must always be located in the left column.

To advance to another row, press the Enter or the down arrow key. The unformatted data table should look like the diagram below.

Graphing Data

Data from Excel can either be plotted on the same sheet as the data table or on a separate sheet. The sheets are indicated by the tabs at the bottom of the screen.

Data Plot on the Same Sheet

To plot a graph of the data on the same sheet, first highlight the data.

Click on the Insert tab located on the Ribbon and click on Scattered.

This will place an X Y scattered graph on the spread sheet.

Under the Design tab select the Chart Layout type to include labeled axis and a chart title.

Delete the Legend labeled Series1 and rename the axis and title as shown below.

Data Plot on the Different Sheet

Right click on the chart and select Move Chart.

Select New sheet:

Trendline

To add a Trendline, right click one of the data points and select Add Trendline.

Check the bottom two boxes to Display Equation and R-squared value on the chart. Then Close.

Error in the Slope

To determine the +/- error in the slope and the y-intercept, an array must be created. Go back to the original spreadsheet and highlight 4 empty boxes as shown below.

Click the mouse in the formula box and enter the LINEST function.

=LINEST(B2:B12,A2:A12,true,true)

The B2:B12 interval represents the known y values and the A2:A12 interval represents the x values. The LINEST function will evaluate the errors in the slope and y-intercept for a data set. The const and stats should be labeled true and true as shown below.

IMPORTANT: To enter an array, hold down the

Ctrl and Shift keys at the same time and then press Enter.

An array should be entered in the four boxes. The array represents the following:

Extra - Select Data Source

Right click on the data and click on Select Data.

Click on Series1 then Edit.

The x and y values can be adjusted from this window.

Q 8/28/07