+1443 776-2705 panelessays@gmail.com
  

Please find the attached

Assignment 1

Total points: 100

Spring 2022 MSIS 672

Deadline: Feb. 27 Sunday Midnight. Cutoff day: March 2 Wed midnight

Please submit the R code to Blackboard. The extension of a R file is .R

You can either work with a team or by yourself. Each team can have up to three people. Each team only needs to submit one copy. Please make sure to write all team members’ names when submitting it.

Chapter 2

You are given two data sets, i.e., ToyotaCorolla.csv and RidingMowers.csv. Please download them and complete the following questions

Attention: Please download data files to your locate drive. Please follow the steps described right before Table 2.3 P. 24 to set the working directory to where you saved the data file.

1). please using
ToyotaCorolla.csv
data set to complete the following steps using R

1.1) Please read the data and create a data frame for the data set

1.2) Please list all attributes (columns)

1.3) Please list the dimension of the data frame

1.4) Please show the data of the column of “Price”

1.5) Please list the summary statistics for each column

1.6) Please follow the R code in Table 2.9 (or alternative ways in R code) to prepare the dataset by creating partitions of training 50% and validation 50%

2) please using
RidingMowers.csv

data set to complete the following steps using R

2.1) explore data and get to know attributes (hint: Chapter 2)

a. The names of each column

b. The variable types of each column

2.2) create a scatter plot of Lot Size vs. Income (hint: figure 3.1 ## scatter plot)

2.3) create a histogram for Lot_Size (hint: figure 3.2)

Income Lot_Size Ownership
60 18.4 Owner
85.5 16.8 Owner
64.8 21.6 Owner
61.5 20.8 Owner
87 23.6 Owner
110.1 19.2 Owner
108 17.6 Owner
82.8 22.4 Owner
69 20 Owner
93 20.8 Owner
51 22 Owner
81 20 Owner
75 19.6 Nonowner
52.8 20.8 Nonowner
64.8 17.2 Nonowner
43.2 20.4 Nonowner
84 17.6 Nonowner
49.2 17.6 Nonowner
59.4 16 Nonowner
66 18.4 Nonowner
47.4 16.4 Nonowner
33 18.8 Nonowner
51 14 Nonowner
63 14.8 Nonowner

Id Model Price Age_08_04 Mfg_Month Mfg_Year KM Fuel_Type HP Met_Color Color Automatic CC Doors Cylinders Gears Quarterly_Tax Weight Mfr_Guarantee BOVAG_Guarantee Guarantee_Period ABS Airbag_1 Airbag_2 Airco Automatic_airco Boardcomputer CD_Player Central_Lock Powered_Windows Power_Steering Radio Mistlamps Sport_Model Backseat_Divider Metallic_Rim Radio_cassette Parking_Assistant Tow_Bar
1 TOYOTA Corolla 2.0 D4D HATCHB TERRA 2/3-Doors 13500 23 10 2002 46986 Diesel 90 1 Blue 0 2000 3 4 5 210 1165 0 1 3 1 1 1 0 0 1 0 1 1 1 0 0 0 1 0 0 0 0
2 TOYOTA Corolla 2.0 D4D HATCHB TERRA 2/3-Doors 13750 23 10 2002 72937 Diesel 90 1 Silver 0 2000 3 4 5 210 1165 0 1 3 1 1 1 1 0 1 1 1 0 1 0 0 0 1 0 0 0 0
3  TOYOTA Corolla 2.0 D4D HATCHB TERRA 2/3-Doors 13950 24 9 2002 41711 Diesel 90 1 Blue 0 2000 3 4 5 210 1165 1 1 3 1 1 1 0 0 1 0 0 0 1 0 0 0 1 0 0 0 0
4 TOYOTA Corolla 2.0 D4D HATCHB TERRA 2/3-Doors 14950 26 7 2002 48000 Diesel 90 0 Black 0 2000 3 4 5 210 1165 1 1 3 1 1 1 0 0 1 0 0 0 1 0 0 0 1 0 0 0 0
5 TOYOTA Corolla 2.0 D4D HATCHB SOL 2/3-Doors 13750 30 3 2002 38500 Diesel 90 0 Black 0 2000 3 4 5 210 1170 1 1 3 1 1 1 1 0 1 0 1 1 1 0 1 0 1 0 0 0 0
6 TOYOTA Corolla 2.0 D4D HATCHB SOL 2/3-Doors 12950 32 1 2002 61000 Diesel 90 0 White 0 2000 3 4 5 210 1170 0 1 3 1 1 1 1 0 1 0 1 1 1 0 1 0 1 0 0 0 0
7  TOYOTA Corolla 2.0 D4D 90 3DR TERRA 2/3-Doors 16900 27 6 2002 94612 Diesel 90 1 Grey 0 2000 3 4 5 210 1245 0 1 3 1 1 1 1 0 1 0 1 1 1 0 0 1 1 0 0 0 0
8 TOYOTA Corolla 2.0 D4D 90 3DR TERRA 2/3-Doors 18600 30 3 2002 75889 Diesel 90 1 Grey 0 2000 3 4 5 210 1245 1 1 3 1 1 1 1 0 1 1 1 1 1 0 0 0 1 0 0 0 0
9  TOYOTA Corolla 1800 T SPORT VVT I 2/3-Doors 21500 27 6 2002 19700 Petrol 192 0 Red 0 1800 3 4 5 100 1185 0 1 3 1 1 0 1 0 0 0 1 1 1 1 0 0 0 1 1 0 0
10  TOYOTA Corolla 1.9 D HATCHB TERRA 2/3-Doors 12950 23 10 2002 71138 Diesel 69 0 Blue 0 1900 3 4 5 185 1105 0 1 3 1 1 1 1 0 1 0 0 0 1 0 0 0 1 0 0 0 0
11 TOYOTA Corolla 1.8 VVTL-i T-Sport 3-Drs 2/3-Doors 20950 25 8 2002 31461 Petrol 192 0 Silver 0 1800 3 4 6 100 1185 1 1 12 1 1 1 1 1 0 1 1 1 1 0 0 0 0 1 0 0 0
12 TOYOTA Corolla 1.8 16V VVTLI 3DR T SPORT BNS 2/3-Doors 19950 22 11 2002 43610 Petrol 192 0 Red 0 1800 3 4 6 100 1185 1 1 3 1 1 1 1 1 1 0 1 1 1 0 1 1 1 1 0 0 0
13 TOYOTA Corolla 1.8 16V VVTLI 3DR T SPORT 2/3-Doors 19600 25 8 2002 32189 Petrol 192 0 Red 0 1800 3 4 6 100 1185 1 1 3 1 1 1 1 1 1 0 1 1 1 0 1 1 1 1 0 0 0
14 TOYOTA Corolla 1.8 16V VVTLI 3DR T SPORT 2/3-Doors 21500 31 2 2002 23000 Petrol 192 1 Black 0 1800 3 4 6 100 1185 1 1 3 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 0 0 0
15 TOYOTA Corolla 1.8 16V VVTLI 3DR T SPORT 2/3-Doors 22500 32 1 2002 34131 Petrol 192 1 Grey 0 1800 3 4 6 100 1185 1 1 3 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 0 0 0
16 TOYOTA Corolla 1.8 16V VVTLI 3DR T SPORT 2/3-Doors 22000 28 5 2002 18739 Petrol 192 0 Grey 0 1800 3 4 6 100 1185 0 1 3 1 1 1 1 1 1 0 1 1 1 0 1 1 1 1 0 0 0
17  TOYOTA Corolla 1.8 16V VVTLI 3DR T SPORT 2/3-Doors 22750 30 3 2002 34000 Petrol 192 1 Grey 0 1800 3 4 5 100 1185 0 1 3 1 1 1 1 1 1 1 1 1 1 0 1 0 1 1 0 0 0
18  TOYOTA Corolla 1.6 VVTI Linea Terra Comfort 2/3-Doors 17950 24 9 2002 21716 Petrol 110 1 Blue 0 1600 3 4 5 85 1105 0 0 18 1 1 0 1 0 0 0 1 1 1 1 0 0 0 0 1 0 1
19 TOYOTA Corolla 1.6 16v L.SOL 2/3-Doors 16750 24 9 2002 25563 Petrol 110 0 Grey 0 1600 3 4 5 19 1065 0 0 3 1 1 1 1 1 1 1 1 1 1 0 1 0 0 0 0 0 0
20 TOYOTA Corolla 1.6 16V VVT I 3DR TERRA 2/3-Doors 16950 30 3 2002 64359 Petrol 110 1 Grey 0 1600 3 4 5 85 1105 1 1 3 1 1 1 1 0 1 1 1 1 1 0 0 1 1 0 0 0 0
21  TOYOTA Corolla 1.6 16V VVT I 3DR TERRA 2/3-Doors 15950 30 3 2002 67660 Petrol 110 1 Blue 0 1600 3 4 5 85 1105 1 1 3 1 1 1 1 0 1 1 1 1 1 0 0 1 1 0 0 0 1
22 TOYOTA Corolla 1.6 16V VVT I 3DR SOL AUT4 2/3-Doors 16950 29 4 2002 43905 Petrol 110 0 Grey 1 1600 3 4 5 100 1170 0 1 3 1 1 1 1 1 1 0 1 1 1 0 1 1 1 0 0 0 0
23 TOYOTA Corolla 1.6 16V VVT I 3DR SOL 2/3-Doors 15950 28 5 2002 56349 Petrol 110 1 Black 0 1600 3 4 5 85 1120 0 1 3 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 0 0 1
24  TOYOTA Corolla 1.6 16V VVT I 3DR SOL 2/3-Doors 16950 28 5 2002 32220 Petrol 110 1 Black 0 1600 3 4 5 85 1120 1 1 3 1 1 1 1 1 1 1 1 1 1 0 1 1 1 0 0 0 0
25 TOYOTA Corolla 1.6 16V VVT I 3DR SOL 2/3-Doors 16250 29 4 2002 25813 Petrol 110 1 Grey 0 1600 3 4 5 85 1120 1 1 3 1 1 1 1 1 1 1 1 1 1 0 1 1 1 0 0 0 0
26 TOYOTA Corolla 1.6 16V VVT I 3DR SOL 2/3-Doors 15950 25 8 2002 28450 Petrol 110 1 Blue 0 1600 3 4 5 85 1120 0 1 3 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 0 0 1
27  TOYOTA Corolla 1.6 16V VVT I 3DR SOL 2/3-Doors 17495 27 6 2002 34545 Petrol 110 1 Blue 0 1600 3 4 5 85 1120 1 1 3 1 1 1 1 1 1 1 1 1 1 0 1 0 1 1 0 0 0
28 TOYOTA Corolla 1.6 16V VVT I 3DR SOL 2/3-Doors 15750 29 4 2002 41415 Petrol 110 1 Black 0 1600 3 4 5 85 1120 1 1 3 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 0 0 0
29 TOYOTA Corolla 1.6 16V VVT I 3DR SOL 2/3-Doors 16950 28 5 2002 44142 Petrol 110 0 Grey 0 1600 3 4 5 85 1120 1 1 3 1 1 1 1 1 1 0 1 1 1 0 1 1 1 0 0 0 0
30 TOYOTA Corolla 1.6 16V VVT I 3DR SOL 2/3-Doors 17950 30 3 2002 11090 Petrol 110 1 Blue 0 1600 3 4 5 85 1120 1 1 3 1 1 1 1 1 1 1 1 1 1 0 1 1 1 0 0 0 0
31  TOYOTA Corolla 1.4 VVTI Linea Terra 2/3-Doors 12950 29 4 2002 9750 Petrol 97 1 Silver 0 1400 3 4 5 19 1100 1 1 12 1 1 0 0 0 0 0 0 0 1 1 0 0 0 0 1 0 0
32 TOYOTA Corolla 1.4 16V VVT I 3DR TERRA COMFORT 2/3-Doors 15750 22 11 2002 35199 Petrol 97 1 Blue 0 1400 3 4 5 85 1100 1 1 3 1 1 1 1 0 1 1 1 1 1 0 0 1 1 1 0 0 1
33 TOYOTA Corolla 1.4 16V VVT I 3DR TERRA COMFORT 2/3-Doors 15950 27 6 2002 29510 Petrol 97 1 Black 0 1400 3 4 5 85 1100 1 1 3 1 1 1 1 0 1 0 1 1 1 0 0 1 1 0 0 0 0
34  TOYOTA Corolla 1.4 16V VVT I 3DR TERRA COMFORT 2/3-Doors 14950 26 7 2002 32692 Petrol 97 1 Grey 0 1400 3 4 5 85 1100 0 1 3 1 1 1 1 0 1 0 1 1 1 0 0 1 1 0 0 0 0
35  TOYOTA Corolla 1.4 16V VVT I 3DR TERRA COMFORT 2/3-Doors 15500 22 11 2002 41000 Petrol 97 1 Grey 0 1400 3 4 5 85 1100 0 0 3 1 1 1 1 0 1 1 1 1 1 0 0 1 1 0 0 0 0
36 TOYOTA Corolla 1.4 16V VVT I 3DR TERRA COMFORT 2/3-Doors 15750 26 7 2002 43000 Petrol 97 0 Grey 0 1400 3 4 5 85 1100 1 1 3 1 1 1 1 0 1 1 1 1 1 0 0 1 1 0 0 0 0
37 TOYOTA Corolla 1.4 16V VVT I 3DR TERRA COMFORT 2/3-Doors 15950 25 8 2002 25000 Petrol 97 0 Grey 0 1400 3 4 5 85 1100 0 1 3 1 1 1 1 0 1 1 1 1 1 0 0 1 1 0 0 0 0
38 TOYOTA Corolla 1.4 16V VVT I 3DR TERRA 2/3-Doors 14950 23 10 2002 10000 Petrol 97 1 Blue 0 1400 3 4 5 85 1100 1 1 3 1 1 1 0 0 1 0 1 1 1 0 0 1 1 0 0 0 0
39 TOYOTA Corolla 1.4 16V VVT I 3DR TERRA 2/3-Doors 15750 32 1 2002 25329 Petrol 97 1 Green 0 1400 3 4 5 85 1100 1 1 3 1 1 1 1 0 1 1 1 1 1 0 0 1 1 0 0 0 0
40  TOYOTA Corolla 1.4 16V VVT I 3DR 2/3-Doors 14750 27 6 2002 27500 Petrol 97 0 Blue 0 1400 3 4 5 85 1100 1 1 3 1 1 1 0 0 1 0 0 0 1 0 0 1 1 0 0 0 0
41  TOYOTA Corolla 1.4 16V VVT I 3DR 2/3-Doors 13950 22 11 2002 49059 Petrol 97 0 Blue 0 1400 3 4 5 85 1100 0 1 3 1 1 1 0 0 1 0 0 0 1 0 0 1 1 0 0 0 0
42 TOYOTA Corolla 1.4 16V VVT I 3DR 2/3-Doors 16750 27 6 2002 44068 Petrol 97 1 Red 0 1400 3 4 5 85 1100 1 1 3 1 1 1 1 0 1 1 1 1 1 0 0 1 1 0 0 0 0
43 TOYOTA Corolla 1.4 16V VVT I 3DR 2/3-Doors 13950 22 11 2002 46961 Petrol 97 0 Blue 0 1400 3 4 5 85 1100 1 1 3 1 1 1 0 0 1 0 0 0 1 0 0 1 1 0 0 0 0
44 TOYOTA Corolla 2.0 D4D 90 5DR TERRA COMFORT 4/5-Doors 16950 27 6 2002 110404 Diesel 90 0 Red 0 2000 5 4 5 234 1255 1 1 3 1 1 1 1 0 1 0 1 1 1 0 0 1 1 0 0 0 0
45 TOYOTA Corolla 2.0 D4D 90 5DR TERRA COMFORT 4/5-Doors 16950 22 11 2002 100250 Diesel 90 0 Red 0 2000 5 4 5 234 1255 1 1 3 1 1 1 1 0 1 0 1 1 1 0 0 1 1 0 0 0 0
46  TOYOTA Corolla 2.0 D4D 90 5DR SOL 4/5-Doors 19000 23 10 2002 84000 Diesel 90 0 Red 0 2000 5 4 5 234 1270 0 1 3 1 1 1 1 1 1 0 1 1 1 0 0 0 1 0 0 0 0
47 TOYOTA Corolla 2.0 D4D 90 5DR TERRA 4/5-Doors 17950 27 6 2002 79375 Diesel 90 1 Grey 0 2000 5 4 5 234 1255 0 1 3 1 1 1 1 0 1 1 1 1 1 0 0 1 1 0 0 0 0
48 TOYOTA Corolla 1.4 16V VVT I 5DR TERRA COMFORT 4/5-Doors 15800 22 11 2002 75048 Petrol 97 1 Blue 0 1400 5 4 5 85 1110 0 1 3 1 1 1 1 0 1 1 1 1 1 0 0 1 1 0 0 0 1
49  TOYOTA Corolla 2.0 D4D 90 5DR TERRA COMFORT 4/5-Doors 17950 22 11 2002 72215 Diesel 90 1 Grey 0 2000 5 4 5 234 1255 1 1 3 1 1 1 1 0 1 0 1 1 1 0 0 1 1 0 0 0 0
50 TOYOTA Corolla 1.8 16V VVTLI 5DR T SPORT 4/5-Doors 21950 31 2 2002 64982 Petrol 192 1 Grey 0 1800 5 4 6 100 1195 1 1 3 1 1 1 1 1 1 0 1 1 1 0 1 1 1 1 0 0 0
51 TOYOTA Corolla 2.0 D4D 90 5DR TERRA COMFORT 4/5-Doors 17950 22 11 2002 62636 Diesel 90 1 Grey 0 2000 5 4 5 234 1255 1 1 3 1 1 1 1 0 1 1 1 1 1 0 0 1 1 0 0 0 0
52  TOYOTA Corolla 1.4 16V VVT I 5DR TERRA 4/5-Doors 15750 30 3 2002 57086 Petrol 97 1 Grey 0 1400 5 4 5 85 1110 0 1 3 1 1 1 1 0 1 1 1 1 1 0 0 0 1 1 0 0 0
53 TOYOTA Corolla 1.6 16V VVT I 5DR SOL AUT4 4/5-Doors 20500 26 7 2002 56000 Petrol 110 1 Blue 1 1600 5 4 5 100 1180 1 1 3 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 0 0 0
54 TOYOTA Corolla 1.8 VVTL-i T-Sport 4/5-Doors 21950 27 6 2002 49866 Petrol 192 1 Green 0 1800 5 4 5 100 1195 0 1 13 1 1 0 1 0 0 0 1 1 1 1 0 0 0 1 1 0 0
55  TOYOTA Corolla 1.6 16V VVT I 5DR TERRA AUT4 4/5-Doors 15500 25 8 2002 49163 Petrol 110 0 Green 1 1600 5 4 5 100 1165 0 1 3 1 1 1 0 0 1 1 0 0 1 0 0 1 1 0 0 0 0
56  TOYOTA Corolla 1.6 16V VVT I LIFTB LUNA 4/5-Doors 13250 32 1 2002 45725