A suburban hotel derives its revenue from its hotel and restaurant operations. The owners are interested in the relationship between the number of rooms occupied on a nightlyI basis and the revenue per day in the restaurant. Following is a sample of 25 days [Monday through Thursday} from last year showing the restaurant income and number of rooms occupied. IO points Day Revenue Occupied Day Revenue Occupied 1 $ 1,452 50 14 $ 1,425 31 2 1, 351 20 15 1,445 51 3 1,426 21 16 1,439 62 El 4 1,4?8 30 17 1, 348 45 mm 5 1,456 70 13 1,458 41 5 1,438 29 19 1,431 62 7 1 , 3 54 30 26 1 , 446 4? 3 1,442 21 21 1,435 43 pm 9 1,394 15 22 1,405 38 18 1,459 36 23 1,461 36 11 1, 399 41 24 1,498 38 if. 12 1,453 35 25 1,425 65 References 13 11537 51 BpictureClick here for the Excel Data File e. Choose the scatter diagram that best fits the data. Scatter diagram 1 Scatter diagram 2 Scatter diagram 3 Scatter diagram 1 O Scatter diagram 2 O Scatter diagram 3 b. Determine the coefcient ofcorrelation between the two variables. [Round your answer to 3 decimal pieces.) _:I c-1. State the decision rule for 0.01 significance level: He: p = 0; Hj: p > 0. (Round your answer to 3 decimal places.) Reject Ho if t > 10 points eBook c-2. Compute the value of the test statistic. (Round your answer to 2 decimal places.) Print Value of the test statistic References c-3. Is it reasonable to conclude that there is a positive relationship between revenue and occupied rooms? Use the 0.01 significance level. Ho. There is between revenue and occupied rooms d. What percent of the variation in revenue in the restaurant is accounted for by the number of rooms occupied? (Round your answer to 1 decimal place.) % of the variation in revenue is explained by variation in occupied rooms