String to Numeric in Excel...How?
Titocan Mark Solutions Titocan Mark Solutions
8.61K subscribers
2,473 views
0

 Published On Jun 20, 2022

In this video you would learn how to process data such as converting nominal or ordinal variables from their String formats to Numeric format in Excel spreadsheet before Loading into SPSS. This conversion enables nominal or ordinal variables to be imported into SPSS as Numeric type rather than as String type. After seeing this video to the end, you would prefer the method exploited in this video to the transformation and recoding methods provided as features in SPSS

In this video, I also demonstrated how to define the value labels of the numeric data you loaded into SPSS from Excel spreadsheet.

The content of this video is impactful and consist of detailed illustrations that makes the tutorial explicit. I hereby encourage you to watch the demonstrations in this video to the end in order to grasp the fully intended knowledge.

The entire section of the demonstration in this video is important to see and learn, but you can use this timeline below to jump to your scene of interest in this video:

TIMELINE:
Introduction/Synopsis: 00:00 – 01:12
Demonstration in Excel: 01:13 – 06:34
Demonstration in SPSS: 06:35 – 10:29

Please, I encourage you to watch the demonstrations in this video from the beginning to the end. Please, like this video, share it and subscribe to my YouTube Channel.

If you wish to contact me directly for business purposes, such as SPSS Tutorial, or data analysis, please use this address: [email protected]

The following videos may also be useful to you. Please, click on the link to see the videos:

Chi-Squared Statistical Test of independence in SPSS:    • Chi-Squared Test in SPSS  
Convert String to Numeric Variable in SPSS (Without Losing Data):    • Convert String to Numeric Variable in...  
Test of Multicollinearity of Data in SPSS:    • Test of Multicollinearity of Data in ...  
Regression Analysis in SPSS Part-2:    • Regression Analysis in SPSS Part 2  
Regression Analysis in SPSS Part-1:    • Regression Analysis in SPSS (Part 1)  
Introduction to SPSS Software for Beginners Part-1:    • Introduction to SPSS Software for Beg...  
Introduction to SPSS Software for Beginners Part-2:    • Introduction to SPSS Software for Beg...  
Merge Two Data Files in SPSS (Part-2):   • Merge Two Data Files in SPSS (Part-2)  
Merge Two Data Files in SPSS (Part-1):    • Merge Two Data Files in SPSS (Part 1)  
Introduction to SPSS Software for Beginners (Part-3):    • Introduction to SPSS Software for Beg...  
Analysis of Variance in SPSS (Effect size and Interpretations):    • Analysis of Variance in SPSS (Effect ...  
Test of Normality of Data in SPSS:    • Test of Normality of Data in SPSS  
Identify Outliers using Tukey's Hinges Approach in SPSS:    • Identify Outliers using Tukey's Hinge...  
Identifying Outliers in Dataset using Stem-and-leaf Plot and Boxplots in SPSS:    • Identify Outliers using Stem-and-leaf...  
Identify Outliers using Scattered Plots in SPSS:    • Identify Outliers using Scattered Plo...  
How to Perform and Interpret One Sample T-Test in SPSS:    • One Sample T-Test in SPSS and Interpr...  
Paired Sample T-Test in SPSS and Interpretations:    • Paired Sample T Test in SPSS and Inte...  
How to Perform Descriptive Statistics in SPSS:    • Descriptive Statistics in SPSS  
How to Perform Pearson’s Correlation Analysis:    • How to Perform Pearson's Correlation ...  
How to Calculate Pearson’s Correlation Coefficient by Hand, Interpret and Report Results in APA style:    • How to Calculate Pearson's Correlatio...  

Titocan Mark Solutions (TMS) is a YouTube Channel that improves the knowledge of how to do things in many endeavours, Please, encourage education and learning by liking and kindly subscribing to this channel, and so that we begin to send you notifications every time I publish new video content. Thank you.

To Subscribe, Please, click on the red SUBSCRIBE button above or on the video to do so.


Soundtrack:
Deep In The Night by chillin_wolf |   / chillin_wolf  
Music promoted by https://www.free-stock-music.com
Creative Commons Attribution-ShareAlike 3.0 Unported
https://creativecommons.org/licenses/...

Author / Artist: chillin_wolf
Website:   / chillin_wolf  
Duration: 02:29
BPM: 70
License: Creative Commons Attribution-ShareAlike 3.0 Unported.

show more

Share/Embed