(Solved): Values of two variable \( x \) and \( y \) are given in the following table: (a) Write the Excel co ...
Values of two variable \( x \) and \( y \) are given in the following table: (a) Write the Excel command to find correlation. (b) Find the equation of a trend line. Answer \( y= \) \( x+ \) (3 decimals). (c) Estimate the value of \( y \) when \( x=38 \). (d) Assuming that p-value is \( 0.067 \), can we deduce that the sample supports correlation?