Summary Statistics

Comparison of R and Excel.

Load package we will need using the library command

library(tidyverse)
library(readxl)
library(skimr)

Read corporate tax spreadsheet into an R dataframe.

Corp_Tax_Break_ <- read_excel("C:/Users/rosal/Desktop/Corp Tax Break .xlsx")

Use the function skim to calculate descriptive statistics.

skim(Corp_Tax_Break_)

Table 1: Data summary

Name	Corp_Tax_Break_
Number of rows	379
Number of columns	5
_______________________
Column type frequency:
character	2
numeric	3
________________________
Group variables	None

Variable type: character

skim_variable	n_missing	complete_rate	min	max	empty	n_unique	whitespace
Industry…1	0	1	2	38	0	379	0
Industry…5	0	1	9	39	0	22	0

Variable type: numeric

skim_variable	n_missing	complete_rate	mean	sd	p0	p25	p50	p75	p100	hist
Profit	0	1	2020.28	3764.71	6.80	348.56	850.30	2045.55	31414.00	▇▁▁▁▁
Tax	0	1	229.14	554.96	-647.00	0.90	44.45	214.95	4718.00	▇▁▁▁▁
Rate	0	1	0.07	0.21	-1.68	0.00	0.10	0.18	0.61	▁▁▁▇▅