Need help to do it in excel please.

Question

Based on the following data and using Regression function in Microsoft Excel, fit a multiple linear equation to the data and determine the R₂

x₁ 0 1 1 2 2 3 3 4 4

x₂ 0 1 2 1 2 1 2 1 2

y 15 18 12.8 25.7 20.6 35.0 29.8 45.5 40.3

a. Write the multiple linear equation:

R₂=

b. Write the multiple quadratic equation:

R₂₌

Answer 1

Scatter plot --> right click on data --> fit --> check show equation