Preview

excel

Good Essays
Open Document
Open Document
3102 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
excel
How to Use a Data Spreadsheet: Excel
One does not necessarily have special statistical software to perform statistical analyses. Microsoft Office Excel can be used to run statistical procedures. Although in some respects Excel is not as preferable for data analyses as IBM SPSS, it is very userfriendly with simpler statistical procedures. This appendix describes how to use Excel to execute basic statistical calculations. Data from the 2004 version of the General Social
Survey (GSS) is used for examples. This Appendix is based on Excel 2007 version, which differs in certain aspects from Excel’s previous versions. The most notable change that affects the exercises presented in this appendix concerns the pivot table feature.

BASIC PROCEDURES
Starting Excel:
To start Excel using Windows, click on the Start button at the bottom left corner of the screen. Under Programs locate and click the Microsoft Excel icon.
The layout of the Excel program has changed substantially for the Microsoft Office
2007 edition compared to its predecessors. Commands are now grouped in ribbons that are accessed by clicking on a specific tab. Thus, the Home tab grants access to a ribbon of several command groups: Clipboard, Font, Alignment, Number, Styles, Cells, and
Editing.
Once the program is started you will see a Worksheet Area that consists of cells forming columns and rows. Rows are identified by numbers, and columns are identified by letters. Consequently, each cell has its own unique address – a combination of letters and numbers. For example, cell C6 is in column C, row6. The dark rim around a cell means that the cell is highlighted or active. You can highlight a range of cells by clicking and dragging the cursor across several adjacent cells.
At the bottom left of the screen you will find worksheet tabs labeled Sheet 1, Sheet
2, etc. You can rename these worksheets, add additional ones or delete ones you do not need. Opening data:
The data you need to use

You May Also Find These Documents Helpful

  • Powerful Essays

    Under Number of columns type “2”; under number of rows type “10”; under width type “3 in.” Hit “OK”.…

    • 2075 Words
    • 9 Pages
    Powerful Essays
  • Good Essays

    When the cell pointer is located in A1 in Excel, then the cell is called a(n)…

    • 663 Words
    • 3 Pages
    Good Essays
  • Good Essays

    When you first enter the classroom you see the homepage. On the home page there is the calendar for the week, assignments for the week in the middle and the blue navigation bar. Other items on the screen is my name, course title, and a search bar. The tabs are the little house, calendar, tasks, resources, connect, reports, and announcements.…

    • 961 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Unit 42 M3

    • 430 Words
    • 2 Pages

    Active X control can be written in Visual Basic but Excel provides some via the tool box.…

    • 430 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Tips for Pam and Sue

    • 1337 Words
    • 6 Pages

    Microsoft Excel with Analysis ToolPak (do NOT use stepwise regression for this project even if it runs on your computer).…

    • 1337 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    Is Case Study

    • 394 Words
    • 2 Pages

    5. Add conditional formatting to each applicable column to highlight the high amount in green and the low amount in red.…

    • 394 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Mth231 R2 Scavenger Hunt

    • 409 Words
    • 3 Pages

    You should download the Excel file “Data Download” and the Documentation (click on the pdf symbol). The documentation has a detailed explanation about how the different variables were collected and their significance.…

    • 409 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    8. You press the Ctrl+ˋ keys to display the formulas in cells instead of their resulting values or click the Show Formulas button in the Formula Auditing group on the FORMULAS tab.…

    • 193 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    Some of software designed for statistical analyses included “Statistical Package for Social Sciences, which offer the ability to collect, organize, analyze, and produce a table with statistical information (Quinn, 2011)”. However, this type of software can be expensive and over the allow funding budget for a human services agency. Another option a human services agency can use Microsoft Excel for statistical analyses. Microsoft Excel for statistical analyses can be complex; if the agency staff members are unfamiliar with how statistics works, spreadsheet formulas, and spreadsheet functions. Web-based statistical analyses program is another option for a human service agency since many of their services include free statistical methods. However, there are some precautions with using free online web-based statistic. For instance, a human service agency would need to consider whether the “analytical meeting the needs of the agency, and the usefulness of the output to the agency (Quinn,…

    • 656 Words
    • 3 Pages
    Good Essays
  • Good Essays

    * Worksheets are handouts the students complete to practice their skills. They give the students a chance to get further repetition without taking the teacher 's full-time attention. While all students complete their worksheets, the teacher can focus on the individual students who need the most help. Worksheets are also a common form of homework assignment. A student 's performance on worksheets can also be used to gauge the student 's progress on that particular subject.…

    • 800 Words
    • 4 Pages
    Good Essays
  • Good Essays

    When I double click on a cell it only displays the formula A: “Allow editing directly in cells” is most likely enabled File > Options > Advanced > clear the “Allow editing directly in cells” checkbox What happened to my Excel? Q: All my worksheets are in the same windows A1: In Pfx Engagement, from the file room view: Tools > Options > General > “Launch separate instances of Excel (Dual monitor)” should be checked A2: In Excel: File > Options > Advanced > Display > “Show all windows in the Taskbar” should be checked What happened to my Excel?…

    • 1503 Words
    • 7 Pages
    Good Essays
  • Good Essays

    ICD9 Tabbing REV 01 31 11

    • 1068 Words
    • 3 Pages

    The first tab label listed on your sheet is the “Table of Contents”. You can find the Table…

    • 1068 Words
    • 3 Pages
    Good Essays
  • Good Essays

    The need for Computer Assisted Survey information System has been a helping hand in acquiring Amount of data needed for a particular Research or Study. Conducting Surveys from The past requires more Time to tabulate amounts of data in the survey. Scanning questionnaires is a method of data collection that can be used with paper questionnaires that have been administered in face-to-face interviews; mail surveys or surveys completed by an Interviewer over the telephone. The method used in the office of The University Research Center is The SPSS (originally, Statistical Package for the Social Sciences) where thesystem reads the encoded or databases of a Conducted system.…

    • 1030 Words
    • 5 Pages
    Good Essays
  • Good Essays

    top of every column and to the left of every row that indicate the number and…

    • 9928 Words
    • 35 Pages
    Good Essays
  • Satisfactory Essays

    MICROSOFT OFFICE

    • 1068 Words
    • 5 Pages

    MS Office is an application made up of some collection of software applications which help user to perform various tasks with little effort in offices now a days. With MS office in our pc we can do many things like creating text documents, spreadsheets, flow charts ,presentations ,pie charts, notes, business cards, greeting cards, calendars , brochures, flyers, postcards ,website templates and many more things. MS office has become a must have requirement for offices, I wonder what it would’ve been like before MS office was made.…

    • 1068 Words
    • 5 Pages
    Satisfactory Essays