Choose one of these three data sets.
(a) Make a scatter plot.
(b) Let Excel estimate the regression line, with fitted equation and R2.
(c) Describe the t of the regression.
(d) Write the fitted regression equation and interpret the slope.
(e) Do you think that the estimated intercept is meaningful? Explain.

Transcribed Image Text:

Commercial Real Estate (Y-assessed value, S000; X-floor space, sq. ft.) (n-15) Assessed Size Assessed 4,790 4,720 5,940 1,796 1,544 2,094 4,880 1,620 1,820 1,678 710 678 Sasnak Co. Salaries (X# employee age; Y employee salary, S000) (n-: 23) Salaries Employee Age Salary Mary Frieda Alicia 23 31 28.6 53.3 73.8 Marcia Ellen lggy 75.8 79.8 70.2 36 Poway Big Homes, Ltd. (X-home size, sq. ft.; Y selling price. S000) (n 20) HomePrice2 SqFt Price 3,570 3,410 2,690 861 740 563 3,020 2,320 3,130 720 575 785