{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel_Activity2

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

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

Developed by Miller/Waymire, Daytona Beach Community College 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 Weight 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.

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}