Create Average Price Table

valid_apt() creates the Average Price Table used for Stage 2 of the intra-regional validation process. In returns a tibble with the input parameters (variables), as well as the

• Number of observations,

• Average price of product,

• Maximum price of product,

• Minimum price of product, and

• Standard deviation.

Usage

valid_apt(
  df,
  Year = "Year",
  `Product code` = "Product code",
  `Product description` = "Product description",
  `Reference quantity` = "Reference quantity",
  `Unit of reference quantity` = "Unit of reference quantity",
  `Reference quantity price` = "Reference quantity price"
)

Arguments

df

add

Year

add

`Product

description` add

`Unit

of reference quantity` add

`Reference

quantity price` add

Details

It furthermore provides the Max-min ratio and Coefficient of variation statistics. All products that do not pass the two tests are flagged in columns #' Max-min ratio FLAG and Coefficient of variation FLAG, respectively.

TODO add description