Chapter 3, Problem 2.12CP

Given x bar = 30  Sigmma x= 12 Sigmma y=1.5  r xy= 0.5 Y bar= 8  Estimate the value of X if the value of Y is12.

Relationship of the student you have to normalized. Do fast neeed in 15 min Please

(b) Using CAGR computed in E15, write the formula in cells D26 and D27 to calculate the Expected Mobile website visitor in 2018 and 2019, respectively. (c) Compute the percent decline or increase in the mobile website visitors, write a formula in cell E26 and copy to cell E27. (d) In cell F26, Use the IF Function to create a formula to print "Yes" if there is cannibalization; else, the formula should print "No".  Copy the formula to cell F27.Hint: If the percent increase is negative then there is cannibalization, else there is no cannibalization.  Screenshot attached thanks !!!!