Correlation Analysis

mackay09

New Member
Joined
Mar 11, 2009
Messages
1
Hi, Could someone please explain to me how to use the correaltion analysis on Excel 2007? Im Struggling. I merely want a graph showing the correlation between 2 sets of data.

Thanks in advance :)
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Hello and welcome to MrExcel.

With X data in column A and Y data in column B (for example)


  • Select the data
  • On the Insert menu, Chart group, click Scatter
  • Click on the scatter chart sub-type that you want
  • Right click a point on the chart and select Add Trendline
  • Tick Display equation on chart and Display R-squared value on chart
  • Click close
 
Upvote 0

Forum statistics

Threads
1,222,042
Messages
6,163,558
Members
451,844
Latest member
ddnndd1234

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top