HW 6 Answers - AGE Module 6 Spreadsheet Assignment First,...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
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
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 13

HW 6 Answers - AGE Module 6 Spreadsheet Assignment First,...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online