26 February 2015 16 8K Report

Hello,

I have no experience with this sort of statistics but hoping to convert some data I've collected into a linear regression so that I can compare mine to some secondary data. 

The raw data/ scatter graph looks at mean depths of sharks (y axis) over time (x axis). I have this for both the secondary data and mine. 

In order for me to make a good comparison, I need to transform the hours... the previous work has used cos2theta. 

Is this something I can do on micrsoft excel? or is there anyother software that can do this? 

Also as the previous research has looked at depths over 24 hours and mine is only over 9 but shows the same pattern for that time, will this effect the R2  value? 

I'm trying to learn as much as I can about trig now so any information will be really appreciated!

I've also created a file (mainly so that I know what I'm trying to do) so I've attached it as t may make more sense to you by seeing the data.

I know theres a good chance what I'm asking might not work/ sound gibberish but thank you in advance and for reading!

Zoe 

More Zoe Collishaw's questions See All
Similar questions and discussions