How to log transform your dataset in Excel
HTML-код
- Опубликовано: 22 авг 2024
- 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
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
Did u resolve it?
You cannot. Only positive values, numbers, items can be transformed.
Thanks❤
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.
Not visible