1. Formulas and cell references a) Define x=4, and y=6 on cells B2 and B3 respectively. b) On cell D2, E2, and F2 type the following formulas and calculate the results: ote: Use x and y values from 1 a) as "Absolute (foced) cell reference". Equation for D2: x2+21x+3+3y3 Equation for E2: cos(60)+(x+y2)1/3 Equation for F2: 2+3x+5y 2. Sequence of numbers and tables a) On cell 86 define a column that contains integers from 0 to 20 with an increment of 0.5 and label it as " X ". b) On cell Co use the values from Bo to calculate "y' by using the following equation: y=x2/23+x2 3. Plotting, trend lines and Iabels a) Download the house_prediction - Sheet1.csv file from canvas. ote: Data was collected from: tosilloithub. com/NitinNandeshwarlPrediction-of-House-Price-using-Expel b) Pick one of the predictors (columns) that you think is the most deterministic for the price prediction. Explain the reason of your choice. c) Make a scatter plot (predictor vs price) and add labels. d) Add the trendline that you think fits better your data and show the equation. e) Comment your results based on the R2 value. If R2 value is low, which predictor would you pick to increase the correlation coefficient?, and why