Multi-Dimensional Scientific Experiment Correlation Engine

Create a complex PostgreSQL stored procedure that performs multi-dimensional correlation analysis across heterogeneous scientific experiment datasets. The procedure must dynamically pivot experimental variables, calculate Pearson correlation coefficients, and generate a normalized correlation matrix. Handle datasets with missing values, implement robust statistical error handling, and optimize for datasets with 50+ experimental variables.