Forum Discussion

datadiver's avatar
datadiver
Copper Contributor
Apr 15, 2025

I need help calculating the correlation coefficient

I am trying to figure out how to calculate in Excel the correlation coefficient of each survey question on a survey to the overall rating question mean score. I am embedding a table below of six sample survey questions with the mean score of each question and the total number of respondents. What I would like to know is how you perform the correlation coefficient analysis of each question to the overall rating question on the survey. I would like the results to show as I have them in the Column D of the image below.

 

QuestionMean ScorenCorrelation Coefficient to Overall Rate
Overall Rating of Food98.2550 
Taste of Food95.2550.52
Quality of Food92.7550.31
Look of Food93.2550.25
Smell of Food91.5050.15
Presentation of Food90.7550.65
 

Any help with this calculation would be greatly appreciated.

  • Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Resources