Using excel for statistics in gateway cases office 2007
Download
1 / 8

Using Excel for Statistics in Gateway Cases – Office 2007 - PowerPoint PPT Presentation


Using Excel for Statistics in Gateway Cases – Office 2007. Concepts Covered. Statistics - Descriptive Statistics - Histograms - Hypothesis Testing - Scatter Plots - Regression Analysis. To Set Up Statistical Package. Click Microsoft Office Button , and Then Click Excel Options

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha

Download Presentation

Using Excel for Statistics in Gateway Cases – Office 2007

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Using Excel for Statistics in Gateway Cases – Office 2007


Concepts Covered

  • Statistics

    - Descriptive Statistics

    - Histograms

    - Hypothesis Testing

    - Scatter Plots

    - Regression Analysis


To Set Up Statistical Package

  • Click Microsoft Office Button , and Then Click Excel Options

  • Click Add-ins. In Manage Box, Select Excel Add-ins

  • Click Go

  • In the Add-Ins Available Box, Select Analysis ToolPak Check Box and Click OK. (If ToolPak Is Not Listed, Click Browse to Locate It.)


Using Excel:Descriptive Statistics

  • Click Data/Data Analysis (Far Right) /Descriptive Statistics & OK.

  • Put Checkmarks on Summary Statistics, 95% or 99% Confidence Interval, & Labels in First Row Boxes.

  • Move Cursor to Input Range Window, Highlight Data to Analyze including Labels, & Click OK.

  • Your Data will Appear on New Worksheet.

  • Widen Columns by Clicking Home/Format/AutoFit Column Width.


Using Excel:Constructing Histograms

  • Click Data/Data Analysis/Histogram & OK.

  • Put Checkmarks on Chart Output & New Worksheet Boxes.

  • Move Cursor to Input Range Window, Highlight Data Going into Histogram.

  • Move Cursor to Input Bin Range, Highlight Data Showing Upper Value of Each Bin & Click OK.

  • Histogram will be on New Worksheet. You May Lengthen it by Clicking Blank Space in Window, Moving Cursor to Window Bottom Line & Holding Down Mouse Button as You Pull Down Window.


Using Excel:Hypothesis Testing

  • Go to Sheet One.

  • Click Data/Data Analysis/ and the Appropriate Statistical Test. Then Click OK.

  • On New Window Check Labels Box and Put Cursor on Variable 1 Range.

  • Highlight Variable 1 Data Including Label.

  • Put Cursor on Variable 2 Range & Highlight Variable 2 Data (Including Label). Then Click OK.

  • Click Home/Format/AutoFit/Column Width


Using Excel:Scatter Plots

  • Go to Sheet One.

  • Highlight Data (Be Sure X Values are in Left Column and Y Values are in Right Column).

  • Click Insert/Scatter. Pull down menu and click Upper Left Icon.

  • Click a Datum Point on Chart with Right Mouse Key, Add Trendline, & Click Linear.


Using Excel:Regression Analysis

  • Go to Sheet One.

  • Click Data/Data Analysis (On Far Right) /Regression & Click OK.

  • On New Window Check Labels Box and Put Cursor on X Range.

  • Highlight X Data Including Label.

  • Put Cursor on Y Range & Highlight Y Data (Including Label), Then Click OK.

  • Click Home/Format/AutoFit Column Width.


ad
  • Login