1. Analyzing Stock Price Movement
Financial AnalystBackground
An analyst is comparing the daily returns of two tech stocks to see if they move together.
Problem
Needs to calculate the sample covariance and correlation to assess portfolio diversification.
How to use
Paste the paired daily return percentages into the Data Pairs field, select 'Sample Covariance', and check 'Include Correlation'.
Covariance Type: sample, Include Correlation: trueOutcome
The tool outputs a positive sample covariance and a correlation coefficient, confirming the stocks generally move in the same direction.