R-Lab 3

This code loads the “readxl” library and imports the “companies.xlsx” data file.

Try executing this chunk by clicking the Run button within the chunk or by placing your cursor inside it and pressing Ctrl+Shift+Enter.

library(readxl)
companies <- read_excel("companies.xlsx")
View(companies)

The following code will:
1. create a new variable “logAssets” which is the log of “assets” 2. summarize: “salesMillions”, “profitsMillions”, “numEmploy”

companies$logAssets <- log(companies$assets)
cat("Sales in Millions\n"); summary(companies$salesMillions)

Sales in Millions
   Min. 1st Qu.  Median    Mean 
  709.3  1173.0  2934.2  5433.9 
3rd Qu.    Max. 
 5566.1 63438.0 

cat("Profit in Millions\n"); summary(companies$profitsMillions)

Profit in Millions
   Min. 1st Qu.  Median    Mean 
-680.40   46.12  201.70  409.32 
3rd Qu.    Max. 
 697.58 3758.00 

cat("Number of employees\n"); summary(companies$numEmploy)

Number of employees
   Min. 1st Qu.  Median    Mean 
   2900    8565   19050   38235 
3rd Qu.    Max. 
  41222  383220 

Next, create a box-whisker plot of profit per employee conditional on the size of the company

boxplot(profitPerEmp ~ sizeCo, data = companies)

When you save the notebook, an HTML file containing the code and output will be saved alongside it (click the Preview button or press Ctrl+Shift+K to preview the HTML file).

The preview shows you a rendered HTML copy of the contents of the editor. Consequently, unlike Knit, Preview does not run any R code chunks. Instead, the output of the chunk when it was last run in the editor is displayed.