315 Final -Fall 2023 (3)

.docx

School

Morehead State University *

*We aren’t endorsed by this school

Course

370

Subject

Statistics

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by MinisterMeerkatPerson1010

MOREHEAD STATE UNIVERSITY BBA 315-Fall 2023 Final Exam Dr. S. Ali Ahmadi NAME___________________ Major:___________________ Based on the Multiple Regression Output in Excel that you have created, using the data file provided to you, answer the following questions: Note: In all Questions, where-ever needed, use the 10% level of significance to test the hypotheses ( α = 0.05 ). 1 .What is the Sample Regression Equation? 2. Which of the independent variables are significant? Why? Explain! Use α = 0.05 in ALL questions. Use only the p-value to explain your answers (No need to go to tables). 3. Test the overall significance of the model by relying on F Statistic.

4. What is the value of r-square? Using Excel formula, verify its value by using Excel Formula function. You need to use the related formula in your Formula Sheet for r-square (which as you know is: R 2 = SSR/SST) and, using the values in your Excel Printout. Use Excel formula and use the cell next to r-square to apply the formula, so that I know where to look for it! 5. Comment on the Normality assumption for the residuals for this model. In other word, has the normality assumption been satisfied? Explain your answer (Hint: you need to run Excel’s Histogram feature for the Column of the Residuals). 6. Do you see any Indication of Autocorrelation? Using Excel Formula commands, calculate the value of the Durbin-Watson test statistics in Excel, based on the data, as you know, in the Residuals column, using the formula from your Formula Sheet or look below: Durbin-Watson Test Statistics

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Recommended textbooks for you

Functions and Change: A Modeling Approach to Coll...

Algebra

ISBN:9781337111348

Author:Bruce Crauder, Benny Evans, Alan Noell

Publisher:Cengage Learning

College Algebra

Algebra

ISBN:9781305115545

Author:James Stewart, Lothar Redlin, Saleem Watson

Publisher:Cengage Learning

Glencoe Algebra 1, Student Edition, 9780079039897...

Algebra

ISBN:9780079039897

Author:Carter

Publisher:McGraw Hill

College Algebra

Algebra

ISBN:9781938168383

Author:Jay Abramson

Publisher:OpenStax

Big Ideas Math A Bridge To Success Algebra 1: Stu...

Algebra

ISBN:9781680331141

Author:HOUGHTON MIFFLIN HARCOURT

Publisher:Houghton Mifflin Harcourt

SEE MORE TEXTBOOKS

Recommended textbooks for you

Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
College Algebra
Algebra
ISBN:9781938168383
Author:Jay Abramson
Publisher:OpenStax
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt