This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Excel Study Guide #1 Chapters 2 & 4 Getting Started: Read Appendix 1.B: Introduction to Microsoft Excel on pages 10 – 14 of the textbook. Pay particular attention to the last paragraph on page 14, “Statistics Practitioners and Students: Beware.” Printing from Excel: A very useful feature on Excel is the viewer. Once you have completed your work and you are ready to print, go to VIEW PageBreakPreview. This shows you what is being printed on each page. You can click on and move the page boundaries. This is often needed when creating STEM and LEAF plots. Using Excel to create Histograms and Stem and Leaf Plots Exercise 2.38 on p. 50 The number of weekly sales calls by a sample of 30 telemarketers are listed in file Xr02-38. Create a histogram. 1. Open file Xr02-38 in Excel. If you are using a personal computer, the file is located in the Keller7 folder which you have installed off the CD that came with your text. If you are using a lab computer, the file is located in the Masc310 folder which should be located on the desktop of all lab computers. They are also in the Excel folder on Blackboard. 2. Find the smallest or largest values of the data. With this information, you can determine the class width. There are two ways to do this: a. Sort the data. Highlight the data set and go to DATA – SORT. You can choose ascending or descending order....
View Full Document
This test prep was uploaded on 04/06/2008 for the course CPSC 120 taught by Professor Cathyhochrine during the Fall '08 term at Clemson.
- Fall '08