1) The production of wine is a multibillion-dollar worldwide industry. In an attempt to develop a model of wine quality as judged by wine experts, data was collected from red wine variants of Portuguese "Vinho Verde" wine. A sample of 50 wines is stored in "Wine Data.xlsx" file. Develop a multiple linear regression model to predict wine quality measured on a scale from 0 (very bad) to 10 (excellent) based on alcohol content (%) and the amount of chlorides. (a) State the multiple regression equation (b) Interpret the meaning of the coefficients B1 and B2, in this problem. (c) What is the significance of Bo? (d) Predict the mean wine quality rating for wines that have 10% alcohol and chlorides of 0.08. 2- The business problem facing the director of broadcasting operations for a television station was the issue of standby hours and what factors were related to standby hours. The study included the following variables: Standby hours (Y) - Total number of standby hours in a week Weekly staff count (X1) - Weekly total of people-days Remote engineering hours (X2) - Total number of engineering hours worked by employees at locations away from the central plant Data were collected for 26 weeks. These data are organized and stored in 26 Weeks.xlsx" file. (a) State the multiple regression equation (b) Interpret the meaning of the coefficients B and Be in this problem. (c) What is the significance of Bo? (d) Predict the mean standby hours for a week in which the weekly staff count was 310 people-days and the remote e DC ed d! of