Staff Skills academy+
Home » Courses » Microsoft Excel Advanced Certification » Module 8 : CORREL Function
Module 8 : CORREL Function
8.1 CORREL Function The CORREL function in Excel will display the correlation coefficient between two sets of data. You can then use CORREL to determine the relationship between the two properties. For example, you can see the relationship between average the temperature in an area and the sales of air conditioners. The data returned will be between 0 and 1, with 1 being a perfect positive correlation, or 0 and -1 with -1 being a perfect negative correlation. Correlation can also be displa...
Lessons
- Module 1: Add a Password
- Module 2 : AND Function
- Module 3 : Auto Updating Drop-down Lists
- Module 4 : CEILING Formula
- Module 5 : Charts that Update Automatically
- Module 6 : CHOOSE Formula
- Module 7 : Compare 2 Lists with VLOOKUP Function
- Module 8 : CORREL Function
- Module 9 : Create an Advanced Calculator
- Module 10 : Create a Combo Chart
- Module 11 : Create a Custom Tab
- Module 12 : Create a Pivot Chart
- Module 13 : Create Visual In-cell Indicators
- Module 14 : Create Visual In-cell Indicators with Icon Sets
- Module 15: Customise the Status Bar
- Module 16: DATEDIF Function
- Module 17: DATEVALUE Function
- Module 18: DAVERAGE Function
- Module 19 : DCOUNT Function
- Module 20 : DCOUNTA Function
- Module 21 : Depreciation Formula
- Module 22 : DGET Function
- Module 23 : DMAX Function
- Module 24 : DPRODUCT
- Module 25: DSUM Function
- Module 26: EDATE Function
- Module 27: EOMONTH Function
- Module 28: Find and Replace
- Module 29: FIND Function
- Module 30: INDEX Function
- Module 31: INDEX MATCH Function
- Module 32: INDIRECT Function
- Module 33: Insert Serial Number Automatically
- Module 34: IPMT Function
- Module 35: ISBLANK Function
- Module 36: ISERR Function
- Module 37: ISLOGICAL Function
- Module 38: ISNONTEXT Function
- Module 39: ISNUMBER Function
- Module 40: ISODD Function
- Module 41: Isolate First Name
- Module 42: ISTEXT Formula
- Module 43: LEFT Function
- Module 44: LEN Function
- Module 45: MATCH Function
- Module 46: VLOOKUP Multiple Results at Once
- Module 47: OR Function
- Module 48: PMT Function
- Module 49: REPLACE Function
- Module 50: Select all Cells with Comments
- Module 51: Sparkline Charts in Excel
- Module 52: Straight Line Depreciation
- Module 53: Strikethrough
- Module 54: Sum of Years Depreciation
- Module 55: Timeline in Pivot Table
- Module 56: VLOOKUP with 2 Criteria
- Module 57: VLOOKUP with DropDown List
- Module 58: VLOOKUP with MAX
- Module 59: VLOOKUP with MIN
- Module 60: Watch Window In Excel
