Use ALL the data found in the Excel file foryour analysis. Calculate the following:

• Run the descriptive statistics for BMI (Body Mass Index) andSysBP (Systolic Blood Pressure), including graphing a scatter plotof BMI by SysBP.
• Calculate the correlation between BMI and SysBP.
• Calculate the regression with SysBP as the response variable(y) and BMI as the explanatory (sometimes called “Independent”)variable (x). In other words, we want to see how much BMI predictsSysBP. Is there a relationship between weight and blood pressure?Yes, we know there is, so we strongly suspect BMI willsignificantly predict SysBP. We can better understand thisrelationship using linear regression

BMI 28 27 33 28 29 24 34 30 36 30 31 30 38 32 27 23 26 38 32 2926 37 24 27 33 32 33 42 30 27 42 34 24 29 28 35 41 26 35 20 28 2740 31 45 37 35 45 29 24 28 32 34 31 30 34 30 40 36 41 30 39 36 3438 36 39 32 28 30 25 39 25 40 21 26 24 24 31 27 29 31 24 39 31 3621 41 23 33 26 27 26 30 23 35 52 26 35 30 47 27 30 47 23 25 32 3928 28 35 28 32 32 30 29 32 30 27 35 36 35 44 31 31 34 25 28 29 3537 27 28 30 24 31 38 26 32 33 31 29 38 30 38 38 36 28 31 43 24 2431 31 36 26 30 29 35 32 24 34 39 38 35 28 38 37 33 28 25 35 33 3836 30 28 35 31 26 64 40 32 28 45 29 25 31 34 30 35 29 33 31 22 3038 29 35 26 41 26 28 32 28 29 27 27 32 38 31 30 27 33 28 38 37 2925 23 38 27 39 20 29 29 25 28 39 31 35 31 39 40 30 29 37 31 33 3425 24 42 23 42 26 34 38 38 44 26 32 30 24 31 30 24 30 31 26 42 2724 27 28 30 24 22 28 32 44 25 31 25 24 36 27 32 25 33 28 30 33 3436 30 30 40 29 39 27 27 31 27 36 35 23 27 24 32 24 30 29 32 29 4031 43 36 40 33 35 38 26 28 34 47 33 25 31 34 34 30 33 33 24 28 3429 29 35 25 40 35 29 28 31 42 38 41 27 37 38 33 40 33 32 30 41 2725 27 34 32 39 24 32 35 24 32 31 29 33 30 32 30 26 28 31 30 27 3423 41 30 45 25 30 30 24 38 36 44 31 30 36 47

SysBP 128 108 108 138 118 114 132 110 162 144 142 158 126 128114 116 134 122 150 138 134 110 138 118 124 158 114 120 110 100 142109 108 124 118 132 126 118 136 148 122 128 135 140 128 110 108 136138 126 114 108 152 126 118 120 146 109 136 120 129 120 130 136 130136 126 112 128 110 122 104 112 138 120 126 122 112 132 122 142 136122 102 112 110 100 152 125 138 130 118 114 120 142 128 138 124 132130 152 126 118 154 118 122 115 122 146 146 124 114 134 140 118 100124 110 124 134 136 138 117 112 112 118 130 128 120 122 142 132 112128 132 120 144 108 122 128 160 124 150 128 130 150 102 110 126 120118 130 144 128 168 134 132 136 130 126 128 134 120 100 110 132 155140 128 112 128 154 114 156 118 142 112 100 143 124 114 132 124 114120 130 118 98 120 158 118 124 140 124 126 140 122 126 132 116 122112 108 136 122 124 122 150 128 142 98 126 116 112 114 136 138 142138 130 122 120 124 108 118 128 122 118 126 136 134 120 136 120 142118 124 136 134 134 118 114 120 126 120 118 112 110 130 124 108 114122 113 112 108 108 124 132 108 134 104 122 114 118 114 118 164 116126 130 120 120 122 132 106 124 142 110 144 136 118 112 128 130 128120 146 136 124 148 116 132 124 116 136 128 127 120 112 112 130 107134 118 112 110 164 128 136 108 130 112 122 116 130 126 120 124 120112 132 118 120 148 118 124 148 140 110 115 114 136 158 122 120 108134 138 122 130 118 138 118 118 136 118 140 120 108 106 120 120 134122 112 130 120 112 120 126 120 134 118 130 104 100 120 122 120 96124 104 112 128 138 100 136 120 118 128 118 128 115 120 132 118