Correlation Analysis

M

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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Sort by date Sort by votes
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
You must log in or register to reply here.

Similar threads

C
  • Question
Plotting 3 points per data set in lollipop-type chart
Replies
2
Views
245
charllottesu
C
S
  • Question
VBA Help- Need to create VBA Function from worksheet
Replies
9
Views
448
scotty1978
S
J
  • Question
drag formula but skip columns
Replies
1
Views
648
iggydarsa
iggydarsa
A
  • Solved
Issues with Capcost (Mismatch Type, Run-time Error '13')
2
Replies
11
Views
273
anonymity
A
L
  • Question
Dynamic chart range based on 2 values
Replies
4
Views
293
levipe
levipe

Forum statistics

Threads
1,215,014
Messages
6,122,697
Members
449,092
Latest member
snoom82

Share this page

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