Part 1: Calculate Rotation Angle. Calculate Chi-square critical value based on required confidence (eg. alpha of 0.05, is 95% confidence ellipse). Using CHISQ.INV() function in Excel. 2 argument in function is degree of freedom, which is number of variables measured as part of sample data, for bivariate data dof=2. Calculate Variance Covariance matrix of sample data. Using COV() function of real stats. Calculate eigen value of covariance matrix. Using eVALUES() function of real stats or using formula considering VarCov matrix. sqrt(λ1) is the radius of the major axis (the longer radius) sqrt(λ1) is the radius of the major axis (the longer radius) Calculate angle from positive X-axis to the ellipse's major axis, in counterclockwise direction Using ATAN2() excel function. atan2()'s first parameter is y and second is x. atan2(covar, λ1-Var.X). θ is the angle in radian. Part 2: Get the points on Confidence Ellipse Calculate rotation matrix, Q, using angle...
Comments
Post a Comment