| Temperature
Unit 8 Individual Project |
| Complete all the information in the BLUE cells. Make sure you show all your work. |
| Name: |
| Date: |
| Step 1:
Identify the city you chose. The city must be listed on: https://www.usclimatedata.com/ | | | 3 points |
| Name of City |
| Step 2:
List the average high temperatures for each month for your chosen city below. | | | 6 points |
| January |
| February |
| March |
| April |
| May |
| June |
| July |
| August |
| September |
| October |
| November |
| December |
| Step 3:
Calculate the values below. | | | 16 points |
| | | Show your work below: |
| Mean for your data |
| Median for your data |
| Mode for your data |
| Range for your data |
| Step 4:
Create an Excel graph of the data (a bar graph or line graph) using the instructions provided and insert in the blue box below.
| | | 15 points |
| * Select all data from Step 2.
* Click on the Insert tab at the top of the page to choose your graph from the Recommended Charts section.
|
| Use this link for help with creating your graph: https://support.microsoft.com/en-us/office/excel-for-windows-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb
Insert the graph you created of your temperature data here: |
| Step 5:
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? | | | 15 points |
| Enter your response to the questions in Step 5 in this box:
|
| Step 6:
1. Are there any unusual data values (like outliers)? If so, explain how they impact the mean, median, mode and range found in Step 3.
2. Discuss the shape of your graph (Normal Distribution, Skewness, etc.) | | | 15 points |
| Enter your response to the questions in Step 6 in this box:
|
BrittanyB
MATH125_U8_IP_Problem_Set_2105D.xlsx
