You decided to join a fantasy Baseball league and you think the best way to pick your players is to look at their Batting Averages.

You want to use data from the previous season to help predict Batting Averages to know which players to pick for the upcoming season. You want to use Runs Score, Doubles, Triples, Home Runs and Strike Outs to determine if there is a significant linear relationship for Batting Averages.

You collect data to, to help estimate Batting Average, to see which players you should choose. You collect data on 45 players to help make your decision.

x1 = Runs Score/Times at Bat

x2 = Doubles/Times at Bat

x3 = Triples/Times at Bat

x4 = Home Runs/Times at Bat

x5= Strike Outs/Times at Bat

Find the estimated regression equation which can be used to estimate Batting Averages when using these 5 variables are predictor variables.

See Attached Excel for Data

Batting AverageRS/Times at BatDoubles/Times at BatTriples/times at batHR/Times at BatSO/Times at Bat0.2830.1440.0490.0120.0130.0860.2760.1250.0390.0130.0020.0620.2810.1410.0450.0210.0130.0740.3280.1890.0430.0010.030.0320.290.1610.0440.0110.070.0760.2960.1860.0470.0180.050.0070.2480.1060.0360.0080.0120.0950.2280.1170.030.0060.0030.1450.3050.1740.050.0080.0610.1120.2540.0940.0410.0050.0140.1240.2690.1470.0470.0120.0090.1110.30.1410.0580.010.0110.070.3070.1350.0410.0090.0050.0650.2140.10.0370.0030.0040.1380.3290.1890.0580.0140.0110.0320.310.1490.050.0120.050.060.2520.1190.040.0080.0490.2330.3080.1580.0380.0130.0030.0680.3420.2590.060.0160.0850.1580.3580.1930.0660.0210.0370.0830.340.1550.0510.020.0120.040.3040.1970.0520.0080.0540.0950.2480.1330.0370.0030.0430.1350.3670.1960.0630.0260.010.0310.3250.2060.0540.0270.010.0480.2440.110.0250.00600.0610.2450.0960.0440.0030.0220.1510.3180.1930.0630.020.0370.0810.2070.1540.0450.00800.2520.320.2040.0530.0170.0130.070.2430.1410.0410.0070.0510.2640.3170.2090.0570.030.0170.0580.1990.10.0290.0070.0110.1880.2940.1580.0340.0190.0050.0140.2210.0870.0380.0060.0150.1420.3010.1630.0680.0160.0220.0920.2980.2070.0420.0090.0660.2110.3040.1970.0520.0080.0540.0950.2970.160.0490.0070.0380.1010.1880.0640.0440.0070.0020.2050.2140.10.0370.0030.0040.1380.2180.0820.0610.0020.0120.1470.2840.1310.0490.0120.0210.130.270.170.0260.0110.00200.2770.150.0530.0050.0390.115