A recruiter for Big Box stores has collected the data in the file BigBox.xlsx summarizing the amount of money the company spent on print, web, and TV advertising in California over the past $22$ months and the resulting number of applications received from job applicants during the same months. The recruiter would like to build a regression model to predict the number of applications the company should expect based on a given advertising mix.

$1)$Prepare scatter plots showing the relationship between the number of applications received and each of the independent variables. What sort of relationship does each plot suggest?

$2)$If the recruiter wanted to build a regression model using only one independent variable to predict the number of applications received, what variable should be used?

SHOW IN THE EXCEL PLEASE