<< Chapter < Page Chapter >> Page >

Another function that we will use to perform relative frequency and cumulative relative frequency is the absolute cell function . If I wanted to find the percentage of students who arrived on campus by car, I would need to take the sum of students who took the survey and drove a car then divide that number by the total number of students who took the survey. I would need to use the same process to find the relative frequency of students who took the bus, rode their bike, or walked to campus. Rather than enter that formula 4 times you will be able to copy and paste this formula from row to row if you use the absolute cell function. To create a cell that will never change even if you copy and paste a cell to a different column or row you will need to add a “$” dollar sign in front of the column and row signature. For instance if you want to keep cell h2 constant even if the formula is copied and pasted to a new row or column, you would need to write that cells name as $h$2, We will see an application of this as we work with relative frequency. When one copies a formula from one cell to another without the absolute cell function “$” the dollar sign, the formula is relative and the cell reference will change. Copy the cell that you used to enter =h2+h5 into a new row in the same column (if you entered it into K2, copy and paste it into cell K4. What happens? The value is not the same. Look at the formula bar and it will indicate that the new reference was +h4+h7. Why did that happen? The reference was relative and you kept the same column but moved down two rows the rows in the formula also changed by two. Now, put an absolute function sign “$” the dollar sign in front of the cell reference. Enter =$h$2+$h$5 in a cell. Then copy and paste this function to any other cell in a different row or column and you will see that the reference is absolute. It does not change.

Optional classroom exercise:

At your computer, try this exercise: (1) Download the file, Statistics First Day of Class Survey; (2) Save the file to your desktop and one other cloud or personal recording device (jump drive, email) Be sure to name this file as indicated above (name of project with your full name); (3) open the file in Google Spreadsheet and create sheet labels; (4) save file and open in Excel; (change at least one row or column by wrapping text, right justifying) (5) Clean the data file so that each column has only categorical information or measurement data with all the same units of measurement and any label (other than in the column headings) removed. (6) Enter a formula into a cell with a relative reference and then with an absolute reference. Copy and paste the two formulas into other columns or rows. What happens? (7) save the file again and post in the appropriate Moodle assignment.

Summarizing Data :

Categorical and measurement data are summarized differently as indicated in the text. Both categorical and measurement data can be summarized by frequency distributions but when we use charts and graphs to display data we will look at the difference between displaying categorical data using pie charts and bar graphs while we will use vertical or horizontal histograms, box plots, or stem and leaf graphs to display measurement data. In this chapter we will only address frequency distributions and the display of categorical data. In the next chapter you will learn how to display measurement data. For the following examples we will use data from the Statistics First Day of Class Survey using only sample data from How did you arrive on campus today? And The number of college credit hours you have completed to date.

Questions & Answers

Do somebody tell me a best nano engineering book for beginners?
s. Reply
what is fullerene does it is used to make bukky balls
Devang Reply
are you nano engineer ?
what is the Synthesis, properties,and applications of carbon nano chemistry
Abhijith Reply
so some one know about replacing silicon atom with phosphorous in semiconductors device?
s. Reply
Yeah, it is a pain to say the least. You basically have to heat the substarte up to around 1000 degrees celcius then pass phosphene gas over top of it, which is explosive and toxic by the way, under very low pressure.
how to fabricate graphene ink ?
for screen printed electrodes ?
What is lattice structure?
s. Reply
of graphene you mean?
or in general
in general
Graphene has a hexagonal structure
On having this app for quite a bit time, Haven't realised there's a chat room in it.
what is biological synthesis of nanoparticles
Sanket Reply
what's the easiest and fastest way to the synthesize AgNP?
Damian Reply
types of nano material
abeetha Reply
I start with an easy one. carbon nanotubes woven into a long filament like a string
many many of nanotubes
what is the k.e before it land
what is the function of carbon nanotubes?
I'm interested in nanotube
what is nanomaterials​ and their applications of sensors.
Ramkumar Reply
what is nano technology
Sravani Reply
what is system testing?
preparation of nanomaterial
Victor Reply
Yes, Nanotechnology has a very fast field of applications and their is always something new to do with it...
Himanshu Reply
good afternoon madam
what is system testing
what is the application of nanotechnology?
In this morden time nanotechnology used in many field . 1-Electronics-manufacturad IC ,RAM,MRAM,solar panel etc 2-Helth and Medical-Nanomedicine,Drug Dilivery for cancer treatment etc 3- Atomobile -MEMS, Coating on car etc. and may other field for details you can check at Google
anybody can imagine what will be happen after 100 years from now in nano tech world
after 100 year this will be not nanotechnology maybe this technology name will be change . maybe aftet 100 year . we work on electron lable practically about its properties and behaviour by the different instruments
name doesn't matter , whatever it will be change... I'm taking about effect on circumstances of the microscopic world
how hard could it be to apply nanotechnology against viral infections such HIV or Ebola?
silver nanoparticles could handle the job?
not now but maybe in future only AgNP maybe any other nanomaterials
I'm interested in Nanotube
this technology will not going on for the long time , so I'm thinking about femtotechnology 10^-15
can nanotechnology change the direction of the face of the world
Prasenjit Reply
At high concentrations (>0.01 M), the relation between absorptivity coefficient and absorbance is no longer linear. This is due to the electrostatic interactions between the quantum dots in close proximity. If the concentration of the solution is high, another effect that is seen is the scattering of light from the large number of quantum dots. This assumption only works at low concentrations of the analyte. Presence of stray light.
Ali Reply
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
Berger describes sociologists as concerned with
Mueller Reply
Got questions? Join the online conversation and get instant answers!
QuizOver.com Reply

Get the best Algebra and trigonometry course in your pocket!

Source:  OpenStax, Collaborative statistics using spreadsheets - snackeru. OpenStax CNX. Jul 09, 2015 Download for free at http://legacy.cnx.org/content/col11842/1.1
Google Play and the Google Play logo are trademarks of Google Inc.

Notification Switch

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