A random sample of 135 artworks created within the last three years and sold at auction has been selected to study art auction price and prior exhibition. Some of the variables recorded for each artwork are listed below.

Variable Description subid Subject ID medium type of artwork exhibWeeks the number of weeks the artwork was exhibited before the auction price sale price (in thousands) Import the data set included in the file sample.csv in Excel. To do this, you need to click on the link above and save the data file in a convenient location on your PC (in your browser, File and Save). Next open Excel, click File in the Menu, select Open and navigate to the file you previously saved – or simply double-click on it, Excel should open automatically. Use Excel and/or probTool, and appropriate hypothesis tests, to address the following research question. Assume all the test assumptions are verified.

Research question: Can linear regression be used to predict sale price (in thousands) from the number of weeks the artwork was exhibited before the auction?

Report the value of the estimated slope [use at least 4dp]: Report the value of the test statistic [use at least 2dp]: Report the p -value [use at least 3dp]: What percentage of the variation in the response variable cannot be explained by the model? Please report a number between 0 and 100 [use at least 1dp]. What is the decision of the test?