Activity 1a-MATH 250 Elements of Statistics-Summer 2024 DUE DATE: 06/07/2024 Assessment /15 NAME General Instructions: Please place your name above (this needs to be done on any document submitted for the course!) Then complete the following questions. Make sure you have saved this Excel file often using the filename "yourname Activityla." Once complete, submit your answers to this activity by attaching your Excel file through the completion link in the Unit 1 Activity la assignment description in Blackboard. This is a "graded" portion of this course, a relatively easy 15-point activity if completed on time. Using a quality measurement instrument (such as a flexibleidoth tape measure) and the help of a friend or family member, measure and record your foot I- length, height and armspan to the nearest half centimeter (note that armspan is the greatest distance from tip of one to tip of other middle finger when arms are stretched horizontally apart at shoulder level). You may want to go to the Discussion Board in Blackboard (click on the Discussion Board icon button) to see an example of such data. Since most of the world works in the metric system, make sure to measure distances in centimeters, rounded to the nearest half centimeter. Put each piece of data requested below in the cell just to the right of the description. In the next column titled "Measurement Type". determine the classification of each measurement as either qualitative or quantitative in type. Qualitative data is distinguished by attributes that are not necessarily numeric and are used to calegorize groups of objects according to shared features of to provide a "non-measurement label of some object. Quantitative data is information about quantities; that is, information that can be measured and written down with numbers. Measurement Variable Value Gender Foot Length (cm) Height (cm) Age (in years) Armspan (cm) Number of (immediate) family members Hair Color NOTE: This data will be complied for all sections of the course without any names attached. It is imperative that this activity be completed as soon as possible, definitely by the due date as later activities use this data for statistical analysis work. 2. Perform the following instructions using Excel commands. Do not perform hand calculations or use hand calculators-Excel is a great calculator once you get familiar with the program. You will be assessed on use of the Excel environment to perform the following actions. If unfamiliar with Excel spreadsheet Squared Values basics, you will want to examine the available Excel Guide within Blackboard (find the guides via the Excel Guides button). Look in the first tab, entitled Excel Time Squared Divided by the Basics. In most cases, place your commandsformulasfactions in the cells of the "Results for Instructions." column next to the proper problem label arrow. Values Average Value 18.625 Instructions Results for Instruction: 11.827 1 Using Excel, sort the eight given time values in column O from greatest to least I. [Reads should be in The" 14.023 It Sum only the greatest and least of these values by using cell references within a oddtern of volkers at the riotal 8 912 Activity 1aR 2. Perform the following instructions using Excel commands. Do not perform hand calculations or use hand calculators-Excel is a great calculator once you get familiar with the program. You will be assessed on use of the Excel environment to perform the following actions. If unfamiliar with Excel spreadsheet Squared Values basics, you will want to examine the available Excel Guide within Blackboard (find the guides via the Excel Guides button). Look in the first tab, entitled Excel Time Squared Divided by the Basics, In most cases, place your commandsformulas/actions in the cells of the "Results for Instructions:" column next to the proper problem label anrow. in Values Average Value 18.625 Instructions Results for Instruction: 11.827 i Using Excel, sort the eight given time values in column O from greatest to least. i. [Results should be in "Time" 14.023 i Sum only the greatest and least of these values by using cell references within a column ed waheed at the right) 8.912 formula. Sum of 19.766 ill Change the font color on your sum result of ii, to purple, greatest and 9.028 iv. Increase the font of your result in il. to 16 point least (i.) 24.985 v. Find the average (mean) of the time values given in column O. Average (v.) 11.904 v. Use Excel's "ROUND" command to round the avearge result from part v. to three Rounded decimal places. (DO NOT USE the format display of three decimal places!!) Average (] vil Within the single result cell, create a formula that will sum the largest three values in the list divided by the value result from li. Will In cell Q35, use a formula to produce the square of the time value given in cell 035. Then use the "will handle" feature to find the square of the remaining seven values in Will. [Results should be in Squared the Time data. ix. In cell $35. divide the squared value in cell Q35 by the average from cell 142 (using an absolute reference for cell M42). Then use the "Till handle" feature to repeat this process for the remaining seven squared values in that list Average Value" column *. Throughout the semester, it will be a common occurrence that a cell will contain more contenttext than is visible in the spreadsheets cell. This will often be the case in regard to feedback provided to you by the instructor or responses that you type. Last sentence Thus, you will need to read the entire contents of a cell by first clicking on the cell and in x then reading the entire contents above in the formula bar area OR you can double click on the cell to expand the cell's content. Do either of these for this instruction cell, writing the last full sentence of this paragraph in the results cell to the right. The