Measures of center

One of the quickest ways to explore a dataset is by calculating summary statistics. There are three main types of summary statistics:

Measures of center
Measures of variance
Measures of frequency

In this exercise, you'll calculate two different types of measures of center: the mean and median. You'll also investigate the dataset further to find the smallest and largest natural satellites in the Solar System.

แบบฝึกหัดนี้เป็นส่วนหนึ่งของหลักสูตร

การวิเคราะห์ข้อมูลใน Google Sheets

ดูคอร์ส

คำแนะนำการฝึกหัด

In F6:G6, calculate the mean of the Mean radius (km) and Sidereal period (days) of the moons.
In F7:G7, calculate the median of the Mean radius (km) and Sidereal period (days).
In F8:G8, find the maximum Mean radius (km) and Sidereal period (days).
In F8:G8, find the minimum Mean radius (km) and Sidereal period (days).

แบบฝึกหัดเชิงโต้ตอบแบบลงมือทำจริง

เปลี่ยนทฤษฎีให้เป็นการลงมือทำด้วยแบบฝึกหัดเชิงโต้ตอบหนึ่งในของเรา

เริ่มแบบฝึกหัด

แบบฝึกหัดนี้เป็นส่วนหนึ่งของหลักสูตร

การวิเคราะห์ข้อมูลใน Google Sheets

SkillTag.level.beginnerSkillTag.label

4.8+

เริ่มคอร์สฟรี

Learn how data analyst skills in spreadsheets can help you draw clearer insights from data. In this chapter, you'll learn how built-in functions can streamline your spreadsheet workflows and improve the readability of your formulas. You'll learn data exploration techniques, such as calculating summary statistics and manipulations like sorting and filtering.

Exercise 1: Built-in functions Exercise 2: The data analysis way!Exercise 3: Rounding values Exercise 4: Summary statistics Exercise 5: Measures of center

แบบฝึกหัดปัจจุบัน

Exercise 6: Counting cells Exercise 7: Sorting and filtering Exercise 8: How big are Jupiter's moons?Exercise 9: Bringing order to the universe!

It is often said that data professionals spend 80% of their time cleaning data and only 20% analyzing it. In this chapter, you'll learn useful functions for cleaning text and DateTime data, two of the trickiest data types to clean. You'll extract date and time components, calculate intervals, and perform a host of common text manipulations on a dataset of the highest-grossing films.

Exercise 1: Extracting date and time components Exercise 2: Extracting years and months Exercise 3: Extracting weekday components Exercise 4: Calculating date intervals Exercise 5: How long has it been?Exercise 6: Intervals between observations Exercise 7: Cleaning text data Exercise 8: Changing cases Exercise 9: Combining text data Exercise 10: Manipulating text data Exercise 11: Counting characters Exercise 12: Extracting characters Exercise 13: Substituting characters

In this chapter, you'll learn to draw insights from your data. You'll perform complex calculations using conditional functions, logical expressions, and conditional aggregation functions. You'll also learn and apply the most important spreadsheet function: VLOOKUP!

Exercise 1: Conditional functions and logic Exercise 2: Logical expressions Exercise 3: Calculating product costs Exercise 4: Evaluting employee performance Exercise 5: Conditional aggregations Exercise 6: Analyzing expenses with conditional aggregation Exercise 7: Number of reports by person and type Exercise 8: Total expenditure by person and type Exercise 9: VLOOKUP Exercise 10: Unsorted lookups Exercise 11: Sorted lookups Exercise 12: Congratulations!