I tried the offset function but it is quite complex. I have 60,000 rows of data from UV detection. I need to offset downwards by +1 for all of them so that only y axis of graphed chromatogram(s) will be affected. If there is a way of manipulating the figure to do this please let me know.
The percentage deviation and multiplication did not work.
I am using excel 2017. If you know Origin it wont matter it is similar. I couldnt download SPSS.
End goal is attached below.
As for statistical analysis: You can use the r language as effectively as SPSS and it is now being used more widely than either SPSS or SAS. There are a lot of tutorials and demonstrations of ways to use it on YouTube. I think a few might even be in Spanish.
Also see:
http://www.r-graph-gallery.com/
- Badges
- Science topic