Worksheet 5-1: First enter your name in cell F1 on this worksheet. The worksheet shows the weight (in thousands of pounds) and fuel efficiency (in miles per gallon) for 50 car models. (a) Create a scatterplot for the data and comment on the visual appearance of a relationship between weight and fuel efficiency. Use weight as the independent variable. (b) State and interpret the regression equation from the analysis. (c) Estimate the fuel efficiency of a car that weighs 3 thousand pounds, (d) Find the coefficient of correlation between the variables and interpret what the value tells you about the nature and strength of the relationship. (e) Find and interpret the standard error for the model. (f) Perform a complete hypothesis test using a t statistic for whether there is a significant relationship between weight and fuel efficiency of a car, using a 0.05 significance levelF1 J.X A B C D E G H J K L M N Weight MPG Enter your name here: 2.7 25 WN 2.305 33 (a) Put your scatterplot as part of your support work to the right. 2.3 34 Place your statement about the appearance of a relationship below. 2.485 26 2.26 32 2.345 29 60 CO - 2.325 26 2.34 35 (b) State and interpret your regression equation below: 10 2.675 28 11 1.9 34 12 2.355 25 13 2.055 35 14 3.11 20 15 2.885 27 16 2.85 19 (c) State the requested fuel efficiency estimate below. 17 2.695 30 (The cell with the reported value should refer to a 18 2.175 33 supporting calculation within the worksheet.) 19 2.215 30 20 2.79 25 21 2.64 26 22 2.485 28 23 2.885 27 24 2.695 28 (d) Find the coefficient of correlation between the variables 25 2.68 25 and briefly interpret what the value indicates: 26 2.655 27 27 3.065 22 28 2.97 25 29 2.69 24 30 2.91 26 31 2.975 25 (e) State and interpret the standard error for your model below: 32 2.92 21 5-1 5-2 Ready 1 12. CAOZ A B C D E F G H K M N O P 31 2.975 25 (e) State and interpret the standard error for your model below: 32 2.92 21 33 2.575 24 34 2.935 23 35 2.92 27 36 3.64 17 37 3.295 21 (f) Perform the requested hypothesis test below: 38 3.38 21 39 3.145 22 Null Hypothesis: 40 3.2 22 41 3.61 23 42 2.885 23 Alternative Hypothesis: 43 17 44 3.93 19 45 3.695 18 Signficance level for test: 46 3.48 21 47 3.2 22 48 3.295 23 Critical value(s): 49 3.295 21 50 3.74 18 51 3.835 19 Decision Rule: 52 53 54 55 Test Statistic: 56 57 58 Conclusion: 59 60 67 p-Value: 62 7 63 64 Whether and why p-value supports above conclusion: 65 66 67 68 Implication: 69 70 5-1 5-2 Ready