Please answer the question FULLY with detailed and neat steps to solve, will rate thumbs up for the correct solution. PLEASE USE THE SOFTWARE/PROGRAM MINITAB (if needed, please use Excel, but prefer Minitab), WITH STEPS TO SOLVE. Thank you in advance!

1. Data in Q1 M2-Assignment.xlsx shows the data collected in 2016 from the National Cancer Institute which provides the per capita numbers of cigarettes sold along with death rates for various forms of cancer. a) Construct a scatter diagram for number of cigarettes sold per capita and Death from lung cancer in the Excel file. Does there appear to be a linear relationship? b) Develop a regression model for predicting Death from lung cancer as a function of Number of cigarettes sold per capita. c) Explain the statistical significance of the model. How useful do you think this model is? d) Draw conclusions about the validity of the regression analysis assumptions from the residual plot and standard residuals. 1 Smoking and Cancer 2 3 # Cigarettes Deaths per 100F Deaths per 10 Deaths per 1001 Deaths per 100K 4 State sold per cap from bladder ca from lung can from kidney car from leukemia 5 AL 18.20 2.90 17.05 1.59 6.15 6 AZ 25.82 3.52 19.80 2.75 6.61 7 AR 18.24 2.99 15.98 2.02 6.94 8 CA 28.60 4.46 22.07 2.66 7.06 9 CT 31.10 5.11 22.83 3.35 7.20 10 DE 33.60 4.78 24.55 3.36 6.45 11 Dc 40.46 5.60 27.27 3.13 7.08 12 FL 28.27 4.46 23.57 2.41 6.07 13 ID 20.10 3.08 13.58 2.46 6.62 14 IL 27.91 4.75 22.80 2.95 7.27 15 IN 26.18 4.09 20.30 2.81 7.00 16 IA 22.12 4.23 16.59 2.90 7.69 17 KS 21.84 2.91 16.84 2.88 7.42 18 KY 23.44 2.86 17.71 2.13 6.41 19 IA 21.58 4.65 25.45 2.30 6.71 20 ME 28.92 4.79 20.94 3.22 6.24 21 MD 25.91 5.21 26.48 2.85 6.81 22 MA 26.92 4.69 22.04 3.03 6.89 23 MI 24.96 5.27 22.72 2.97 6.91 24 MN 22.06 3.72 14.20 3.54 8.28 25 MS 16.08 3.06 15.60 1.77 6.08 26 MO 27.56 4.04 20.98 2.55 6.82 27 MT 23.75 3.95 19.50 3.43 6.90 28 NB 23.32 3.72 16.70 2.92 7.80 29 NE 42.40 6.54 23.03 2.85 6.67 30 NJ 28.64 5.98 25.95 3.12 7.12 31 NM 21.16 2.90 14.59 2.52 5.95 32 NY 33 ND 34 OH 35 OK 36 PE 37 RI 38 SC 39 SD 40 TE 41 TX 42 UT 43 VT 44 WA 45 WI 46 WV 47 WY 48 AK 49 29.14 19.96 26.38 23.44 23.78 29.18 18.06 20.94 20.08 22.57 14.00 25.89 21.17 21.25 22.86 28.04 30.34 5.30 2.89 4.47 2.93 4.89 4.99 3.25 3.64 2.94 3.21 3.31 4.63 4.04 5.14 4.78 3.20 3.46 25.02 12.12 21.89 19.45 12.11 23.68 17.45 14.11 17.60 20.74 12.01 21.22 20.34 20.55 15.53 15.92 25.88 3.10 3.62 2.95 2.45 2.75 2.84 2.05 3.11 2.18 2.69 2.20 3.17 2.78 2.34 3.28 2.66 4.32 7.23 6.99 7.38 7.46 6.83 6.35 5.82 8.15 6.59 7.02 6.71 6.56 7.48 6.73 7.38 578 4.90 1. Data in Q1 M2-Assignment.xlsx shows the data collected in 2016 from the National Cancer Institute which provides the per capita numbers of cigarettes sold along with death rates for various forms of cancer. a) Construct a scatter diagram for number of cigarettes sold per capita and Death from lung cancer in the Excel file. Does there appear to be a linear relationship? b) Develop a regression model for predicting Death from lung cancer as a function of Number of cigarettes sold per capita. c) Explain the statistical significance of the model. How useful do you think this model is? d) Draw conclusions about the validity of the regression analysis assumptions from the residual plot and standard residuals. 1 Smoking and Cancer 2 3 # Cigarettes Deaths per 100F Deaths per 10 Deaths per 1001 Deaths per 100K 4 State sold per cap from bladder ca from lung can from kidney car from leukemia 5 AL 18.20 2.90 17.05 1.59 6.15 6 AZ 25.82 3.52 19.80 2.75 6.61 7 AR 18.24 2.99 15.98 2.02 6.94 8 CA 28.60 4.46 22.07 2.66 7.06 9 CT 31.10 5.11 22.83 3.35 7.20 10 DE 33.60 4.78 24.55 3.36 6.45 11 Dc 40.46 5.60 27.27 3.13 7.08 12 FL 28.27 4.46 23.57 2.41 6.07 13 ID 20.10 3.08 13.58 2.46 6.62 14 IL 27.91 4.75 22.80 2.95 7.27 15 IN 26.18 4.09 20.30 2.81 7.00 16 IA 22.12 4.23 16.59 2.90 7.69 17 KS 21.84 2.91 16.84 2.88 7.42 18 KY 23.44 2.86 17.71 2.13 6.41 19 IA 21.58 4.65 25.45 2.30 6.71 20 ME 28.92 4.79 20.94 3.22 6.24 21 MD 25.91 5.21 26.48 2.85 6.81 22 MA 26.92 4.69 22.04 3.03 6.89 23 MI 24.96 5.27 22.72 2.97 6.91 24 MN 22.06 3.72 14.20 3.54 8.28 25 MS 16.08 3.06 15.60 1.77 6.08 26 MO 27.56 4.04 20.98 2.55 6.82 27 MT 23.75 3.95 19.50 3.43 6.90 28 NB 23.32 3.72 16.70 2.92 7.80 29 NE 42.40 6.54 23.03 2.85 6.67 30 NJ 28.64 5.98 25.95 3.12 7.12 31 NM 21.16 2.90 14.59 2.52 5.95 32 NY 33 ND 34 OH 35 OK 36 PE 37 RI 38 SC 39 SD 40 TE 41 TX 42 UT 43 VT 44 WA 45 WI 46 WV 47 WY 48 AK 49 29.14 19.96 26.38 23.44 23.78 29.18 18.06 20.94 20.08 22.57 14.00 25.89 21.17 21.25 22.86 28.04 30.34 5.30 2.89 4.47 2.93 4.89 4.99 3.25 3.64 2.94 3.21 3.31 4.63 4.04 5.14 4.78 3.20 3.46 25.02 12.12 21.89 19.45 12.11 23.68 17.45 14.11 17.60 20.74 12.01 21.22 20.34 20.55 15.53 15.92 25.88 3.10 3.62 2.95 2.45 2.75 2.84 2.05 3.11 2.18 2.69 2.20 3.17 2.78 2.34 3.28 2.66 4.32 7.23 6.99 7.38 7.46 6.83 6.35 5.82 8.15 6.59 7.02 6.71 6.56 7.48 6.73 7.38 578 4.90