how to I solve a using single linear Regression in excel or any excel method? I am struggling to understand this question. Can please be very detailed about it, how you were able to do so and what you used to get these answers. I struggle to understand how to answer to this question below.   An agent for a real estate company in a suburb has

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

how to I solve a using single linear Regression in excel or any excel method? I am struggling to understand this question. Can please be very detailed about it, how you were able to do so and what you used to get these answers. I struggle to understand how to answer to this question below.

 

An agent for a real estate company in a suburb has the business objective of developing more accurate estimates of the monthly rental cost for apartments. The agent would like to use the size of an​ apartment, as defined by square footage to predict the monthly rental cost. The agent collects data from a sample of 30 ​one-bedroom apartments. 

b. Construct a 95​% prediction interval estimate of the monthly rental for all​ one-bedroom apartments that is 810 square feet in size.

_____≤μYX=810≤______
(Type integers or decimals. Round to two decimal places as needed. Use ascending​ order.)

Apartment
Size (sq feet)
Rent ($)
1
516
1118
2
621
1187
3
664
1176
4
842
1410
450
1225
6.
542
1213
7
767
1482
8
816
1504
1087
1507
10
605
1671
11
835
1822
12
672
1624
13
597
1458
14
669
1399
15
747
1136
16
815
1126
17
928
1219
18
632
1421
19
647
1509
20
857
1116
21
815
1123
22
820
1252
23
966
1455
24
816
1159
25
803
1226
26
949
1390
27
742
1147
28
699
1095
29
855
1349
30
850
1515
Transcribed Image Text:Apartment Size (sq feet) Rent ($) 1 516 1118 2 621 1187 3 664 1176 4 842 1410 450 1225 6. 542 1213 7 767 1482 8 816 1504 1087 1507 10 605 1671 11 835 1822 12 672 1624 13 597 1458 14 669 1399 15 747 1136 16 815 1126 17 928 1219 18 632 1421 19 647 1509 20 857 1116 21 815 1123 22 820 1252 23 966 1455 24 816 1159 25 803 1226 26 949 1390 27 742 1147 28 699 1095 29 855 1349 30 850 1515
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman