Afrikaans
Akan
Albanian
Amharic
Arabic
Armenian
Azerbaijani
Basque
Belarusian
Bemba
Bengali
Bihari
Bosnian
Breton
Bulgarian
Cambodian
Catalan
Cebuano
Cherokee
Chichewa
Chinese (Simplified)
Chinese (Traditional)
Corsican
Croatian
Czech
Danish
Dutch
English
Esperanto
Estonian
Ewe
Faroese
Filipino
Finnish
Frisian
Ga
Galician
Georgian
German
Greek
Guarani
Gujarati
Haitian Creole
Hausa
Hawaiian
Hebrew
Hindi
Hmong
Hungarian
Icelandic
Igbo
Indonesian
Interlingua
Irish
Italian
Japanese
Javanese
Kannada
Kazakh
Kinyarwanda
Kirundi
Kongo
Korean
Krio (Sierra Leone)
Kurdish
Kurdish (Soranรฎ)
Kyrgyz
Laothian
Latin
Latvian
Lingala
Lithuanian
Lozi
Luganda
Luo
Luxembourgish
Macedonian
Malagasy
Malay
Malayalam
Maltese
Maori
Marathi
Mauritian Creole
Moldavian
Mongolian
Myanmar (Burmese)
Montenegrin
Nepali
Nigerian Pidgin
Northern Sotho
Norwegian
Norwegian (Nynorsk)
Occitan
Oriya
Oromo
Pashto
Persian
Polish
Portuguese (Brazil)
Portuguese (Portugal)
Punjabi
Quechua
Romanian
Romansh
Runyakitara
Russian
Samoan
Scots Gaelic
Serbian
Serbo-Croatian
Sesotho
Setswana
Seychellois Creole
Shona
Sindhi
Sinhalese
Slovak
Slovenian
Somali
Spanish
Spanish (Latin American)
Sundanese
Swahili
Swedish
Tajik
Tamil
Tatar
Telugu
Thai
Tigrinya
Tonga
Tshiluba
Tumbuka
Turkish
Turkmen
Twi
Uighur
Ukrainian
Urdu
Uzbek
Vietnamese
Welsh
Wolof
Xhosa
Yiddish
Yoruba
Zulu
so here we are
we're at our source of data
that we're going to be using for this project
we're at the World Weather Information Service web page
I'm looking at Charlotte
North Carolina's data
you may be looking at data
for another city around the world
and what we're going to be doing
before we start entering data
is we're going to think about
how we want our spreadsheet set up
this will be the first time we're designing
our own spreadsheet
and we wanna make sure we do it right
part of the reason we're using this data set
is because it's a fantastic model
for a good way to set up data
what you'll notice here
is that every column in this table represents
in a variable of its own
we have the variable of month
we have the variable of low temperatures
mean daily minimum temperatures
we have the variable of high temperatures
mean daily high temperatures and so on
every column is its own variable
this is an excellent principle to follow
when setting up a spreadsheet
which is what we'll be doing in Excel in a moment
so every column is available
every row then
is an observation
we have an observation associated with January
we have another observation associated with February
and so on and so
keeping this idea in our head
columns are variables
rows are observations
can be very
very helpful
when we're setting up a spreadsheet of our own
so what we'll do now
is with this in mind
we're going to go over into an Excel
and set up our spreadsheet
so that we're going to be ready and organized
for our data entry
which will be our next step
before we start working with these data
so here we are
we're in Excel
we're ready to start entering our data
but first we need to set up our spreadsheet
one thing that you'll notice here
is that I've already
saved this file
I've given it a name
weather data
and I encourage you to do that as well
this is always a really good first step
to get in the habit of
is to give your file a name and save it
and that way
you're not going to lose anything
and you're going to keep very organized
with whatever you're doing in Excel
something else I'm going to do is
I'm gonna rename this sheet
I'm gonna rename it CLT
that's the abbreviation for Charlotte
and now if I
decide to put in weather data for other cities
I can have different sheets for those as well
so that's not really necessary
if I'm only working with one set of data
but now at least
I know that the data I'm working with
come from Charlotte and North Carolina
what's next
the final thing we need to do
in setting up our spreadsheet
before we can enter data
is just giving us our column headers
right and so
we're going to name each column
because each column represents a variable
you may recall that these were months
these were daily
low temperature
the average
and daily high temperature
the average
we also have a column for precipitation
which will enter in as well
as we've seen before
sometimes our labels are too long for the column width
and so we can just double click between those columns
to automatically space the column to the right size
and finally
as a reminder
one thing I like to do is
I like to bold that first row
those column headers
so that those stand out
and we know that that's information
separate from the rest of the data table
and now we're already
all set to start entering our data
which is what we're going to do right now
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.