Download the dataset advertising.csv. This dataset includes sales data, as well as the budget for TV, Radio and Newspaper advertising. We are interested in predicting sales given a certain budget. a. (12 mark) Read in the dataset into a dataframe called advertising. b. (12 mark) Display the last 15 elements of the dataframe. C. (1 mark) Create three scatterplots showing the relationship of Sales with the other 3 variables. Use plot(). d. (2 marks) Create a linear model using TV to explain Sales. e. (1/2 mark) Print out the summary table of the linear model. f. (1 mark) Plot the linear model onto the graph of Sales and TV. Make the colour of the line red. TV 19.6 2.6 8.6 65.9 9.2 39.6 Radio Newspaper Sales 230.1 37.8 69.2 22.1 44.5 39.3 45.1 10.4 17.2 45.9 69.3 9.3 151.5 41.3 58.5 18.5 180.8 10.8 58.4 12.9 8.7 48.9 75 7.2 57.5 32.8 23.5 11.8 120.2 11.6 13.2 8.6 2.1 4.8 199.8 21.2 10.6 66.1 5.8 24.2 214.7 24 4 17.4 23.8 35.1 97.5 7.6 7.2 9.7 204.1 32.9 46 19 195.4 47.7 52.9 22.4 67.8 36.6 114 12.5 281.4 55.8 24.4 69.2 18.3 11.3 147.3 23.9 19.1 14.6 218.4 27.7 53.4 237.4 23.5 12.5 13.2 15.9 49.6 5.6 228.3 16.9 26.2 15.5 62.3 12.6 18.3 262.9 3.5 19.5 142.9 29.3 12.6 240.1 16.7 22.9 15.9 248.8 27.1 22.9 18.9 70.6 16 40.8 10.5 292.9 28.3 43.2 21.4 112.9 17.4 38.6 11.9 97.2 30 9.6 265.6 0.3 17.4 95.7 7.4 290.7 4.1 8.5 12.8 266.9 43.8 25.4 20.5 18 5.1 9.7 12 15 1.5 20 1.4 9.5



Answer :