Scribd Logo
Upload

Welcome to Scribd!

  • 14 views

    Day-2 Q2 Correlational-Test

    Uploaded by

    hotdog sunog
    Here are the steps to determine Pearson's correlation coefficient (r) using Microsoft Excel: 1. Enter the data for the two variables in separate columns. 2. Select the data range for both variables (including the column headers). 3. Go to the Data tab and click Correlation. 4. The correlation coefficient (r) will appear in the Correlation dialog box. 5. Copy or note the r value. 6. Interpret the r value based on its sign (positive or negative) and magnitude (closer to 1 or -1 indicates a stronger correlation). For example, if r = 0.87, this would indicate a strong positive correlation, meaning that as one variable increases,

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Day-2 Q2 Correlational-Test

    Uploaded by

    hotdog sunog
    14 views13 pages
    Here are the steps to determine Pearson's correlation coefficient (r) using Microsoft Excel: 1. Enter the data for the two variables in separate columns. 2. Select the data range for both variables (including the column headers). 3. Go to the Data tab and click Correlation. 4. The correlation coefficient (r) will appear in the Correlation dialog box. 5. Copy or note the r value. 6. Interpret the r value based on its sign (positive or negative) and magnitude (closer to 1 or -1 indicates a stronger correlation). For example, if r = 0.87, this would indicate a strong positive correlation, meaning that as one variable increases,

    Original Title

    Day-2 Q2 Correlational-Test (2)

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Here are the steps to determine Pearson's correlation coefficient (r) using Microsoft Excel: 1. Enter the data for the two variables in separate columns. 2. Select the data range for both variables (including the column headers). 3. Go to the Data tab and click Correlation. 4. The correlation coefficient (r) will appear in the Correlation dialog box. 5. Copy or note the r value. 6. Interpret the r value based on its sign (positive or negative) and magnitude (closer to 1 or -1 indicates a stronger correlation). For example, if r = 0.87, this would indicate a strong positive correlation, meaning that as one variable increases,

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    14 views13 pages

    Day-2 Q2 Correlational-Test

    Uploaded by

    hotdog sunog
    Here are the steps to determine Pearson's correlation coefficient (r) using Microsoft Excel: 1. Enter the data for the two variables in separate columns. 2. Select the data range for both variables (including the column headers). 3. Go to the Data tab and click Correlation. 4. The correlation coefficient (r) will appear in the Correlation dialog box. 5. Copy or note the r value. 6. Interpret the r value based on its sign (positive or negative) and magnitude (closer to 1 or -1 indicates a stronger correlation). For example, if r = 0.87, this would indicate a strong positive correlation, meaning that as one variable increases,

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 13

    PRACTICAL RESEARCH 2

    MAUREEN M. NERI
    LEARNING
    OBJECTIVE
    Uses statistical techniques to
    analyze data—study of differences
    and relationships limited for
    bivariate analysis.
    Correlation
    ❖ is used to determine the existence,
    strength, and direction of the
    relationship between two variables.
    Correlation coefficient r is a number
    between -1 and 1 that describes both
    the strength and the direction of
    correlation. In symbol, we write -1 ≤ r
    ≤ 1.
    ❖ is also known as Pearson r.
    Pearson Product
    ❖ is a statistical measure that
    Moment quantifies the linear relationship
    between two variables. It is a value
    Correlational Test between -1 and 1, where -1 indicates
    a perfect negative correlation, 0
    indicates no correlation, and 1
    indicates a perfect positive
    correlation 1.
    The formula for calculating the Pearson correlation coefficient is as follows:

    Where:
    X – refers to the first (independent) variable
    Y – refers to the second (dependent) variable
    Interpretation of r value
    Interpretation of r value
    ❖ Positive r value means direct relationship (as one value
    increases, the other one increases as well).

    ❖ Negative r value means indirect/inverse relationship (as one


    value increases, the other one decreases).
    Testing for the significance of the Pearson correlation coefficient
    The Pearson correlation coefficient can also be used to test
    whether the relationship between two variables is significant.

    Where:
    r – Pearson’s r value
    n – number of sample
    EXAMPLE
    Research Question: Is there a relationship between the number of
    absences and final average grade of students?
    A Pearson r correlation test was run in
    Microsoft Excel to determine if there is a
    relationship in the number of absences and
    final average grade of students.
    The computed r value (r = -0.87) indicates a
    strong negative correlation. This means that
    the higher the number of absences, the lower
    the final average grade and vice versa. This
    also implies that the two variables are strongly
    associated with each other.
    𝑟 𝑑𝑓 = 𝑛 − 2 = 7 − 2 𝛼 = 0.05
    𝑡=
    1 − 𝑟2 𝑑𝑓 = 5
    𝑛−2
    𝑡 𝑐𝑟𝑖𝑡𝑖𝑐𝑎𝑙 𝑣𝑎𝑙𝑢𝑒 = ±2.571
    −0.87
    𝑡=
    1 − −0.87 2
    7−2
    −0.87
    𝑡=
    0.22
    𝑡 = −3.95
    Example: Reporting the Pearson correlation coefficient in APA Style

    To determine if there is a significant relationship in the number of


    absences and final average grade of students, t-test was run.
    The number of absences and final average grade of students are
    strongly correlated and statistically significant, r(5) = -.87, p <
    0.05.
    Note:
    •If the t value is greater than the critical value, then the relationship is statistically significant (p < α). The data
    allows you to reject the null hypothesis and provides support for the alternative hypothesis.

    •If the t value is less than the critical value, then the relationship is not statistically significant (p > α). The data
    doesn’t allow you to reject the null hypothesis and doesn’t provide support for the alternative hypothesis.
    LEARNING TASK 2
    Directions: Determine the value of Pearson’s correlation coefficient
    (r) using Microsoft Excel and give an interpretation.

    You might also like