Prepare Descriptive Statistics Data Analysis Plan

profileTggri2147
Stat2004015Fall1ProjectDataset.doc

STAT200 Introduction to Statistics

Dataset for Written Assignments

Description of Dataset:

The data is a random sample from the US Department of Labor’s 2016 Consumer Expenditure Surveys (CE) and provides information about the composition of households and their annual expenditures ( https://www.bls.gov/cex/ ). It contains information from 30 households, where a survey responder provided the requested information; it is all self-reported information. This dataset contains four socioeconomic variables (whose names start with SE) and four expenditure variables (whose names start with USD).

Description of Variables/Data Dictionary:

The following table is a data dictionary that describes the variables and their locations in this dataset (Note: Dataset is on second page of this document):

Variable Name

Location in Dataset

Variable Description

Coding

UniqueID#

First Column

Unique number used to identify each survey responder

Each responder has a unique number from 1-30

SE-MaritalStatus

Second Column

Marital Status of Head of Household

Not Married/Married

SE-Income

Third Column

Total Annual Household Income

Amount in US Dollars

SE-AgeHeadHousehold

Fourth Column

Age of the Head of Household

Age in Years

SE-FamilySize

Fifth Column

Total Number of People in Family (Both Adults and Children)

Number of People in Family

USD-Food

Sixth Column

Total Amount of Annual Expenditures on Food

Amount in US Dollars

USD-Meat

Seventh Column

Total Amount of Annual Expenditure on Meat

Amount in US Dollars

USD-Bakery

Eighth Column

Total Amount of Annual Expenditure on Bakery

Amount in US Dollars

USD-Fruits

Ninth Column

Total Amount of Annual Expenditure on Fruit

Amount in US Dollars

How to read the data set: Each row contains information from one household. For instance, the first row of the dataset starting on the next page shows us that: the head of household is not married and is 52 years old, has an annual household income of $95,744, a family size of 4, annual food expenditures of $7,040, and spends $906 on meat, $353 on bakery items, and $753 on fruit.

UniqueID#

SE-MaritalStatus

SE-Income

SE-AgeHeadHousehold

SE-FamilySize

USD-Food

USD-Meat

USD-Bakery

USD-Fruits

1

Not Married

95744

52

4

7040

906

353

753

2

Not Married

94867

60

1

6935

918

351

746

3

Not Married

96244

56

4

7073

918

338

773

4

Not Married

98717

40

3

7036

889

348

768

5

Not Married

96697

49

2

6971

898

357

779

6

Not Married

96886

44

2

6982

917

359

752

7

Not Married

94929

59

2

6948

899

345

771

8

Not Married

96653

51

4

6943

880

352

781

9

Not Married

96928

43

3

6953

887

343

759

10

Not Married

96522

43

4

6991

922

349

758

11

Not Married

96572

59

2

7179

880

353

744

12

Not Married

96621

54

2

7000

911

344

768

13

Not Married

96690

57

2

6822

880

349

764

14

Not Married

96664

53

3

7051

906

346

772

15

Not Married

95366

48

2

7130

904

344

760

16

Married

100947

35

4

8455

910

415

1001

17

Married

114505

36

5

11375

1368

537

1124

18

Married

95865

46

1

9321

1159

447

1006

19

Married

95835

54

3

9111

1098

452

1027

20

Married

100350

31

5

9044

1015

407

1142

21

Married

113558

31

5

10346

1343

515

1122

22

Married

95706

52

4

8925

1207

454

1003

23

Married

106906

51

3

11356

1434

493

1286

24

Married

109377

48

4

10575

1492

517

1096

25

Married

102081

42

4

11738

1348

484

1379

26

Married

103001

34

4

8947

864

427

951

27

Married

110553

23

4

10575

1346

531

1090

28

Married

106977

56

3

10611

1320

546

1120

29

Married

101890

48

2

11089

1481

541

1157

30

Married

100565

18

3

8479

893

370

1068