Assign the values 1, 2, 3…, 26 to A, B, C…, Z respectively

Assign the values 1, 2, 3…, 26 to A, B, C…, Z respectively.

A (1) B (2) C (3) D (4) E (5) F(6) G(7) H (8) I (9) J (10) K (11) L (12) M (13) N (14 (1) O(15) P(16) Q (17) R (18) S (19) T (20) U(21) V(22 ) W (23) X (24) Y (25) Z(26)

Find the value of (F+L) *1000, where F is the first letter of your first name and L is the last letter of your first name.

ADD this number to each number in the Sale Price column. Label the new Sale Price Column as FLY.

Example: My first name- MAHESH

I will use M for F, H for L

M=13. H=8. So I will add 21,000 to each value in sale price column and label the revised sale prices as MHY.

FLY = New Sale Price ($), X1= No. Apartments, X2= Age of Structure, X3= Lot Size

X4= No. of Parking Spaces, X5= Gross Building Ares( sq. ft.)

1. Analyze the data, using FLY as the dependent variable and X1, X2, X3, X4, X5 as independent variables.

Is the fitted model useful? Use α=0.5
ii.. Which terms in the model are useful ? Use α=0.05

1. Analyze the same data, using FLY as the dependent variable and X1, X2, X3, X4, X5 and condition as independent variables. Is this model better than the first model for predicting sale price? Use 5% level of significance.