CommencerCommencez gratuitement

Investigating age and volunteering

Earlier you observed a strong correlation between age & annual religious observation. Another interesting field which could indicate a profile's moral values is the number of volunteer hours annually. In each profile a user can add information regarding their annual estimated hours spent volunteering.

In addition to corrlation you decide to plot a scatter plot. If there is a correlation between age & volunteer_hrs, you should be able to observe a trend sloping upward or downward. If the correlation is low, you could surmise that people volunteer at similar rates regardless of their age

Cet exercice fait partie du cours

<cours>Introduction aux statistiques dans Google Sheets</cours>
Voir le cours

Instructions de l’exercice

  • In G2 calculate the correl Then compare with church visits' correlation 0.61
  • Highlight B1:C501 to select the fields for the chart.
  • Using the navigation bar, insert a Chart
  • Select Scatter from the Chart type dropdown.

Exercice interactif pratique

Transformez la théorie en action avec l’un de nos exercices interactifs

Commencer l’exercice