mean median mode climate

profilenoa5844
MATH125_U8_IP_Template_2101C.xlsx

Budget

Temperature
Unit 8 Individual Project
Name:
Date:
Cells shaded in BLUE are the cells in which you should enter information.
List the monthly average high temperatures for your chosen city below.
Step 1: Identify the city you chose. 3 points
Step 2: List the temperatures for each month. 6 points
January
February
March
April
May
June
July
August
September
October
November
December
Step 3: Calculate the values below. 16 points
Mean for your data
Median for your data
Mode for your data
Range for your data
Step 4: Provide a visual representation of the data using a bar graph or line graph below. 15 points
You will need to select all data from Step 2. Then, click on the Insert tab at the top of the page to choose your graph from the Recommended Charts section. If you need assistance with Excel, explore the Microsoft Excel site. (https://support.microsoft.com/en-us/office/excel-for-windows-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb)
Step 5: Answer the following question in the box provided below: 15 points
Which statistic (mean, median, or mode) do you think is the best measure of center for the temperature information of the city you chose? Why?
Step 6: Answer the following question in the box provided below: 15 points
* Are there any unusual data values (like outliers)? * If so, how do they impact the descriptive statistics you found? * If not, describe the data from your visual representation.