3.7 Bivariate descriptive statistics: using spreadsheets to view

 Page 1 / 3
Basic directions on how to use Google Spreadsheet and Excel to explore and summarize bivariate data.

Displaying bivariate data in graphs

In this section we will discuss techniques using a spreadsheet for displaying quantitative data using stemplots, histograms, boxplots and qualitative data using bar graphs and pie charts. We will primarily use Microsoft Excel and Google Spreadsheet, as we will use these two resources for sampling and surveying in this introductory course.

Categorical- categorical

We will review a few techniques that you will use to create, copy, and paste into a document, and save your displays of data.

Contingency Tables: Excel - We will use pivot tables to create contingency tables. We have used them before for univariate data. This time we will highlight two columns of data to create our pivot tables. Both columns of data must be categorical. The two columns of data must be side-by-side. A good technique to use is to copy the two columns of data you want to display in a contingency table to a new labeled worksheet, side by side. The example below demonstrates that process.

I have two columns of data in a new worksheet labeled. When I mouse over the OK button, and click, the PivotTable Fields will appear and I can use them to create a contingency table. I usually select the variable with the least number of “categories” for the columns and the variable with the largest number of “categories” for the rows. This just makes the chart easier to cut and paste into a word document. In the example below I have dragged and dropped “Where do you live?” to the “Columns” field and “College Rank” to the “Rows” field. I can then either put college rank or where do you live in the “Values” field. For this example I put college rank into the values field. I now have a contingency table. See image below. I have only the “counts” in my contingency table. The next step will be to create row or column percents.

I can now add another “college rank” to the “Values” field to create a percent field. I now have two “college rank” fields in my “Values” field. I will create percentages for either row or columns by clicking on the down arrow next to the count of “college rank” and picking “Value field setting” from the drop-down menu. When I pick “value field settings” a pop-up menu will appear and you will select the tab that says “Show Values As”, and then from the drop-down menu of “Show Values As”, select percent of column or percent of rows. For this example I have picked “percent of column” since my data is mostly off campus. I can now see that 60 percent of the students from this sample that live off campus are seniors. I can use the percents to interpret my data. Note that when I created the second “Values” field, a “Value” field was created in the “Columns” field. You don’t create this field, the Excel spreadsheet did that automatically from you creation in the “Values” field. See image below. Also note that I highlighted my titles on the actual PivotTable and then from the home tab selected “wrap text” to make my columns neater. You can experiment with other editing of the titles to get the “look” you want.

how can chip be made from sand
is this allso about nanoscale material
Almas
are nano particles real
yeah
Joseph
Hello, if I study Physics teacher in bachelor, can I study Nanotechnology in master?
no can't
Lohitha
where is the latest information on a no technology how can I find it
William
currently
William
where we get a research paper on Nano chemistry....?
nanopartical of organic/inorganic / physical chemistry , pdf / thesis / review
Ali
what are the products of Nano chemistry?
There are lots of products of nano chemistry... Like nano coatings.....carbon fiber.. And lots of others..
learn
Even nanotechnology is pretty much all about chemistry... Its the chemistry on quantum or atomic level
learn
da
no nanotechnology is also a part of physics and maths it requires angle formulas and some pressure regarding concepts
Bhagvanji
hey
Giriraj
Preparation and Applications of Nanomaterial for Drug Delivery
revolt
da
Application of nanotechnology in medicine
has a lot of application modern world
Kamaluddeen
yes
narayan
what is variations in raman spectra for nanomaterials
ya I also want to know the raman spectra
Bhagvanji
I only see partial conversation and what's the question here!
what about nanotechnology for water purification
please someone correct me if I'm wrong but I think one can use nanoparticles, specially silver nanoparticles for water treatment.
Damian
yes that's correct
Professor
I think
Professor
Nasa has use it in the 60's, copper as water purification in the moon travel.
Alexandre
nanocopper obvius
Alexandre
what is the stm
is there industrial application of fullrenes. What is the method to prepare fullrene on large scale.?
Rafiq
industrial application...? mmm I think on the medical side as drug carrier, but you should go deeper on your research, I may be wrong
Damian
How we are making nano material?
what is a peer
What is meant by 'nano scale'?
What is STMs full form?
LITNING
scanning tunneling microscope
Sahil
how nano science is used for hydrophobicity
Santosh
Do u think that Graphene and Fullrene fiber can be used to make Air Plane body structure the lightest and strongest. Rafiq
Rafiq
what is differents between GO and RGO?
Mahi
what is simplest way to understand the applications of nano robots used to detect the cancer affected cell of human body.? How this robot is carried to required site of body cell.? what will be the carrier material and how can be detected that correct delivery of drug is done Rafiq
Rafiq
if virus is killing to make ARTIFICIAL DNA OF GRAPHENE FOR KILLED THE VIRUS .THIS IS OUR ASSUMPTION
Anam
analytical skills graphene is prepared to kill any type viruses .
Anam
Any one who tell me about Preparation and application of Nanomaterial for drug Delivery
Hafiz
what is Nano technology ?
write examples of Nano molecule?
Bob
The nanotechnology is as new science, to scale nanometric
brayan
nanotechnology is the study, desing, synthesis, manipulation and application of materials and functional systems through control of matter at nanoscale
Damian
how did you get the value of 2000N.What calculations are needed to arrive at it
Privacy Information Security Software Version 1.1a
Good
Got questions? Join the online conversation and get instant answers!