Complex Time Series Analysis of Protein Degradation Rates

Design a PostgreSQL stored procedure that calculates protein half-life using time-series experimental data from multiple research batches. The procedure should handle irregular time intervals, calculate exponential decay rates, and produce statistical confidence intervals. Include error handling for null values, implement window functions to compare degradation across different protein types, and generate a comprehensive statistical report with R-squared values and confidence metrics.