Question

In: Statistics and Probability

Make a scatter plot, including the regression line and its equation. Use an appropriate Excel function...

  1. Make a scatter plot, including the regression line and its equation.
  2. Use an appropriate Excel function to find the correlation coefficient r. Determine the type of linear relationship, if any.
  3. Interpret the slope and y-intercept, if appropriate, in the context of the data.
  4. Use an appropriate Excel function and the data to find a predicted(average) selling price for a single- family house measuring 1960 square feet. Does the house that measured 1960 square feet in the sample have a selling price that is below or above average, and why?
    Square Footage Selling Price
    1746 129320
    1764 97000
    676 35000
    2788 400000
    1944 68000
    1960 117000
    1056 148400
    1564 35000
    1100 165000
    1120 114480
    4080 175000
    1442 65000
    1937 60000
    1900 18000
    1150 258000
    1650 134800
    1953 30000
    2424 69100
    512 63000
    1540 82500
    1200 50000
    1316 37500
    1840 69000
    3500 270000
    5000 485000
    1564 27000
    1018 37000
    2176 168000
    1600 208500
    1532 100700
    1525 86000
    2488 6500
    1200 50001
    1300 89000

Solutions

Expert Solution


Related Solutions

Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line. (The pair of variables have a significant correlation.) Then use the regression equation to predict the value of y for each of the given x-values, if meaningful. The table below shows the heights (in feet) and the number of stories of six notable buildings in a city. Height : 772, 628, 518, 508, 496, 483, y:...
Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line.​ (The pair of variables have a significant​ correlation.) Then use the regression equation to predict the value of y for each of the given​ x-values, if meaningful. The table below shows the heights​ (in feet) and the number of stories of six notable buildings in a city. Height comma x 762 621 515 508 491 480...
Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line.​ (The pair of variables have a significant​ correlation.) Then use the regression equation to predict the value of y for each of the given​ x-values, if meaningful. The table below shows the heights​ (in feet) and the number of stories of six notable buildings in a city. Height comma xHeight, x 766766 620620 520520 508508 494494...
Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line.​ (Each pair of variables has a significant​ correlation.) Then use the regression equation to predict the value of y for each of the given​ x-values, if meaningful. The caloric content and the sodium content​ (in milligrams) for 6 beef hot dogs are shown in the table below. font size decreased by 1 font size increased by...
Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line.​ (Each pair of variables has a significant​ correlation.) Then use the regression equation to predict the value of y for each of the given​ x-values, if meaningful. The caloric content and the sodium content​ (in milligrams) for 6 beef hot dogs are shown in the table below. font size decreased by 1 font size increased by...
Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line. (The pair of variables have a significant correlation.) Then use the regression equation to predict the value of y for each of the given x-values, if meaningful. The number of hours 6 students spent for a test and their scores on that test are shown below. font size decreased by 1 font size increased by 1...
Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line.​ (The pair of variables have a significant​ correlation.) Then use the regression equation to predict the value of y for each of the given​ x-values, if meaningful. The table below shows the heights​ (in feet) and the number of stories of six notable buildings in a city. Height comma x 775 619 519 508 491 474...
Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line.​ (The pair of variables have a significant​ correlation.) Then use the regression equation to predict the value of y for each of the given​ x-values, if meaningful. The number of hours 6 students spent for a test and their scores on that test are shown below. Hours spent studying, x: 0, 1, 2, 4, 5, 6...
find the equation of the regression line for the given data. then construct a scatter plot...
find the equation of the regression line for the given data. then construct a scatter plot if the data and draw a regression line. then use the regression equation to predict the value of y for each of the given x values m, if meaningful. x= 778, 621, 519, 510, 494, 473 y= 51, 47, 44, 43, 39, 37 y=____x + _______ predict the value y for x= 499 "                                      " x= 642 "                                      " x= 802 "                                      " x=...
Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line.​ (Each pair of variables has a significant​ correlation.) Then use the regression equation to predict the value of y for each of the given​ x-values, if meaningful. The caloric content and the sodium content​ (in milligrams) for 6 beef hot dogs are shown in the table below. Calories, x 160 180 120 120 80 190 ​(a)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT