Refer to the weights of garbage in Data Set 1 of Appendix B. Let the dependent variable be HHSIZE (household size), and let the independent variables be those given in the exercise. (The data sets are already stored on the data disk and STATDISK.) Use software such as Excel, Minitab, or STATDISK to answer these questions:
a. Find the multiple regression equation that expresses the dependent variable HHSIZE in terms of the given independent variables.
b. Identify the values of the multiple coefficient of determination R2, the adjusted R2, and (if Excel is used) the P-value corresponding to the overall significance.
c. Does the multiple regression equation seem suitable for making predictions of household size based on the given independent variables?
METAL, PAPER, PLASTIC, GLASS, and FOOD