Download Analyzing Time Series Data: One-Way and Two-Way ANOVA in Excel and EViews and more Lab Reports Introduction to Econometrics in PDF only on Docsity! Econ 240C LAB One 1 4-1-2009 I. Pooling A. Open data file XM 14-02 in Excel 1. Note there are 200 rows of data, one for each teenager, with the columns labeled for day of the week from Sunday through Saturday. 2. Go to the Tools menu, Data Analysis and select Anova: Single factor 3. In the dialog box that opens, select cells B1:H201, and check the box for labels in the first row, and choose new worksheet ply for the output option. This is the One-Way ANOVA for the time or day of the week factor. 4. Using data file XM14-02 in Excel, select columns A-H and rows 1-201, And paste into a new Excel file using the paste-special command from the edit menu with the transpose box checked. Go to the Tools menu, Data Analysis and select Anova: Single factor 5. In the dialog box that opens, select cells B1:GS8, and check the box for labels in the first row, and choose new worksheet ply for the output option. This is the One-Way ANOVA for the blocks or teenager factor. 6. The two-way ANOVA could be constructed from these one-way ANOVAs, or run directly by going to the Tools menu, Data Analysis and selecting ANOVA: Two-Factor without replication. 7. In the dialog box that opens, select cells B2:H201, and do not check the box for labels in the first row, and choose new worksheet ply for the output option. This is the Two-Way ANOVA for the time factor and the blocks factor. II. Transferring the Rock Minutes Data to EViews A. Using data file XM14-02 in Excel, select columns A-H and rows 1-201, And paste into a new Excel file using the paste-special command from the edit menu with the transpose box checked. In cell B1, type in min_1 and drag across the first row until min_200. Save this Excel file to the Econ240C lab One folder as Rockmin, and close this file. Econ 240C LAB One 2 4-1-2009 B. Open EViews and from the file menu select new workfile. In the dialog box choose daily (seven days) with a start date, for example of 12/24/00 and an end date of 12/30/2000. C. In the workfile window go to the PROCS menu and select import, read Excel, and open the rockmin file from the lab one folder. Type in 200 for the number of series and hit OK. This should import the 200 time series into Eviews. A similar Eviews file, POOLMIN, is in the lab one folder. D. To conduct one-way ANOVA across the 200 blocks, select the 200 series min_1 etc. Go to the view menu and choose open selected, one window, one group. In the group window, go to the view menu and choose tests of equality, mean, and hit OK. E. Alternatively, go to the workfile window menu and select Object, pool. In Excel, in a new file, type _1 in cell A1, and drag to row 200. Select, copy, and paste into the Pool window in Eviews under cross section identifiers. In the pool window, go to the estimate menu, and a dialog box opens. Type min? for the dependent variable Type c for cross section specific coefficients Choose none for intercept Choose no weighting Note that the sum of squared residuals is 507798.9. The total sum of squares can be calculated from the standard deviation of the dependent variable, 22.64866.Square this number and multiply by the degrees of freedom, 1399 (7x200 minus 1). The explained sum of squares can be calculated by difference. F. To control for the time factor, set the sample to 12/24/00 12/24/00 and generate Sunday=1, Monday=0, ……..Saturday=0. Then set the sample to 12/25/00 12/25/00 and generate Sunday=0, Monday=1, Tueday =0, …. Saturday=0, etc., i.e. day of the week dummies. As in section E, above, create a pool object and paste in the cross section identifiers from Excel. Go to estimate Type min? for the dependent variable
