(49) using the data below answer the following questions 1. Write the regression equation. 2. Interp

(49) using the data below answer the following questions 1. Write the regression equation. 2. Interpret the regression constant and regression coefficient, 3. Forecast a value for the dependent variable,4 Test the significance of the regression coefficient at an alpha level of .05, 5.Test the overall significance of the regression model,6. Interpret the coefficient of determination 7.Are there any indications of violations of the general linear model? You must address each assumption separately and explain. Yes and no answers are unacceptable.(must use excel or minitab)

recent family home sales in San Antonio provided the following data

Square footage                price$

1580                                  142500

1572                                  145000

1352                                  115000

2224                                  155900

1556                                    95000

1435                                   128000

1438                                   100000

1089                                    55000

1941                                   142000

1698                                   115000

1539                                   115000

1364                                   105000

1979                                    155000

2183                                   132000

2096                                    140000

1400                                   85000

2372                                   145000

1752                                   155000

1386                                    80000

1163                                  100000

 

Looking for a Similar Assignment? Hire our Top Techical Tutors while you enjoy your free time! All papers are written from scratch and are 100% Original. Try us today! Active Discount Code FREE15