Module 5 assignment (2) Q Search Sheet View Home Insert Page Layout Formulas Data Review Insert E Calibri (Body) * 11 . A- A = Wrap Text General AP . = = x Delete #+ Merge & Center $ - % " -00 Conditional Format Cell Sort & Formatting as Table Styles Format Filter Paste F12 X v fx K M N 0 P Q F G H A B C D E Attribution: Data source: Applied Regression Models, (4th edition), Kutner, Neter, and Nachtsheim 1 Triceps Thigh Midarm Bodyfat z-score outlier? 19.5 43.1 29.1 1. IN 24.7 49.8 28.2 22.8 30.7 51.9 37 18.7 Outlier Parameters Calculate for Bodyfat Column 29.8 54.3 31.1 20.1 mean 19.1 42.2 30.9 12.9 QR: median: 23.7 21.7 Lower Limit 25.6 53.9 58.5 27.6 27.1 Upper Limit mode: 31.4 # of outliers standard deviation: 27.9 52.1 30.6 25.4 # of outliers 10 22.1 49.9 23.2 21.3 11 25.5 53.5 24.8 19.3 Run a multiple regression that predicts bodyfat based on midarm, thigh, and 12 31.1 56.6 30 25.4 triceps measurements. 13 30.4 56.7 28.3 27.2 14 18.7 46.5 23 11.7 Write your equation here: 15 19.7 44.2 28.6 17.8 Using the model, provided, find the predicted body fat of someone who has a 16 14.6 42.7 21.3 12.8 triceps measurement of 21.4, thigh of 45.6, and midarm measurement of 27.6. 17 29.5 54.4 30.1 23.9 Show your work below: 18 27.7 55.3 25.7 22.6 19 30.2 58.6 24.6 25.4 20 22.7 48.2 27.1 14.8 21 25.2 51 27.5 21.1 22 23 24 25 26 27 28 29 30 Linear Regression Data Mult Regression_Height Mult Regression_Bodyfat + + 120% Ready