Question
The Excel file DASS_Anxiety.xlsx contains information recorded on a sample of 40 of the college students responses. The file contains the DASScore (representing level of
The Excel file DASS_Anxiety.xlsx contains information recorded on a sample of 40 of the college students responses. The file contains the DASScore (representing level of mood) and the AnxietyScore for each student. Download the data file and fit a linear regression model for predicting DASSScore (Y) from AnxietyScore (X).
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.
Answer the following questions by choosing the most correct option or typing the answer:
-
(1 mark) The slope of the least squares regression line is Answerpositivenegative
- (3 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 Anxiety Score appears reasonably linear AnswerFigure 1Figure 2Figure 3None of these
- The residuals may be drawn from a normal distribution AnswerFigure 1Figure 2Figure 3None of these
- The residuals may have a constant standard deviation across the range of Anxiety Scores AnswerFigure 1Figure 2Figure 3None of these
-
(1 mark) The highest Anxiety Score had the highest DASS Score Answertruefalse
-
(2 marks) The Anxiety Score with the largest residual had a DASS Score of 51.1 and an Anxiety Score of 8. Calculate the value of the residual. Type your answer with 3dp Answer
-
(2 marks) The absolute value of the test statistic for testing the slope of the regression line is: Answer (3dp) with degrees of freedom equal to: Answer (integer).
-
(1 mark) The p-value for testing the slope of the regression line is less than 0.05. Answertruefalse
-
(2 marks) Select the most appropriate conclusion to the question Is the Anxiety Score of a student a useful predictor for the students DASS Score?. AnswerThere is a significant negative linear relationship between DASS Score and the Anxiety Score.There is not enough evidence to indicate that the Anxiety Score is a useful predictor of a students DASS Score.There is a significant positive linear relationship between DASS Score and the Anxiety Score
-
(1 mark) The correlation is: Answer (3dp - remember to include a negative sign if appropriate)
-
(2 marks) Use the regression equation to predict the DASS Score for a student whose Anxiety Score is 9 (3dp): Answer
-
(3 marks) We are 95% confident that for each extra score for Anxiety, the average DASS Score is expected to Answerincreasedecrease between Answer (lower limit) and Answer (upper limit). Type your answers with 3dp.
| AnxietyScore | DASSScore | |
| 8 | 15.08122 | |
| 4 | 23.19532 | |
| 12 | 42.39401 | |
| 10 | 25.75587 | |
| 8 | 51.09966 | |
| 5 | 16.96568 | |
| 0 | 2.349467 | |
| 1 | 0.267959 | |
| 10 | 47.4848 | |
| 1 | 3.787423 | |
| 4 | 42.00374 | |
| 8 | 7.60902 | |
| 6 | 12.44567 | |
| 9 | 30.58308 | |
| 25 | 62.64683 | |
| 5 | 18.75553 | |
| 12 | 30.96183 | |
| 8 | 38.2575 | |
| 0 | 5.2406 | |
| 3 | 28.65528 | |
| 2 | 12.19127 | |
| 7 | 18.17264 | |
| 1 | 15.80457 | |
| 3 | 12.90154 | |
| 1 | 14.88175 | |
| 13 | 7.192944 | |
| 2 | 16.30841 | |
| 2 | 17.93904 | |
| 0 | 12.12141 | |
| 4 | 7.886561 | |
| 10 | 8.779442 | |
| 1 | 4.413921 | |
| 1 | 7.815313 | |
| 13 | 34.30991 | |
| 8 | 20.80715 | |
| 16 | 36.99705 | |
| 9 | 39.73929 | |
| 22 | 48.63596 | |
| 3 | 0.4154 | |
| 3 | 1.242671 | |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Accounting For Sustainability
Authors: Gunnar Rimmel
1st Edition
0367478927, 9780367478926
