Mathematics Homework Help

STAT 211 ERAU Low Negligible Negative Correlation Between the Variables Analysis

Get Your Custom Essay Written From Scratch
We have worked on a similar problem. If you need help click order now button and submit your assignment instructions.
Just from $13/Page
Order Now

Introduction

A person studying in the kitchen while eating an apple and a croissant. 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.

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.

Spreadsheet with data on altitude  (X) and altimeter error (Y). Includes a scatter plot and r value. 

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?