Using Excel, go to Data, select Data Analysis, choose Regression. Put Stress in X input range and Depression in Y input range.
SUMMARY OUTPUT | ||||||
Regression Statistics | ||||||
Multiple R | 0.647 | |||||
R Square | 0.418 | |||||
Adjusted R Square | 0.345 | |||||
Standard Error | 5.326 | |||||
Observations | 10 | |||||
ANOVA | ||||||
df | SS | MS | F | Significance F | ||
Regression | 1 | 163.072 | 163.072 | 5.749 | 0.043 | |
Residual | 8 | 226.928 | 28.366 | |||
Total | 9 | 390.000 | ||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
Intercept | 4.819 | 6.552 | 0.736 | 0.483 | -10.289 | 19.927 |
Stress | 0.490 | 0.204 | 2.398 | 0.043 | 0.019 | 0.961 |
a. b1 = 0.49
Standard error of b1 = 0.204
p-value of b1 = 0.043
b. With one unit increase in stress, depression increases by 0.49 units
c. Standardised value of b1 (Multiple R) = 0.647
d. a = 4.819
Standard error of a = 6.552
p-value of a = 0.483
e. If there is no stress, depression score will be 4.819.
f. y = 4.819 + 0.49x
Stress = 30
Depression = 4.819 + 0.49*30 = 4.819+14.7 = 19.519
3. A researcher was interested in whether there was a relationship between stress and depression scores...
PREDICTION (REGRESSION) – Chapter 12 3. A researcher was interested in whether there was a relationship between stress and depression scores obtained from emergency health care providers. The data from 10 emergency workers are below. This is the same data you calculated a correlation on in Question 1. We are trying to use stress scores (IV or Predictor) to predict depression scores (DV or outcome). Using SPSS, calculate a linear regression model: Y = a+b1X1 where Y is Depression and...
1. A researcher was interested in whether there was a relationship between stress and depression scores obtained from emergency health care providers. The data from 10 emergency workers are below. Stress Depression 38 26 28 16 42 34 18 22 26 15 45 24 32 18 26 18 22 12 33 15 Stress M = 31 , SD = 8.25 Depression M = 20, SD = 6.24 By hand, calculate the correlation coefficient. You are given the mean and standard...
Assignment 8 In this assignment you will practice calculating correlations and regressions. These are a little different than what we have done in the previous labs. In this lab we are using continuous variables. Correlations and regressions are some of the most common types of statistical procedures. There are countless variations of the regression based model, but they all attempt to accomplish the same thing: prediction. This assignment will help you get the basics. You should use the two lab...
A psychologist wanted to assess the relationship between depression and self-esteem. She believes that as depression increases, self-esteem decreases. She asked a group of 25 participants to complete both Beck’s Depression Inventory (Beck, Ward, Mendelson, Mock, & Erbaugh, 1961) and Rosenberg’s Self-Esteem Scale (1965). The data for each participant is as follows: Depression (X) Self-Esteem (Y) 60 11 27 34 15 33 30 24 56 14 52 16 40 23 49 33 24 27 38 26 48 17 58 10...
A nurse is interested in whether there is a relationship between daily levels of stress and likelihood of a heart attack. The stress scores (predictor variable) and risk of heart attack values (criterion variable) from a small sample of participants are depicted below. Stress Score Risk of Heart Attack (Higher values = more stress) (Higher values = greater risk) 8 3 4 8 1 8 3 2 What is the Pearson's r value?
The student government association wanted to demonstrate the relationship between the # of beers (“beers”) a student drinks and their blood alcohol content (“BAC”). A random sample of students participated in a study, and the data below was obtained. Use alpha = .05 for statistical tests. Given the following two regression output tables, answer the questions: ANOVA df SS MS F Significance F Regression 1 0.002811 0.002811 10.11611 0.015478078 Residual 7 0.001945 0.000278 Total 8 0.004756 Coefficients Standard Error t...
Erika Diaz Your name Assignment 10 Correlation, Scatterplot, and Prediction (due 7/30/20 - 1/4/20)(28 pts) 1. A teacher hypothesizes that the more days of school student misses, the worse the student will do on a final exam (possible scores on the exam range from 0 to 20). She obtained a random sample of 12 students. The data are shown below. Student days missed Final exam score 1 3 16 2 2 17 3 5 13 4 8 7 5 4...
BBA 403 TEST 3: Name: Score:_ SOLVE AND THOROUGHLY INTERPRET YOUR ANSWER 1. A marketing manager conducted a study to determine whether there is a linear relationship between many spent on advertising and company sales. The data are shown on the table below. Display the data in a scatter plot, calculate the correlation coefficient, state a conclusion, and interpret the result Adverstising Company Expense, (1000s of s) (1000s of ) 2.4 16 2.0 26 14 1.6 2.0 2.2 184 220...
1. (55 points) The investigators are interested in asses the relationship between Systolic Blood Pressure (SBP) in mm Hg and Age in years among Hypertensive Patients. Specif- ically, whether a patient's SBP can be predicted from his or her age. They selected n=122 patients at random from a medical record database in a hospital. Assume that the simple linear regression model is appropriate. The following table shows regression output of a simple linear regression model relating the SBP to the...
(28 pts) A grocery store manager did a study to look at the relationship between the amount of time (in minutes) customers spend in the store and the amount of money (in dollars) they spend. The results of the survey are shown below. Time: 18 24 9 32 12 17 22 28 15 21 19 Money: 31 30 26 79 24 37 45 88 22 35 25 (4 pts) What is the value of the correlation coefficient? (12 pts) Test...