1. For the data set below, calculate the correlation between X and Y to three (3
ID: 3244917 • Letter: 1
Question
1. For the data set below, calculate the correlation between X and Y to three (3) decimal places.
Hints:
I strongly recommend using Excel's = CORREL function, which is available in both PC and Mac versions. It is also available in various "knock-off" versions of Excel such as OpenOffice or Libre Office Calc.
1). Open a blank workbook
2). Copy and paste the data below into the blank workbook
3). In a blank cell, type =CORREL(
4). Select the X data
5). Type a comma: ,
6). Select the Y data
7). Type ) and hit Enter
The number that you get is the correlation that you would enter as the answer.
If you have a TI-83 or similar graphing calculator, you can calculate the correlation by doing the following:
1). From a blank screen, go to STAT EDIT 1: Edit.
2). Type the X data into L1 and the Y data into L2.
3). Go to STAT CALC 2: 2-Var Stats. Hit ENTER, and then ENTER again.
You will then get some statistics that you would then need to plug into the correlation formula in the notes.
2.
the dean of a college of business wants to create some marketing materials to advertise its MBA in finance. The university sends a survey to a random sample of individuals with MBAs who are mutual fund managers for large investment firms. The survey asked two questions: "What was the rank of your MBA program" and "Did your funds outperform the market last year?" The responses were entered into a 3x2 contingency table such as the one shown below. What value of the chi-squared distribution marks the rejection region for a test at the 0.01 level of significance? Hint: you don't need the actual data in the table to find this; that is why the table below is blank.
What value of the chi-square distribution, to two decimal places, would mark the rejection region for a test at the 0.01 level of significance?
3.
A political scientist is interested in the relationship between someone's political views and his or her optimism about the future. A random sample of 1,092 American adults 18 and over was taken and the following questions were asked:
1). What are your political views (conservative, moderate, liberal)?
(This variable is called "POLITICS" for short).
2). When your children are the age you are at right now, what do you believe their standard of living will be (worse, about the same, or better)?
(This variable is called "OPTIMISM" for short).
The researcher decides to conduct a chi-squared test of independence at the 0.05 level of significance.
The data for the experiment are summarized in the following table:
Using the observed counts and expected counts that are given to you, calculate the test statistic to two decimal places.
x y 3 39 4 22 26 48 49 21 47 34 9 16 19 2 17 38 30 55 36 2 21 8 47 18 29 48Explanation / Answer
(1)
x y 3 39 4 22 26 48 49 21 47 34 9 16 19 2 17 38 30 55 36 2 21 8 47 18 29 48 Correlation coefficient = -0.01855Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.