1. Use the least squares method to fit a simple linear model that relates the annual number of Australian wines sold to the annual growth rate in Canada. In your analysis, state what your model is, and determine whether the independent variable is significant or not at an ?-level of significance = 5%).
2. How effective is the independent variable in predicting the movement of the dependent variable?

Brand Bottles sold Avg Price Exp in NA (in Market Growth Color ID in 2014 ($) '000)$ Share (%) (%) Segment Appreciation H 44,039 43.10 1, 145.72 2.51 17.00 Red 6 41,687 28.15 1,384.94 5.51 7.50 Red S W N 2,754 17.80 737.60 10.91 -36.00 Rose 56, 107 63.00 560.77 8.27 38.60 Rose 73,512 19.80 1,936.77 9.15 25.00 Rose ONNN 25,619 15.00 100.61 5.51 7.50 White 5 0 NOUA 60,380 36.00 785.15 8.54 27.50 Red 40,409 20.30 521.54 7.07 -24.50 Red w 78,233 27.75 2,211.56 12.54 62.00 Red 58,516 25.70 1,418.28 8. 51.20 Red N 11 29,619 33.75 690. 5.38 18.50 Red 12 30,400 23.60 497.96 5.43 -32.50 White St 13 28,897 13.80 492.88 8.48 32.00 White A 14 28,049 24.00 434.34 7.8 41.10 Rose 15 55,043 29.00 2,673.55 10.34 5.50 Red 16 32,751 23.85 2,154.65 5.15 -2.00 Rose 17 39,473 16.25 1,936.97 6.64 14.90 White J UI WN 18 33,609 42.25 1, 141.45 5.45 13.00 Red 39,170 52.85 1,505.67 6.31 -5.00 Red 20 41,443 25.00 930.28 6.35 -16.70 White 20,897 12.50 215.24 7.37 -1.50 White UI - NH 24,429 13.80 892.88 8.39 -21.50 White 18,936 18.15 711.38 5.15 0.20 Red 24 50,009 48.50 1,265.03 12.88 63.10 Red 10 25 3,600 21.15 888.00 9.14 -13.70 Rose w 26 22,593 11.50 711.00 2.51 17.00 White 12,755 15.30 459.24 5.51 7.50 White 28 13,960 18.40 554.58 10.91 0.60 White st 29 654 42.20 666.18 6.27 -10.50 Red w . 30 1,364 60.70 482.04 9.15 -33.50 Red 531 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 461 20,615 769 21,628 1,049 14,689 26,036 19,276 13,713 2,403 13,908 22,336 11,384 13,603 22,613 13,586 21,021 9,633 10,274 16,621 20.00 30.35 12.15 25.75 16.25 17.10 23.10 28.30 25.90 18.50 16.80 24.70 15.55 22.40 20.20 15.35 23.20 12.55 17.80 17.25 299.04 687.12 305.34 773.58 288.84 513.00 693.06 684.96 617.70 557.16 506.34 741.18 466.62 672.60 606.12 459.12 696.54 376.32 509.46 531.84 0.51 8.54 7.07 12.54 0.85 5.38 5.43 8.48 7.8 3.34 5.15 6.64 5.45 6.31 6.35 7.37 8.39 5.15 1.28 7.14 -21.50 67.50 -7.00 42.00 11.40 48.50 43.20 2.30 -3.50 0.00 -25.20 3.40 -33.00 -15.50 24.00 -1.50 16.50 2.00 -11.00 10.00 Rose Rose White Red Red Red Red Rose Red White White White Rose Red Red Rose Red White White Red unbmbwbwnwumbmmuumun