Data, Find - Comments.. IE 3244 Regression Himalayan Vital Capacity Excel Online 1 Data below are measurements of chest circumference in cm and vital capacity of lungs of 16 male Himalayan subjects 2 who were participants in a study to determine if high altitude rewidents have larger lung capacities than do low altitude residents. Perform the following 4 1. Chart the data using Excel. 5 2. Perform a correlation analysis including a test for significance. 6 3. Perform a linear regression using both Data Analysis and Trendline regression. Obtain R2 7 4.What vitl capacity does the model predict for a subject with an 85 cm chest circumference? values. Circumference Vital Cap 10 79.4 81.8 81.8 82.3 83.7 4.8 4.7 5.0 4.9 4.4 13 14 15 16 17 18 19 20 21 6.1 4.7 5.7 5.7 87.0 87.3 87.7 88.1 88.1 88.6 89.0 89.5 12 13 24 25 26 27 28 5.0 15 16 Data, Find - Comments.. IE 3244 Regression Himalayan Vital Capacity Excel Online 1 Data below are measurements of chest circumference in cm and vital capacity of lungs of 16 male Himalayan subjects 2 who were participants in a study to determine if high altitude rewidents have larger lung capacities than do low altitude residents. Perform the following 4 1. Chart the data using Excel. 5 2. Perform a correlation analysis including a test for significance. 6 3. Perform a linear regression using both Data Analysis and Trendline regression. Obtain R2 7 4.What vitl capacity does the model predict for a subject with an 85 cm chest circumference? values. Circumference Vital Cap 10 79.4 81.8 81.8 82.3 83.7 4.8 4.7 5.0 4.9 4.4 13 14 15 16 17 18 19 20 21 6.1 4.7 5.7 5.7 87.0 87.3 87.7 88.1 88.1 88.6 89.0 89.5 12 13 24 25 26 27 28 5.0 15 16