Question
A recent graduate moving to a new job collected a sample of the monthly rent (in dollars) and the size (in square feet) of 3-bedroom
A recent graduate moving to a new job collected a sample of the monthly rent (in dollars) and the size (in square feet) of 3-bedroom apartments in one area of a city. Use Excel to find thebest fit linear regression equation, where size of the apartmentis the explanatory variable.Round the slope and intercept to two decimal places.
Size Rent 961 "909 " 949 1048 924 "841 " 920 "704 " 902 1131 893 "867 " 888 2532 886 "800 " 876 1030 875 "758 " 864 "930 " 860 1227 851 "931 " 848 1820 845 "711 " 841 1040 838 1373 829 1158 827 3111 815 "733 " 802 "870 " 801 1464 792 "839 " 790 1387 779 2050 748 3275 741 1996 730 1708 727 4031 711 1756
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started