Conteúdo do Curso

R Introduction: Part II

## R Introduction: Part II

# Data Extraction

Finish the section with practice on abstract local furniture store selling data!

Tarefa

You will work with the data below. This data is stored in the `store`

variable.

Item | Price | Sold |

Sofa | 340 | 67 |

Armchair | 150 | 81 |

Dining table | 115 | 79 |

Bookshelf | 160 | 42 |

Kitchen Cabinet | 70 | 67 |

Your tasks are:

- Add a new column named
`'Revenue'`

with the revenue of each item (multiply`'Price'`

and`'Sold'`

). To access columns, use the`$`

sign. - Using the
`sum()`

function, calculate the total number of items sold. Save in`items_sold`

variable and output its value. - Calculate total revenue using
`sum()`

function. Save in the`total_revenue`

variable and output its value. - Find out the average price of the sold item - divide
`total_revenue`

by`items_sold`

.

Tarefa

You will work with the data below. This data is stored in the `store`

variable.

Item | Price | Sold |

Sofa | 340 | 67 |

Armchair | 150 | 81 |

Dining table | 115 | 79 |

Bookshelf | 160 | 42 |

Kitchen Cabinet | 70 | 67 |

Your tasks are:

- Add a new column named
`'Revenue'`

with the revenue of each item (multiply`'Price'`

and`'Sold'`

). To access columns, use the`$`

sign. - Using the
`sum()`

function, calculate the total number of items sold. Save in`items_sold`

variable and output its value. - Calculate total revenue using
`sum()`

function. Save in the`total_revenue`

variable and output its value. - Find out the average price of the sold item - divide
`total_revenue`

by`items_sold`

.

Tudo estava claro?

# Data Extraction

Finish the section with practice on abstract local furniture store selling data!

Tarefa

You will work with the data below. This data is stored in the `store`

variable.

Item | Price | Sold |

Sofa | 340 | 67 |

Armchair | 150 | 81 |

Dining table | 115 | 79 |

Bookshelf | 160 | 42 |

Kitchen Cabinet | 70 | 67 |

Your tasks are:

- Add a new column named
`'Revenue'`

with the revenue of each item (multiply`'Price'`

and`'Sold'`

). To access columns, use the`$`

sign. - Using the
`sum()`

function, calculate the total number of items sold. Save in`items_sold`

variable and output its value. - Calculate total revenue using
`sum()`

function. Save in the`total_revenue`

variable and output its value. - Find out the average price of the sold item - divide
`total_revenue`

by`items_sold`

.

Tarefa

You will work with the data below. This data is stored in the `store`

variable.

Item | Price | Sold |

Sofa | 340 | 67 |

Armchair | 150 | 81 |

Dining table | 115 | 79 |

Bookshelf | 160 | 42 |

Kitchen Cabinet | 70 | 67 |

Your tasks are:

- Add a new column named
`'Revenue'`

with the revenue of each item (multiply`'Price'`

and`'Sold'`

). To access columns, use the`$`

sign. - Using the
`sum()`

function, calculate the total number of items sold. Save in`items_sold`

variable and output its value. - Calculate total revenue using
`sum()`

function. Save in the`total_revenue`

variable and output its value. - Find out the average price of the sold item - divide
`total_revenue`

by`items_sold`

.

Tudo estava claro?

# Data Extraction

Finish the section with practice on abstract local furniture store selling data!

Tarefa

You will work with the data below. This data is stored in the `store`

variable.

Item | Price | Sold |

Sofa | 340 | 67 |

Armchair | 150 | 81 |

Dining table | 115 | 79 |

Bookshelf | 160 | 42 |

Kitchen Cabinet | 70 | 67 |

Your tasks are:

- Add a new column named
`'Revenue'`

with the revenue of each item (multiply`'Price'`

and`'Sold'`

). To access columns, use the`$`

sign. - Using the
`sum()`

function, calculate the total number of items sold. Save in`items_sold`

variable and output its value. - Calculate total revenue using
`sum()`

function. Save in the`total_revenue`

variable and output its value. - Find out the average price of the sold item - divide
`total_revenue`

by`items_sold`

.

Tarefa

You will work with the data below. This data is stored in the `store`

variable.

Item | Price | Sold |

Sofa | 340 | 67 |

Armchair | 150 | 81 |

Dining table | 115 | 79 |

Bookshelf | 160 | 42 |

Kitchen Cabinet | 70 | 67 |

Your tasks are:

- Add a new column named
`'Revenue'`

with the revenue of each item (multiply`'Price'`

and`'Sold'`

). To access columns, use the`$`

sign. - Using the
`sum()`

function, calculate the total number of items sold. Save in`items_sold`

variable and output its value. - Calculate total revenue using
`sum()`

function. Save in the`total_revenue`

variable and output its value. - Find out the average price of the sold item - divide
`total_revenue`

by`items_sold`

.

Tudo estava claro?

Finish the section with practice on abstract local furniture store selling data!

Tarefa

You will work with the data below. This data is stored in the `store`

variable.

Item | Price | Sold |

Sofa | 340 | 67 |

Armchair | 150 | 81 |

Dining table | 115 | 79 |

Bookshelf | 160 | 42 |

Kitchen Cabinet | 70 | 67 |

Your tasks are:

- Add a new column named
`'Revenue'`

with the revenue of each item (multiply`'Price'`

and`'Sold'`

). To access columns, use the`$`

sign. - Using the
`sum()`

function, calculate the total number of items sold. Save in`items_sold`

variable and output its value. - Calculate total revenue using
`sum()`

function. Save in the`total_revenue`

variable and output its value. - Find out the average price of the sold item - divide
`total_revenue`

by`items_sold`

.