(1) Read Homework Instruction #1 on the Instructions for All STAT 3331 Homeworks spreadsheet (located in Blackboard’s Assigned Homework folder). |
(2) Open your Homework 7.xlsb file and go to the UsedCamry sheet. |
(3) Using the Chap12 sheet in the Excel Templates spreadsheet (located on Blackboard’s Textbook/Packet Discussion board) as a guide, construct a Regression output in the designated cells. The output MUST be |
placed in these designated cells to receive any credit. To move the data into column A and B of the UsedCamry sheet, simply click on the button! On your output, make sure… |
(a) you use the 95% CI/PI defaults |
(b) your prediction block has information for x0=7.6 and x0=5.7 (in that order). |
(4) The Regression output MUST |
(a) be in bold font |
(b) be formatted to four decimal places |
(c) have an appropriate column width (i.e., a width of at least 17 for column L through column R on the UsedCamry sheet). |
(5) The following MUST be deleted off the output before answering any Homework 7 questions: |
(a) the duplicate Upper and Lower 95% C.I. endpoints for β0 and β1 |
(b) the resulting values of Multiple R and Standard Error in the Regression Statistics section. (Do not delete the words “Multiple R” and “Standard Error”.) |
(6) Re-save the Homework 7.xlsb file. |
(7) Once you are finished with your homework, follow Homework Instruction #2 on the Instructions for All STAT 3331 Homeworks spreadsheet to submit your homework for grading. |