Cara Membuat Tabulasi Data Kuesioner di Excel dan SPSS (Contoh Kuesioner Google Form)
Introduction and Research Background
In this section, the speaker introduces the topic of creating data tabulation for a questionnaire in Excel. The example used is a research study on the impact of Instagram promotion on brand awareness.
Creating Data Tabulation in Excel
- The speaker presents an example research study on the influence of Instagram promotion by Shopee Food on brand awareness.
- The data collected through Google Forms needs to be tabulated in Excel for better organization and analysis.
Tabulating Raw Data
This section focuses on tabulating the raw data obtained from Google Forms in Excel to make it more organized and presentable.
Tabulating Raw Data
- After downloading the results from Google Forms, they appear as raw data in Excel.
- The speaker demonstrates how to tabulate the data to make it visually appealing and easier to analyze.
- By organizing the data, it becomes clearer which responses correspond to each variable (promotion content or brand awareness).
Creating Tabs for Promotion Content Variables
In this section, the speaker explains how to create tabs for different variables related to promotion content.
Creating Tabs for Promotion Content Variables
- To organize the data further, separate tabs are created for each variable (e.g., advertising, publicity, direct marketing, sales promotion).
- Each variable has multiple indicators/items that need to be categorized accordingly.
Merging Indicators within Promotion Content Variables
This section covers merging indicators within each promotion content variable to simplify the tabulation process.
Merging Indicators within Promotion Content Variables
- Within each promotion content variable (e.g., advertising), merge all corresponding indicators/items into a single row.
- This consolidation helps in presenting the data more efficiently and facilitates analysis.
Creating Tabs for Brand Awareness Variables
Here, the speaker explains how to create tabs for different variables related to brand awareness.
Creating Tabs for Brand Awareness Variables
- Similar to promotion content variables, separate tabs are created for each brand awareness variable (e.g., top of mind, brand recall, brand recognition).
- Each variable consists of multiple indicators/items that need to be categorized accordingly.
Merging Indicators within Brand Awareness Variables
This section focuses on merging indicators within each brand awareness variable to simplify the tabulation process.
Merging Indicators within Brand Awareness Variables
- Within each brand awareness variable (e.g., top of mind), merge all corresponding indicators/items into a single row.
- This consolidation helps in presenting the data more efficiently and facilitates analysis.
Copying Data from Google Forms
In this final section, the speaker demonstrates how to copy the data obtained from Google Forms into the respective tabs created earlier.
Copying Data from Google Forms
- The raw data collected through Google Forms is copied and pasted into their corresponding tabs in Excel.
- This step completes the process of creating organized and tabulated data for further analysis.
[t=0:10:40] Creating Borders
In this section, the speaker discusses creating borders and undoing previous actions.
Creating Borders
- The speaker mentions that they will create borders again.
- They mention that the previous border was accidentally deleted.
[t=0:10:47]
[t=0:10:53] Adjusting Placement
In this section, the speaker talks about adjusting the placement of certain elements.
Adjusting Placement
- The speaker mentions moving certain elements by dragging them.
- They realize they made a mistake and decide to start from the beginning.
- They copy item 1-12 and adjust it to be 11.
- They also adjust the volume.
[t=0:11:03]
[t=0:11:19] Merging Data
In this section, the speaker discusses merging different types of data.
Merging Data
- The speaker merges data for gender, education, and occupation.
- They copy items until number 12.
- They mention that there is something visible on the side but don't specify what it is.
- They copy and paste items into a new location.
- They order and align them properly.
[t=0:12:07]
[t=0:12:41] Adding Questionnaire Items
In this section, the speaker adds questionnaire items for brand awareness.
Adding Questionnaire Items
[Musik]
[t=0:12:47]
[Musik]
[t=0:13:01]
[Musik]
[t=0:13.09]
[Musik]
[t=0.13.21]
[t=0.13.21] Finalizing Data Table
In this section, the speaker finalizes the data table by adding variables and adjusting settings.
Finalizing Data Table
- The speaker adds variables for age, gender, education, and occupation.
- They set the decimal places to zero.
- They add items P1-P12.
- They mention that age, gender, education, and occupation are string types.
- They explain that if there are specific codes for certain categories (e.g., 1 for SD), they can be used instead of text.
- They adjust the settings accordingly.
[t=0:14:48]
[t=0:15:16] Adding Instrument Data
In this section, the speaker adds instrument data for brand awareness.
Adding Instrument Data
- The speaker mentions adding data for "promosi konten" (content promotion).
- They mention that it is labeled as "ba1" to differentiate it from other items.
- They continue adding instrument data until "ba11".
[t=0:15:40]
[t=0:16:27] Completing Data Entry
In this section, the speaker completes the data entry process.
Completing Data Entry
- The speaker mentions completing the entry by adding total values.
- They ensure there are no spaces in the labels.
- They copy and paste the data into a new location.
[t=0:16:48]
[t=0.17.07] Customizing Variables
In this section, the speaker explains how to customize variables by assigning values to different responses.
Customizing Variables
- The speaker suggests using different labels (e.g., pk1, pk2) to differentiate between similar items.
- They demonstrate assigning values to each response option using a scale of agreement/disagreement.
[t=0.17.33]
[t=0.18.39] Analyzing Data
In this section, the speaker discusses analyzing the data using regression analysis.
Analyzing Data
- The speaker suggests using regression analysis to examine the relationship between content promotion and brand awareness.
- They mention that the total of content promotion can be used as an independent variable.
- They encourage exploring frequency distribution of responses.
[t=0.18.45]
[t=0.19.23] Conclusion
In this section, the speaker concludes the video and thanks viewers for watching.
Conclusion
- The speaker concludes by thanking viewers for watching and invites them to ask questions or leave comments.
[t=0:19:23]