Libreoffice calc sum column software#

You pick the data - you decide on the sample. At midterm you will turn in a proposed ratio level data set with basic statistics. For one sixteen week term period in your life I want you to walk with an awareness of the data around you. You might not go into statistics professionally, yet you will always live in a world filled with numbers and data. The point is that data is all around us all the time. I asked some of the markets to share their cup tally sheets with me, and a number of them obliged. While researching sakau consumption in markets here on Pohnpei I found differences in means between markets, and I found a variation with distance from Kolonia. This allowed an analysis of the true center of the rainbow. Could the middle of the rainbow actually be at 180° cyan, or was Newton correct to say the middle of the rainbow is at 120° green? I used a hue analysis tool to analyze the image of an actual rainbow taken by a digital camera here on Pohnpei. And there is no cyan in Newton's rainbow. I knew that Newton had put green in the middle of the red-orange-yellow-green-blue-indigo-violet rainbow, but green is at 120° on a hue color wheel. The hue was based on a color wheel with cyan at the 180° middle of the wheel. One term I learned that a new Cascading Style Sheets level 3 color specification for hue, luminosity, and luminance was available for HyperText Markup Language web pages. 'The dump trucks are basically priced by a linear relationship between horsepower and price.' The representative included a complete list of 'Funny you should ask,' a Terex sales representative replied in writing. I write to Terex in Scotland and ask them about how the prices vary for the dump trucks, explaining that I teach statistics. I find pictures of Terex dump trucks on the Internet. My son likes articulated mining dump trucks. I also ran a survey of students and determined that students prefer Kikkoman to Yamasa. Showed that the mean price per milliliter for Yamasa is higher than Kikkoman. I recorded prices and volumes, working out the cost per milliliter. I walked into a store back in 2003 and noticed that Yamasa soy sauce appeared to cost more than Kikkoman soy sauce. I later incorporated this data in the fall 2007 final. I later find that a linear correlation does exist, and I am able to show by a t-test that the faster jumpers have statistically significantly higher jump counts. I used my stopwatch to record the time and total jump count. I saw that I could begin to predict jump counts based on the starting rhythm of the jumper.

Then I noticed that faster jumpers attained higher jump counts than slower jumpers. With a mode, median, mean, and standard deviation. The number of jumps for each jumper until they fouled out was being recorded on the wall.

I walked into a school fair and noticed a jump rope contest. We all walk in an almost invisible sea of data. A browser such as FireFox 4 or higher is required to properly display and print this text. This text utilizes HyperText Markup Language, Scalable Vector Graphics, and Mathematics Markup Language (HTML+SVG+MathML). Given an 'out-of-the-box' installation of a spreadsheet, course alumni, or for that matter any reader of this text, should be able to generate and use the statistics introduced by this text. Course alumni should not feel that they cannot 'do' statistics because they lack a special add-in or dedicated package function that may require administrative privileges to install.

Libreoffice calc sum column software#

Course alumni and readers of this text are most likely to encounter default installations of spreadsheet software without such additional software.

The text does not use any add-ins, add-ons, statistical extensions, or separate dedicated proprietary statistical packages. The text also uses Gnome Gnumeric to generate box plots. This text also includes references to Microsoft Excel functions where they differ from Calc functions. This statistics text utilizes Calc to make statistical calculations. Hypothesis testing against a known population mean.Introduction to the normal distribution.