ED

illbreedinggrouseΠολεοδομικά Έργα

16 Νοε 2013 (πριν από 3 χρόνια και 10 μήνες)

69 εμφανίσεις

E. Hamilton

DLI Atlantic Training 2002


What’s the scoop on …


ED:

[
Employment Dynamics
]




What is it?


This product is comprised of Excel spreadsheets containing select statistics on businesses (new,
continuing or defunct) and the number of jobs involved at a national and provincial level.
Statistics
provided in the Excel tables include the number of employers/businesses organized by province,
industry, comparison years from 1983
-
1984 to 1997
-
1998, employment size and life status
(continuing, new, defunct); and indicating aggregate payroll a
nd their employment levels.


When would I use it?


The statistics are pulled from a longitudinal database [LEAP] of all businesses that issue T4 slips,
and provide the data for Statistics Canada to be able to relate the following


In 1997, there were about

955,800 active employers of all sizes. About 718,000, or 75%, had fewer
than five employees; 213,000 or about 22%, had between 5 and 50…. In 1996, about 145,500
employer businesses with fewer than 50 employees began operations, up 2.6% from 1995. At the
same time, 125,900 firms of the same size went out of business, 11.7% fewer firms than went out of
business in 1995.
The Daily
, 8 March 2000


With ED, your users can do the same sort of analysis for different industries or provinces. [see last
page for sam
ple spreadsheets].


What do I need to use it?


All that is needed to use this product is the MSOffice Suite (data are in Excel and documentation
comes in Word format), or the Excel and Word viewers (available for free downloading from
www.microsoft.com/dow
nloads).


How do I use it?


Download the zip file (english.zip), unzip it and you are ready to go! When you unzip the file, a
directory called “ED” is created and you will see the following structure unfold before your eyes:



ED

Data Tables




Alberta


A
B (Divisions).xls




2,175 KB


AB (Major Groups).xls


10,850 KB


AB (Total All Industries).xls


117KB

British Columbia

Canada




[etc.]



Documentation


GeneralProductInformation.DOC


IndustryCodes.XLS


LicenceAgreement.DOC


TableNotes.DOC

E. Hamilton

DLI Atlantic Training 2002


Note of
advice
: Print out the General Product Information and Table Notes. These two documents
are concise, providing an introduction to ED and including key definitions (like what an ALU is).


What is the difference between the files available? It is the level
of detail in the industry code.
In the three files for Nova Scotia, for example:


NS (total all industries).xls

11 columns and 643 rows (the single code, Z00, is for “all industries”)


NS (divisions).xls

11 columns, but 12,614 rows representing xx indus
try divisions


NS (Major groups).xls

11 columns, but 49,154 rows


With this product, a picture is worth a thousand words. After you have printed out the General
Product Information and Table Notes, check the Industry Codes (don’t print the whole thing, t
hough).
With these documents in hand, open a table and have a look.





“Firms in 1998 employed about
12,952,000

part
-
time and full
-
time employees on average during
the year, about 672,000 more than in 1997.
Newly
-
identified employers added 516,000

jobs
; a
loss of 399,000 jobs was attributed to firms that terminated, and firms that were present in both
1997 and 1998 contributed a net addition of 556,000 jobs.”
The Daily

13 June 2001



Where do I get more information?


The documentation for this prod
uct is remarkably clear, but do not hesitate to contact the DLI List if
you have questions! Related products include
Sub
-
provincial Employment Dynamics
,
Canadian
Business Patterns
,
Small Business Profiles
, and
Insights on…

(61F0019XIE, available freely fo
r
downloading on the Statistics Canada web site.