From the course: Google Sheets: Advanced Formulas and Functions
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Represent data using a mean of zero and standard deviation of one - Google Sheets Tutorial
From the course: Google Sheets: Advanced Formulas and Functions
Represent data using a mean of zero and standard deviation of one
- [Instructor] When you perform advanced statistical analyses such as multilinear regression, your results might be thrown off if one set of values is much larger than another. For example, a house's cost as opposed to its square footage. In this movie I'll show you how to standardize data so it has a mean of zero and a standard deviation of one. This workbook contains a single worksheet and in it I have selling prices as compared to square footage for a set of houses. Because price is so much larger than square feet, I want to standardize the values so that each of the columns has a mean of zero and a standard deviation of one. So that means that a house that happened to have exactly the average price would have a value of zero and a house with exactly the average square feet would also have a zero. And you can go plus or minus above and below the mean based on standard deviations as we go through the data. To calculate the standardized price for the value in row two, I'll click in…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
Find the nth largest or smallest value1m 56s
-
(Locked)
Identify the smallest and largest values3m 49s
-
(Locked)
Rank values in a range4m 32s
-
Calculate distribution statistics3m 16s
-
(Locked)
Calculate values in the normal distribution8m 13s
-
(Locked)
Represent data using a mean of zero and standard deviation of one3m 26s
-
(Locked)
-
-
-
-
-