sponsored ads

how to do multiple correlation in excel?

sponsored ads

I was wondering if there was a way to find multiple correlation between one independent variable and every possible combination of the others, and how I can do multiple correlation in excel? Any guidance is appreciated! Asked Dec, 17 2010
add commentflag 

sponsored ads

answer this question

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
vote up 1 vote down


  • 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
    vote up 1 vote down

    Your Answer

    community wiki:

    The Verified Code is to stop spamming. It will be hidden once your reputation reached 100.
    or
    Create one

    Options

    sponsored ads

    Download related software from AFC

    Office Excel 2007 1.0

    Last Updated: Apr 2, 2011
    License: Demo
    Filesize: 10.17MB

    Continue to downloadPower by Afreecodec.com