excelColor: Coloring the signigicant variables and corresponding p values...

In usagi-san-dayo/UsagiSan: Edit summary-tables on a Excel-file

Description

Coloring the signigicant variables and corresponding p values in statistical tests tables on a EXCEL sheet.

Usage

excelColor(
  dataName,
  fileName,
  level = 0.05,
  pValue = c("Pr(>|z|)", "Pr(>|t|)", "p-value"),
  significanceColor = "#FFFF00",
  headerColor = "#92D050",
  fontSize = 11,
  fontName = "Yu Gothic",
  fontColor = "#000000",
  intercept = FALSE,
  adj = TRUE,
  fileEncoding = "CP932"
)

Arguments

dataName	The name of a csv-file you want to edit with coloring.
fileName	The name of a Excel-file you want to save as.
level	The significance level applied in coloring significant variables and p values.
pValue	The character object which indicates the column name in each stitistical test tables.
significanceColor	The fore-ground-color of the significant variables.
headerColor	The fore-ground-color of the headers of a data-frame.
fontSize	Font-size.
fontName	Font-name.
fontColor	The color of fonts.
intercept	Allows you to color significant intercept variable with the fontColor.
adj	Allows you yo adjust shifted statistical test tables.
fileEncoding	File-encoding.

See Also

Examples of this function can be found at https://multivariate-statistics.com/2020/07/21/r-programming-excel-coloring/

usagi-san-dayo/UsagiSan documentation built on Dec. 29, 2021, 10:17 p.m.