Excel_Activity2 - Excel Activity #2: Description: Using...

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

View Full Document Right Arrow Icon
Excel Activity #2: Using Excel to Perform Statistical Functions and Formulas Description : This lesson investigates the use of statistical functions and mathematical formulas. The functions AVERAGE, MEDIAN, MODE, MIN, MAX, and STDEV are used along with user defined formulas. Part I : Entering User Defined Formulas The following data represent the weights of babies born at Halifax Hospital for two days in January 2003. Note: The student may collect his or her own data or use the data provided below for this activity. Weight W e i g h t 7 lbs. 2 ounces 6 lbs. 8 ounces 8 lbs. 5 ounces 7 lbs. 5 ounces 7 lbs. 11 ounces 7 lbs. 9 ounces 7 lbs. 3 ounces 8 lbs. 1 ounce Notice that the data are given in mixed units, pounds and ounces. Before doing any mathematical calculations, it is necessary to convert all units to pounds or all units to ounces. Recall that 16 oz = 1 lb. Therefore, the quantity 7 lbs 2 oz is equivalent to: 7 lbs 2 oz = 7 lbs + 2 16 lb = 7.125 lbs or 7 lbs 2 oz = (7 * 16) oz + 2 oz = 114 oz We will enter the data in pounds and then find the mean, median, mode, and standard deviation of the baby weights. 1) In cell A1, type Weight (pounds) Then hit the ENTER key. 2) You can expand the width of column A by placing the cursor on the boundary between column A and column B at the top of the spreadsheet. When the cursor turns into a cross , depress the left mouse key and drag the boundary to the right. 3) In cell A2, type: =7+2/16 and hit the ENTER key. (By starting the cell with an “=” sign, it instructs Excel to perform the mathematical calculation that follows. In this case, Excel divides 2 by 16 and adds the result to 7. It is particularly important that you begin typing with the “=” sign. If you forget the “=” sign, Excel will read the entry as text.) 4) In cell A3, type: =8+5/16 and hit the ENTER key. 5)
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.

This note was uploaded on 04/20/2011 for the course MATH 101 taught by Professor Ihcsol during the Spring '08 term at Capital University.

Page1 / 4

Excel_Activity2 - Excel Activity #2: Description: Using...

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