japan s modern economy excel tips l.
Skip this Video
Loading SlideShow in 5 Seconds..
Japan’s Modern Economy Excel Tips PowerPoint Presentation
Download Presentation
Japan’s Modern Economy Excel Tips

play fullscreen
1 / 4
Download Presentation

Japan’s Modern Economy Excel Tips - PowerPoint PPT Presentation

brigid
111 Views
Download Presentation

Japan’s Modern Economy Excel Tips

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Japan’s Modern EconomyExcel Tips September 11, 2007 Economics 272

  2. Excel (1 of 3) • How to get notebooks, log in • Go to Cabinet Office web site • download GDP data (as .cvs file) • Import into Excel • Calculate GDP year-on-year growth rates • Create graph • Calculate trade as share of GDP • Net trade, exports, imports • Create graph • ∑ trade not a big share of Japan’s economy! • But net trade grew recently, undergirding growth

  3. Excel (2 of 3) • Excel tricks • May need to make columns wider to be able to see numbers [depends on setup] • Insert blank columns • Use “=” sign to begin formulas, can use mouse to select, keyboard “/” to divide • Then format cell if necessary to get % • Can drag to replicate for a column

  4. Excel (3 of 3) • Select a column of data and then Insert Chart to start setup menu • I use a line graph for this sort of data • Need to go to the series tab to select year headings for bottom • Make sure have a data cell corresponding to each label or they won’t align in your graph! • I then fiddle with the xy axis labels to get where things end up, size etc • We’ll practice again!!