Correlation
What's the relationship between a company's revenue and its other financial attributes? Compute the correlation between revenues and other financial variables with the corr() function.
This is a part of the course
“Exploratory Data Analysis in SQL”
Exercise instructions
- Compute the correlation between
revenuesandprofits. - Compute the correlation between
revenuesandassets. - Compute the correlation between
revenuesandequity.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Correlation between revenues and profit
SELECT ___ AS rev_profits,
-- Correlation between revenues and assets
___ AS rev_assets,
-- Correlation between revenues and equity
___ AS rev_equity
FROM fortune500;