MATH 105 - INTRO TO STATISTICS COMPUTER PROJECT #2 You will analyze data from two different files: one will be data from a survey conducted on the first day of class (F24 Project 2 survey data.xlsx), and the other will be state educational data (State Educational Data.xlsx). The data files are posted in Canvas under the assignment "Project #2", along with a link to Crunch It. Use Microsoft Word (or a comparable program) to create a report document. At the top of the document, type your name, Math 105, and Project #2. Follow the instructions in "Project Guidelines". You will submit your project document in Canvas, saved as a PDF. 1. Using the Survey data (Note: The survey was conducted in several sections of statistics classes.): a. Select Insert Random Numbers Uniform, then input 0 for Minimum, 1 for Maximum, 180 for Samples, then click the Samples button. A new column of numbers is added to the data set. Move your mouse to the variable name for this column, click the down arrow, then choose Sort Ascending. Scroll down to the last case, click to the left of the row number to select it, then choose FilteringExclude Selected. Repeat the instructions in the previous sentence for the second-last case. Identify, by giving the height and handspan, the two cases that were excluded.

b. Generate Descriptive Statistics for the height (X, in inches) and the handspan (Y, in centimeters) of USF statistics students.

c. Choose Statistics Regression Simple Linear. Specify your dependent (Y) and independent (X) variables. Produce numeric results by selecting Numeric Results under Display.

d. Again, choose Statistics Regression Simple Linear, and select Fitted Plot under Display. Divide this scatterplot up into four quadrants using the means of each variable. You can do this in Microsoft Word by choosing Insert Shapes Lines. The regression line should go through the intersection of the means.

e. Describe the form, direction, and strength of the association that is depicted in your scatterplot. Explain what the direction of association implies about the relationship between the variables.

f. Identify the regression line, then write a sentence that explains how to interpret the slope in terms of these specific variables.

g. Use the regression equation to predict the handspan for a person of your height (show your calculation). Measure the handspan of your writing hand to the nearest tenth of a centimeter (Report it.). Does the regression equation underpredict or overpredict your handspan? MY HEIGHT IS EXACTLY 5 FEET

Sex Height Handspan Male 67 22.5 Female 23.6 Male 70 23.2 Male 72 22 Male 69 22.3 Male 72 24.5 Male 73 25.6 Male 75 24.4 Female 64 18 Male 73 22.5 Male 68 22.8 Male 74.8 23 Male 68 23.3 Male 70 21.8 Female 67 24.5 Female 65 18.5 Male 72 23.5 Male 72 22 Female 71 24 Female 67 21.5 Female 65.5 21 Male 72 21.7 Male 68 23.5 Female 65 18 Male 66 20 Female 65 20.5 Male 61 23 Male 71 26 Male 73 21.7 Female 58 21.7 Female 64 20.2 Female 65.74 21.4 Female 66 22.3 Female 63 20 Male 68 23.5 Female 63 21 Female 61 21.4 Female 64 19.05 Female 62 19.1 Female 64 19.5 Female 64.8 20 Female 17.5 Female 60 18.1 Male 72 25.4 Male 69 25 Male 70 20 Female 66 19.3 Female 68 21.9 Male 75 24.6 Female 63 19.7 Female 62 18 Female 18.3 Male 70 23 Male 71 23 Female 65 18 Male 75 24.6 Male 70 25 Female 64 22.5 Female 68 19 Female 66 20 Male 74 24.9 Female 60 19.8 Male 68 22 Female 64 20.1 Male 71 23.4 Male 72 23.9 Female 62 18 Female 66 20.1 Male 72 24.5 Female 63 22 Female 63 18.5 Male 80 27 Male 74 25.5 Male 75 24.1 Male 72.5 24 Male 69 21.9 Male 68 20.5 Male 69.6 20 Female 19 Female 68.9 21.5 Male 68 23.8 Male 73 22.9 Female 63 19.9 Female 69 19.2 Female 66 19.5 Male 65 23.3 Male 65 22.4 Male 72 23.9 Male 74 24.5 Male 75 24 Female 64 19 Female 66 20.4 Female 65 19.7 Female 61 20 Female 64 20.1 Female 61 20 Female 65 23.5 Female 61 18.5 Female 64 18.5 Male 71 21.7 Female 66 22 Female 72 22.5 Male 71 20.9 Female 66 20.4 Male 68 21 Female 66 20 Female 66 20 Male 72 24.5 Male 70 22 Male 73.49 22 Male 73 23.8 Male 74 22.5 Male 68.4 22 Female 65 21 Female 70 24 Male 68 20.8 Female 67 18 Female 64 18.5 Male 72 24.4 Female 67 18 Male 74 25.1 Female 63 20.1 Female 66.9 20.5 Male 74 22 Female 63 15.3 Female 73 22.1 Male 66 19.8 Male 71 23.5 Male 76 22.5 Female 62 18.4 Female 59 18.5 Female 64 18.5 Female 61 19.7 Male 71 22.7 Male 72 22.9 Male 72 21.9 Female 65 17.5 Female 60.5 20 Female 66 19 Female 67.7 20.1 Female 65 15 Female 60 19.2 Male 69 22 Female 73.5 20.3 Female 63 20 Female 67 20 Female 60 19.2 Male 72 23.5 Male 75 23.5 Male 71.5 21.3 Male 67 20.9 Female 63 18.2 Female 68 21.3 Female 68 20.8 Female 65 17.5 Female 61 19.2 Female 70 19.5 Female 63 21 Female 65 18 Female 63 18.5 Male 73 22 Male 69 23 Female 66 20.4 Male 72 23 Female 66 19.1 Female 63 20 Male 74 24 Female 59 18.7 Female 60 18.7 Male 70 21 Male 69 20.4 Male 67.72 22 Male 73 22.4 Female 69.5 23.1 Female 61.5 19.7 Female 67 19.5 Male 72 21.5 Female 64 19.4 Female 69.75 19.6 Female 62 14.5