R script that generate Excel statistical report

Job ID: 32499062

Budget: $30 – $250 USD

I need a R script that has the following input: dataset in xlsx with a dozen variables and a grouping variable name (0 or 1 in value).

It needs to generate the following Excel report:
-all variables in the dataset on a separate row (except the grouping variable)

-first column: mean + SD if parametric distribution, median + IQR if non-parametric distribution or absolute frequency + relative frequency for categorical data (e.g., 0 or 1) for the entire dataset
-second column: the same as above, but only for cases without grouping variable
-next column: the same as above, but only for cases without grouping variable
-next column: p value for unpaired t test if both are parametric, Mann-Whitney test if at least one is non-patametric, Chi/Fisher test if categorical data
- next 3 columns: univariate binary logistic regression with p value, OR and 95% CI
- next column: generate cut-off value using Youden's criteria
- next 3 columns: univariate binary logistic regression with p value, OR and 95% CI with independent variable from Youden's criteria
- next 3 columns: area under receiver operator curve: using bootstrapping - AUC, 95% CI, p value when comparing AUC with a specified variable using De Long test
- next 3 column: area under precision recall curve using bootstrapping: AUC, 95%
- next column: F1 max score

Attached are examples of dataset and expected report. Maximum budget is 100 usd.