Tute Exercise 5

22
Introduction and Objectives: There are 3 parts to this tutorial exercise. All 3 parts use the data in the sheet named "Auction". In parts 1 and 2 you will investigate how results can change when multiple regression is used r explore the meaning of R 2 , the relationship between R 2 and the correlation coefficient, and som tool. You will perform a hypothesis test for the slope in part 3. Instructions: As indicated above, there are 3 parts to this exercise, each on separate worksheets (as labelled tab and complete the tasks outlined within them. Be sure to paste the appropriate Excel output i worksheets for any working if needed. Once you have completed all three parts, save your work for future reference. Feedback on the exercise will be provided on Blackboard next week; this week's exercises are

Transcript of Tute Exercise 5

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 1/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 2/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 3/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 4/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 5/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 6/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 7/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 8/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 9/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 10/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 11/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 12/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 13/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 14/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 15/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 16/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 17/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 18/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 19/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 20/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 21/22

7/27/2019 Tute Exercise 5

http://slidepdf.com/reader/full/tute-exercise-5 22/22