This preview has intentionally blurred parts. Sign up to view the full document

View Full Document

Unformatted Document Excerpt

AGE MONTH SEX HEADLEN HEADWTH NECK LENGTH CHEST WEIGHT Module 6 19 7 1 11 5.5 16 53 26 80 Spreadsheet Assignment 55 7 1 16.5 9 28 67.5 45 344 81 9 1 15.5 8 31 72 54 416 115 7 1 17 10 31.5 72 49 348 104 8 2 15.5 6.5 22 62 35 166 Open the file on your computer, work on the problems, re-saving your file in .xls format always 100 4 2 13 7 21 70 41 220 56 7 1 15 7.5 26.5 73.5 41 262 You may copy the data and/or problems to additional sheets in this workbook or work on this page. 51 4 1 13.5 8 27 68.5 49 360 To add a sheet, click Shift+F11. Or right-click on the sheet tab, which also al ows you to rename the tab. 57 9 2 13.5 7 20 64 38 204 53 5 2 12.5 6 18 58 31 144 Attach the file in the assignment drop box for Module 6. 68 8 1 16 9 29 73 44 332 8 8 1 9 4.5 13 37 19 34 44 8 2 12.5 4.5 10.5 63 32 140 Copy the data set into this spreadsheet. 32 8 1 14 5 21.5 67 37 180 Please organize your work so that it is easily understood. Some people put each problem on a separate sheet with label ed tabs. 20 8 2 11.5 5 17.5 52 29 105 Be sure to show your calculations and/or paste in results from StatCrunch, DDXL, etc. 32 8 1 13 8 21.5 59 33 166 Remember to use 4-Step problem solving process: Declare, Strategize, Execute, Deduce. Always characterize the distributions. 45 9 1 13.5 7 24 64 39 204 9 9 2 9 4.5 12 36 19 26 Problem 1 (25 points) 21 9 1 13 6 19 59 30 120 177 9 1 16 9.5 30 72 48 436 Find the correlations of various pairs of data column: HeadLength, HeadWidth, Neck, Length, Chest, Weight (there wil be 15 pairs) 57 9 2 12.5 5 19 57.5 32 125 81 9 2 13 5 20 61 33 132 21 9 1 13 5 17 54 28 90 HdLngth HdWidth Neck Length Chest Weight 9 9 1 10 4 13 40 23 40 HdLngth 1 45 9 1 16 6 24 63 42 220 HdWidth 1 << fil in yel ow cel s 9 9 1 10 4 13.5 43 23 46 Neck 1 33 9 1 13.5 6 22 66.5 34 154 Length 1 57 9 2 13 5.5 17.5 60.5 31 116 Chest 1 45 9 2 13 6.5 21 60 34.5 182 Weight 1 21 9 1 14.5 5.5 20 61 34 150 10 10 1 9.5 4.5 16 40 26 65 82 10 2 13.5 6.5 28 64 48 356 Problem 2 (25 points) 70 10 2 14.5 6.5 26 65 48 316 10 10 1 11 5 17 49 29 94 10 10 1 11.5 5 17 47 29.5 86 give regression equations for Neck, Length, Chest, Weight (as response variables), and provide each correlation value R (there wil be 4) 34 10 1 13 7 21 59 35 150 Using the value of 12.95 for Head Length, predict each response variable. Which are you most / least confident about? 34 10 1 16.5 6.5 27 72 44.5 270 34 10 1 14 5.5 24 65 39 202 Note: the regression equation is a linear equation of the form: y = m*x + b, where m is the slope and b is the y-intercept 58 10 2 13.5 6.5 21.5 63 40 202 58 10 1 15.5 7 28 70.5 50 365 Using the Excel regression tool in the Analysis Toolpak, the coefficients are given in the bottom table. 11 11 1 11.5 6 16.5 48 31 79 StatCrunch regression provides the coefficients as intercept and slope 23 11 1 12 6.5 19 50 38 148 Statdisk correlation and regression cal s the coefficients y-intercept and slope 70 10 1 15.5 7 28 76.5 55 446 DDXL simple regression refers to the y-intercept as the Constant coefficient... View Full Document

End of Preview

Sign up now to access the rest of the document