# Drent U8 IP MATH125.xlsx - Temperature Unit 8 Individual...

• 6

This preview shows page 1 - 6 out of 6 pages.

TemperatureUnit 8 Individual ProjectName:Allen DrentDate:11/18/2021Cells shaded in BLUE are the cells in which you should enter information.List the monthly average high temperatures for your chosen city below.Shreveport3 points77.56 pointsJanuary57February60March70April77May95June98July101August95September89October78November67December5816 pointsMean for your data78.40Median for your data77.50Mode for your data95.00Range for your data58-101Step 1: Identify the city you chose.Step 2: List the temperatures for each month.Step 3: Calculate the values below.
15 points15 points15 pointsStep 4:Provide a visual representation of the data usinga bar graph orline graph below.You will need to select all data from Step 2. Then, click on the Insert tab atthe top of the page to choose your graph from the Recommended Chartssection. If you need assistance with Excel, explore the Microsoft Excel site.(-9bc05390-e94c-46af-a5b3-d7c22f6990bb)Step 5:Answer the following question in the box provided below:
End of preview. Want to read all 6 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
N/A
Tags
Mean

Unformatted text preview: 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: Mode Honestly because I dont care what that graph says we hardly ever see 78 degrees. Its either Scorch 90-ish January February March April May June July August September 20 40 60 80 100 120 Shreveport Avg. High Temps (monthly) * 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. 1. No, Nothing it flows pretty steadily 2. N/A 3. At the first of the year, it starts at an Avg of 58 Degrees rises slowly and steadily until July When it peaks rate declining as inclining to end the holidays with a 57 Degree Avg hing or Freezing. Its more like October November December s, and Follows close to the same...
View Full Document