solution
Instructions: You will need to run the data below and answer the following question: Question: What is the correlation coefficient for this model? On that same excel sheet, write the answer to the question. It has to be explicitely stated to be graded. Use a 4 decimal number Save your Excel sheet with your last name and upload it (under attach file, select browse my computer and upload the excel sheet) Data: A doctor office has collected the following data on patients blood pressure along with their age and weight. They are interested to explore if there is any relationship between age and weight with their level of blood pressure. In other words the stipulated modells: Y(blood pressure level) = 60+b 1 (Age). b 2 (weight) Below is the data. Run a linear regression with Excel and answer the question below (Note that you can copy and paste the data into Excel Sheet to save time). Blood Pressure Age (years) Weight (lbs) Y X1 X2 125 52 173 140 59 184 153 67 194 162 73 186 154 64 1969 168 74 220 132 54 149 61 188 159 65 207 128 46 167 166 72 200 Do not forget to write the answer to question above on your excel sheet!
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

