Question

The Excel file: DASSxlsx contains information recorded on a sample of 40 of the college students' responses. The file contains the DASScore (representing level of mood) and the Arxiety Score for each student Download the data file and fit a linear regression model for predicting DASSScore (Y) from AnxietyScore (0) Use your Excel output, and any other information provided to answer the following questions. For each question, either choose the most correct option, or type in the answer to the number of decimal places specified Figure 1 Figure 2 Figure 3 . Route 1. W. R 20 15 Residus 10 Ancore 10 Answer the following questions by choosing the most correct option or typing the answer 1. (1 mark) The slope of the least squares regression line is 2.13 marks) The assumptions for a linear model appear to be reasonable since choose the figure that goes with each statement: The relationship between DASS Score and Ariety Score appears reasonably linear The residuals may be drawn from a normal distribution The residuals may have a constant standard deviation across the range of Anciety Scores 3.(1 mark) The highest Anxiety Score had the highest DASS Score 4. (2 marks) The Anxiety Score with the largest residual had a DASS Score of 88 812 and an Ariety Score of 10. Calculate the value of the residual. Type your answer with 3dp

Answer 1

B C D E А SUMMARY OUTPUT Regression Statistics Multiple R 0.693470494 R Square 0.480901326 Adjusted R Square 0.467240835 Standard Error 14.94541662 Observations 40 ANOVA df F Significance F 7.02847E-07 35.203809 Regression Residual Total 1 38 SS MS 7863.315556 7863.3156 8487.888159 223.36548 16351.20371 39 P-value Intercept X Variable 1 Coefficients 6.287397769 3.010921285 Standard Error t Stat 3.705697869 1.6966839 0.507463226 5.9332798 0.0979346 7.028E-07 Lower 95% -1.214395369 1.983615693 Upper 95% 13.78919091 4.038226878 Sheet2 Sheet1 +

1) y Be + Bx. Bo entencept ß, slope from above regression output intencept coefficient = 6.28139 slope coefficient = 3.01092 slope of the least square negresion line is 13.01092 3 here the Regression equation is 9 6.287 397 3.01092 x unit increase in Anxity 1 for Every score inncrease by scove DASS 3.01092 . The highest Anxiety score had the highest Dass score Yes