Multiple Linear Regression (2 factors, 1 output)

[ChaoticLlama]

Hello all;

I'm doing work for my job, and I've forgotten my statistics =(.

I first want to know if what I'm trying to do is possible.

I want to create a linear regression of the form Y = a * x1 + b * x2 + c.

http://imgur.com/Q4vGP"

As you can see, there is space that is grayed out (those tests were not performed). I was originally instructed to run my experiment by holding x1 constant and varying x2, and holding x2 constant and varying x1. (I made a dummy data set to make it easier to analyze).

I'm attempting to find the parameters (a,b, & c) using the trusty formula $$\beta = (X'X)^{-1}X'Y$$.

Thanks for your help!

 

[ChaoticLlama]

http://imgur.com/mciGw"