產品

SurveyMonkey 能滿足各種使用案例和需求。歡迎探索我們的產品,瞭解 SurveyMonkey 能為您提供什麼協助。

使用領先全球的線上調查問卷服務,獲得以資料為導向的深入解析。

探索集合於單一強大平台上的核心功能和進階工具。

建立並自訂線上表單,以收集資訊並接受付款。

可與超過 100 款應用程式和外掛程式整合,讓您事半功倍。

量身打造的解決方案,滿足您所有的市場研究需求。

利用內建的 AI 打造更優質的調查問卷並快速獲得獨到見解。

範本

測量客戶對貴公司的滿意度和忠誠度。

瞭解如何讓客戶滿意,使他們成為您忠實的擁護者。

取得可化為實際行動的深入解析,改善使用者的體驗。

向潛在客戶、受邀人等對象收集聯絡資訊。

輕鬆收集並追蹤下一場活動的邀請回函。

瞭解出席者的期待,使下一場活動更成功。

發掘能提升員工參與度並改善績效的深入解析。

收集出席者的想法和意見,把下一場會議辦得更好。

運用同儕的想法和意見來協助員工提升績效。

打造更好的課程並改善教學方法。

瞭解學生對課程資料和教學狀況的評價。

瞭解客戶對您的新產品構想有何看法。

資源

使用調查問卷和調查資料的最佳實務

有關問卷調查、商務技巧及更多其他內容,都在我們的部落格。

SurveyMonkey 的使用教學與指南。

頂尖品牌如何透過 SurveyMonkey 推動成長。

聯絡銷售人員登入
聯絡銷售人員登入

How correlation analysis identifies market and customer segments

Better understand your survey data with correlation analysis. SurveyMonkey can help.

You’ve sent out your surveys and collected the responses. Now what? It’s time to analyze your data. Correlation analysis of your data can help you understand the relationship between data points, turning insights into patterns and trends within your dataset’s variables. You can then determine which variables need further investigation.

It sounds pretty technical, but we’ve put together helpful information to help you understand how to use correlation analysis with your market research.

Using correlation analysis, you can identify market and customer segments that will help you reach your business goals.

Correlation analysis is a statistical research technique used to determine if there is a relationship between two variables or datasets. In the area of market research, it’s used to examine quantitative survey data to identify significant patterns, trends, or connections between the variables.

Correlation should not be confused with causation. In correlation, your variables move together. In causation, one variable causes the others to change. 

For example, Paula did a study on the relationship between bottled water sales and air conditioner sales. She determined that when air conditioner sales were low, bottled water sales were also low. She also found that when air conditioner sales were high, bottled water sales were high. She concluded that bottled water sales and air conditioner sales are correlated, but she can’t conclude that one causes the other. With further research, Paula found that both variables are caused by an increase in temperature. Therefore, bottled water and air conditioner sales are correlated, and the sales of both have a causal relationship with hot weather.

Correlation is commonly measured using Pearson correlation analysis, though some researchers use the Spearman method. Let’s look at both types of correlation analysis and how they’re used.

The Pearson method is the most commonly used correlation method in market research. It’s a way to measure the degree of a relationship between two linearly related variables. It uses the Pearson correlation coefficient test to compare the mean value of the product of the standard scores of matched pairs of observations. This yields an answer in the range of -1 to +1. 

To use the Pearson correlation, each variable must be continuous, and the shape of the variable’s relationship must be linear. If these two assumptions are not applicable, you should use Spearman’s correlation.

The Pearson correlation coefficient ( r ) is calculated using this expression: 

Pearson correlation coefficient formula

In this calculation: 

  • Xi represents the values of the x variable
  • X-bar indicates the mean of the values of the x variable
  • Yi is the value of the y variable
  • Y-bar represents the mean of the values of the y-variable
  • S indicates the sum of squares of both the x and y variables
  • N is the number of observations of the x and y variables

The Spearman correlation method is a non-parametric version of the Pearson method. The statistics are not based on assumptions, meaning the data can be collected from a sample that doesn’t follow a specific distribution. The analysis uses the median rather than the mean. As with the Pearson correlation, your data will yield a number from -1 to +1. The closer your number is to 1, the stronger the monotonic relationship.

To use Spearman’s correlation, create a table from your data, ranking the largest number in a column as 1, the next largest value as 2, and so on. Then find the difference in ranks in each row. Square the differences and sum them.

Example:

ConceptConcept evaluation (0-10)Concept evaluation rankingPrice willing to payPrice willing to pay rankingDifference between rankings (d)d2
191$3.50100
214$3.20224
372$3.003-11
433$1.504-11
TOTAL6

Use the data from your table to calculate Spearman’s rank with the following formula:

Spearman's rank formula

Pearson’s correlation determines the strength and direction of the linear relationship between two variables. Spearman’s correlation determines the strength and direction of the monotonic relationship (movement in the same general direction) between two variables.

Both of these methods can be calculated by hand, but you’ll save time and avoid human error if you use a tool to complete the calculations.

Correlation can be categorized both by how strong the relationship between variables is and the nature of the correlation.

When variables have a high correlation, they have a strong relationship with each other. Variables with a low correlation are barely related.

These types of correlations describe the nature of the relationship between variables.

  • Positive correlation indicates an increase or decrease in one variable creates a like change in the other variable.
  • Negative correlation indicates that an increase or decrease in one variable creates an alternate effect in the other variable.
  • No correlation indicates that a change in one variable may not correspond to any change in the other variable.

In marketing, correlation analysis can be used to analyze customer satisfaction, employee satisfaction, and customer experience surveys, among others.

The data gained from correlation analysis is extremely useful in determining areas that need more investigation and may lead to regression analysis for further insights into the relationships between variables.

Correlation data is a critical component of your research into your target market and your employee satisfaction. 

Remember, correlation does not indicate causation. Correlation analysis does not allow you to draw any conclusions about a causal effect. You can determine the size, degree, and direction of the relationship, but not causation. This is an important disclaimer that should be indicated within your results.

When you use correlation analysis, you gain an understanding of how specific variables affect key performance indicators (KPIs) like customer satisfaction or  Net Promoter Score® (NPS).

Correlation analysis is also used to measure the effectiveness of advertising campaigns by looking at correlations between increases or decreases in sales related to a specific marketing campaign.

Customer satisfaction is a distinguishing factor used to differentiate your business from the competition. Using customer satisfaction surveys is necessary for gathering data from your customers to guide your business decisions. Satisfied customers often become repeat customers and build brand loyalty.

Analyze the data you collect on your CSAT for correlations that will provide insights into your target market.

For example, you want to know if there is a relationship between sales of a particular product and the demographics of the customer making the purchase. With correlation analysis, you find that your product sales are correlated with males of ages 20-35. This information helps you to target your marketing and advertising, inform product development, and increase overall satisfaction in the demographic segment you’ve identified. 

Employee Net Promotor Score® (eNPS) correlations to independent variables or organizational factors can be made through employee surveys.

eNPS asks an employee, “How likely are you to recommend working at XYZ company to a friend or family member on a scale of 1–10?” The score serves as the dependent variable.

Further questions ask about independent variables such as salary, benefits, working conditions, company culture, employee morale, opportunities, training, etc.

Correlation analysis of the data will reveal which independent variables have a positive or strong correlation with the eNPS. And this information can be used to determine areas for improvement. eNPS surveys should be administered regularly to track trends over time. As the score goes up, it can be used in recruiting materials to attract high-level candidates.

Use the following steps to perform your own correlation analysis:

  1. Design your survey: Ensure that your questions yield data that is numerical and ordinal, such as:
    1. Age
    2. Income/money 
    3. Satisfaction scales
    4. Importance scales
  2. Test your survey: Ensure that all questions are functioning so that data will be correct and valid.
  3. Administer your survey, and then collect and clean your data.
  4. Run your correlation analysis using the Pearson or the Spearman analysis method.
  5. You can calculate manually for variables or save time and potential for human error by using a program like Excel.
    1. If you’re familiar with entering functions in Excel, you could enter the CORREL command: =CORREL(array 1, array 2) 

For example, =CORREL(A3:A8, B3:B8)

  1. You can also load the Excel Data Analysis Tookpak, which includes several types of analysis tools. Here’s how to do it: 
    1. Type your collected data into an Excel worksheet. Use two columns to place your x and y values in the table.
    2. Click “Data” and “OK.”
    3. Click “Correlation,” then “OK.”
    4. Enter the location for your x-y variables in the “Input Range” box.
    5. Click either “columns” or “rows” to indicate how your data is arranged (usually it’s columns).
    6. Check “Labels in first row” if you have column headers.
    7. Click “Output Range” and select where you want your output to appear on the worksheet.
  2. Review results for correlations between variables.

Does your market research include correlation analysis? While it doesn’t reveal causal relationships, it does provide you with important information that can be used in your analysis of employee and customer satisfaction and more.

Get started today with a survey sent to your target audience. SurveyMonkey Audience will send your survey to the exact participants you need. And check out all of our market research solutions to help you run your business today!

Net Promoter®, NPS®, NPS Prism®, and the NPS-related emoticons are registered trademarks of Bain & Company, Inc., Satmetrix Systems, Inc., and Fred Reichheld. Net Promoter Score℠ and Net Promoter System℠ are service marks of Bain & Company, Inc., Satmetrix Systems, Inc., and Fred Reichheld.

To read more market research resources, visit our Sitemap.