In the dataset below, we will refresh your Excel knowledge and basic understanding of statistical information.
Open the below Excel spreadsheet to use as your data.
Create a second sheet.
In cells A1, B1, C1, D1, E1, F1 type:
“Month” A1
“Mean” B1
“Median” C1
“Mode” D1
“Range” E1
“Standard Deviation” F1
In cell A2:A12, type the following rows:
“January, February March…etc”
In the “Month” column, enter the list of Months.
In the “Mean” column, use the AVERAGE function to calculate the mean of the temperatures.
In the “Median” column, use the MEDIAN function to calculate the median of the temperatures.
In the “Mode” function, use the MODE function to calculate the mode of the temperatures.
In the “Range” function, use the =MAX(XX:XX)-MIN(XX:XX) function to calculate the mode of the temperatures.
In the “Standard Deviation” function, use the STDEV.S function to calculate the mode of the temperatures.
Explain your results by Quarter (JAN,FEB,MAR / APR,MAY,JUN / JUL,AUG,SEP/ OCT,NOV,DEC)
Save the file with a .xlsx extension.
You will be graded by successful formulas of the six functions, each worth 13 points, and explanation (Step 11) worth 22 points.
Here are some additional instructions for completing this homework assignment:
The AVERAGE, MEDIAN, and MODE functions are all built-in functions in Excel. You can find more information about these functions in the Excel Help.
Once you have calculated the mean, median, mode, and standard deviation in the columns, write a brief paragraph explaining what each of these measures of central tendency means.
Resources:
NCC 2022 Weather_Data.xlsxDownload NCC 2022 Weather_Data.xlsx
You will be expected to submit a single fully functional, and clearly labeled Excel spreadsheet that uses a separate worksheet within the spreadsheet for each problem. For each problem, you will be expected to submit a complete copy of your original work, documenting all calculations.
Your spreadsheet will be expected to include the complete data set used and a complete copy of all calculations or other work you have performed to derive your answers for each problem. No credit will be granted for work that is not completed using Excel, for which your Excel worksheet is not fully interactive, or for which your work shown is incomplete.
