bluefoxr
commented
1 year ago what is the direction assigned to that indicator in iMeta?
Closed MoujibChahid closed 1 year ago
bluefoxr
commented
1 year ago what is the direction assigned to that indicator in iMeta?
MoujibChahid
commented
1 year ago The direction assigned to this indicator is -1, and its distribution includes no negative values. But as you know, the direction is not concerned by the normalization step (according to the min-max normalization formula). It's at the aggregation level that directions are taken into consideration.
bluefoxr
commented
1 year ago
The results calculated by COINr during the normalization step (mix-max, 0-100) are incorrect. After verification on an Excel spreadsheet, the results are even inverted. The minimum value gets a score of 100 after normalization and vice versa. For example, here are the data for one indicator:
The minimum is 7.23 and the maximum is 455.82. The results calculated by COINr are as follows:
The correctly normalized data are as follows:
The R code used to normalize the data is as follows: library(readxl) iData <- read_excel("/Users/moujib0/Desktop/Normalisation_panel/Data_treated.xlsx", sheet = "iData") iMeta <- read_excel("/Users/moujib0/Desktop/Normalisation_panel/Data_treated.xlsx", sheet = "iMeta") library(COINr) coin <- new_coin(iData = iData, iMeta = iMeta) coin <- new_coin(iData = iData, iMeta = iMeta, split_to = "all") coin <- qNormalise(coin, dset = "Raw", f_n = "n_minmax", f_n_para = list(l_u = c(0, 100))) coin <- Aggregate(coin, dset = "Normalised", f_ag = "a_amean")