Description

Use the Cars data set in the SP4R library to complete this exercise.

1. Creating and Row-Binding Data Tables
a. Create a new data table called sports, which has only three columns from the Cars data set:
make, type, and msrp. In addition, keep only those observations where type is equal to sports and msrp is greater than $100,000.
b. Create another data table called suv, which has the same three columns. In addition, keep only those observations where type is equal to suv and msrp is greater than $60,000.
c. Create a new data table called expensive by row-binding sports and suv. Then print expensive to see the results.
Obs Make Type MSRP

1 Mercedes-Benz Sports $121,770
2 Mercedes-Benz Sports $126,670
3 Porsche Sports $192,465
4 Land Rover SUV $72,250
5 Lexus SUV $64,800
6 Mercedes-Benz SUV $76,870