An academic is interested in whether international collaboration, measured by the international co-publication rate, is associated with a higher quality of scientific work, measured by the relative impact factor of the publication. The EXCEL file InternationalCollaborations.xlsx (see image attached) contains the international co-publication rate and the relative impact factor of 31 randomly sampled journal articles, and this is Sample A.

Research Question: "Is there a linear relationship between the international co-publication rate and the relative impact factor of the publication?"

Aanalysing the data in EXCEL. Assume the relevant assumptions for linear regression are satisfied and fit a linear regression model to predict the publication's relative impact factor from its international co-publication rate. Use your Excel output and any other information provided to answer the following questions. For each question, either choose a correct option or type the numerical value with a specified number of decimal places into provided answer space.

A B 1 international co-publication rate Relative impact factor 2 0.87 2.02 3 0.82 1.95 4 0.5 1.74 0.58 1.69 0.71 1.82 0.68 1.79 0.94 2.26 0.55 1.64 10 0.73 1.63 11 0.51 1.62 12 0.81 1.8 13 1.06 2.14 14 1.03 2.1 15 0.73 1.76 16 0.93 1.96 17 0.69 1.69 18 0.39 1.48 19 0.57 1.61 20 0.86 1.99 21 0.83 1.88 22 1.06 2.11 23 0.49 1.66 24 0.53 1.75 25 0.71 1.81 26 0.98 2.05 27 0.65 1.64 28 0.74 2 29 0.75 1.99 30 0.64 1.71 31 0.58 1.59 32 0.58 2.52Figure 1 Figure 2 O O Frequency 1.8 2.0 2.2 2.4 0 8 Relative impact factor O O O O O 0.4 -0.2 0.0 0.2 0.4 0.6 0.8 0.4 0.5 0.6 0.7 0.8 0.9 1.0 Residuals international co-publication rate Figure 3 O -0.2 0.0 0.2 0.4 0.6 0.8 Residuals O O O O O O O On O O O O O 0.4 0.5 0.6 0.7 0.8 0.9 1.0 international co-publication rateThe academic obtained a new sample (Sample B) and fitted a second regression model. The ANOVA table and the regression results are shown below. ANOVA df SS MS F Significance F Regression 1 0.162 0.162 3.802 0.061 Residual 28 1.239 0.043 Total 29 1.401 Regression results on Sample B Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 0.760 0.166 4.588 0.000 0.421 1.099 international co-publication rate 0.479 0.246 1.950 0.061 -0.023 0.982