Excel and Statistics, everybody should know. : Contents
Find and Replace
If you somehow know that m exists, select the corresponding column to replace it with M, use <Ctrl HŒ> to open the <Find and Replace> window, enter m and M, and click <Replace AllŽ>.
It tells me that 33 have changed, but in fact both ‘m’ and ‘M’ have been changed to ‘M’. <Option> allows you to find ‘m’ and ‘M’ separately, but you don’t have to do that now.
If you do not specify a column and try to replace f with F, all fs in the other columns will also be replaced. <Replace All> is so fast and powerful that you should use it with caution and use Ctrl Z if you want to revert it.
In the case of replacing F ‘with 0 and M with 1, or similar, it is often better to specify and replace the columns first in the same way.
=================================================
- R statisics portal https://tinyurl.com/stat-portal
- R data visualization book 1 https://tinyurl.com/R-plot-I (chart)
- R data visualization book 2
https://tinyurl.com/R-plot-II-3-4 many variables / map
https://tinyurl.com/R-plot-II-5-6 time related / statistics related
https://tinyurl.com/R-plot-II-7-8 others / reactive chart
- R data visualization book 3 https://tinyurl.com/R-data-Vis3
- R data visualization book 4 R 데이터 시각화 4권
- Meata Analysis book 1 https://tinyurl.com/MetaA-portal
- Meata Analysis book 2 https://tinyurl.com/MetaA-portal(2)
- Preciction Model and Machine Learning https://tinyurl.com/Machine-Learning-EZ
- Sample Size Calculations https://tinyurl.com/MY-sample-size
- Sample data https://tinyurl.com/data4edu
댓글 없음:
댓글 쓰기