Lab 4 Temperature
.docx
keyboard_arrow_up
School
CUNY College of Staten Island *
*We aren’t endorsed by this school
Course
111
Subject
History
Date
Dec 6, 2023
Type
docx
Pages
7
Uploaded by HighnessMorning12743
ESC 111 Lab 4
Temperature
Introduction
In this lab, you will demonstrate the range of temperatures found in the United States and relate
these to the varying geographic locations and related factors. Temperature can be influenced by a
variety of factors such as latitude, proximity to water, elevation, and other factors. This material
was covered in the lectures on temperature and chapter 3 of the textbook.
Where to Get the Data
1.
Go to Northeast Regional Climate Center web page,
http://www.nrcc.cornell.edu
2.
Click on: Weather Station Data
3.
Click on: US Comparative Climatic Data
4.
Click on: Normal Daily Mean Temperature
Visualizing the Data in Excel
What Data Do You Need?
Choose one city from each of the following states:
1.
Alaska
2.
Colorado
3.
Florida
4.
New Jersey
5.
the Dakotas
6.
Illinois, Indiana, or Ohio
7.
Northern coastal California
8.
Southern California
9.
Hawaii or another Pacific island
Making the Line Graph
Using a single line graph in Excel you need to visualize the monthly temperatures (for the full
year) from nine cities. We have made a line graph before in lab 2, but this one will have a few
additional steps as we are displaying nor data then the previous one
and will do some additional
formatting to make things look nice.
When you are in putting the data I recommend using this data structure in Excel:
This will help you keep the information needed organized and easier to plot than other ways to
input the data in Excel. Notice that I have removed the columns for years and annual. This is
because years is the number of years observations were taken for each month to create the
normal daily mean temperature in degrees Fahrenheit and the annual is the average temperature
of this location for the full year. Plotting these values would make your graphs look very odd and
is not needed.
If you want to copy and paste the data into Excel that is doable, but you must use the paste
option
"Match Destination Formatting"
. If you do not do this your values will paste as text and
you will be unable to make a line graph
.
Making and Formatting the Line Graph
To make this figure you are going to want to have your x axis represent the months and your y-
axis representing the temperature. To make this if you want to select your data and insert a line
graph, using the same steps outlined in lab 2. Once completed your graph will look something
like this:
Although this is showing what we want, noticed that it looks a little "gross". We want to change:
●
the y-axis to range from -20 °F to 100 °F
●
Add a legend Dash - in lab 2
●
An appropriate title
●
Labeled axes with units for X and Y
Formatting and axis in Excel
This process is quite simple and will make many of the figures in this class much better. for this
lab assignment you only need to format your y-axis to be within the appropriate range, and to do
this:
1.
Right click on the y-axis
2.
At the bottom click on format axis
3.
Find access options
4.
Input the appropriate values for minimum and maximum
5.
You should also form at the position of the x-axis. Follow the above steps to format the x
axis, but scroll to the bottom, Quick labels, click the drop-down menu for label position,
and select low.
Now that you have formatted the acting appropriately, provided an appropriate title, and included
a legend your graph should look similar to this:
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help