Y	X1	X2	X3	X4
City	Number of weekly riders	Price per week	Population of city	Monthly income of riders	Average parking rates per month
1	192,000	$15	1,800,000	$5,800	$50
2	190,400	$15	1,790,000	$6,200	$50
3	191,200	$15	1,780,000	$6,400	$60
4	177,600	$25	1,778,000	$6,500	$60
5	176,800	$25	1,750,000	$6,550	$60
6	178,400	$25	1,740,000	$6,580	$70
7	180,800	$25	1,725,000	$8,200	$75
8	175,200	$30	1,725,000	$8,600	$75
9	174,400	$30	1,720,000	$8,800	$75
10	173,920	$30	1,705,000	$9,200	$80
11	172,800	$30	1,710,000	$9,630	$80
12	163,200	$40	1,700,000	$10,570	$80
13	161,600	$40	1,695,000	$11,330	$85
14	161,600	$40	1,695,000	$11,600	$100
15	160,800	$40	1,690,000	$11,800	$105
16	159,200	$40	1,630,000	$11,830	$105
17	148,800	$65	1,640,000	$12,650	$105
18	115,696	$102	1,635,000	$13,000	$110
19	147,200	$75	1,630,000	$13,224	$125
20	150,400	$75	1,620,000	$13,766	$130
21	152,000	$75	1,615,000	$14,010	$150
22	136,000	$80	1,605,000	$14,468	$155
23	126,240	$86	1,590,000	$15,000	$165
24	123,888	$98	1,595,000	$15,200	$175
25	126,080	$87	1,590,000	$15,600	$175
26	151,680	$77	1,600,000	$16,000	$190
27	152,800	$63	1,610,000	$16,200	$200

Homework 2_Oct13.docx (Protected View) - Word lucas yos!mura - File Home Insert Design Layout References Mailings Review View ell me what you want to do 1. 4 polnts. (a) use the multiple linear regression model to fit the "Denand estination" data below (you can copy and paste the data into a file and save it as, e.g., *.txt or xlsx); compute SSE, MSE; and predict the number of weekly riders of a new city, given its known values on X1 $35, X2-$1,600,000, X3-$12,000 and X4= $ 110. 1 Bonus point: Plot a graph where you have a best fit line for this dataset. Please 1) attach your R or Matlab codes and output in your word file as Appendices; (2) save and name your original scripts as "Group#Reg. R" (e.g., Group1-Reg.R) or "Group#Reg.m" (e.g., "Group1 Reg.m"). X1 Price par X2 Population of city 1,800,000 1,790,000 1,780,000 1,778,000 1,750,000 1,740,000 1,725,000 1,725,000 1,720,000 1,705,000 1,710,000 1,700,000 1,695,000 1,695,000 1690 0On X4 Average parking rates per month $50 $50 X3 Monthly income of riders $5,800 $6,200 $6,400 $6,500 $6,550 $6,580 $8,200 $8,600 $8,800 $9,200 $9,630 10,570 11,330 $11,600 Number of weakly City 192,000 190,400 191,200 177,600 176,800 178,400 180,800 175,200 174,400 173,920 172,800 163,200 161,600 161,600 160 80n $15 $15 $15 $25 $25 $25 $25 530 530 530 530 540 540 540 $70 $75 $75 $75 $80 $80 $80 $85 $100 10 12 13 14. S11 Page 2 1.0 1 253 wurds H -+ 100% 3:35 PM Type here to search ^ 10/22/2017