Directions

HW Excel Directions

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