A recent graduate moving to a new job collected a sample of the monthly rent (in...
70.2K
Verified Solution
Link Copied!
Question
Statistics
A recent graduate moving to a new job collected a sample of themonthly 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 apartment isthe explanatory variable. Round the slope and intercept to twodecimal 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
A recent graduate moving to a new job collected a sample of themonthly 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 apartment isthe explanatory variable. Round the slope and intercept to twodecimal 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
Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.