Excel and Statistics(7), Text to a table

 Excel and Statistics, everybody should know.  : Contents

Text to a table

 

Let’s say you get the result from R. I think it would be nice to tabulate this material.

 

After pasting the data into Excel, select ‘Text to Columns’ under ‘Data’.

 

Choose between  “Delimited” or  “Fixed Width. “

 

The appropriate divider is automatically created, which you can move, delete, or add. I dragged the last divider to move it.

The following format it appropriately. Specify whether it is a number, letter, or date.

Now that it’s properly separated, you can specify the borders, etc., and then copy and paste them into Word or PowerPoint to use as a table.

‘Using separators’ is sometimes very useful, depending on the nature of the data.

 

 

 

Excel and Statistics, everybody should know.  : Contents

=================================================

• 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-2  simple variables
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 

• easier R than SPSS with Rcmdr : Contents