1 / 13

Simple Statistics Using Excel

Simple Statistics Using Excel. LABORATORY SKILLS TRAINING SCI 110. Introduction. The following slides are just a few data points measuring pressure in mmHg, and will serve as a good example.

king
Download Presentation

Simple Statistics Using Excel

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. Simple Statistics Using Excel LABORATORY SKILLS TRAINING SCI 110

  2. Introduction • The following slides are just a few data points measuring pressure in mmHg, and will serve as a good example. • The screenshots are fairly accurate except for some reason when a dialog box is open in Excel, some information is not visible in the screenshot. • Follow through each screenshot to be able to determine the statistical information need for your lab reports.

  3. Enter Data & Use a Function 1. Open a new spreadsheet in Excel. 2. Enter your title on the top line and data points in the column, one per cell. 3. Click in a cell below the data you wish to display the average (A12).

  4. Find the Average of Cells A2-A10 1. Place the cursor on fx symbol and click, you will see an = sign appear in the cell and in the white space. The dialog box below will open. 2.Click on Average and then click OK.

  5. Find the Average of Cells A2-A10 1. Check the cell numbers that are to be averaged and make sure they are correct. 2. These are not, so place the cursor in the space and click to activate edit.

  6. Find the Average of Cells A2-A10 1. Change the numbers to include all the numbers you want to average. (For this example, we will average cells A2:A10. If you include the title, the average will not display.) 2. Click OK.

  7. Your Page Should Look Like This 1. The formula will be displayed in the white space. 2. The mean value will be displayed in cell A12 and

  8. Type a Title & Add Another Function 2. Click in cell A13, then click on fx to add your next function. 1. Type the title Average in the cell adjacent to the average for identification.

  9. Find the Standard Deviation of A2-A10 1. To find the Standard Deviation (STDev), first select the Statistical functions 2. Search the list, select STDev. 3. Click OK

  10. Edit Numbers for Correct Cells 1. Place the cursor in the Number1 box and click to edit the cells.

  11. Edit To Evaluate STDev of A2-A10 1. Enter A2:A10. 2. Click OK

  12. Your Page Should Look Like This The mean and standard deviation for this set of data is written as 766.5245 ± 0.247228, the smaller the STDev the better the data! 1. Give a title to the cell to identify the STDev. 2. Now you are ready to present the mean and standard deviation in your lab report.

  13. Keep Adding More Functions • Find all of the rest of the statistics that you need by repeating the steps. • Scroll through the different functions to see what else you should report as statically important information. • Make sure to discuss your statistical interpretation of the data in the Summary portion of your lab report.

More Related