<< Chapter < Page Chapter >> Page >
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.

Questions & Answers

where we get a research paper on Nano chemistry....?
Maira Reply
what are the products of Nano chemistry?
Maira Reply
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
Google
da
no nanotechnology is also a part of physics and maths it requires angle formulas and some pressure regarding concepts
Bhagvanji
Preparation and Applications of Nanomaterial for Drug Delivery
Hafiz Reply
revolt
da
Application of nanotechnology in medicine
what is variations in raman spectra for nanomaterials
Jyoti Reply
I only see partial conversation and what's the question here!
Crow Reply
what about nanotechnology for water purification
RAW Reply
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
Brian Reply
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?
LITNING Reply
what is a peer
LITNING Reply
What is meant by 'nano scale'?
LITNING Reply
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 ?
Bob Reply
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
Is there any normative that regulates the use of silver nanoparticles?
Damian Reply
what king of growth are you checking .?
Renato
What fields keep nano created devices from performing or assimulating ? Magnetic fields ? Are do they assimilate ?
Stoney Reply
why we need to study biomolecules, molecular biology in nanotechnology?
Adin Reply
?
Kyle
yes I'm doing my masters in nanotechnology, we are being studying all these domains as well..
Adin
why?
Adin
what school?
Kyle
biomolecules are e building blocks of every organics and inorganic materials.
Joe
how did you get the value of 2000N.What calculations are needed to arrive at it
Smarajit Reply
Privacy Information Security Software Version 1.1a
Good
Got questions? Join the online conversation and get instant answers!
Jobilize.com Reply

Get the best Algebra and trigonometry course in your pocket!





Source:  OpenStax, Collaborative statistics using spreadsheets. OpenStax CNX. Jan 05, 2016 Download for free at http://legacy.cnx.org/content/col11521/1.23
Google Play and the Google Play logo are trademarks of Google Inc.

Notification Switch

Would you like to follow the 'Collaborative statistics using spreadsheets' conversation and receive update notifications?

Ask