Reading and Visualizing Data from a CD-ROM using Excel: An Example with Beanie Babies - Pr, Assignments of Statistics

Download Reading and Visualizing Data from a CD-ROM using Excel: An Example with Beanie Babies - Pr and more Assignments Statistics in PDF only on Docsity! Example. Exercise 2.97 How to read data? 1. To read data from the data CD-ROM (that goes with the textbook) click first File  Open Worksheet… It opens the Open Worksheet window. 2. Choose Data(*.dat) as Files of type. The data file is on the data CD-ROM in folder Exercise. Select the appropriate setting in the Look in field. The list of the data files appears in the window. 3. Click Options… and select None in Variables Name, Ignore blank data rows, and Free format in Field Definition. Click OK. 4. Select Beanie and click Open. It opens BEANIE.DAT: C1 C2-T C3 C4-T C5 1 Ally 52 R 55 2 Batty 12 C 12 3 Bongo 28 R 40 4 Blackie 52 C 10 5 Bucky 40 R 45 ... ... How to construct a pie chart for the retired/current status? 1. Click Graph  Pie Chart… It opens the Pie Chart window. 2. Select Chart data in and type C4 there ( or add it using the Select botton). Type a name of your graph in the Title field (for example, Pie Chart for the Retired/Current Status). Click OK. It produces the following picture: 1 How to construct the histogram for the value of the 50 Beanie Babies? 1. Type a name of the last colomn in the cell right under the C5 in the open worksheet. For example, Value ($). 2. Click Graph  Histogram… It opens the Histogram window. Select C5 as Graph Variables and then press OK. It produces the histogram: 2