(18) 3. bozeman electric company is studying the relationship between household electric usage (kwh 000's) and number of rooms in single-family homes. a random sample of 10 customers yielded the following. electric usage (y) number of rooms (x) (kwh 000's) 12 9 9 7 14 10 6 5 10 8 8 2 10 8 10 10 5 4 7 7 (a) construct a scatterplot in excel and provide a full evaluation. (b) compute the correlation coefficient using the excel function and interpret? (c) based on your results in parts a