{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

CEX4OVExcel

CEX4OVExcel - Econ 444 Elementary Econometrics(Fall 2007...

This preview shows pages 1–3. Sign up to view the full content.

Econ 444 Elementary Econometrics (Fall 2007) COMPUTER EXERCISES The main purpose of these exercises is threefold: 1. to learn how to run a regression in Excel with its Data Analysis tool; 2. to learn how to plot the data in Excel; 3. to learn how to import data in the text format to Excel. 1 MICROSOFT EXCEL BASICS If you are familiar with Excel, try to do the following exercise in any way you like and skip to the next section of "Running Regressions in Excel." If you are not familiar with Excel or if you have any trouble doing the exercise, follow the step-by-step instructions given below. 1.1 Exercise for Excel Basics Type in 70, 110, 155 in cells in cells A1, A2, and A3. Then type in 80, 160, and 240 in cells B1, B2,and B3. For today°s exercise, these two numbers are the data for Y and X . The ±rst column is the data for Y as in the examples and applications we have seen in the course. For plotting the data in Excel, it is more convenient to have X in the ±rst column. For this purpose, copy A1-A3 to B5-B7, and copy B1-B3 to A5-A7. After this, make sure that you have 80, 160, 240 in cells A 5 ; A 6 ; A 7 , respectively, and 70, 110, and 155 in cells B 5 ; B 6 , and B 7 , respectively. 1.2 Step-by-Step Instructions Start Excel. 1 1 To start Excel, move your mouse to the "Start" button. Then click the mouse ("click" means to quickly press and release the left mouse button.) the "Start" button. A box will appear. Then click at the "Programs" icon in the box. A new box will appear. Then click at the "Microsoft O¢ ce" icon, and then "Microsoft Excel" icon. If you cannot ±nd the Microsoft Excel icon in this way, it may be placed in some other places in di/erent computers. Ask someone who is famiilar with the particular computer you are woking on. 1

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
1.2.1 Cells Observe that cells are arranged in rows and columns in Microsoft Excel. Columns are indicated by Letters while rows are indicated by integers. Hence cell B 7 is in column B and row 7. 1.2.2 Moving Around the Worksheet Press Num Lock key repeatedly until the Num Lock light is o/. Use the cursor (arrow) keys to move around the worksheet. As you move around, observe that the highlighted cell moves around. Also press the "Page-Up" and "Page- Down" keys and observe that you can move in bigger steps. Finally press "Ctrl-Home" (meaning press the "Ctrl" and "Home" keys at the same time) to jump back to cell A 1 . 1.2.3 Highlight Cells Move your mouse while pressing the left mouse button and observe how cells are highlighted. Then go to A1 and click the left mouse button.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern