You will be using an Excel spread sheet to complete the following activities. Once the activity is completed you will take a snapshot of the work you completed in Excel and place it in this word document.

Find the Mean

Begin with a blank spreadsheet open in Excel

Key in the following data about inpatient hospital days, entering one numeral per cell in consecutive cells of the same row, beginning in row 2, column C (C2), and ending with cell G2:

1, 3, 2, 1, 3

Use the average function to fine the means of the dataset. To do so, click in cell H2, select the average function form the Formulas tab, or type the following formula in cell H2: =AVERAGE(C2:G2)

Click out of cell H4, and the means should appear in this cell

Insert your snapshot here.

Find the Median

Begin with a blank spreadsheet open in Excel

Key in the following data, entering one numeral per cell in consecutive cells of the same row, beginning in cell A2 and ending in cell K2:

2, 3, 4, 5, 5, 6, 9, 77, 5, 4, 3

Use the average function to find the median of the dataset. To do so, click in cell L2, then select the median function from the Formulas tab, or type the following formula in cell L2: =MEDIAN(A2:K2).

Click out of cell L2, and the median should appear in this cell

Insert your snapshot here.

Find the Mode

Begin with a blank spreadsheet open in Excel

Key in the following data, entering one numeral per cell in consecutive cells of the same row, beginning in cell G2 and ending in cell M2

4, 4, 5, 6, 4, 2, 3

Use the mode function to find the median of the dataset. To do so, click in cell F2, then select the median function from the Formulas tab, or type the following formula in cell F2: = MODE(G2:M2)

Click out of cell F2, and then median should appear in this cell.

Insert your snapshot here.