一夜。統計學:SPSS介紹&問卷編碼
Summary
TLDRThe video script offers a comprehensive introduction to SPSS, a statistical software package. It highlights the software's interface, which resembles Excel but is tailored for statistical analysis through drag-and-drop and click methods. The tutorial covers key features, such as Data View for entering survey responses and Variable View for coding and defining variables. The script guides viewers on how to input demographic data and Likert scale responses, emphasizing the importance of accurate data entry for reliable statistical analysis. It also touches on the manual effort required for data entry and the provided teaching materials to facilitate the learning process.
Takeaways
- 💻 The video introduces an interface for the statistical software SPSS, which is similar to Excel but designed for more powerful statistical analysis.
- 🔍 SPSS uses a drag-and-click method to assist users in performing statistical analysis, making it user-friendly for those familiar with Excel.
- 📊 The SPSS interface has two main views: 'Data view' for entering and analyzing survey responses, and 'Variable view' for coding and defining variables.
- 📝 In 'Variable view', researchers can define what each code represents, such as assigning '1' for males and '2' for females, to facilitate analysis.
- 🔢 For questions with a continuous scale, like a 5-point Likert scale for agreement, SPSS requires defining each numerical value to represent its corresponding sentiment.
- 📋 The script demonstrates how to manually enter data into SPSS, emphasizing the importance of accuracy to ensure correct statistical calculations.
- 🔖 The process of entering data into SPSS is labor-intensive and requires patience, as errors can lead to incorrect analysis results.
- 📚 The video script includes an example of a questionnaire with demographic and Likert scale questions, showing how they would be coded in SPSS.
- 🔄 The script mentions the efficiency of copying and pasting in SPSS for coding questions with the same scale, to save time and effort.
- 👨🏫 The video is educational, providing a step-by-step guide for students on how to use SPSS for data entry and analysis, with a focus on accuracy and patience.
Q & A
What is the main purpose of the video?
-The main purpose of the video is to introduce the interface of the statistical software SPSS and explain how to use it for data analysis.
How is the SPSS interface similar to Excel?
-The SPSS interface is similar to Excel in that it has a spreadsheet-like appearance with cells where data can be entered and manipulated.
What are the two main views in SPSS that the video discusses?
-The two main views in SPSS discussed in the video are Data View and Variable View.
What is the purpose of Data View in SPSS?
-Data View in SPSS is used for entering and analyzing data for each subject, such as responses to a questionnaire.
What is Variable View used for in SPSS?
-Variable View in SPSS is used for coding the questionnaire items, assigning numerical values to different responses, and providing identification for the researcher.
Why is it necessary to code questionnaire items in SPSS?
-Coding questionnaire items in SPSS is necessary to convert text content into numerical data that the software can analyze, making it easier to perform statistical analysis.
How does the video demonstrate the coding process for questionnaire items?
-The video demonstrates the coding process by showing how to enter variable names, assign numerical values to responses, and use the Numerical Annotation feature to define what each number represents.
What is an example of a demographic variable that might be coded in SPSS?
-An example of a demographic variable coded in SPSS is gender, where 1 might represent male and 2 might represent female.
How does SPSS handle continuous scale questions like those found in a corporate reputation survey?
-For continuous scale questions, such as those in a corporate reputation survey, SPSS allows the user to assign numerical values from 1 to 5, representing different levels of agreement, and then define what each number means.
What is the advantage of using copy and paste in SPSS when coding questionnaire items?
-Using copy and paste in SPSS when coding questionnaire items saves time and effort, especially when the scale or coding system is the same across multiple questions.
Why is it important to be careful when keying in data in SPSS?
-It is important to be careful when keying in data in SPSS because any errors made during this process can lead to incorrect calculations and analysis results.
How does the video suggest organizing the data entry process in SPSS?
-The video suggests organizing the data entry process by keying in data from left to right for each questionnaire, ensuring a consistent and orderly approach to data entry.
What does the video imply about the relationship between the effort put into data entry and the quality of statistical analysis?
-The video implies that the effort put into accurate data entry is directly related to the quality of the statistical analysis, as errors in data entry can compromise the validity of the results.
Outlines
💻 Introduction to SPSS Interface
This paragraph introduces the statistical software SPSS and its user interface. The speaker compares the interface to Excel, highlighting its drag-and-drop functionality for statistical analysis. The focus is on the initial blank state of SPSS, the Data View for entering questionnaire responses, and the Variable View for coding and defining variables. The speaker explains the importance of coding textual questionnaire items into a format that can be analyzed statistically, using the Variable View to assign numerical codes and annotations to different survey responses.
🔢 Coding Survey Data in SPSS
The speaker demonstrates how to code survey data in SPSS, starting with demographic variables like gender and age, and then moving on to more complex questionnaire items such as corporate reputation. The paragraph explains the process of defining numerical values for categorical data (e.g., 1 for male, 2 for female) and annotating these values for the computer to understand. It also covers the coding of continuous scale items, such as a 5-point Likert scale for agreement, with examples of how to input these values into SPSS. The speaker also mentions the efficiency of using copy and paste for repeated scale annotations and the importance of understanding the codes for accurate data entry.
📝 Data Entry Process in SPSS
This paragraph details the manual data entry process in SPSS, emphasizing the importance of accuracy and patience. The speaker uses examples to illustrate how to enter data for each questionnaire item, such as gender, age, and Likert scale responses for corporate reputation questions. The paragraph also discusses the potential for errors during data entry and the consequences these can have on subsequent analysis. The speaker provides a hypothetical scenario of entering data for multiple questionnaires, explaining the repetitive nature of the task and the need for careful attention to detail. Additionally, the paragraph touches on the time-saving benefits of pre-prepared coding for teaching purposes and the necessity of creating unique codes for individual research papers.
Mindmap
Keywords
💡SPSS
💡Interface
💡Drag and Click
💡Data View
💡Variable View
💡Coding
💡Numerical Annotation
💡Continuous Scale
💡Keyin
💡Copy and Paste
💡Questionnaire
Highlights
Introduction to SPSS as a statistical software with a user-friendly interface similar to Excel.
Explanation of SPSS's drag and click method for statistical analysis.
Comparison between SPSS and Excel in terms of functionality and capabilities.
Overview of the initial blank state of SPSS's Data View.
Introduction to Data View and Variable View in SPSS.
Importance of Variable View for coding and identifying questionnaire items.
Demonstration of how to input data into SPSS for questionnaire responses.
Explanation of coding gender in SPSS with numeric values.
Guidance on using Numerical Annotation to define variable values in SPSS.
Process of entering demographic data and questionnaire responses into SPSS.
Efficiency tips for entering data with copy and paste functionality in SPSS.
Instructions on how to avoid common data entry errors in SPSS.
Example of entering corporate reputation survey data into SPSS.
Clarification on how to handle open-ended questions like age in SPSS.
Discussion on the manual nature of data entry and its implications.
Highlighting the provided teaching materials with pre-encoded SPSS data.
Emphasis on the importance of accurate data entry for reliable statistical analysis.
Conclusion of the SPSS environment introduction and its practical applications.
Transcripts
各位親愛的同學
Dear classmates
這一段影片
this video
主要是要跟各位介紹
Mainly I want to introduce it to you
有關於
About
Spss這個統計軟體的一個界面
An interface for the statistical software Spss
所以同學現在畫面上所看到的
So what students see on the screen now
是我已經把軟體打開呈現的一個畫面
This is a picture that appears after I open the software.
各位同學應該會覺得那個畫面
You students should think that picture
有點面熟
A bit familiar
因為
because
這個畫面看起來就很像我們用的EXCEL
This screen looks very similar to the EXCEL we use
那其實
That's actually
他的確很像EXCEL
He does look like EXCEL
不過 他是比較屬於
But he is relatively
商業套裝軟體
Commercial software package
也就是他在執行統計的功能上面來說
That is to say, he is talking about the function of performing statistics.
他是用拖拉點選的方法
He uses drag and click to select
來幫你做分析
Come and help you analyze
所以EXCEL當然也是一個試算表
So of course EXCEL is also a spreadsheet
不過呢 spss
But spss
他可以幫助你
he can help you
做出很多
make a lot
更Powerful的一個statistics
A more powerful statistics
好 那我們現在看一個
Okay, let's look at one now
Spss這個介面的畫面
Spss interface screen
他一開始這邊的儲存格
The cell here where he started
當然是空白的
Of course it's blank
因為我們還沒有輸入任何的data
Because we haven’t entered any data yet
到裡面去
go inside
所以說他當然是一個空白的
So of course he is a blank
那我們比較需要注意的其實是他
Then what we need to pay more attention to is actually him.
左下角的部分
The lower left corner part
你可以看到左下角的部分
You can see the lower left corner
他有兩個按鈕
He has two buttons
分別叫做
respectively called
資料檢視
Data view
還有
besides
變數檢視
Variable view
資料檢視是我們目前呈現的畫面
The data view is the screen we currently have
都是空白的儲存格
All are blank cells
資料檢視是我們在keyin問卷的時候
Data review is when we are in the keyin questionnaire
那針對每一個受試者他填答的一個內容
For each subject, he answered a question
去做分析
do analysis
去做keyin的動作
do keyin action
那變數檢視 我今天把它圈起來用藍色的框框圈起來的部分
As for the variable inspection, I circled it with a blue frame today.
他主要是做一個編碼coding的功能
It mainly does a coding function
也就是說
That is to say
我們的問卷不都是一些文字內容嗎
Aren’t our questionnaires all text content?
你問人家的題目都是文字的內容
The questions you ask people are all text content
那你要key到電腦裡面去
Then you need to key it into the computer.
你要自己去判讀或分辨的時候
When you have to judge or distinguish by yourself
你應該要把一些題目的代號和代稱
You should give the codes and titles of some topics
放到軟體裡
Put it in the software
這樣子的話 你在分析
In this case, you are analyzing
你比較知道
you know better
你現在到底在分析 哪些題目
What topics are you analyzing now?
主要是給研究者本身一個識別的作用
Mainly to provide the researcher with an identification function
免得自己都搞不清楚
In case you don’t even understand it
你等一下要分析哪些題
Which questions do you want to analyze later?
好 那我們來看一下實例 我們要看一下實例
Okay, so let's look at an example. We're going to look at an example.
我們剛才的問卷
The questionnaire we just asked
我們再跟大家複習一下
Let’s review it with you again
這個問卷的內容呢
What is the content of this questionnaire?
大家已經有一定的了解
Everyone already has a certain understanding of
所以說這些問卷呢 我們假設你的受試者都已經填答完畢
So what about these questionnaires? We assume that your subjects have already filled out the answers.
所以每一個人會針對他自己的不同狀況
So everyone will respond to his own different situation
給予不同的填答
Give different answers
所以這邊的每一個題目呢
So what about every question here?
假設都已經回收了他上面應該是會有答案的
Assuming they have been recycled, there should be answers from above.
好 那回收的問題以後要打開這個SPSS這個視窗
Okay, for the issue of recycling, we need to open this SPSS window in the future.
去做keyin的動作
do keyin action
首先我們現在看到的是已經完成的Spss的資料
First of all, what we are seeing now is the completed Spss data.
好 那當然就是為了教學還有節省時間
Okay, of course it’s for teaching purposes and to save time.
我已經幫各位同學準備好了
I have prepared it for all my classmates
那實際上來說
That's actually
這邊的 變數檢視 資料
Variable view data here
理論上來講
Theoretically
一開始是空白的 就是我現在紅色方框
It was blank at the beginning, which is the red box I have now.
框起來的部分 他理論上當然是空白的
The framed part is of course theoretically blank.
那 我們是要怎麼做呢
So what are we going to do?
我們應該要自己一筆一畫的把它打出來
We should type it out stroke by stroke ourselves
比如說
For example
現在我們看到的第一個欄位
Now the first column we see
他寫的是性別
He writes about gender
好 這個性別 其實 是 我們自己用手key出來的
Okay, this gender was actually keyed out by ourselves.
回到剛才 這個空白的檔案裡面
Go back to this blank file just now
他是怎麼key呢
How did he key?
好 我們按這個 變數檢視 變數檢視
Okay, let's click on this variable view variable view
按下去之後 就像我剛剛說講他是空白的
After pressing it, just like I just said, it is blank.
所以我應該是在這邊按兩下
So I should have clicked twice here.
打開我的輸入法
Open my input method
然後自己 key性別
Then key the gender yourself
是這樣子出來的
This is how it came out
那第二個如果叫做 年齡 那我就可以打 年齡
If the second one is called age, then I can type age.
這樣也都是我們一筆一畫慢慢key出來的
In this way, we slowly key it out one stroke at a time.
好 那像這個性別 性別
Well that's like this sex sex
不就是男生或女生嗎
Isn’t it a boy or a girl?
男生和女生 我們的代碼
Boys and Girls Our Code
分別用 1號 或者 是 2號
Use No. 1 or No. 2 respectively
1號 或 0號
No. 1 or No. 0
那這種數字的代碼
What is the code for this number?
你必須要告訴電腦
You have to tell the computer
所以我們在這個
So here we are
值 的部分
value part
在這個 值 value 的部分呢
What about the value part?
我們應該要 幫電腦做一個定義
We should give a definition to computers
就是說我們這邊滑鼠按一下
That is to say, if we click the mouse here
他會出現一個叫做 數值註解
It will appear a tool called Numerical Annotation
好 那我們今天如果把 數字1 當作 男性
Okay, then if we treat the number 1 as male today
那我們就要告訴電腦 1 代表男性
Then we have to tell the computer that 1 represents male
然後 按下新增
Then click Add
好 2 代表 女性
Good 2 represents women
然後 按 新增
Then press Add
好 那接下來我們就可以按確定了
Okay, then we can press OK.
這樣所以依此類推 所以你的
so so and so on so your
人口統計變數或是名義尺度呢
What about demographic variables or nominal scales?
基本上 都是這樣的key出來的
Basically, these keys come out
好 假設說
Okay, let's say
我們除了基本資料之外
In addition to basic information, we
我們可能還有一些問卷的題項
We may also have some questionnaire items
譬如說
For example
這是屬於企業聲望的第一題
This is the first question related to corporate reputation
我就打聲望1
I'll hit Reputation 1
那像聲望第一題呢
What about the first question on reputation?
我們今天要打的這樣子的值
The value we are going to fight today is like this
他就不是屬於 類別尺度
He does not belong to the category scale
那像這種企業聲望的問題
What about issues like corporate reputation?
他是屬於連續尺度的
It is on a continuous scale
所以 從1分到5分
So from 1 to 5
分別代表的是 非常不同意 不同意 普通 同意 非常同意 的 5點尺度
They represent a 5-point scale of strongly disagree, disagree, moderate, agree, and strongly agree.
所以你要告訴電腦這些12345代表什麼意思
So you have to tell the computer what these 12345s mean.
好我這邊做一次給各位同學看
Okay, I'll do it here once and show it to all my classmates.
那等一下 就可以依此類推
Then wait a moment and so on.
像1 是 屬於 非常不同意
Like 1 is belongs to strongly disagree
所以 他是分數比較低的 你要打 非常不同意 然後 按 新增
So he has a relatively low score. If you want to hit him, you strongly disagree and then click Add.
然後
Then
2呢 就是 不同意 按 新增
2. Just don’t agree. Click Add.
3 代表的是 普通 然後 按 新增
3 stands for Normal and then press Add
然後4呢 就變成 同意 再按一次 新增
Then 4 becomes Agree and click Add again.
然後5呢 就代表的是 非常同意
Then 5 means strongly agree.
好 這樣的話 各位同學就明白了
Okay, in this case, all students will understand
所以呢 你可以看到
So you can see
這邊少打了一個5
There is one less 5 here.
我剛才忘了 按 非常同意 再 新增
I just forgot to click Strongly Agree and then Add
所以 以下 以此類推
So the following and so on
你的聲望可能還有第二題
There may be a second question about your reputation
你說這樣子 每一題 都要 12345 好像很麻煩 對不對
You said that each question requires 12345, which seems very troublesome, right?
其實不用啦 像你這個聲望 我們再打一題好了
Actually, no need. With your reputation, let’s take another question.
其實因為他的尺度都是5點尺度
In fact, because his scales are all 5-point scales
所以尺度的說明是一樣 其實你是可以用複製的 他是允許你用複製的
So the description of the scale is the same. In fact, you can use copy. He allows you to use copy.
然後呢在下面的空格我選起來之後按貼上
Then I select the space below and press Paste
所以你會發現
so you will find
這邊的尺度啊 他都已經可以完整的複製下來了
The scale here can be copied completely.
你就不用每一題去keyin
You don’t have to key in every question
當然 像這種人口統計變數的 1代表男性 2代表女性
Of course, for demographic variables like this, 1 represents men and 2 represents women.
跟 那種 學歷
With that kind of education
1號 代表 小學畢業
No. 1 represents primary school graduates
2號 代表 國中畢業
No. 2 represents junior high school graduates
3號 代表 高中畢業
No. 3 represents high school graduation
當然是不能複製貼上
Of course you can't copy and paste it
不過呢 如果是這種同意度的
But if it’s this level of agreement
五點尺度的
five point scale
你只要key一題
You only need one key question
你後面呢
What's behind you?
都可以用複製貼上的動作 都可以用複製貼上的動作
You can use the copy and paste action. You can use the copy and paste action.
就可以幫你省很多的力氣
It can save you a lot of effort
當然 在左邊的空格
Of course in the space on the left
你可以自己填問卷的題目 看你要填多長
You can fill in the questions of the questionnaire yourself. It depends on how long you want it to be.
都可以啊
It's all fine
不過基本上 這份資料是讓你自己分析的
But basically, this information is for you to analyze on your own.
所以你只要自己看得懂這個代號就可以
So you only need to understand the code name yourself.
不需要
unnecessary
把問卷裡面很長的中文全部都寫下來
Write down all the long Chinese words in the questionnaire
這樣反而有時候會造成視覺上的困擾
This may sometimes cause visual disturbance.
好 那我們這邊就可以先講到這裡
Okay, then we can stop here first.
我們看了這麼多 這裡是屬於 變數檢視 的部分喔
We have seen so much. This is the part of variable inspection.
那 變數檢視 我們把 問卷的每一題key完以後 我們可以回到 資料檢視 的視窗
Then in variable view, after we key each question in the questionnaire, we can return to the data view window.
你可以看到 資料檢視 的 地方
You can see where the data view
本來空白沒有東西的地方呢 這裡已經有題目了
There is already a question in the place where there was nothing originally.
這裡是要幹嘛呢 就是讓你研究者 在keyin 你的 受試者資料 的 時候
What is going on here is to let you, the researcher, keyin your subject information.
你有所依據
You have some basis
所以 我們這裡呢
So where are we?
跟大家舉個例子來說
Let me give you an example
假設 我們的問卷回收 已經回收的完全 而且 已經有很多的資料了
Assume that our questionnaire collection has been completely collected and there is already a lot of information.
所以我們手上或是我們桌上有厚厚一疊問卷資料
So we have a thick stack of questionnaires on our hands or on our desks
這時候呢 我們拿起 第一份問卷
At this time, we picked up the first questionnaire
來看一下裡面的資料
Let’s take a look at the information inside
好 我們看一下 第一份資料裡面呢
Okay, let's take a look at the first document.
好 假設
good hypothesis
他填答的是 男性
He answered "male"
男性的代號是1
The male code is 1
對吧 所以我們 在 spss 的 編碼
Right so we code in spss
就要勾1
Just tick 1
就要輸入1
Just enter 1
我們回到我們spss
Let's go back to our spss
我們在這個地方呢就要給他數字1
When we are here, we have to give him the number 1
那年齡呢 年齡我們這邊的 年齡 是 屬於開放式的問答 所以這邊是一個填充題
What about age? Our age here is an open-ended question and answer, so this is a filler question.
假設 他這邊寫23歲好了
Suppose he writes 23 years old here
所以我們就要 按照上面的數字寫 23
So we're going to follow the numbers above and write 23
接下來我們看那個 聲望1
Next let’s look at that Reputation 1
在企業聲望有八題 我們舉個例子
There are eight questions about corporate reputation. Let’s give an example.
假設 他今天呢 企業的聲望的部分
Suppose he is today, the prestige part of the company
他這邊填答是
His answer here is yes
第一題是4分
The first question is 4 points
第二題是5分
The second question is 5 points
那第三題又是填4分
Then the third question is worth 4 points again
假設這個受試者 他前面3題 回答的是4分、5分、4分
Assume that this subject answered the first three questions with 4 points, 5 points, and 4 points.
好 那我們在spss軟體裡面
Okay, then we are in spss software
就依序給他 5分、4分、5分
Just give him 5 points, 4 points, 5 points in order
好 這樣子的話你就可以了解
Okay, this way you can understand
他的填答是怎麼樣的一回事
What was his answer like?
好 我這邊只是一個舉例
Okay, I'm just giving an example here.
你就可以依此類推
You can deduce this
好 假設 第二份問卷 她是女生
Okay, let’s say in the second questionnaire, she is a girl.
女生的代號是2
The girl’s codename is 2
那她的年齡填的可能是25歲
Then her age may be 25 years old
那她聲望呢 可能是勾 4分、3分、3分
What about her reputation? Maybe 4 points, 3 points, 3 points
然後以此類推
and so on
這個問卷的填答呢
How about filling out this questionnaire?
一定是從左到右 這樣子算 第一份問卷
It must be calculated from left to right. The first questionnaire
key完之後 再拿出第二份問卷 從左到右 第二份問卷
After keying, take out the second questionnaire. Second questionnaire from left to right.
key完之後再 Key 第三份 從左到右 都是這樣的順序
After keying, key the third copy in the same order from left to right.
也就是說
That is to say
你的有效問卷有多少 你就重複這個動作多少次
Repeat this action as many times as you have valid questionnaires
所以你這樣一直拉下來 他可以key 幾百份幾千份都沒有問題
So if you keep pulling it down like this, he can key hundreds or thousands of copies without any problem.
比較大的問題是 這邊都是屬於人工的動作
The bigger problem is that these are all manual actions.
他沒有任何的捷徑
He doesn't have any shortcuts
所以你今天如果用的是紙本問卷
So if you are using a paper questionnaire today
這個動作可能是不可避免的
This move may be unavoidable
好 那 為了節省各位同學的時間 我剛已經說過了 已經幫大家
Okay, in order to save everyone's time, I have just said that I have already helped you.
把這個該keyin的地方 我們都已經做了一個很完整的編碼
We have already done a very complete encoding of this keyin place.
所以你看網路上 你所下載我的教學資料
So you look at my teaching materials that you downloaded from the Internet
這邊的每一個題目 的 每一個編碼
Every code for every question here
我都已經幫你做好了
I've already done it for you
各位同學 你要注意 就是以後你的論文 你當然是要自己做
Dear students, please note that in the future, you will of course have to do your own papers.
這個教學的內容呢
What is the content of this teaching?
他不可能跟你的論文內容一樣
He cannot have the same content as your paper
那編碼完後 我們就可以看一下 資料檢視
After the encoding is completed, we can take a look at the data view
所以你可以看到
so you can see
都是從左到右 這是一份
All from left to right. This is one serving.
從左到右 第二份
Second copy from left to right
從左到右 這樣子 第三份
Like this from left to right, the third copy
從左到右 這樣子 第四份
From left to right like this, the fourth copy
依此類推
So on and so forth
你的有效樣本 有幾份
How many valid samples do you have?
這邊就要重複多少次
How many times do we have to repeat this?
他的確是一個很花眼力跟手指頭力量的一份工作
It is indeed a job that requires a lot of eyesight and finger strength.
他不是很困難
He is not very difficult
但是呢 很煩雜 所以 就是必須要耐著性子來做
But it’s very complicated, so you have to be patient and do it.
因為你一旦keyin錯誤 你後面的計算 當然是不會正確的
Because once you make a wrong keyin, of course your subsequent calculations will not be correct.
我們看一下這一份問卷
Let’s take a look at this questionnaire
我們的教學範例這種問卷你看他總共有幾份呢
How many questionnaires are there in total for our teaching examples?
他有405份的有效樣本
He has 405 valid samples
代表呢 我們當初在keyin這份資料
Representative, we were keying in this information.
執行了405次的keyin動作
The keyin action was executed 405 times
這樣子的動作 的確是 會花點時間 所以我們今天把這個資料先提供給各位
Such an action will indeed take some time, so we will provide you with this information today.
以利後續的統計教學的一個動作
An action to facilitate subsequent statistics teaching
好 大概 有關於spss的環境介紹
OK, probably an introduction to the environment of spss
就到此告一段落
That’s it.
希望對同學有幫助
Hope it helps my classmates
謝謝
Thanks
Browse More Related Video
5.0 / 5 (0 votes)