Hello, I need help with Part D, specifically with finding F. Here is the data. I have been using stat crunch but I can't figure out how to get the answer. please help explain. Thank you

Transfer_Time_(sec) File_Size_(MB) Hours_past_8 18.4 22 0 22.4 22 0.0625 11.7 22 0.125 23.5 22 0.1875 16.2 23 0.25 12.1 23 0.3125 15.8 26 0.375 9.9 26 0.4375 15.1 26 0.5 16.6 26 0.5625 12.9 27 0.625 18.0 27 0.6875 16.7 29 0.75 17.7 29 0.8125 19.5 29 0.875 9.1 29 0.9375 15.4 29 1 15.0 29 1.0625 11.3 30 1.125 12.7 30 1.1875 20.9 31 1.25 19.9 31 1.3125 15.8 31 1.375 10.5 31 1.4375 17.8 31 1.5 26.4 31 1.5625 16.6 39 1.625 21.9 39 1.6875 18.5 40 1.75 25.9 40 1.8125 24.5 50 1.875 11.2 50 1.9375 25.2 52 2 15.4 52 2.0625 23.1 54 2.125 27.4 54 2.1875 20.9 54 2.25 38.3 54 2.3125 23.8 56 2.375 27.3 56 2.4375 19.3 59 2.5 35.2 59 2.5625 20.4 59 2.625 24.6 59 2.6875 21.8 60 2.75 20.6 60 2.8125 17.4 60 2.875 31.9 60 2.9375 22.4 63 3 25.9 63 3.0625 25.9 64 3.125 32.1 64 3.1875 22.6 71 3.25 37.4 71 3.3125 25.3 73 3.375 19.1 73 3.4375 25.4 74 3.5 41.1 74 3.5625 28.9 75 3.625 32.3 75 3.6875 28.3 86 3.75 43.8 86 3.8125 25.4 89 3.875 43.4 89 3.9375 33.4 89 4 49.9 89 4.0625 28.6 89 4.125 45.8 89 4.1875 28.5 90 4.25 32.7 90 4.3125 35.6 91 4.375 45.6 91 4.4375 24.5 93 4.5 41.2 93 4.5625 33.3 95 4.625 35.6 95 4.6875 31.4 98 4.75 43.1 98 4.8125 35.5 99 4.875 52.6 99 4.9375

Before purchasing videoconferencing equipment, a company tested its current internal computer network. The tests measured how rapidly data moved through its network given the current demand on the network. Eighty files ranging in size from 20 to 100 megabytes (MB) were transmitted over the network at various times of day, and the time to send the files (in seconds) recorded. In the accompanying data, the time is given as the number of hours past 8 A.M. on the day of the test. Use the transfer time as the response, with the file size and time of day as explanatory variables. Complete parts (a) through (f) below. Click the icon to view the network transmission data. (Round all coefficients and standard errors to two decimal places. Round all test statistics to two decimal places. Round all probabilities to three decimal places.) Term Estimate Std Error t-statistic p-value Intercept 7.13 2.89 2.47 0.016 File Size (MB) 0.32 0.18 1.80 0.075 Hours past 8 -0.20 3.16 -0.06 0.950 (c) Does the fit of this model meet the conditions of the MRM? Select all that apply. A. No, because File Size and Hours past 8 are not independent. B. No, because there is a distinct pattern in the residuals. C. No, because the residuals are not normal. D. Yes, all of the conditions are satisfied. (d) Compare the sizes of the t-statistics of the fitted model to the overall F-statistic. Do these tests agree with each other? with each other because the overall F-statistic of F = 0 IS at a= 0.05, which is These tests (Round to two decimal places as needed.) true of the t-statistics. Enter your answer in the answer boy and then click Check Answer Before purchasing videoconferencing equipment, a company tested its current internal computer network. The tests measured how rapidly data moved through its network given the current demand on the network. Eighty files ranging in size from 20 to 100 megabytes (MB) were transmitted over the network at various times of day, and the time to send the files (in seconds) recorded. In the accompanying data, the time is given as the number of hours past 8 A.M. on the day of the test. Use the transfer time as the response, with the file size and time of day as explanatory variables. Complete parts (a) through (f) below. Click the icon to view the network transmission data. (b) Assuming that a multiple regression is appropriate, fit the multiple regression of the transfer time on the file size and the time of day. Summarize the estimates obtained for the fitted model. The fit has R2 = 0.62 and se = 6.28 (Round to two decimal places as needed.) Complete the table below. (Round all coefficients and standard errors to two decimal places. Round all test statistics to two decimal places. Round all probabilities to three decimal places.) Term Estimate Std Error t-statistic p-value Intercept 7.13 2.89 2.47 0.016 File Size (MB) 0.32 0.18 1.80 0.075 Hours past 8 -0.20 3.16 -0.06 0.950 (c) Does the fit of this model meet the conditions of the MRM? Select all that apply. A. No, because File Size and Hours past 8 are not independent. B. No, because there is a distinct pattern in the residuals. EXC. No, because the residuals are not normal. D Yes all of the conditions are satisfied Before purchasing videoconferencing equipment, a company tested its current internal computer network. The tests measured how rapidly data moved through its network given the current demand on the network. Eighty files ranging in size from 20 to 100 megabytes (MB) were transmitted over the network at various times of day, and the time to send the files (in seconds) recorded. In the accompanying data, the time is given as the number of hours past 8 A.M. on the day of the test. Use the transfer time as the response, with the file size and time of day as explanatory variables. Complete parts (a) through (f) below. Click the icon to view the network transmission data. (Round all coefficients and standard errors to two decimal places. Round all test statistics to two decimal places. Round all probabilities to three decimal places.) Term Estimate Std Error t-statistic p-value Intercept 7.13 2.89 2.47 0.016 File Size (MB) 0.32 0.18 1.80 0.075 Hours past 8 -0.20 3.16 -0.06 0.950 (c) Does the fit of this model meet the conditions of the MRM? Select all that apply. A. No, because File Size and Hours past 8 are not independent. B. No, because there is a distinct pattern in the residuals. C. No, because the residuals are not normal. D. Yes, all of the conditions are satisfied. (d) Compare the sizes of the t-statistics of the fitted model to the overall F-statistic. Do these tests agree with each other? with each other because the overall F-statistic of F = 0 IS at a= 0.05, which is These tests (Round to two decimal places as needed.) true of the t-statistics. Enter your answer in the answer boy and then click Check Answer Before purchasing videoconferencing equipment, a company tested its current internal computer network. The tests measured how rapidly data moved through its network given the current demand on the network. Eighty files ranging in size from 20 to 100 megabytes (MB) were transmitted over the network at various times of day, and the time to send the files (in seconds) recorded. In the accompanying data, the time is given as the number of hours past 8 A.M. on the day of the test. Use the transfer time as the response, with the file size and time of day as explanatory variables. Complete parts (a) through (f) below. Click the icon to view the network transmission data. (b) Assuming that a multiple regression is appropriate, fit the multiple regression of the transfer time on the file size and the time of day. Summarize the estimates obtained for the fitted model. The fit has R2 = 0.62 and se = 6.28 (Round to two decimal places as needed.) Complete the table below. (Round all coefficients and standard errors to two decimal places. Round all test statistics to two decimal places. Round all probabilities to three decimal places.) Term Estimate Std Error t-statistic p-value Intercept 7.13 2.89 2.47 0.016 File Size (MB) 0.32 0.18 1.80 0.075 Hours past 8 -0.20 3.16 -0.06 0.950 (c) Does the fit of this model meet the conditions of the MRM? Select all that apply. A. No, because File Size and Hours past 8 are not independent. B. No, because there is a distinct pattern in the residuals. EXC. No, because the residuals are not normal. D Yes all of the conditions are satisfied