How to log transform your dataset in Excel

This lesson explains how to log transform your dataset in Excel. Transforming a dataset is one of the ways in cleaning your datasets in order to have normally distributed datasets

[@user-to6kz2fd5h]

Hello.. I have a question. What if your data have negative values? How can you run a log model if your data have some negative values? Thank you

[@nihadashraf1072]

Did u resolve it?

[@AkshayKumar-vd5wn]

You cannot. Only positive values, numbers, items can be transformed.

[@olufunmilolablossom2348]

Thanks❤

[@gregorysikakwe4159]

When I tried to log transform in excel I have issues faith typing the log on a cell . No dropdown appears for me to choose. When I type LN nothing appears and I get stuck there. How can I over come this problem. I need your guide. Thanks.

[@ayenewendalew3150]

Not visible