pls provide the full and correct answers
A company ran tests of its current internal computer network. Thirty 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 recorded, as shown in the accompanying data table. Formulate the simple linear regression with Y given by Transfer Time and X given by File Size. Complete parts (a) through (f) below. Click the icon to view the data table of file sizes and transfer times. Use Excel to conduct a simple linear regression analysis and answer the following questions. Find the value of the test statistic t associated with B1 . t= 18.98 (Round to two decimal places as needed.) Find the p-value for this test. p-value = (Round to four decimal places as needed.) Determine whether the correlation between file size and transfer time differs significantly from zero, or whether there is a significant linear relationship between file size and transfer time. Choose the correct answer below. O A. Reject Ho. There is sufficient evidence that the correlation between file size and transfer time is not zero. O B. Do not reject Ho. There is sufficient evidence that the correlation between file size and transfer time is not zero. O C. Reject Ho. There is insufficient evidence that the correlation between file size and transfer time is not zero. O D. Do not reject Ho. There is insufficient evidence that the correlation between file size and transfer time is not zero. Click to select your answer(s) and then click Check Answer.\fA company ran tests of its current internal computer network. Thirty 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 recorded, as shown in the accompanying data table. Formulate the simple linear regression with Y given by Transfer Time and X given by File Size. Complete parts (a) through (f) below. Click the icon to view the data table of file sizes and transfer times. (c) Estimate the average "setup" time to start the file transfer. This time is used to synchronize the computers making the transfer and is unrelated to file size. Use a confidence level of 95%. The average setup time is 23.07 to 27.46 seconds. (Round to one decimal place as needed.) d) Estimate the average change in transfer time when the size of a file is reduced by 1-MB. Use a confidence level of 95%. The average transfer time is O increased O decreased by to seconds. (Round to three decimal places as needed. Use ascending order.) (e) To speed transfers, the company introduced compression software that halves the size of a file when sent over the network. On average, what is the improvement in time when sending a 50-MB file (note that the file starts at 50-MB)? Use a confidence level of 95% to state your answer as a range. On average, the improvement in time is to seconds. (Round to one decimal place as needed. Use ascending order.) (f) Is the simple regression model a reasonable description of the association between the two variables? In particular, consider the conditions needed for the reliable use of the Simple Linear Regression. Present the residual plot and Click to select your answer(s) and then click Check Answer.(f) Is the simple regression model a reasonable description of the association between the two variables? In particular, consider the conditions needed for the reliable use of the Simple Linear Regression. Present the residual plot and normal probability plot in Excel and comment. Then consider the scatterplot in part (a) to justify. O A. The variances of the residuals are significantly different. O B. The residuals are not normal. C. The association between y and x is not linear. O D. All the conditions for the SRM are satisfied
