Lab 2 Weather ForecastingTu
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 2 Weather
Forecasting Cont.
This lab is a follow up to lab 1. You will write your first lab report based on the results of
both of these labs. An outline for your first lab report can be found at the end of this
lab
assignment.
Finding the Actual Weather for the Past Week
●
Go to
www.wunderground.com/history
●
Enter the same location you used for your weather forecast in lab 1.
●
Select Tuesday 8/29/2023 as the date. You will need to do this for each individual
day, do not click weekly.
●
Then fill in the 2 tables
○
1 for actual observed weather on this date
○
1 for showing the historical averages going through all the same dates are
your original forecast and observations.
●
For wind speed, record the average, and wind direction the one that’s most
common.
Your location:
10306
Table 1: Actual observed weather
Temperature
(Day High
and Night
Low)
Measured
precipitation
(inches)
Wind Speed
(mph)
Wind
direction
Tuesday
8/29/23
Day
81
0
10
Night
69
Wednesday
8/30/23
Day
87
0
20
Night
71
Thursday
8/31/23
Day
79
0
21
Night
65
Friday
9/1/23
Day
77
0
13
Night
60
Saturday
9/2/23
Day
82
0
13
Night
59
Sunday
9/3/23
Day
91
0
17
Night
66
Monday
9/4/23
Day
93
0
16
Night
72
Table 2: Historical average weather
Temperature
(Day High
and Night
Low)
Measured
precipitation
(inches)
Tuesday
8/29/23
Day
82.9
0
Nigh
t
66.1
Wednesday
8/30/23
Day
82.7
0
Nigh
t
65.6
Thursday
8/31/23
Day
82.5
0.1
Nigh
t
65.6
Friday
9/1/23
Day
82.3
0
Nigh
t
65.4
Saturday
9/2/23
Day
82.1
0
Nigh
t
65.1
Sunday
9/3/23
Day
81.8
0
Nigh
64.9
t
Monday
9/4/23
Day
81.6
0
Nigh
t
64.6
Making a Line Plot in Excel
We will be using Microsoft Excel to create a line plot visualizing the maximum and
minimum temperature - 2 line graphs in total. Each of these line graphs will have three
different colored lines -
predicted temperature, actual temperature, and historical
average temperature. Although this can be done using other software such as Google
Sheets, we will be using Excel throughout this entire course and it is important to begin
using the program to ensure future assignments are easier to do as we will be building
upon skills throughout the whole semester.
Step 1: Record the Data in Excel
Type in the data that you recorded from your lab 1 and lab 2 into a new spreadsheet in
Excel. make sure that you have your dates on the left, 3 columns for the different data
you are recording, and make sure you are not confusing your maximum and minimum
values. Your spreadsheet should look something like this:
Step 2: Select the Data in Excel
Once your data is recorded, you will need to select it to begin plotting it. To select data
click and drag from cell A2 to D9 from the above example. Once your data is selected it
should look very 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
Step 3: Plotting the Data in Excel
Once your data is selected a box should appear in the bottom right corner called "Quick
Analysis". Click on this, Then click on charts, and you should see several options -
one
of which should be a line. The flow of this should look something similar to the picture
below:
If this did not work for you do not worry, there are many ways to create graphs in Excel.
Instead of clicking on Quick Analysis after selecting your data go to Insert at the top of
the screen, find 2-D Line, hover over it with your mouse, then click on the first option.
Your screen should look something like this:
Step 4: Add All Required Elements to your Graph
All graphs need some essential elements to ensure your reader knows exactly what you
are presenting in your figure. In the case for this assignment you will need:
●
A title
●
A legend
●
X-axis name and units
●
Y-axis name and units
To add in these chart elements click on your graph, in the top left corner of your screen
you will click the drop-down menu that says "Add Chart Element" and select the options
specified above. You can find these this drop-down in a similar position as the
screenshot below:
Step 5: Adding your Graph to your Lab Report
Adding a graph into your lab report is very easy, right click the graph, click copy, and in
your lab report click paste. I will take points off on your lab report if you provide me a
screenshot of your final graph oh, like the picture I have above. By copying and pasting
your graph into your lab report it will look much nicer and will be a static image if you
paste into Google Docs, in Microsoft Word you have other paste options and all are
appropriate. Your figure should look something like this:
Steps 7: Line Graph for Minimum Temperatures
Follow the same steps as outlined above in maximum temperatures to create a graph
for minimum temperatures.
Step 8: Bar Graph for Annual Rainfall and Historic Averages
Now that you have learned how to create a line graph in Microsoft Excel, you are going
to need to create a bar graph for the annual rainfall and historic average data. This
graph will look a little bit weird because of the data in Weather Underground, but that is
okay. For this I want you to learn how to create a bar graph so you are prepared for
future lab assignments. You're going to follow the same steps as outlined above, but
instead of clicking a 2-D line, you will click the column or bar options. If you are having
problems feel free to ask me questions in the lab.
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
●
Brief summary of your findings.
Include with report:
●
Completed table of weather forecast from lab 1
●
Completed table of actual weather from lab 2
●
Completed table of historical average weather from lab 2
●
Three charts from lab 2 (Max temperature, min temperature and rainfall)
All materials for the lab report MUST be submitted as a single pdf file.