Microsoft Excel file:

This problem is designed to familiarize you with basic Microsoft Excel functions. You will be using the Microsoft Excel file to work in the spreadsheet and then answer the ques

Column A contains a generic dataset. Column $C$ is a list of questions that correspond to the questions below. Column D indicates which Excel function$($s$)$ that question is desig

where you will work with the function$($s$)$ to generate the answer to each question. And finally Column $F$ displays the formula you used to generate your answer in Column $E.$

To place your answers from Column E into the blanks below, use the copy$/$paste keyboard shortcut: $Ctrl+C$ and $Ctrl+V$ on a PC or $Cmd+C$ and $Cmd+V$ on a Mac.

If you would like to learn more about a specific function, you can always visit the Microsoft Office Support site and type the function into the search box at the top$-$right of the

How many data observations are present $($sample size$)?$

What is the sum of the data?

What is the mean $($average$)$ of the data $($unrounded$)?($Enter your answer to at least six decimal places.$)$

What is the median of the data?

What is the minimum value of the data?

$5c$

What is the maximum value of the data?

$94$

What is the square root of the sample size $($unrounded$)?($Enter your answer to at least six decimal places.$)$

What is the value of the third observation when squared?

$5$

What is the square root of the sample size $($to $2$ digits$)?$