From the course: CompTIA Data+ (DA0-002) Cert Prep
Unlock this course with a free trial
Join today to access over 25,500 courses taught by industry experts.
Variance and standard deviation
From the course: CompTIA Data+ (DA0-002) Cert Prep
Variance and standard deviation
- [Instructor] The last two measures of dispersion that we need to discuss are variance and standard deviation. These values are related to each other, and they give us a sense of how values are spread from the mean. Let's start with variance. The variance is the average of the squared differences of each value in a dataset from the mean. We calculate variance with this formula. Now, once again, we have some Greek letters here, so I'm going to walk you through this formula. We saw a mu earlier in the course, that's the mean value for the population. And lowercase x is each of the values in the dataset. So we take each value in the dataset and subtract the mean from it. Then we square that difference. After calculating all the squared differences, we add them together and divide by N the number of values in the population. That gives us lowercase sigma squared, the variance. Now, with that explanation under our belts, let's try calculating the variance for our class height dataset. We…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
(Locked)
Structured query language3m 41s
-
SELECT statement2m 27s
-
(Locked)
Sorting results4m 3s
-
(Locked)
Filtering data4m 1s
-
(Locked)
NULL values3m 26s
-
(Locked)
Aggregating data3m 8s
-
(Locked)
Grouping data3m 7s
-
(Locked)
String manipulation2m 43s
-
(Locked)
Working with dates2m 14s
-
(Locked)
Derived values3m 16s
-
(Locked)
Set operations5m 37s
-
(Locked)
Join operations1m 58s
-
(Locked)
Inner joins7m 7s
-
(Locked)
Joining multiple tables6m 34s
-
(Locked)
Outer joins2m 55s
-
(Locked)
Nested queries2m 17s
-
(Locked)
-
-
(Locked)
Line chart1m 32s
-
(Locked)
Scatterplots and bubble charts1m 48s
-
(Locked)
Pie charts1m 24s
-
(Locked)
Bar charts and histograms2m 33s
-
(Locked)
Waterfall charts1m 22s
-
(Locked)
Heat maps and geographic maps1m 54s
-
(Locked)
Tree maps1m 25s
-
(Locked)
Word clouds and infographics1m 18s
-
(Locked)
Pivot tables4m 54s
-
(Locked)
-
-
Today's regulatory landscape3m 35s
-
(Locked)
Health insurance portability and accountability act (HIPAA)4m 45s
-
(Locked)
Family educational rights and privacy act (FERPA)5m 25s
-
Gramm leach bliley act (GLBA)4m 10s
-
(Locked)
Data breach notification laws3m 19s
-
(Locked)
International data transfers3m 22s
-
-
-
(Locked)
Goals of information security2m 9s
-
(Locked)
Preserving data confidentiality2m 18s
-
(Locked)
Building an access management program3m 12s
-
(Locked)
Authentication, authorization, and accounting2m 58s
-
(Locked)
Managing the data lifecycle4m 43s
-
(Locked)
Data classification2m 41s
-
(Locked)
Control and risk frameworks8m 54s
-
(Locked)
Audits and assessments5m 52s
-
(Locked)