The MINVERSE function returns the inverse matrix of a given array. Lets understand the use of TINV function as inverse t distribution calculator. Using the arcsine inverse sine we can find the angle a using the equation The screen shot below shows how we used Excel to determine that the launch angle of the ramp is 1404.
You can find the inverse of any square matrix Now we will get the inverse of 5 x 5 matrix.
These two functions are ATAN and ATAN2 atan is short for arctangent and they each have specific uses depending on the desired results that youd like to obtain and the inputs available. The NormInv function is new in Excel 2010 and so is not available in earlier versions of Excel. The MINVERSE function returns the inverse matrix of a given array. Use the z -score formula and solve it for x.