1 / 8

Density Calculation with Excel: An Easy Guide for Data Analysis

Learn how to calculate density using Excel by selecting and copying data into a new spreadsheet, paying attention to dates and categories. Follow the steps to enter the equation for density and create charts for analysis. Use the provided tables in written reports easily by copying from Excel and pasting into Word documents.

yosef
Télécharger la présentation

Density Calculation with Excel: An Easy Guide for Data Analysis

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Working With Excel Coin Density

  2. Calculate Density • We are going to select the data you need to use. • From the data table, copy and paste the lines that you need into a new spread sheet. • PAY ATTENTION TO THE DATES!! • MAKE SURE TO COPY THE ENTIRE LINE!! • COPY THE CATEGORIES TOO!!

  3. Add title for Column ‘E’ • What are the units? • We’re going to enter the equation for Density

  4. Use the format: =C2/D2 • Press ‘enter’ • The box should now show a number value • Raise your hand if this hasn’t worked

  5. Click on lower right side of the box you just entered the equation in. • Drag down while holding down the mouse button.

  6. What do we do with our chart? • Now we know the density of the pennies that we’re using in the project. • You are going to use these tables in your reports. • You will copy and paste them into your written papers.

  7. Copy from Excel, paste into Word

More Related