ПочатиПочніть безкоштовно

What's the drinking age?

Now you want to add more data to your descriptive stats. In profiles, users report how often they drink alcohol in a week so you add it to your sample. Drinking behaviour can be important in relationships so obtaning additional summary statistics could help you learn more about profiles.

You'll revisit the COUNTIF() function you saw in an earlier exercise. Recall that this is like COUNT(), except it only counts an observation if a certain condition is met. For example, COUNTIF(C2:C10, 1) would only count observations between C2 and C10 if those observations were equal to 1. Here, you'll use this to count the number of non-drinkers.

Ця вправа є частиною курсу

Вступ до статистики в Google Sheets

Переглянути курс

Інструкції до вправи

  • In E2, calculate the median number of drinks per week.
  • In F2, calculate the mode of the "Drinks per week" column.
  • In G2, use COUNTIF() to calculate the number of non-drinkers - that is, rows where "Drinks per week" is 0.

Практична інтерактивна вправа

Перетворіть теорію на практику за допомогою однієї з наших інтерактивних вправ

Почати вправу