Mar 18 2020 12:26 PM
Mar 18 2020 12:26 PM
Hi all,
Recently I have been working on a spreadsheet to measure firms performance (Return on assets-dependent variable) in relation to Natural log of Total Assets, Leverage and various dummy variables (Independent variables). I have had various number errors in regards to my dummy variables (see attached) which makes me think that I have not set it up right. Any insight into this problem would be greatly appreciated, thanks!
Mar 18 2020 12:37 PM
@Deleted
I see a few #NUM! errors on your "Results" page, but no formulas to assess. You can help us here (others as well as me) help you if you leave the formula or formulas in place. Or tell me what I'm missing if in fact it's there somewhere.
Mar 18 2020 01:46 PM
@mathetes Hi, thanks for your reply. Most of my data is inputted manually without formulas, but here are the ones that I have used in my spreadsheet so far, thanks again.
Mar 18 2020 02:07 PM
@Deleted
I see those formulas, but I don't see what those formulas have to do with the #NUM! errors that you were originally asking about.
It's not at all clear to me, given the absence of formulas in those #NUM! cells (AND in all adjacent cells, so far as I can tell), where those errors come from. You asked whether you've set it up correctly, but it's not at all clear how you've set it up in the first place.
So could I ask that you clarify your original question.