Serving the Quantitative Finance Community
standard deviation
does anyone know how to calculate the standard deviation in a bivariate system. i have a scatter plot. and i have plotted a regression. how do i calculate the stdev and can it be done in excel for such a systemThanks
standard deviation
I would not say that's stdev... That's correlation between the two variates.
standard deviation
In a bivariate system there are two variables, hence two standard deviations. You can compute either one in a spreadsheet. The regression will introduce a new standard deviation, the standard deviation of the residuals.