Excel 2013 Statistical Analysis #24: Numerical Measures: Covariance and Correlation Coefficient

Topics in this video:
1. (00:15) Review of different X-Y Scatter
2. (02:42) Add Xbar Line and Ybar Line to X Y Scatter Chart to help interpret how Covariance is calculated and why the math behind the calculation makes sense
3. (08:36) Formulas and Calculations for Covariance and Correlation Coefficient (Long Hand)
4. (12:38) COVARIANCE.S Excel function for calculation Sample Covariance
5. (13:41) Correlation Coefficient & PEARSON Excel function for calculation Correlation Coefficient
6. (16:11) CORREL Excel function for calculation Correlation Coefficient
7. (18:50) Summary

[excelisfun]

Excel 2013 Statistical Analysis #24: Numerical Measures: Covariance and Correlation Coefficient
Topics in this video:
1. (00:15) Review of different X-Y Scatter 
2. (02:42) Add Xbar Line and Ybar Line to X Y Scatter Chart to help interpret how Covariance is calculated and why the math behind the calculation makes sense
3. (08:36) Formulas and Calculations for Covariance and Correlation Coefficient (Long Hand)
4. (12:38) COVARIANCE.S Excel function for calculation Sample Covariance
5. (13:41) Correlation Coefficient & PEARSON Excel function for calculation Correlation Coefficient
6. (16:11) CORREL Excel function for calculation Correlation Coefficient
7. (18:50) Summary

[zhouyinwei]

The first time to know the great way adding mean bars and with the help of 4 Quadrant to understand data a better way, it is easy to understand, remember, and meantime powerful and insightful!

[michikarpfen]

Great how clear you explain this. All thumbs up (again)

[HariKSamineni]

As always its great to watch your videos. Thanks so much.

[lionelshaneyfelt]

I'm so glad I found you. I'm in love. SWEEEET LOOOVEEE.

[FarshidBesharati]

Thank you sir, you are awesome. can't be explain than the way u explain

[DIGITAL_COOKING]

Very good explanation, and beautiful worksheet

[chinhpham]

I realy love your presentation, thanks a lot

[markpoliti]

My gosh I can't tell you how helpful your videos are.  You're the B.E.S.T. !!!  Thanks so much.

Well, here's what I'm trying to do.

I''m creating a Photo Log and want to automatically add new Rows at the top of the Workbook.  I'm working with a total of eight columns.  Column "A" should contain a number that increases sequentially each time a new Row is created at the top, with the newest (highest) number in the newest created Row.  This will allow me to work always at the top so the newest photo is always at the top along with its newly created corresponding number.  This also lets me always see the total number of photos I have right there at the top of the list. 

The macro I found that automatically creates the new rows at the top is this: 

Private Sub CommandButton21_Click()

Sheets("Photo Log").Range("A11").Select
ActiveCell.EntireRow.Insert Shift:=x1Down

Sheets("Photo Log").Range(A11:E:11").Select
Selection.Borders.Weight = x1Thin

End Sub

Is there something I can add to the above macro that will accomplish what I'm trying to do?  If not, do you have any suggestions?

Thanks a gazillion !!

Mark Politi
Boca Raton, FL

[chriswang]

I love the statistical classes, thank you so much Mike. is the next class video coming soon? I'm looking forward to it.

[anuppsna]

Could you please add tutorials on creating excel interactive dashboards?

[samkab]

hi .just to be accurate.the mean should be 3902 instead of 4070..please correct me if im wrong..thank u