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.

Deze oefening maakt deel uit van de cursus

Exploratory Data Analysis in SQL

Cursus bekijken

Oefeninstructies

Compute the correlation between revenues and profits.
Compute the correlation between revenues and assets.
Compute the correlation between revenues and equity.

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

-- 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;

Code bewerken en uitvoeren