Question: please use excel for answer 1. The electric power consumed each month by a chemical plant is thought to be related to the average ambient

please use excel for answer
please use excel for answer 1. The electric power
1. The electric power consumed each month by a chemical plant is thought to be related to the average ambient temperature (xi), the number of days in the month (x2) and the tons of product produced (xs). The past years historical data are available and are presented in the following table: y 240 236 270 274 301 316 300 296 267 276 288 261 Xi 30 31 45 60 65 72 80 84 75 60 50 38 X2 24 25 24 25 25 26 25 25 24 25 25 23 100 95 110 88 94 105 97 100 110 105 100 198 3.) Fit a multiple linear regression model for electricity consumption and analyze the adequacy of the model using the coefficient of determination (R'). b.) Predict the monthly electricity consumption of the plant when x: - 24C, X3 - 24 days and x 90 tons c.) Construct the correlation matrix including four variables (electricity consumption, the average ambient temperature, the number of days in the month, the tons of product produced) and interpret the correlation coefficients between the variables

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!