From the course: Google Sheets: Advanced Formulas and Functions
Join today to access over 22,500 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.
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.