Construct a scatter plot in Excel with Floor Area as the independent variable (X) and Assessed Value as the dependent variable (Y). Next, insert the linear regression equation and R2 in your graph using a trendline Include the x- and y-axis labels.

1. Do you observe a linear relationship between the two variables; consider R2?
2. Now, would the Floor Area a significant predictor of Assessed Value; consider R2?

Construct a scatter plot in Excel with Age as the independent variable (X) and Assessed Value as the dependent variable (Y).

1. Do you observe a linear relationship between the two variables?

Use Excel's Data Analysis to conduct a regression analysis of Age and Assessed Value.

1. Would Age a significant predictor of Assessed Value?

Construct a multiple regression model. Questions E, F, G require having a multiple regression model

1. Use Excel's Data Analysis to conduct a regression analysis with Assessed Value as the dependent variable and Floor Area, Offices, Entrances, and Age as independent variables.
   1. What is the R2?
   2. What is the adjusted R2?
2. Predictors with =0.05
   1. Which predictors do you consider significant?
   2. Which predictors would you be comfortable eliminating?
3. G. Use Excel's Data Analysis with Assessed Value as the dependent variable and Floor Area and Offices as independent variables.
   1. What is the final model if we only use Floor Area and Offices as predictors?
4. H. Suppose our final model was: Assessed Value ($'000) = 145.921 + 0.307 * Floor Area
   1. What would be the assessed value of a medical office building with a floor area of 3500 sqft and two offices built 15 years ago?
   2. Is this assessed value consistent with what appears in the database?

Floor Area (Sq.Ft.)	Offices	Entrances	Age	Assessed Value ($'000)
4720	3	2	12	1544
5940	4	2	2	2094
5720	4	2	34	1968
3660	3	2	38	1567
5000	4	2	31	1878
2990	2	1	19	949
2610	2	1	48	910
5650	4	2	42	1774
3570	2	1	4	1187
2930	3	2	15	1113
1280	2	1	31	671
4880	3	2	42	1678
1620	1	2	35	710
1820	2	1	17	678
4530	2	2	5	1585
2570	2	1	13	842
4690	2	2	45	1539
1280	1	1	45	433
4100	3	1	27	1268
3530	2	2	41	1251
3660	2	2	33	1094
1110	1	2	50	638
2670	2	2	39	999
1100	1	1	20	653
5810	4	3	17	1914
2560	2	2	24	772
2340	3	1	5	890
3690	2	2	15	1282
3580	3	2	27	1264
3610	2	1	8	1162
3960	3	2	17	1447
4384	3	2	20	1507
2340	3	1	5	890
3690	2	2	15	1282
3580	3	2	27	1264
3610	2	1	8	1162
3960	3	2	17	1447
3014	2	2	18	1052
2990	2	2	18	1043
2965	2	2	17	1034
2941	2	2	17	1025
2916	2	2	17	1016
2892	2	2	17	1007
2867	2	2	16	998
2843	2	2	16	989
2818	2	2	16	980
2794	2	2	15	971
2769	2	2	15	962
2745	2	2	15	953
2720	2	2	14	944