Question:

Obtain an open data via online database in regards to your majoring field (business/accounting/finance/economic). Data must consists of TWO independent variable and ONE dependent variable. It must also contains at least 40 set observations. (Eg: x1 = Weight (kg), x2 =Height, y = calories intake, of 40 patients)

Task

* Calculate the mean, median, mode and standard deviation for each independent variables and dependent variable. Hence, interpret each of the answer accordingly.

* Obtain the regression analysis between the variables using excel and interpret the summary table, fitted line plot and normal probability plot.

* Compute a regression analysis for each independent variable separately. Interpret the results obtain.

* Consider evaluating whether or not a linear relationship exists between the independent and dependent variable. Using the t-test for testing the existence of a linear relationship by two tail test of correlation coefficient. (Manual working only)

* Obtain and interpret polygon/histogram chart graph for each variable using excel only.

I have attached the data set the data set contains house sales prices for king county, seattle. It includes homes sold between may 2014 and may 2015