Question: Fit a predictive linear regression model to estimate weight of the fish from its length (length1, length2, length3), height and width using the data source

Fit a predictive linear regression model to estimate weight of the fish from its length (length1, length2, length3), height and width using the data source fish.xls provided to you. Use only 70% of the data as training set (15 points) -Report the coefficients values by using the standard Least Square Estimates -What is the standard error of the estimated coefficients, R-squared term, and the 95% confidence interval? -Is there any dependence between the length and weight of the fish?

 Q2 Using the data source in Q1(only 70% of the data points as training set), fit the Ridge and Lasso Regression Models (15 points) - Report the coefficients for both the models. - Report the attribute(s) least impacting the weight of the fish. Justify your answer.

 Q3 Using remaining 30% of the data in Q1 first , test the trained regression models in Q1 and Q2 and report their performance (model accuracy) using MSE (mean square error) and R-squared metrics. Which model is performing the best? Explain your answer. (20 points)

 

fish.xls file is below as text format 

 

SpeciesWeightLength1Length2Length3HeightWidth
Bream24223.225.43011.524.02
Bream2902426.331.212.484.3056
Bream34023.926.531.112.37784.6961
Bream36326.32933.512.734.4555
Bream43026.5293412.4445.134
Bream45026.829.734.713.60244.9274
Bream50026.829.734.514.17955.2785
Bream39027.6303512.674.69
Bream45027.63035.114.00494.8438
Bream50028.530.736.214.22664.9594
Bream47528.43136.214.26285.1042
Bream50028.73136.214.37144.8146
Bream50029.131.536.413.75924.368
Bream34029.53237.313.91295.0728
Bream60029.43237.214.95445.1708
Bream60029.43237.215.4385.58
Bream70030.43338.314.86045.2854
Bream70030.43338.514.9385.1975
Bream61030.933.538.615.6335.1338
Bream6503133.538.714.47385.7276
Bream57531.33439.515.12855.5695
Bream68531.43439.215.99365.3704
Bream62031.534.539.715.52275.2801
Bream68031.83540.615.46866.1306
Bream70031.93540.516.24055.589
Bream72531.83540.916.366.0532
Bream720323540.616.36186.09
Bream71432.73641.516.5175.8515
Bream85032.83641.616.88966.1984
Bream100033.53742.618.9576.603
Bream9203538.544.118.03696.3063
Bream9553538.54418.0846.292
Bream92536.239.545.318.75426.7497
Bream97537.44145.918.63546.7473
Bream950384146.517.62356.3705
Roach4012.914.116.24.14722.268
Roach6916.518.220.35.29832.8217
Roach7817.518.821.25.57562.9044
Roach8718.219.822.25.61663.1746
Roach12018.62022.26.2163.5742
Roach01920.522.86.47523.3516
Roach11019.120.823.16.16773.3957
Roach12019.42123.76.11463.2943
Roach15020.42224.75.80453.7544
Roach14520.52224.36.63393.5478
Roach16020.522.525.37.03343.8203
Roach1402122.5256.553.325
Roach16021.122.5256.43.8
Roach169222427.27.53443.8352
Roach1612223.426.76.91533.6312
Roach20022.123.526.87.39684.1272
Roach18023.625.227.97.08663.906
Roach290242629.28.87684.4968
Roach272252730.68.5684.7736
Roach39029.531.7359.4855.355
Whitefish27023.62628.78.38044.2476
Whitefish27024.126.529.38.14544.2485
Whitefish30625.62830.88.7784.6816
Whitefish54028.5313410.7446.562
Whitefish80033.736.439.611.76126.5736
Whitefish100037.34043.512.3546.525
Parkki5513.514.716.56.84752.3265
Parkki6014.315.517.46.57722.3142
Parkki9016.317.719.87.40522.673
Parkki12017.51921.38.39222.9181
Parkki15018.42022.48.89283.2928
Parkki1401920.723.28.53763.2944
Parkki1701920.723.29.3963.4104
Parkki14519.821.524.19.73643.1571
Parkki20021.22325.810.34583.6636
Parkki27323252811.0884.144
Parkki30024262911.3684.234
Perch5.97.58.48.82.1121.408
Perch3212.513.714.73.5281.9992
Perch4013.815163.8242.432
Perch51.51516.217.24.59242.6316
Perch7015.717.418.54.5882.9415
Perch10016.21819.25.22243.3216
Perch7816.818.719.45.19923.1234
Perch8017.21920.25.63583.0502
Perch8517.819.620.85.13763.0368
Perch8518.220215.0822.772
Perch110192122.55.69253.555
Perch115192122.55.91753.3075
Perch125192122.55.69253.6675
Perch13019.321.322.86.3843.534
Perch120202223.56.113.4075
Perch120202223.55.643.525
Perch130202223.56.113.525
Perch135202223.55.8753.525
Perch110202223.55.52253.995
Perch13020.522.5245.8563.624
Perch15020.522.5246.7923.624
Perch14520.722.724.25.95323.63
Perch150212324.55.21853.626
Perch17021.523.5256.2753.725
Perch225222425.57.2933.723
Perch145222425.56.3753.825
Perch18822.624.626.26.73344.1658
Perch180232526.56.43953.6835
Perch19723.525.6276.5614.239
Perch2182526.5287.1684.144
Perch30025.227.328.78.3235.1373
Perch26025.427.528.97.16724.335
Perch26525.427.528.97.05164.335
Perch25025.427.528.97.28284.5662
Perch25025.92829.47.82044.2042
Perch30026.928.730.17.58524.6354
Perch32027.83031.67.61564.7716
Perch51430.532.83410.036.018
Perch5563234.536.510.25656.3875
Perch84032.53537.311.48847.7957
Perch6853436.53910.8816.864
Perch700343638.310.60916.7408
Perch70034.53739.410.8356.2646
Perch69034.63739.310.57176.3666
Perch90036.53941.411.13667.4934
Perch65036.53941.411.13666.003
Perch82036.63941.312.43137.3514
Perch85036.94042.311.92867.1064
Perch900374042.511.737.225
Perch1015374042.412.38087.4624
Perch82037.14042.511.1356.63
Perch1100394244.612.80026.8684
Perch100039.84345.211.93287.2772
Perch110040.14345.512.51257.4165
Perch100040.243.54612.6048.142
Perch100041.14446.612.48887.5958
Pike2003032.334.85.5683.3756
Pike30031.73437.85.70784.158
Pike30032.73538.85.93644.3844
Pike30034.837.339.86.28844.0198
Pike43035.53840.57.294.5765
Pike3453638.5416.3963.977
Pike4564042.545.57.284.3225
Pike5104042.545.56.8254.459
Pike54040.14345.87.7865.1296
Pike5004245486.964.896
Pike56743.24648.77.7924.87
Pike77044.84851.27.685.376
Pike95048.351.755.18.92626.1712
Pike1250525659.710.68636.9849
Pike16005660649.66.144
Pike15505660649.66.144
Pike16505963.46810.8127.48
Smelt6.79.39.810.81.73881.0476
Smelt7.51010.511.61.9721.16
Smelt710.110.611.61.72841.1484
Smelt9.710.411122.1961.38
Smelt9.810.711.212.42.08321.2772
Smelt8.710.811.312.61.97821.2852
Smelt1011.311.813.12.21391.2838
Smelt9.911.311.813.12.21391.1659
Smelt9.811.41213.22.20441.1484
Smelt12.211.512.213.42.09041.3936
Smelt13.411.712.413.52.431.269
Smelt12.212.11313.82.2771.2558
Smelt19.713.214.315.22.87282.0672
Smelt19.913.81516.22.93221.8792

Step by Step Solution

3.43 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To address your questions well first need to load the data split it into a training set and a test set and then fit linear ridge and lasso regression models to the training data After that we can eval... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!