excel by example a microsoft excel cookbook for electronics engineers phần 3

Excel có khả năng tạo ra một hồi quy trên một đường thẳng và xác định hình thức tốt nhất của phương trình. Nhấp chuột phải vào dòng đầu ra hiện tại và chọn Thêm đường xu hướng từ menu như thể hiện trong hình | Example 4 Counting Machine Cycles Figure 4-1 Open a list file. Open the file and you will be presented with the Text Import Wizard as shown in Figure 4-2. Figure 4-2 Step 1 of the Text Import Wizard. Click on the Delimited data type. It is possible to remove a number of lines from the top of the file by starting the import at a particular row. Identify which row by scrolling down the preview window at the bottom of the screen but you must manually enter the line number in the Start import at row box. Then click on the Next button. The next step in the File Import process is seen in Figure 4-3. 59 Excel by Example Figure 4-3 Second stage of file import definition of delimiters. Choose Tab and Space as delimiters and Treat consecutive delimiters as one. The Data Preview provides an idea of how the worksheet is going to appear. Select the Next button and the third stage Figure 4-4 will be seen. Figure 4-4 Third stage of file insert formatting columns. For each of the first four columns click on the bar at the top and format the column as text using the radio buttons in the Column data format area. This is important because without this Excel will look at each cell in the op-codes and interpret as a number when there is no 60 Example 4 Counting Machine Cycles alpha character and text when there is. Classifying it as text will allow us to analyze the opcodes in a consistent manner. Click on Finish to see the initial worksheet Figure 4-5 . Figure 4-5 Initial worksheet. Some comments in a line may stretch across many cells in a row but this will not affect what we are trying to do. You will notice that the file importation results in only one worksheet. Of particular note is that the compiler places a backslash as the first character of any line with code in it so I will use this as an indicator of a machine code entry. .