Please Use R to Answer the Following Questions 5. Bicyclists are crazy about weight. They will pay a lot of money to reduce the weight of their bike. A 'iend of mine who is a serious cyclist once told me that a serious cyclist would pay a price per gram to reduce the weight of their bike that was greater than the price of gold. There is data on bicycle saddles on the course web page giving the price of the saddle, the brand, the mass of the saddle in grams and the material 'om which the rails are made. A. Use the bicycle seats data available on the D2L site to estimate a linear regression of the regular price of a bicycle seat on the weight of the seat. Briey explain what the coefcient estimates mean. B. How does the explanatory power of the model change if Brand is added, if the materials from which the rails are made is added and if both are added? C. Brooks saddles are unusual and are generally favored by members of a group of extremist cyclists. How does the explanatory power of the model from part A change if Brooks saddles are excluded from the analysis? Price Brand Weight Rails 180 Fabric 182 Car 399.99 Fizik 147 Car 199.99 Fizik 199 Car 172.99 Fizik 179 Car 224.99 Fizik 179 Car 229.99 Pro 175 Car 189.99 Pro 190 Car 229.99 Pro 172 Car 229.99 Pro 172 Car 349.99 Pro 145 Car 349.99 Pro 145 Car 124.99 Prologo 129 Car 271.99 Prologo 169 Car 166.99 Prologo 189 Car 449 Selle 240 Car 599.99 SelleItalia 61 Car 399.99 SelleItalia 122 Car 449.99 Specialized 190 Car 449 .99 Specialized 190 Car 299.99 Specialized 134 Car 299.99 Specialized 149 Car 299.99 Specialized 149 Car 179.99 SQLab 157 Car 215.99 SQLab 229 Car 179.99 SQLab 157 Car 215.99 SQLab 229 Car 219.95 Terry 218 Car 190 Tioga 150 Car 224.95 WTB 165 Car 224.95 WTB 165 Car 108 Brooks 446 Chr 130 Brooks 446 Chr 130 Brooks 446 Chr 180 Brooks 1600 Chr 165 Brooks 810 Chr 126 Brooks 450 Chr 171 Brooks 490 Chr 108 Brooks 432 Chr 108 Brooks 464 Chr 108 Brooks 446 Chr 135 Brooks 510 Chr 150 Brooks 410 Chr 144 Brooks 510 Chr 119.99 Pro 231 Chr 119.99 Pro 221 Chr 119.99 Pro 229 Chr 152.99 Prologo 198 Chr 109.99 Prologo 218 Chr 99 Selle 485 Chr 239.95 Selle 350 Chr 239.95 Selle 350 Chr 239.95 Selle 280 Chr 239.95 Selle 280 Chr 249 Selle 260 Chr 54.99 SelleItalia 299 Chr 35.99 SelleRoyal 650 Chr 129.99 Specialized 247 Chr 109.95 Terry 295 Chr 42.95 WTB 292 Chr 159.99 SelleItalia 190 Man152.99 Prologo 198 Chr 109.99 Prologo 218 Chr 99 Selle 485 Chr 239.95 Selle 350 Chr 239.95 Selle 350 Chr 239.95 Selle 280 Chr 239.95 Selle 280 Chr 260 Chr 54.99 SelleItalia 299 Chr 35.99 SelleRoyal 650 Chr 129.99 Specialized 247 Chr 109.95 Terry 295 Chr 42.95 WTB 292 Chr 159.99 SelleItalia 190 Man 139.99 SelleItalia 300 Man 139.99 SelleItalia 315 Man 169.99 SelleItalia 233 Man 69.99 SelleRoyal 465 Man 139.99 Terry 258 Man 139.95 Terry 258 Man 105 Fabric 237 Ti 105 Fabric 239 Ti 105 Fabric 237 Ti 105 Fabric 239 Ti 149.99 Fizik 229 Ti 134.99 Fizik 229 Ti 149.99 Fizik 235 Ti 174.99 Fizik 200 Ti 149.99 Fizik 215 Ti 149.99 Fizik 215 Ti 149.99 Fizik 230 Ti 129.99 Fizik 238 Ti 131.5 Prologo 220 Ti 199.99 SelleItalia 280 Ti 129.99 SelleItalia 230 Ti 189.99 SelleItalia 230 Ti 299.99 SelleItalia 170 Ti 199.99 SelleItalia 330 Ti 189.99 SelleItalia 230 Ti 159.99 Specialized 243 Ti 159.99 Specialized 268 Ti 274.99 Specialized 231 Ti 159.99 Specialized 213 Ti 159.99 Specialized 268 Ti 115.95 Terry 266 Ti 189.95 Terry 268 Ti 174.95 Terry 255 Ti 199.95 Terry 235 Ti 174.95 Terry 225 Ti 189.95 Terry 268 Ti 130 Tioga 175 Ti 125 Tioga 190 Ti 128.95 WTB 208 Ti 128.95 WTB 210 Ti 116.95 WTB 193 Ti 128.95 WTB 218 Ti 144.95 WTB 193 Ti 128.95 WTB 239 Ti 128.95 WTB 210 Ti 116.95 WTB 193 Ti