Use R script to solve the following problem:

Problem: The amount of water used by the production facilities of a plant varies. Observations on water usage and other, possibility related, variables were collected for 250 months. The data are given in water.csv file. The explanatory variables are

TEMP= average monthly temperature (degree celsius)

PROD=amount of production (in hundreds of cubic)

DAYS=number of operationing day in the month (days)

HOUR=number of hours shut down for maintenance (hours)

The response variable is USAGE=monthly water usage (gallons/minute)

a. Test the hypothesis for the full model i.e the test of overall significance. Use significance level 0.05. Ensure that you include the hypotheses, p-value, and conclusion.

b. Would you suggest the model in part a for predictive purposes? Which model or set of models would you suggest for predictive purposes? Hint: Use Individual Coefficients Test (t-test) to find the best model. Make sure you provide your hypotheses, p-value(s), and final model.)