Question
A recent graduate moving to a new job collected a sample of the monthly rent (in dollars) and the size (in square feet) of3-bedroom apartments
A recent graduate moving to a new job collected a sample of the monthly rent (in dollars) and the size (in square feet) of3-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