Derivation of the Correlation Coefficient Data Science and A.I. Lecture Series Problem Statement Objective: Derive the formula for the correlation coefficient \( r(X, Y) \): \[ r(X, Y) = \frac{\sigma_X^2 + \sigma_Y^2 – \sigma_{X-Y}^2}{2 \sigma_X \sigma_Y}. \] Definitions: \( \sigma_X^2 \): Variance of \( X \). \( \sigma_Y^2 \): Variance of \( Y […]
Derivation of Correlation Coefficient Property Read More »
Prove \( -1 \leq r(X, Y) \leq 1 \) for Karl Pearson’s Correlation Coefficient Data Science and A.I. Lecture Series Author: Bindeshwar Singh Kushwaha Institute: PostNetwork Academy Problem Statement Prove that: \[ -1 \leq r(X, Y) \leq 1 \] The correlation coefficient \( r(X, Y) \) is a measure of the linear relationship between
Karl Pearson’s Correlation −1≤r(X,Y)≤1 Read More »
COUNTIF() and SUMIF are very important functions in excel which are used to automate manual tasks. Furthermore, these functions are frequently used in finance and accounting. In this post, I am going to explain working of these two functions. COUNTIF() function- This function counts the values of a column when a condition if fulfilled
COUNTIF and SUMIF Functions in MS Excel Read More »
Python is a very popular language for data analysis and data manipulation. Furthermore, Python has a lot of libraries to manipulate Excel data. In this post, I will explain how to write to and read from Excel sheet using Python’s script . Which will be very useful for you to learn data science and Artificial
Writing and Reading Excel Data from Python Read More »
Microsoft Excel is a very popular spreadsheet program which is easy to use and it has a lot formulas which are related to finance, statistics, logical and arithmetic etc.. Furthermore, this is very popular among those who are working in office, in the field finance, administration and management. In this post, I will demonstrate how
Addition In Microsoft Excel Read More »