- #1
saybrook1
- 101
- 4
Hi guys, I have a set of 2-D data in excel, an X and Y column. The X column ranges from ±200 and the Y column is a Gaussian distribution ranging from about 6 to 12. In total there are about 500 data points. I need to normalize the data so that the Y column values have endpoints at 0 for X=±200. I know this requires a rotation of the data or a linear transformation but I'm really pretty foreign to that process. If anyone could point me in the direction of being able to do this either on paper or within excel or other software, I would really appreciate it. Please let me know if you need any more information or pictures. Thanks!