Mathematics Homework Help
STAT 211 ERAU Low Negligible Negative Correlation Between the Variables Analysis
Introduction
Now that you have compared the altimeters on 20 flights, you are concerned about the amount of error. This question popped into your head, “Is there a correlation between altitude and altimeter error?”
The goal of the assignment is to effectively use the formulas and functions to determine if there is a relationship between altimeter error and measurement error. Complete the following steps:
- Run the regression and calculate r.
- Interpret the data.
- Submit your results.
Run Regression and Calculate r
To run the regression and calculate r, open the STAT 211 Does Higher Lead to Error (XLSX) spreadsheet. 
Download STAT 211 Does Higher Lead to Error (XLSX) spreadsheet.Column A will contain altitude for 20 randomly selected customers. Column B will include altimeter error.
To populate column A, copy one of the Altitude in Feet columns (D-H in yellow) (cells 3-22) and paste it into cell A3. To populate column B, copy one of the Altimeter Error in Feet columns (J-O in blue) (cells 3-22) and paste it in cell B3.
Once you have the two columns with 20 values each, use these resources to run the regression and include the Pearson’s r correlation coefficient.
- How to do a Linear Regression on Excel (YouTube 5:18) (Links to an external site.)
- Step-by-Step Instructions: Scatter Plot, Trend Line, and Correlation
When you are finished, your spreadsheet should look similar to the following example. Remember, your numbers will be different, so your regression line will also be different (either positivity or negatively skewed). We are not looking for the “right number” to an assignment question. The goal of the assignment is to effectively use the formulas and functions of excel to evaluate your data, then interpret the results.
Interpret the Data
Now evaluate your data and interpret the results. Answer the following questions in a document.
- What is Pearson’s r that you calculated, and what does it tell us?
- What is the r2 that you calculated, and what does it tell us?
- Is this a good model for prediction? Why or why not?
- Is there a relationship between altitude and altimeter error?
