How to Find Mean, Mode, Median, and Range Using Google Sheets
Автор: Tim Cavey at VCS
Загружено: 2023-06-01
Просмотров: 313
Use Google Forms to create a survey for your classmates with ONE question that will generate a set of numerical values (answers that are numbers).
Determine the mean, median, and mode and record the results in the private comment.
⭐ IMPORTANT INSTRUCTIONS:
1. Require email address collection
2. Limit participants to ONE response
3. Go to Responses and select the Google Sheet icon to generate a spreadsheet of your responses.
4. Calculate your mean, median, and mode once you have at least 15 responses.
GOOGLE SHEETS FORMULAS to TRY:
=average(C1:C20)
=mode(C1:C20)
=median(C1:C20)
TO FIND THE RANGE:
=MAX(C2:C11)
=MIN(C2:C11)
Then subtract the minimum from the maximum.
🎯 Learning Target: I can … generate a small data set (number of values) and analyze the numbers using digital tools.
❓ Essential Question: How can we apply statistics and probability outside of school life?
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
![[4K FULL HD] Relaxing Water Background | 1 HOUR | Calm Water Wallpaper (No Sound)](https://image.4k-video.ru/id-video/y9PTNTSpGJs)
