Forum Discussion
Correlation calculation between rows within a table
Yes, I am looking for this kind of correlation coefficient only.
Let me further explain what my requirement is...
We are trying to find out how a particular question's score is influencing other question's score, for ex: if a user gives low score for a question like "Are you satisfied with salesperson's demo/explanation?" ... this should automatically reduce score for a question like "How satisfied are you with dealership in helping, buy you the product?"
With existing sample data, Say If I choose question "Overall Sales Experience Satisfaction" as a base question, then I want to correlate its score with all other questions.
As per above link,
Item is question,
Value X is Score of question
Value Y should be base question score, repeating for all question within that survey id's (which I want it to be dynamic based on certain per selected questions)
Then calculate Correlation coefficient for each question for selected duration using a date filter.
Below is the required format to calculate the Correlation coefficient and that has to be happen dyamically wheneven base question is changed.
| Survey Id | Date | Question | Score | Overall Sales Experience Satisfaction |
| 817852 | 1/23/2019 | Delivered When Promised | 90 | 80 |
| 817852 | 1/23/2019 | Delivery Personnel Appearance and Condition | 60 | 80 |
| 817852 | 1/23/2019 | Delivery Personnel Explanation | 0 | 80 |
| 817852 | 1/23/2019 | Delivery Personnel Installation | 30 | 80 |
| 817852 | 1/23/2019 | Delivery Personnel Specifications | 80 | 80 |
| 817852 | 1/23/2019 | How likely to use Dealership in future | 40 | 80 |
| 817852 | 1/23/2019 | How likely to use TCIF in future | 30 | 80 |
| 817852 | 1/23/2019 | Overall Delivery Experience | 40 | 80 |
| 817852 | 1/23/2019 | Overall Sales Experience Satisfaction | 80 | 80 |
| 817852 | 1/23/2019 | Overall Sales Personnel Satisfaction | 70 | 80 |
| 817852 | 1/23/2019 | Overall TCIF Satisfaction | 90 | 80 |
| 817852 | 1/23/2019 | Sales Personnel Explanation of features and options | 70 | 80 |
| 817852 | 1/23/2019 | Sales Personnel Explanation of financing alternatives | 40 | 80 |
| 817852 | 1/23/2019 | Sales Personnel Explanation of warranty coverage | 20 | 80 |
| 817852 | 1/23/2019 | Sales Personnel Fair and honest | 0 | 80 |
| 817852 | 1/23/2019 | Sales Personnel Helpful and courteous | 80 | 80 |
| 817852 | 1/23/2019 | Sales Personnel Product knowledge | 30 | 80 |
| 817852 | 1/23/2019 | Sales Personnel Product recommendations | 70 | 80 |
| 818467 | 1/2/2019 | Delivered When Promised | 50 | 70 |
| 818467 | 1/2/2019 | Delivery Personnel Appearance and Condition | 30 | 70 |
| 818467 | 1/2/2019 | Delivery Personnel Explanation | 0 | 70 |
| 818467 | 1/2/2019 | Delivery Personnel Installation | 40 | 70 |
| 818467 | 1/2/2019 | Delivery Personnel Specifications | 80 | 70 |
| 818467 | 1/2/2019 | How likely to use Dealership in future | 40 | 70 |
| 818467 | 1/2/2019 | How likely to use TCIF in future | 80 | 70 |
| 818467 | 1/2/2019 | Overall Delivery Experience | 50 | 70 |
| 818467 | 1/2/2019 | Overall Sales Experience Satisfaction | 70 | 70 |
| 818467 | 1/2/2019 | Overall Sales Personnel Satisfaction | 70 | 70 |
| 818467 | 1/2/2019 | Overall TCIF Satisfaction | 40 | 70 |
| 818467 | 1/2/2019 | Sales Personnel Explanation of features and options | 0 | 70 |
| 818467 | 1/2/2019 | Sales Personnel Explanation of financing alternatives | 20 | 70 |
| 818467 | 1/2/2019 | Sales Personnel Explanation of warranty coverage | 50 | 70 |
| 818467 | 1/2/2019 | Sales Personnel Fair and honest | 20 | 70 |
| 818467 | 1/2/2019 | Sales Personnel Helpful and courteous | 80 | 70 |
| 818467 | 1/2/2019 | Sales Personnel Product knowledge | 70 | 70 |
| 818467 | 1/2/2019 | Sales Personnel Product recommendations | 0 | 70 |
| 819074 | 3/7/2019 | Delivery Personnel Appearance and Condition | 70 | 30 |
| 819074 | 3/7/2019 | Delivery Personnel Installation | 50 | 30 |
| 819074 | 3/7/2019 | Delivery Personnel Specifications | 0 | 30 |
| 819074 | 3/7/2019 | How likely to use Dealership in future | 70 | 30 |
| 819074 | 3/7/2019 | Overall Sales Personnel Satisfaction | 30 | 30 |
| 819074 | 3/7/2019 | Sales Personnel Explanation of features and options | 30 | 30 |
| 819074 | 3/7/2019 | Sales Personnel Explanation of financing alternatives | 60 | 30 |
| 819074 | 3/7/2019 | Sales Personnel Explanation of warranty coverage | 30 | 30 |
| 819074 | 3/7/2019 | Sales Personnel Fair and honest | 60 | 30 |
| 819074 | 3/7/2019 | Sales Personnel Helpful and courteous | 90 | 30 |
| 819074 | 3/7/2019 | Sales Personnel Product knowledge | 90 | 30 |
| 819074 | 3/7/2019 | Sales Personnel Product recommendations | 20 | 30 |