Question

In: Statistics and Probability

Based on your scatter diagram, is there a relationship between the variables? If yes, describe the...

Based on your scatter diagram, is there a relationship between the variables? If yes, describe the relationship.
-Does it appear to be positive or negative? Strong or weak or moderate?
-What would your guess of r, the correlation coefficient, be?

Solutions

Expert Solution

We will describe the relationship from scatter diagram and its direction.

For example:

1. Bring data in to excel sheet

2.Select both x and y variable and insert scatter plot chart. Select any data point in the excel and add trend line.

Does it appear to be positive or negative? Strong or weak or moderate?

It appears to be a positive and it looks like Strong positive

  1. Values between 0 and 0.3 (0 and -0.3) indicate a weak positive (negative) linear relationship
  2. Values between 0.3 and 0.7 (-0.3 and -0.7) indicate a moderate positive (negative) linear relationship
  3. Values between 0.7 and 1.0 (-0.7 and -1.0) indicate a strong positive (negative) linear relationship

What would your guess of r, the correlation coefficient, be?

we can use "=CORREL(Array 1, Array 2) " formula in excel to find the r value

correlation coefficeint r = 0.70. as we mentioned the strength from 0.70 to 1.00 is strong positive correlation  


Related Solutions

1) Construct a scatter diagram and comment on the relationship, if any, between the variables Weekly Hours and Weekly Earnings.
Using the table of data at the bottom. Part One: 1) Construct a scatter diagram and comment on the relationship, if any, between the variables Weekly Hours and Weekly Earnings. 2) Determine and interpret the correlation for hours worked and earnings. The CORREL function in Excel will be helpful. Based upon the value of the correlation, is your answer to the previous question reasonable? 3) Based upon the data given, estimate the average weekly earnings for a workweek of 33.8...
Contract the scatter plot of these data. Describe relationship between x and y. What type of relationship appears to exist between two variables?
Use the following data: x y 10 3 6 7 9 3 3 8 2 9 8 5 3 7 Contract the scatter plot of these data. Describe relationship between x and y. What type of relationship appears to exist between two variables? (you can copy and past from Excel,SAS,etc) Compute the correlation coefficient r. Test to determine whether the population correlation coefficient is positive. Use the α=0.01 level to conduct test. (calculate test statistics and make conclusion)
Using a scatter plots describe the relationship between (i) Hwage and Educ and (ii) Hwage and...
Using a scatter plots describe the relationship between (i) Hwage and Educ and (ii) Hwage and Exper. Use Hwage as the Y-variable Hwage Educ Exper Female 9 10 27 0 5.5 12 20 0 3.8 12 4 1 10.5 12 29 1 15 12 40 0 9 16 27 1 9.57 12 5 1 15 14 22 0 11 8 42 0 5 12 14 1 24.98 17 18 0 20.4 17 3 0 25 14 4 0 13.98 14...
Describe in words the nature of the relationship between each pair of variables as indicated by...
Describe in words the nature of the relationship between each pair of variables as indicated by the value of the correlation coefficient. Be sure to include     a. the direction of the relationship     b. the strength of the relationship.     c. a verbal description of the way the variables "go together." Please read the interpretation below, to considered your interpretation complete, you need to write the verbal description with a similar format. The first sentence describes the direction and...
What is the purpose of a scatter diagram (Scatter plot)? (Please provide Scatter plot examples)
What is the purpose of a scatter diagram (Scatter plot)? (Please provide Scatter plot examples)
Scatter diagrams allow us to see relationships between two variables. Cite an example of two variables...
Scatter diagrams allow us to see relationships between two variables. Cite an example of two variables that might have a strong positive relationship. What would that scatter diagram look like? Next, cite an example of two variables that have very little relationship and describe what that scatter diagram would look like. Last, tell us why illustrating data in this way is helpful. Can this be typed out? It's for a discussion board.
Describe if there is a relationship between the variables Product Quality, Competitive Price, Accessibility, and Advertising...
Describe if there is a relationship between the variables Product Quality, Competitive Price, Accessibility, and Advertising Capability towards Customer Satisfaction, use these data Customer Satisfaction Customer Satisfaction Pearson Correlation 1 Sig. (2-tailed) N 100 Product Quality Pearson Correlation .486** Sig. (2-tailed) .000 N 100 Competitive Price Pearson Correlation .113 Sig. (2-tailed) .265 N 100 Accessibility Pearson Correlation .305** Sig. (2-tailed) .002 N 100 **. Correlation is significant at the 0.01 level (2-tailed). 2. State also the hypothesis 3. which has...
Is there a relationship between the variables and Success Rating?
Is there a relationship between the variables and Success Rating?
create an entity relationship diagram to describe the data requirements of the system. Your client is...
create an entity relationship diagram to describe the data requirements of the system. Your client is a local real estate company that wants to automate some of their processes. Here is how some of the business is described: - In a real estate transaction, there is a buyer, a seller, a property, a purchase agreement and a real estate agent - A seller may have one or more properties to sell - A buyer wants to buy only one property...
1) One way to graphically present a bivariate relationship. A. Pie Graph B. Scatter diagram 2)...
1) One way to graphically present a bivariate relationship. A. Pie Graph B. Scatter diagram 2) A correlation coefficient close to 0 indicates the relationship between the two variables. A. is very strong B.   is very weak 3) A correlation of -0.48 is _____ than a correlation of +0.36, whereas a correlation of .79 is _____ than a correlation of -0.25. A. Stronger, weaker B. Stronger, stronger 4) The technique used to develop the equation describing the relationship between two variables....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT