Foreclosure scores- Week 1- 105 Week 2- 65 Week 3- 135 Week 4- 65 Week 5- 190 Ac
ID: 3355452 • Letter: F
Question
Foreclosure scores- Week 1- 105 Week 2- 65 Week 3- 135 Week 4- 65 Week 5- 190 Actual scores- Week 1- 100 Week 2- 65 Week 3- 134 Week 4- 60 Week 5- 190This is a personal case study. Each case study will be unique to the student submitting it.
My Wednesday of Week 1 forecasts your scores you think you will achieve for Weeks, 1, 2, 3, and 4, and send them to your professor. During Week 5, using your actual scores for Weeks 1, 2, 3, and 4 and your forecast values, calculate a regression equation, r, and R2 for this data. Prepare a case study document to answer the following questions. The case study should have a cover page, intro, and body that follows APA format. If a reference is used, such as our text, then a reference page should be included, and appropriate citation(s) should appear in the body of your case study. See the sample case study above for guidance. 1. What data did you use in your regression equation? Which is the independent and dependent variable? 2. What is the regression equation, r, and R2 for your data? 3. Statistically, what does r and R2 tell you? 4. Based on your empirical evidence, how who well did you forecast your results? Justify your response. You can use any method you like to complete this assignment; however, you need to show your work. Two items in Excel are useful. The correl function will return the correlation coefficient and add-in called "Data Analysis" has a function called regression that will provide all the rest of the information you should need. Foreclosure scores- Week 1- 105 Week 2- 65 Week 3- 135 Week 4- 65 Week 5- 190 Actual scores- Week 1- 100 Week 2- 65 Week 3- 134 Week 4- 60 Week 5- 190
This is a personal case study. Each case study will be unique to the student submitting it.
My Wednesday of Week 1 forecasts your scores you think you will achieve for Weeks, 1, 2, 3, and 4, and send them to your professor. During Week 5, using your actual scores for Weeks 1, 2, 3, and 4 and your forecast values, calculate a regression equation, r, and R2 for this data. Prepare a case study document to answer the following questions. The case study should have a cover page, intro, and body that follows APA format. If a reference is used, such as our text, then a reference page should be included, and appropriate citation(s) should appear in the body of your case study. See the sample case study above for guidance. 1. What data did you use in your regression equation? Which is the independent and dependent variable? 2. What is the regression equation, r, and R2 for your data? 3. Statistically, what does r and R2 tell you? 4. Based on your empirical evidence, how who well did you forecast your results? Justify your response. You can use any method you like to complete this assignment; however, you need to show your work. Two items in Excel are useful. The correl function will return the correlation coefficient and add-in called "Data Analysis" has a function called regression that will provide all the rest of the information you should need. Foreclosure scores- Week 1- 105 Week 2- 65 Week 3- 135 Week 4- 65 Week 5- 190 Actual scores- Week 1- 100 Week 2- 65 Week 3- 134 Week 4- 60 Week 5- 190
This is a personal case study. Each case study will be unique to the student submitting it.
My Wednesday of Week 1 forecasts your scores you think you will achieve for Weeks, 1, 2, 3, and 4, and send them to your professor. During Week 5, using your actual scores for Weeks 1, 2, 3, and 4 and your forecast values, calculate a regression equation, r, and R2 for this data. Prepare a case study document to answer the following questions. The case study should have a cover page, intro, and body that follows APA format. If a reference is used, such as our text, then a reference page should be included, and appropriate citation(s) should appear in the body of your case study. See the sample case study above for guidance. 1. What data did you use in your regression equation? Which is the independent and dependent variable? 2. What is the regression equation, r, and R2 for your data? 3. Statistically, what does r and R2 tell you? 4. Based on your empirical evidence, how who well did you forecast your results? Justify your response. You can use any method you like to complete this assignment; however, you need to show your work. Two items in Excel are useful. The correl function will return the correlation coefficient and add-in called "Data Analysis" has a function called regression that will provide all the rest of the information you should need. This is a personal case study. Each case study will be unique to the student submitting it.
My Wednesday of Week 1 forecasts your scores you think you will achieve for Weeks, 1, 2, 3, and 4, and send them to your professor. During Week 5, using your actual scores for Weeks 1, 2, 3, and 4 and your forecast values, calculate a regression equation, r, and R2 for this data. Prepare a case study document to answer the following questions. The case study should have a cover page, intro, and body that follows APA format. If a reference is used, such as our text, then a reference page should be included, and appropriate citation(s) should appear in the body of your case study. See the sample case study above for guidance. 1. What data did you use in your regression equation? Which is the independent and dependent variable? 2. What is the regression equation, r, and R2 for your data? 3. Statistically, what does r and R2 tell you? 4. Based on your empirical evidence, how who well did you forecast your results? Justify your response. You can use any method you like to complete this assignment; however, you need to show your work. Two items in Excel are useful. The correl function will return the correlation coefficient and add-in called "Data Analysis" has a function called regression that will provide all the rest of the information you should need.
Explanation / Answer
(a) Regression analysis is also used to understand which among the independent variables are related to the dependent variable, and to explore the forms of these relationships.
foreclosure (y) is dependent variable and acutal (x)is independent variable
(b) regression equation is y=4.092+0.985x, r=0.9971, R2=0.9943
(c) r tells about the degree of linear relationship between x and y and it ranges between -1 and 1
R2 tells how much variation explained by the model, here model explains 99.55% variation and it ranges between 0 to 1
(d) for given value of x i.e. actual we calcuate or estimate the y with using equation y=4.092+0.985x,
for example if actual(x)=100 then forcast value will be y=4.092+0.985*100=102.592
following data has been used for the analysis
foreclosure(y) actural(x) week1 105 100 week2 65 65 week3 135 134 week4 65 60