Vora_Sarah_HW2

H If you have any question DO NOT change the structure of Follow the su Name the f Problem Set 1 Set 2 Set 3 Set 4 Total You must use Excel functions when Do not round-off your answ DO NOT change the structure of the shee Before uploading, double-check that you are uploading the submission is FINAL. NO e-m 5-point (non-refundable) penalty for missing these two steps.

HOMEWORK 2 ::: 30 Points INSTRUCTIONS ns regarding your HW grade, please contact the TA f the sheets. That is, do not add or delete columns / rows. ubmission guidelines (see eLearning). file as: LastName_FirstName_HW2 Last Name Vora First Name Sarah NetID SXV190066 Do not make any changes here Points Earned Comments 12 8 4 6 30 0 n available. The work must be done within the cells themselves. wers , but format the cells to show 4 decimal places. ets. That means do not add or delete columns or ro correct file. Do not upload while the file is still open. Once uploade mailed or late submissions will be accepted.

ows. D O N OT ch an ge th e str uc tur e of th e sh ee ts. Th at m ea ns do no t ad ed, your

ad d or de let e col u m ns or ro ws . `

Name : Sarah Vora 12 0 Miles Price 24.2 15.4 $15.6354 -$0.2354 38.8 14.3 $14.6018 -$0.3018 45.6 14.5 $14.1204 $0.3796 28.7 15.6 $15.3168 $0.2832 38.2 14.7 $14.6443 $0.0557 36.7 14.4 $14.7504 -$0.3504 32.5 15.2 $15.0478 $0.1522 39.1 14.1 $14.5805 -$0.4805 45.3 14.2 $14.1416 $0.0584 34.4 14.8 $14.9133 -$0.1133 38.4 15.1 $14.6301 $0.4699 32.2 15.0 $15.0690 -$0.0690 26.6 15.7 $15.4655 $0.2345 33.5 14.6 $14.9770 -$0.3770 41.8 14.5 $14.3894 $0.1106 36.7 14.8 $14.7504 $0.0496 37.5 14.8 $14.6938 $0.1062 25.6 15.7 $15.5363 $0.1637 40.1 15.0 $14.5097 $0.4903 31.0 14.9 $15.1540 -$0.2540 42.2 14.4 $14.3611 $0.0389 37.4 14.2 $14.7009 -$0.5009 The table below lists the prices (in thousands) of use (regression line) using Excel. Run Excel's Regression the predicted price. Then fill the remaining columns. numbers calculated by Excel's Regression program. C Predicted Price Residual (Error) DO NOT change the structure of the sh keep out of this area