how to do multiple correlation in excel?

First. Select the data
Second. On the Insert menu, Chart group, click Scatter
Third. Click on the scatter chart sub-type that you want
Fourth. Right click a point on the chart and select Add Trendline
Fifths. Tick Display equation on chart and Display R-squared value on chart
Last. Click close Answered Feb, 26 2011

1
Launch Excel 2007.

2
Create two columns of data, one for each variable, in an Excel spread sheet. These columns should be made up of a variable name as the header in the top row with the numerical data for the variable listed down the column below the header. It does not matter which order you list your variable data.

3
Highlight the two columns by dragging you mouse down from the header over all of the numerical data.

4
Click on the "Insert" tab in the top menu bar, and select "Scatter" from the Charts options.

5
Select the first chart style type from the drop down menu. Your scatter plot will now appear in Excel.

6
Select the "Legend" with your mouse and click the "Del" key on your keyboard to remove it from the graph.

7
Click on the "Layout" tab in the top menu bar, and click "Axis Titles" from the Labels option. Enter the variable names for your scatter plot. Keep in mind that Excel has placed the variable that was in the left column of the spread sheet on the x-axis and the second variable on the y-axis.

8
Change the scatter plot title by clicking on the current title in the graph, then typing in a new title in the text box above the plot and pressing the "Enter" button on your keyboard.

Read more: How to Make a Scatter Plot in Excel 2007 | eHow.com http://www.ehow.com/how_6320130_make-scatter-plot-excel-2007.html#ixzz1FudKgFha

Answered Mar, 07 2011