city is houston texas
https://www.usclimatedata.com/
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: | ||||||||||||
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: | ||||||||||||
* 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. |