2
ACCT 3302 – ASSESSMENT #1
– PART C JAN-22 - 20 MARKS.
A NAIT instructor is trying to predict the 2022 final exam grade of Acct4402 students based on their
grades on two term tests and a case study. Actual 2021 data for 25 students can be found on the
Moodle website. Download this data, perform all required regression operations, and answer
the questions below.
Type your answer to each question using WORD. Use a BOLD RED font for
your answers.
Be specific and state any statistical values, benchmarks or graphs that are relevant in
your answers. Your answers should reflect a level of understanding suitable for a third
year college accounting student
When you are done be sure to drop this file into the Dropbox provided.
a) Regress the data using Excel and state the multiple regression equation in
mathematically correct understandable terms. (4 marks)
ESTIMATED FINAL EXAM GRADE= -12.4813 + 0.7994 (#TEST1) + 0.4077
(#TEST2) +
-0.1584 (#CASE STUDY)
b) How do you explain the negative Y-intercept in the equation above? (2 marks)
THE INTERCEPT IS CALCULATED WHEN ALL X’S ARE ZERO. SINCE OUR MODEL
X’S ARE ALL MUCH HIGHER THAN ZERO THE INTERCEPT ALONE IS OUTSIDE
THE RELEVANT RANGE OF OUR MODEL.
This study source was downloaded by 100000848934517 from CourseHero.com on 07-09-2022 12:54:06 GMT -05:00
https://www.coursehero.com/file/150360564/2022-EXAM-QUESTION-1docx/
ACCT 3302 – ASSESSMENT #1
– PART C JAN-22 - 20 MARKS.
A NAIT instructor is trying to predict the 2022 final exam grade of Acct4402 students based on their
grades on two term tests and a case study. Actual 2021 data for 25 students can be found on the
Moodle website. Download this data, perform all required regression operations, and answer
the questions below.
Type your answer to each question using WORD. Use a BOLD RED font for
your answers.
Be specific and state any statistical values, benchmarks or graphs that are relevant in
your answers. Your answers should reflect a level of understanding suitable for a third
year college accounting student
When you are done be sure to drop this file into the Dropbox provided.
a) Regress the data using Excel and state the multiple regression equation in
mathematically correct understandable terms. (4 marks)
ESTIMATED FINAL EXAM GRADE= -12.4813 + 0.7994 (#TEST1) + 0.4077
(#TEST2) +
-0.1584 (#CASE STUDY)
b) How do you explain the negative Y-intercept in the equation above? (2 marks)
THE INTERCEPT IS CALCULATED WHEN ALL X’S ARE ZERO. SINCE OUR MODEL
X’S ARE ALL MUCH HIGHER THAN ZERO THE INTERCEPT ALONE IS OUTSIDE
THE RELEVANT RANGE OF OUR MODEL.
This study source was downloaded by 100000848934517 from CourseHero.com on 07-09-2022 12:54:06 GMT -05:00
https://www.coursehero.com/file/150360564/2022-EXAM-QUESTION-1docx/
