Data Analysis Question

[dbigelow123]

All,

I have a large spreadsheet with fishing data on it. Dates, times, tides, water temperature, fish caught, fish targeted etc. It is all in one line by date. Basically it is results (fish) and variables. What would be the easiest way to see which variables are the most important in the role of catching fish. I have SQL, Access, and Power BI skills but this is beyond me. I would like to also be able to use the sheet as a predictor of best fishing days\times. Is this possible?

Thank you,

 

[AhoyNC]

See if these links on multiple regression help.
I would also probably start with scatter charts of each of the variables plotted against fish caught to see which ones to include in the multiple regression.

http://www.statsoft.com/Textbook/Multiple-Regression
https://www.youtube.com/watch?v=dQNpSa-bq4M
Multiple Regression in Excel
https://www.youtube.com/watch?v=tlbdkgYz7FM
https://www.youtube.com/watch?v=1oBXXsxcp5k

Scatter Chart
https://www.youtube.com/watch?v=LDH-B_B6zJ0

 

[dbigelow123]

I have a question about the variables. Some of them are either 0 or 1. For example full moon - it is either full or not. When scatter charts it doesn't seem to really help. Is there another way to check to include the variable?

 

[AhoyNC]

See if these links help.

https://www.youtube.com/watch?v=MZQYmmUbjUE
https://www.youtube.com/watch?v=H07l1zgM-cw