Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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. (1 mark) The slope of the least squares regression line is Answerpositivenegative

  2. (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
  3. (1 mark) The highest Anxiety Score had the highest DASS Score Answertruefalse

  4. (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

  5. (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).

  6. (1 mark) The p-value for testing the slope of the regression line is less than 0.05. Answertruefalse

  7. (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

  8. (1 mark) The correlation is: Answer (3dp - remember to include a negative sign if appropriate)

  9. (2 marks) Use the regression equation to predict the DASS Score for a student whose Anxiety Score is 9 (3dp): Answer

  10. (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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting For Sustainability

Authors: Gunnar Rimmel

1st Edition

0367478927, 9780367478926

More Books

Students also viewed these Accounting questions