Excel 2010 for Environmental Sciences Statistics: A Guide to by Thomas J. Quirk, Meghan H. Quirk, Howard F. Horton

By Thomas J. Quirk, Meghan H. Quirk, Howard F. Horton

This is the 1st booklet to teach the features of Microsoft Excel to coach environmental sciences information effectively.  it's a step by step exercise-driven advisor for college kids and practitioners who have to grasp Excel to unravel sensible environmental sciences problems.  If figuring out records isn’t your most powerful go well with, you're not particularly mathematically-inclined, or when you are cautious of desktops, this is often the perfect ebook for you. 

Excel, a greatly on hand desktop software for college kids and executives, can also be an efficient educating and studying instrument for quantitative analyses in environmental technology classes.  Its robust computational skill and graphical capabilities make studying information a lot more uncomplicated than in years past.  notwithstanding, Excel 2010 for Environmental Sciences records: A advisor to fixing functional Problems is the 1st ebook to capitalize on those advancements by way of instructing scholars and bosses find out how to practice Excel to statistical suggestions worthy of their classes and work.

Each bankruptcy explains statistical formulation and directs the reader to exploit Excel instructions to resolve particular, easy-to-understand environmental technology problems.  perform difficulties are supplied on the finish of every bankruptcy with their options in an appendix.  individually, there's a complete perform try out (with solutions in an Appendix) that permits readers to check what they've got learned.

Show description

Read or Download Excel 2010 for Environmental Sciences Statistics: A Guide to Solving Practical Problems PDF

Best environmental studies books

Chemistry Fundamentals Of Environmental Chemistry

Basics of Environmental and Toxicological Chemistry: Sustainable technology, Fourth variation covers university-level environmental chemistry, with toxicological chemistry built-in during the booklet. This new version of a bestseller presents an up-to-date textual content with an elevated emphasis on sustainability and eco-friendly chemistry.

Bioremediation of Petroleum Hydrocarbons in Cold Regions

This sensible consultant to bioremediation in chilly areas is designed to help environmental practitioners, undefined, and regulators within the remediation of petroleum spills and infected websites in chilly areas. Remediation layout and know-how utilized in temperate climates doesn't inevitably paintings in chilly climates, and cleanup takes longer as a result of shorter remedy seasons, sub-freezing temperatures, flooring freezing and thawing, and constrained bioactivity.

Biotechnology of Aroma Compounds (Advances in Biochemical Engineering Biotechnology)

Discussing the biotechnology of aroma compounds, this paintings contains insurance of: enzymes and flavour biotechnology; glycoconjugated aroma compounds - occurence, position and biotechnological transformation; and clients for the bioengineering of isoprenoid biosynthesis.

Nanotechnology in Electrocatalysis for Energy

This ebook specializes in nanotechnology in electrocatalysis for strength purposes. specifically the ebook covers nanostructured electrocatalysts for low temperature gasoline cells, low temperature electrolyzers and electrochemical valorization. The functionality of this booklet is to supply an advent to simple ideas of electrocatalysis, including a evaluate of the most sessions of fabrics and electrode architectures.

Extra info for Excel 2010 for Environmental Sciences Statistics: A Guide to Solving Practical Problems

Example text

Because of budget constraints, you need to choose a random sample of 12 of these 42 water sample collection sites. 5 End-of-Chapter Practice Problems 33 (b) Then, create a separate column to the right of these frame numbers which duplicates these frame numbers with the title: Duplicate frame numbers. (c) Then, create a separate column to the right of these duplicate frame numbers called RAND NO. and use the ¼RAND() function to assign random numbers to all of the frame numbers in the duplicate frame numbers column, and change this column format so that three decimal places appear for each random number.

1) so that the frame numbers go from 1 to 32, with the number 32 in cell A35. If you need to be reminded about how to do that, here are the steps: Click on cell A4 to select this cell Home Fill (then click on the “down arrow” next to this command and select) Series (see Fig. 1) Fig. 1 Dialogue Box for Fill/Series Commands Columns Step value: Stop value: 1 32 (see Fig. 2) Fig. 1 Creating Frame Numbers for Generating Random Numbers 23 Then, save this file as: Random29. You should obtain the result in Fig.

95 Home Highlight cells A4:A6 by left-clicking your mouse on A4 and dragging it down so that these three cells are highlighted in a darker color Number (top center of screen: click on the down arrow on the right; see Fig. 15) Fig. 8 Formatting Numbers in Number Format (Three Decimal Places) 17 Category: Currency Decimal places: 2 (then see Fig. 16) Fig. 16 Dialogue Box for Currency (two decimal places) Format for Numbers OK The three cells should have a dollar sign in them and be in two decimal places.

Download PDF sample

Rated 4.27 of 5 – based on 4 votes