phish108 / empxl Goto Github PK

Some functions are complex and whitespace are not significant.

Need a tool to create flattened versions of the functions.

This should create for each function file a flattened output file.

Then creating the lambdas should create less crashes.

this has two parts:

1. the test itself
2. extracting the residuals

The final function should have the following Synopsis:

WILCOXON.TEST(values, groups; alternative; paired)

alternative accepts left, right, two.sided or either first letter as arguments.

The Function will return a line vector containing:

• W - Ranksum value
• z-score
• p-value

The correlation tests for Kendall's tau, Spearman's rho, and Pearson's r have their own helper functions. There should be a main function for correlation tests (as there is one in R):

CORR.TEST(varA; varB; method; alternative)

• alternative is left (negatively correlated), right (positively correlated), or two.sided for either correlation.
• method is either pearson, kendall or spearman.

The result will be a line vector with the following values:

• coefficient
• z-value
• p-value

Open pyxl handles lambda functions correctly in recent versions.

• Test openpyxl to handle optional parameters.
• Test exceljs to handle named lambda functions & optional parameters.

In both cases some preprocessing might be required.

• Implement xlst builder
• Create gh action to build the template.