management assignment

ppl

Week08_NationalInsuranceData_Practice_Solution.xlsx

Home >Business & Finance homework help >Marketing homework help >management assignment

national

p10

p11

p12

p13

p14

p15

p16

p17

p18

p19

p20

p21

p22

tanimp

relimp

resimp

asrimp

empimp

rec

use

prob

resolve

sex

mstat

age

inc

reliavrg

empavrg

tangavrg

respavrg

assuravg

Strongly Agree

Yes

5 or more years

Female

Married

25-44

$30K-$49.9K

High School or Less

Strongly Disagree

Disagree

Strongly Disagree

Agree Slightly

Strongly Disagree

2 to 5 years

Yes

1.4

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree

Agree Slightly

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

Graduate School

6.2

5.75

6.25

6.5

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

Less than 1 year

Male

Married

25-44

$30K-$49.9K

Some College

6.6

6.8

6.5

Agree

Strongly Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

6.2

5.8

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Strongly Agree

Agree

Neither Agree Nor Disagree

Disagree Slightly

Agree

Strongly Agree

Agree

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Yes

5 or more years

Yes

Female

Married

25-44

$30K-$49.9K

Some College

5.2

4.6

6.25

4.5

4.75

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Agree Slightly

Agree

Strongly Agree

Agree

Yes

5 or more years

Female

Married

25-44

$20K - $29.9 K

High School or Less

6.2

5.75

6.75

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Disagree Slightly

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Yes

Male

Married

25-44

$50K-$64.9

Some College

6.4

5.6

5.5

6.5

Neither Agree Nor Disagree

Agree

Agree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Yes

5 or more years

Yes

Female

Married

25-44

>$65K

Some College

4.4

4.5

4.25

Agree

Disagree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Strongly Agree

Agree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

College Graduate

5.25

6.5

Neither Agree Nor Disagree

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$10K-$19.9 K

Some College

5.2

6.5

6.25

Strongly Agree

Agree Slightly

Strongly Agree

Yes

2 to 5 years

Male

Married

25-44

$30K-$49.9K

Graduate School

6.5

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Neither Agree Nor Disagree

Disagree

Agree Slightly

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Agree

Agree Slightly

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

Some College

5.6

4.4

5.5

4.75

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Yes

Male

Married

25-44

$20K - $29.9 K

High School or Less

6.4

6.8

6.75

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree

Yes

2 to 5 years

Yes

Male

Married

25-44

$20K - $29.9 K

Some College

4.2

4.75

4.5

Strongly Agree

Disagree Slightly

Neither Agree Nor Disagree

Strongly Agree

Yes

5 or more years

Female

Single

< 25

< $10K

High School or Less

3.5

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Disagree

Disagree Slightly

Disagree

Disagree Slightly

Yes

5 or more years

Yes

Female

Divorced

65+

$50K-$64.9

College Graduate

4.8

3.8

2.5

2.75

2.5

Agree

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Disagree

Agree Slightly

Disagree

Agree Slightly

Neither Agree Nor Disagree

Strongly Agree

Agree Slightly

Neither Agree Nor Disagree

Disagree

Neither Agree Nor Disagree

Disagree

Yes

5 or more years

Yes

Female

Married

25-44

$30K-$49.9K

Some College

4.8

3.2

5.75

3.25

2.5

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Yes

2 to 5 years

Yes

Male

Married

25-44

$30K-$49.9K

Some College

5.8

5.75

Strongly Agree

Agree

Strongly Agree

Yes

Less than 1 year

Female

Widowed

45-64

< $10K

High School or Less

6.8

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

Less than 1 year

Yes

Male

Married

25-44

$20K - $29.9 K

Some College

6.2

6.4

6.5

6.25

6.5

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Female

Married

25-44

< $10K

High School or Less

6.4

6.5

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Male

Divorced

65+

$50K-$64.9

College Graduate

5.4

6.6

6.25

6.75

Agree

Neither Agree Nor Disagree

Disagree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

1 to 2 years

Yes

Female

Single

< 25

$30K-$49.9K

High School or Less

4.2

4.6

5.25

4.5

Neither Agree Nor Disagree

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Disagree Slightly

Strongly Agree

Agree

Strongly Agree

Neither Agree Nor Disagree

Yes

1 to 2 years

Female

Married

25-44

$10K-$19.9 K

Some College

6.8

6.75

Strongly Agree

Yes

5 or more years

Male

Married

25-44

< $10K

High School or Less

Agree

Neither Agree Nor Disagree

Agree

Yes

5 or more years

Male

Married

25-44

$20K - $29.9 K

Some College

Agree Slightly

Agree

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree

Yes

5 or more years

Female

Married

25-44

$20K - $29.9 K

High School or Less

5.8

6.4

6.25

Agree

Strongly Agree

Disagree Slightly

Agree

Neither Agree Nor Disagree

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Neither Agree Nor Disagree

Agree

Agree Slightly

Strongly Agree

Yes

5 or more years

Yes

Male

Married

25-44

$30K-$49.9K

Graduate School

5.2

6.2

4.75

Neither Agree Nor Disagree

Disagree Slightly

Strongly Agree

Agree

Agree Slightly

Strongly Agree

Agree

Neither Agree Nor Disagree

Agree Slightly

Agree

Strongly Agree

Agree Slightly

Strongly Agree

Yes

5 or more years

Female

Married

25-44

$30K-$49.9K

High School or Less

4.6

5.4

6.5

Strongly Disagree

Agree Slightly

Strongly Disagree

Agree Slightly

Strongly Disagree

Agree Slightly

Strongly Disagree

5 or more years

Yes

Female

Married

25-44

$30K-$49.9K

Some College

1.8

Strongly Disagree

Neither Agree Nor Disagree

Strongly Agree

Strongly Disagree

Agree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Strongly Disagree

Disagree Slightly

Strongly Disagree

Neither Agree Nor Disagree

5 or more years

Yes

Female

Married

25-44

$20K - $29.9 K

High School or Less

4.25

2.5

1.75

Agree

Agree Slightly

Agree

Strongly Agree

Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

2 to 5 years

5.8

6.6

6.25

6.5

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Disagree

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Disagree

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

5 or more years

Female

Married

25-44

$30K-$49.9K

College Graduate

4.2

4.25

4.75

Strongly Agree

Agree

Strongly Agree

Agree Slightly

Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree

Yes

2 to 5 years

Female

Married

25-44

$20K - $29.9 K

High School or Less

6.8

6.2

5.75

6.5

Agree

Agree Slightly

Agree

Strongly Agree

Agree

Agree Slightly

Agree

Strongly Agree

Agree Slightly

Agree

Agree Slightly

Strongly Agree

Agree

Yes

5 or more years

Male

Married

25-44

$50K-$64.9

Graduate School

5.8

6.2

5.75

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Female

Married

25-44

$20K - $29.9 K

Some College

6.6

6.8

Agree Slightly

Agree

Disagree Slightly

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Yes

5 or more years

Yes

Male

Married

25-44

$30K-$49.9K

College Graduate

4.8

5.4

5.25

5.75

5.5

Strongly Agree

Yes

2 to 5 years

Male

Married

25-44

$30K-$49.9K

High School or Less

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Neither Agree Nor Disagree

Agree

Strongly Agree

Agree

Agree Slightly

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Yes

5 or more years

Female

Single

< 25

>$65K

Some College

6.4

6.2

5.75

6.75

Neither Agree Nor Disagree

Agree Slightly

Disagree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Disagree

Agree

Agree Slightly

Disagree Slightly

Disagree

Disagree Slightly

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Disagree Slightly

Agree Slightly

Strongly Agree

Agree

Yes

5 or more years

Male

Single

< 25

< $10K

High School or Less

4.2

4.25

Agree

Strongly Agree

Agree

Strongly Agree

Agree Slightly

Strongly Agree

Yes

5 or more years

Female

Married

25-44

$30K-$49.9K

Some College

6.4

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

High School or Less

6.8

6.25

6.75

Strongly Agree

Yes

5 or more years

Yes

Male

Married

25-44

$10K-$19.9 K

High School or Less

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Disagree Slightly

Neither Agree Nor Disagree

Disagree

Disagree Slightly

Strongly Agree

Agree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Agree Slightly

Yes

5 or more years

Yes

Male

Married

25-44

>$65K

Some College

5.2

3.2

3.75

4.75

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Agree Slightly

Male

Divorced

65+

$20K - $29.9 K

Some College

6.4

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Yes

1 to 2 years

Male

Married

25-44

$30K-$49.9K

High School or Less

6.4

6.75

6.25

Strongly Agree

5 or more years

Male

Married

25-44

$30K-$49.9K

Graduate School

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Yes

5 or more years

Female

Divorced

65+

$30K-$49.9K

Some College

4.8

4.5

Strongly Agree

Agree

Strongly Agree

Yes

1 to 2 years

Female

Married

25-44

$30K-$49.9K

Some College

Neither Agree Nor Disagree

Agree

Disagree Slightly

Agree Slightly

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Agree Slightly

Strongly Agree

Neither Agree Nor Disagree

Agree

Strongly Agree

Agree Slightly

Agree

Yes

2 to 5 years

Male

Single

< 25

$20K - $29.9 K

Some College

4.4

5.2

5.25

6.25

5.5

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Yes

5 or more years

Female

Married

25-44

$50K-$64.9

High School or Less

6.4

6.75

6.5

6.75

Agree

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Yes

5 or more years

Male

Married

25-44

$50K-$64.9

Some College

6.4

6.25

6.75

Neither Agree Nor Disagree

Agree Slightly

Disagree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Disagree

Neither Agree Nor Disagree

Agree Slightly

Yes

1 to 2 years

Male

Married

25-44

$30K-$49.9K

Some College

4.2

4.6

4.75

4.5

Strongly Agree

Agree

Agree Slightly

Strongly Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Strongly Agree

Yes

1 to 2 years

Female

Married

25-44

$30K-$49.9K

College Graduate

5.8

Agree Slightly

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Agree Slightly

Agree

Agree Slightly

Agree

Yes

Less than 1 year

Female

Married

25-44

$50K-$64.9

College Graduate

5.4

6.2

4.5

5.25

Strongly Agree

Yes

5 or more years

Female

Married

25-44

$20K - $29.9 K

College Graduate

Strongly Disagree

Disagree

Agree Slightly

Strongly Disagree

Neither Agree Nor Disagree

Disagree

Agree Slightly

Disagree

Strongly Disagree

Neither Agree Nor Disagree

Agree

Disagree

Strongly Disagree

Disagree

Agree Slightly

Agree

Less than 1 year

Yes

Male

Married

25-44

$50K-$64.9

Graduate School

2.6

2.2

1.25

3.5

Neither Agree Nor Disagree

Disagree

Neither Agree Nor Disagree

Strongly Agree

Agree Slightly

Strongly Agree

Neither Agree Nor Disagree

Disagree Slightly

Disagree

Male

Divorced

65+

$30K-$49.9K

Some College

3.8

5.4

2.5

Strongly Agree

Yes

5 or more years

Male

Divorced

65+

< $10K

High School or Less

Strongly Disagree

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Agree

Strongly Disagree

Neither Agree Nor Disagree

Agree

Strongly Agree

Agree

Strongly Agree

Strongly Disagree

Strongly Agree

5 or more years

Yes

Female

Married

25-44

$20K - $29.9 K

Some College

3.2

3.6

3.75

Strongly Agree

Yes

5 or more years

Female

Widowed

45-64

< $10K

High School or Less

Strongly Agree

Yes

5 or more years

Female

Married

25-44

$10K-$19.9 K

High School or Less

Agree Slightly

Agree

Strongly Agree

Agree Slightly

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Agree

Agree Slightly

Neither Agree Nor Disagree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

Some College

5.8

5.25

4.75

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Strongly Agree

Agree Slightly

Strongly Agree

Neither Agree Nor Disagree

Agree

Agree Slightly

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$20K - $29.9 K

High School or Less

4.6

5.8

5.5

5.75

Strongly Agree

Agree Slightly

Strongly Agree

Agree Slightly

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

Some College

5.5

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Agree Slightly

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$10K-$19.9 K

Some College

6.4

6.75

Agree Slightly

Strongly Agree

Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree

Agree Slightly

Strongly Agree

Yes

5 or more years

Yes

Female

Married

25-44

$30K-$49.9K

Some College

6.2

6.75

6.25

Disagree

Disagree Slightly

Disagree

Disagree Slightly

Disagree

Agree Slightly

Disagree Slightly

Agree Slightly

Neither Agree Nor Disagree

Disagree

Neither Agree Nor Disagree

Disagree

5 or more years

Yes

Female

Married

25-44

$30K-$49.9K

High School or Less

2.6

3.2

4.75

2.5

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Strongly Agree

Agree Slightly

Agree

Agree Slightly

Strongly Agree

Agree

Yes

5 or more years

Female

Married

25-44

$30K-$49.9K

High School or Less

5.4

5.2

5.5

5.25

5.75

Agree Slightly

Agree

Disagree Slightly

Agree Slightly

Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree

Yes

5 or more years

Yes

Male

Married

25-44

$20K - $29.9 K

College Graduate

4.8

5.8

6.5

6.25

Neither Agree Nor Disagree

Disagree

Neither Agree Nor Disagree

Agree

Strongly Disagree

Strongly Agree

Disagree

Neither Agree Nor Disagree

Agree

Disagree

Neither Agree Nor Disagree

Disagree

Neither Agree Nor Disagree

Disagree

Strongly Disagree

Neither Agree Nor Disagree

2 to 5 years

Yes

Male

Married

25-44

$30K-$49.9K

Graduate School

3.6

4.2

2.75

Agree

Agree Slightly

Strongly Agree

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree

Strongly Agree

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

High School or Less

5.2

6.5

5.75

Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree Slightly

5 or more years

Yes

Female

Married

25-44

High School or Less

5.25

4.5

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Female

Married

25-44

>$65K

High School or Less

6.4

6.75

6.5

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

College Graduate

6.4

6.75

Strongly Disagree

100

Female

Divorced

65+

$10K-$19.9 K

Neither Agree Nor Disagree

Strongly Agree

Disagree Slightly

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Agree

Disagree

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Agree Slightly

Disagree

Agree Slightly

Neither Agree Nor Disagree

Strongly Agree

Agree

Yes

5 or more years

Yes

Female

Married

25-44

$10K-$19.9 K

College Graduate

4.4

4.75

4.25

5.5

Strongly Agree

Yes

5 or more years

Female

Married

25-44

$30K-$49.9K

High School or Less

Agree

Neither Agree Nor Disagree

Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree Slightly

Yes

1 to 2 years

Male

Married

25-44

$20K - $29.9 K

5.6

4.5

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Female

Single

< 25

$50K-$64.9

Graduate School

6.2

6.5

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Strongly Agree

Agree

Agree Slightly

Agree

Agree Slightly

Yes

5 or more years

Female

Married

25-44

$30K-$49.9K

Some College

5.4

5.6

6.5

5.25

5.6666666667

Strongly Agree

Agree

Agree Slightly

Strongly Agree

Agree Slightly

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree Slightly

Strongly Agree

Agree Slightly

Yes

Less than 1 year

Male

Married

25-44

$50K-$64.9

High School or Less

6.6

6.75

Neither Agree Nor Disagree

Agree

Agree Slightly

Agree

Agree Slightly

Disagree Slightly

Agree Slightly

Female

Widowed

45-64

$10K-$19.9 K

Some College

5.4

5.6

Neither Agree Nor Disagree

Agree

Disagree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Agree Slightly

Agree

Disagree Slightly

Agree

Neither Agree Nor Disagree

Disagree

Strongly Agree

Agree

Disagree Slightly

Strongly Disagree

Agree

Neither Agree Nor Disagree

5 or more years

Yes

Male

Married

25-44

>$65K

Graduate School

4.4

5.25

3.5

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Agree Slightly

Strongly Agree

Yes

5 or more years

Yes

Female

Married

25-44

$30K-$49.9K

College Graduate

6.3333333333

Strongly Agree

Agree

Strongly Agree

Agree Slightly

Neither Agree Nor Disagree

Strongly Agree

Agree

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree

Disagree Slightly

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

College Graduate

6.6

5.8

6.5

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Female

Married

25-44

$20K - $29.9 K

High School or Less

6.4

6.25

Strongly Agree

Yes

2 to 5 years

Male

Married

25-44

$30K-$49.9K

College Graduate

Strongly Agree

Agree Slightly

Strongly Agree

Agree Slightly

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$10K-$19.9 K

High School or Less

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree

Yes

2 to 5 years

Male

Married

25-44

$20K - $29.9 K

Some College

6.2

6.5

Agree Slightly

Strongly Agree

Disagree Slightly

Agree Slightly

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Yes

2 to 5 years

Male

Married

25-44

$20K - $29.9 K

High School or Less

5.2

6.5

6.75

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$10K-$19.9 K

Some College

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Yes

5 or more years

Female

Married

25-44

$30K-$49.9K

Graduate School

5.8

5.75

Agree

Strongly Disagree

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Strongly Disagree

Strongly Agree

Neither Agree Nor Disagree

Disagree Slightly

Strongly Disagree

Strongly Agree

Strongly Disagree

5 or more years

Yes

Female

Married

25-44

$30K-$49.9K

Graduate School

4.6

2.2

5.5

3.5

2.5

Agree

Agree Slightly

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree

Agree Slightly

Agree

Yes

Less than 1 year

Female

Married

25-44

$50K-$64.9

Some College

5.4

4.75

5.75

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Agree

Strongly Agree

Yes

Less than 1 year

Female

Married

25-44

$30K-$49.9K

Some College

5.25

Strongly Agree

Agree

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Yes

Female

Married

25-44

$20K - $29.9 K

High School or Less

6.8

6.75

Strongly Agree

Yes

2 to 5 years

Male

Married

25-44

$20K - $29.9 K

High School or Less

100

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Agree

Agree Slightly

Strongly Agree

Agree

Neither Agree Nor Disagree

Disagree

Agree Slightly

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Yes

5 or more years

Yes

Male

Married

25-44

$50K-$64.9

High School or Less

5.2

5.8

6.5

3.5

101

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree

Agree Slightly

Agree

Strongly Agree

Agree

Disagree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Strongly Agree

Agree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

Some College

5.2

5.6

5.5

102

Agree Slightly

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree

Agree Slightly

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Yes

5 or more years

Female

Married

25-44

$30K-$49.9K

Some College

5.6

5.8

5.25

103

Agree Slightly

Strongly Agree

Agree Slightly

Neither Agree Nor Disagree

Strongly Agree

Agree

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree

Neither Agree Nor Disagree

Agree

Strongly Agree

Yes

5 or more years

Yes

Male

Married

25-44

>$65K

High School or Less

5.6

6.8

104

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Strongly Agree

Agree Slightly

Neither Agree Nor Disagree

Agree

Yes

5 or more years

Yes

Female

Married

25-44

$20K - $29.9 K

High School or Less

4.2

6.2

5.5

105

Neither Agree Nor Disagree

Disagree Slightly

Agree

Neither Agree Nor Disagree

Strongly Agree

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Disagree

Disagree Slightly

Neither Agree Nor Disagree

Disagree

Neither Agree Nor Disagree

Disagree Slightly

Yes

2 to 5 years

Female

Married

25-44

$20K - $29.9 K

College Graduate

4.2

5.2

3.75

2.75

3.5

106

Agree Slightly

Agree

Strongly Agree

Agree

Neither Agree Nor Disagree

Agree

Agree Slightly

Agree

Disagree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Less than 1 year

Female

Married

25-44

$50K-$64.9

Graduate School

5.6

5.2

5.5

107

Strongly Agree

Yes

5 or more years

Female

Married

25-44

$30K-$49.9K

High School or Less

108

Strongly Disagree

Agree Slightly

Disagree Slightly

Strongly Disagree

Agree

Agree Slightly

Strongly Disagree

5 or more years

Yes

Male

Married

25-44

>$65K

Graduate School

1.8

1.4

5.5

109

Strongly Agree

Disagree Slightly

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

College Graduate

110

Disagree Slightly

Agree

Strongly Agree

Disagree Slightly

Strongly Agree

Agree

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Yes

5 or more years

Female

Married

25-44

$30K-$49.9K

Some College

5.2

6.8

4.75

6.25

6.5

111

Agree

Neither Agree Nor Disagree

Agree Slightly

Disagree Slightly

Neither Agree Nor Disagree

Agree

Agree Slightly

Disagree

Disagree Slightly

Agree Slightly

Agree

Agree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Yes

5 or more years

Yes

Female

Married

25-44

$20K - $29.9 K

College Graduate

4.6

5.25

3.25

4.5

112

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Disagree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Agree

Agree Slightly

Yes

5 or more years

Yes

Male

Married

25-44

$20K - $29.9 K

High School or Less

4.6

5.25

4.5

4.75

113

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Yes

5 or more years

Female

Married

25-44

$30K-$49.9K

High School or Less

5.6

5.5

5.25

5.75

114

Agree

Strongly Agree

Agree

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree

Strongly Agree

Yes

5 or more years

Yes

Male

Married

25-44

>$65K

Graduate School

6.2

4.8

5.3333333333

6.3333333333

115

Agree

Strongly Agree

Disagree

Agree

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Yes

Less than 1 year

Male

Married

25-44

$30K-$49.9K

Some College

5.8

6.6

5.75

6.75

116

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Disagree Slightly

Neither Agree Nor Disagree

Agree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

Some College

5.4

4.6

117

Disagree

Strongly Disagree

Neither Agree Nor Disagree

Disagree

Neither Agree Nor Disagree

Agree Slightly

Strongly Disagree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Neither Agree Nor Disagree

Disagree

Agree Slightly

Disagree Slightly

5 or more years

Yes

Male

Married

25-44

>$65K

College Graduate

2.2

3.8

5.5

3.5

118

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Agree

Agree Slightly

Agree

Yes

5 or more years

Male

Married

25-44

$50K-$64.9

College Graduate

4.6

4.8

4.5

4.75

5.5

119

Strongly Agree

Disagree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Yes

2 to 5 years

Male

Married

25-44

$10K-$19.9 K

College Graduate

5.25

6.6666666667

6.25

120

Agree Slightly

Agree

Agree Slightly

Agree

Disagree Slightly

Strongly Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

High School or Less

5.2

5.5

5.25

121

Agree

Neither Agree Nor Disagree

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Yes

5 or more years

Yes

Male

Married

25-44

$30K-$49.9K

High School or Less

5.4

5.6

5.5

5.25

122

Strongly Agree

Agree Slightly

Strongly Agree

Yes

2 to 5 years

Male

Married

25-44

High School or Less

123

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Yes

Less than 1 year

Male

Married

25-44

$30K-$49.9K

Some College

6.6

6.25

124

Agree Slightly

Strongly Agree

Agree Slightly

Strongly Agree

Agree

5.4

6.4

125

Strongly Agree

Agree

Strongly Agree

Yes

Less than 1 year

Female

Divorced

65+

$10K-$19.9 K

College Graduate

6.8

126

Agree Slightly

Agree

Strongly Agree

Neither Agree Nor Disagree

Agree

Strongly Agree

Yes

Less than 1 year

Male

Married

25-44

$20K - $29.9 K

High School or Less

5.4

5.75

6.75

127

Strongly Agree

Agree

Strongly Agree

Agree Slightly

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree

Yes

Less than 1 year

Female

Married

25-44

$30K-$49.9K

Some College

6.4

5.5

6.75

128

Strongly Agree

Yes

5 or more years

Male

Divorced

65+

$10K-$19.9 K

Some College

129

Strongly Agree

Yes

5 or more years

Female

Married

25-44

$20K - $29.9 K

130

Strongly Agree

Yes

5 or more years

Female

Widowed

45-64

< $10K

High School or Less

131

Strongly Agree

Neither Agree Nor Disagree

Agree

Agree Slightly

Agree

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$20K - $29.9 K

High School or Less

4.75

6.5

132

Disagree Slightly

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Disagree Slightly

Agree Slightly

Disagree Slightly

Agree Slightly

Disagree

Agree

Yes

5 or more years

Yes

Female

Widowed

45-64

$20K - $29.9 K

High School or Less

4.2

5.4

6.5

3.5

4.5

133

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Female

Married

25-44

$30K-$49.9K

High School or Less

6.5

6.75

134

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

5 or more years

Yes

Female

Married

25-44

>$65K

Some College

4.4

4.8

5.5

4.75

4.25

135

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Yes

5 or more years

Female

Married

25-44

$30K-$49.9K

High School or Less

5.8

6.5

136

Agree

Agree Slightly

Neither Agree Nor Disagree

Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Strongly Agree

Agree Slightly

Strongly Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree Slightly

Agree

Yes

5 or more years

Female

Married

25-44

>$65K

Graduate School

4.2

4.4

6.5

5.5

5.25

137

Neither Agree Nor Disagree

Agree

Agree Slightly

Agree

Strongly Agree

Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree

Strongly Agree

Yes

Less than 1 year

Yes

Male

Married

25-44

$10K-$19.9 K

High School or Less

5.6

5.8

5.75

5.5

6.75

138

Agree

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

1 to 2 years

Female

Married

25-44

$30K-$49.9K

High School or Less

6.6

6.75

139

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Yes

1 to 2 years

Male

Married

25-44

$30K-$49.9K

High School or Less

6.2

6.8

6.5

6.75

140

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Agree Slightly

Yes

5 or more years

Yes

Female

Married

25-44

$30K-$49.9K

Some College

4.6

5.4

141

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Strongly Disagree

Neither Agree Nor Disagree

Agree Slightly

Agree

Yes

5 or more years

Yes

Male

Married

25-44

$50K-$64.9

Some College

5.4

5.25

142

Agree

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Yes

5 or more years

Male

Married

25-44

$20K - $29.9 K

College Graduate

6.2

6.5

6.25

143

Neither Agree Nor Disagree

Agree

Strongly Agree

Disagree

Strongly Agree

Yes

5 or more years

Female

Married

25-44

$50K-$64.9

High School or Less

5.6

4.5

144

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

High School or Less

6.2

6.6

145

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Agree

Strongly Agree

Agree

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree

Agree Slightly

Yes

2 to 5 years

Female

Divorced

65+

< $10K

Some College

4.6

6.2

6.5

6.25

5.75

146

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree Slightly

Agree

Strongly Agree

Agree

Agree Slightly

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

Some College

5.2

5.8

5.25

6.25

147

Neither Agree Nor Disagree

Disagree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Disagree

Disagree Slightly

Male

Married

25-44

$30K-$49.9K

Graduate School

3.5

3.2

148

Disagree

Neither Agree Nor Disagree

Strongly Agree

Disagree Slightly

Strongly Disagree

Neither Agree Nor Disagree

Strongly Disagree

Agree Slightly

Strongly Disagree

Strongly Agree

Agree Slightly

Yes

5 or more years

Yes

Female

Single

< 25

$20K - $29.9 K

High School or Less

5.4

1.6666666667

3.3333333333

6.5

149

Agree Slightly

Neither Agree Nor Disagree

Yes

5 or more years

Female

Divorced

65+

$30K-$49.9K

College Graduate

4.2

150

Agree

Agree Slightly

Agree

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Agree Slightly

Agree

Strongly Agree

Yes

5 or more years

Yes

Female

Married

25-44

$30K-$49.9K

College Graduate

5.8

6.2

6.5

151

Agree

Agree Slightly

Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree Slightly

Neither Agree Nor Disagree

Agree

Agree Slightly

Agree

Agree Slightly

Strongly Agree

Agree Slightly

Yes

Less than 1 year

Yes

Male

Married

25-44

>$65K

College Graduate

5.6

6.25

4.75

5.25

5.5

152

Agree Slightly

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Yes

5 or more years

Female

Married

25-44

>$65K

Some College

6.8

6.5

6.75

153

Neither Agree Nor Disagree

Strongly Disagree

Neither Agree Nor Disagree

Disagree

Strongly Disagree

Disagree Slightly

Strongly Disagree

Disagree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Strongly Disagree

Disagree

Neither Agree Nor Disagree

Disagree

Disagree Slightly

Agree Slightly

Neither Agree Nor Disagree

5 or more years

Yes

Male

Married

25-44

$50K-$64.9

Graduate School

4.25

2.75

3.5

154

Disagree Slightly

Strongly Disagree

Agree Slightly

Disagree

Disagree Slightly

Disagree

Agree Slightly

Disagree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Disagree

Neither Agree Nor Disagree

Disagree

Strongly Disagree

Neither Agree Nor Disagree

Disagree

1 to 2 years

Yes

Male

Married

25-44

>$65K

Graduate School

1.8

2.6

4.25

2.75

2.25

155

Agree

Strongly Agree

Agree Slightly

Strongly Agree

Yes

5 or more years

Yes

Male

Married

25-44

$50K-$64.9

High School or Less

6.4

156

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Yes

5 or more years

Female

Married

25-44

$50K-$64.9

High School or Less

5.75

5.5

157

Neither Agree Nor Disagree

Strongly Disagree

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Agree

Strongly Agree

Yes

Less than 1 year

Yes

Male

Married

25-44

>$65K

Graduate School

3.4

4.6

158

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$20K - $29.9 K

High School or Less

159

Agree Slightly

Neither Agree Nor Disagree

Agree

Disagree Slightly

Strongly Disagree

Neither Agree Nor Disagree

Strongly Disagree

Neither Agree Nor Disagree

Agree Slightly

Strongly Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Strongly Agree

Agree

Yes

Less than 1 year

Male

Single

< 25

$30K-$49.9K

College Graduate

4.8

2.8

5.5

5.25

160

Strongly Agree

Agree Slightly

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree

Yes

2 to 5 years

Female

Divorced

65+

$30K-$49.9K

Some College

6.5

5.6666666667

6.5

6.25

161

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree Slightly

Strongly Agree

Agree

Agree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Strongly Agree

Agree Slightly

Strongly Agree

Yes

5 or more years

Yes

Male

Married

25-44

$50K-$64.9

Some College

6.4

4.75

6.5

162

Yes

Less than 1 year

163

Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree

Agree Slightly

Yes

5 or more years

Yes

Male

Married

25-44

$30K-$49.9K

High School or Less

5.8

5.6

5.75

164

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Strongly Disagree

Strongly Agree

Neither Agree Nor Disagree

Strongly Disagree

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

High School or Less

6.6

4.75

6.25

6.75

165

Strongly Agree

Agree

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Yes

5 or more years

Female

Married

25-44

$50K-$64.9

Some College

6.2

5.2

5.5

4.5

166

Neither Agree Nor Disagree

Strongly Disagree

Neither Agree Nor Disagree

Strongly Disagree

Neither Agree Nor Disagree

Strongly Disagree

Neither Agree Nor Disagree

Less than 1 year

Yes

Male

Married

25-44

$50K-$64.9

Some College

3.4

1.6

167

Strongly Agree

Agree Slightly

Agree

Agree Slightly

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$50K-$64.9

High School or Less

5.25

168

Agree

Strongly Agree

Agree

Strongly Agree

Neither Agree Nor Disagree

Agree

Strongly Agree

Yes

Less than 1 year

Female

Married

25-44

$50K-$64.9

Some College

6.5

6.6

5.6666666667

6.75

169

Disagree

Neither Agree Nor Disagree

Disagree

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Neither Agree Nor Disagree

Agree

Agree Slightly

Disagree Slightly

Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree

5 or more years

Female

Married

25-44

>$65K

Graduate School

2.8

3.8

4.75

3.75

170

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Yes

2 to 5 years

Female

Married

25-44

>$65K

High School or Less

5.4

5.6

5.5

171

Strongly Disagree

Neither Agree Nor Disagree

Disagree

Strongly Disagree

Disagree

Neither Agree Nor Disagree

Agree Slightly

Strongly Agree

Neither Agree Nor Disagree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree Slightly

Disagree

Neither Agree Nor Disagree

Disagree Slightly

Neither Agree Nor Disagree

Agree Slightly

Disagree

Yes

Less than 1 year

Yes

Male

Married

25-44

>$65K

High School or Less

6.25

3.5

172

Disagree Slightly

Neither Agree Nor Disagree

Disagree

Disagree Slightly

Neither Agree Nor Disagree

Agree Slightly

Disagree Slightly

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Yes

2 to 5 years

Female

Married

25-44

$30K-$49.9K

Some College

3.2

4.2

5.25

4.6666666667

173

Strongly Agree

Agree

Neither Agree Nor Disagree

Strongly Agree

Agree Slightly

Strongly Agree

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Strongly Agree

Agree Slightly

Disagree Slightly

Agree Slightly

Agree

Agree Slightly

Yes

2 to 5 years

Male

Single

< 25

$20K - $29.9 K

College Graduate

5.8

4.25

4.75

174

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Yes

5 or more years

Male

Divorced

65+

$30K-$49.9K

High School or Less

4.4

4.75

4.5

175

Agree Slightly

Strongly Agree

Agree

Agree Slightly

Strongly Agree

Agree Slightly

Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree Slightly

Male

Married

25-44

$30K-$49.9K

High School or Less

5.6

5.8

4.5

176

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Agree

Agree Slightly

Agree

Yes

5 or more years

Female

Married

25-44

$20K - $29.9 K

High School or Less

5.2

4.75

5.75

177

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Female

Widowed

45-64

$10K-$19.9 K

High School or Less

6.4

6.6

6.5

178

Agree

Agree Slightly

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Agree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

High School or Less

5.2

4.8

4.5

5.25

179

Agree

Strongly Agree

Neither Agree Nor Disagree

Agree Slightly

Strongly Agree

Agree Slightly

Strongly Agree

Agree Slightly

Neither Agree Nor Disagree

Yes

5 or more years

Yes

6.8

5.6

4.5

180

Agree

Strongly Agree

Neither Agree Nor Disagree

Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree

Agree Slightly

Agree

Strongly Agree

Agree

Agree Slightly

Agree

Yes

5 or more years

Yes

Female

Married

25-44

>$65K

College Graduate

5.6

5.2

4.75

5.75

181

Disagree

Disagree Slightly

Neither Agree Nor Disagree

Agree

Strongly Agree

Agree

Agree Slightly

Agree

Agree Slightly

Disagree

Neither Agree Nor Disagree

Disagree

Strongly Agree

Agree

5 or more years

Yes

Female

Married

25-44

High School or Less

4.2

5.8

4.25

182

Agree

Strongly Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Yes

5 or more years

Female

Single

< 25

College Graduate

5.6

5.25

4.25

4.75

183

Strongly Agree

Agree Slightly

Neither Agree Nor Disagree

Strongly Disagree

Agree Slightly

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree Slightly

Neither Agree Nor Disagree

Strongly Agree

Agree

Strongly Agree

Yes

Less than 1 year

Female

Single

< 25

$10K-$19.9 K

Some College

4.4

184

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Disagree Slightly

Agree

Strongly Agree

Disagree Slightly

Agree

Disagree Slightly

Strongly Agree

Agree

Agree Slightly

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Yes

Male

Married

25-44

>$65K

Graduate School

4.6

5.8

4.75

6.75

185

Agree Slightly

Disagree Slightly

Neither Agree Nor Disagree

Agree

Agree Slightly

Disagree Slightly

Agree

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree

Disagree

5 or more years

Male

Married

25-44

$30K-$49.9K

College Graduate

4.2

4.25

186

Strongly Disagree

Disagree

Strongly Disagree

Disagree

Strongly Disagree

Disagree

Yes

5 or more years

Male

Married

25-44

$20K - $29.9 K

High School or Less

1.4

1.25

187

Disagree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Disagree

Neither Agree Nor Disagree

Disagree Slightly

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Agree

Agree Slightly

Yes

5 or more years

Male

Married

25-44

$50K-$64.9

Graduate School

3.4

2.8

4.5

4.75

5.25

188

Agree Slightly

Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Strongly Agree

Agree

Agree Slightly

Agree

Strongly Agree

Agree

Yes

5 or more years

Yes

Female

Single

< 25

$20K - $29.9 K

College Graduate

5.2

5.8

5.5

6.25

189

Agree

Neither Agree Nor Disagree

Disagree

Neither Agree Nor Disagree

Strongly Disagree

Neither Agree Nor Disagree

Strongly Disagree

Disagree

Agree

Strongly Disagree

Disagree Slightly

Disagree

Strongly Disagree

Disagree Slightly

Neither Agree Nor Disagree

Yes

5 or more years

Female

Married

25-44

$50K-$64.9

Some College

4.4

2.4

3.5

2.75

2.5

190

Neither Agree Nor Disagree

Agree

Strongly Agree

Agree Slightly

Strongly Agree

Disagree Slightly

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Yes

5 or more years

Female

Widowed

45-64

$20K - $29.9 K

Some College

5.8

5.6

6.5

6.25

191

Disagree

Disagree Slightly

Strongly Disagree

Disagree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Strongly Agree

Agree

Disagree Slightly

Disagree

Neither Agree Nor Disagree

Strongly Disagree

Agree

Disagree

5 or more years

Female

Married

25-44

$50K-$64.9

High School or Less

3.2

6.25

2.25

3.25

192

Disagree

Neither Agree Nor Disagree

Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Strongly Agree

Agree Slightly

Disagree Slightly

Agree Slightly

Agree

Disagree Slightly

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Strongly Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Yes

5 or more years

Yes

Female

Married

25-44

$20K - $29.9 K

College Graduate

3.4

5.4

4.75

4.25

5.5

193

Disagree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Neither Agree Nor Disagree

Agree Slightly

Disagree Slightly

Disagree

Agree Slightly

Neither Agree Nor Disagree

Strongly Disagree

Disagree Slightly

Neither Agree Nor Disagree

5 or more years

Yes

Female

Single

< 25

Some College

3.4

4.5

3.5

194

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

College Graduate

195

Agree Slightly

Disagree

Agree

Strongly Agree

Agree

Strongly Agree

Neither Agree Nor Disagree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Yes

Less than 1 year

Male

Married

25-44

>$65K

Graduate School

4.8

6.25

6.5

196

Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Yes

Less than 1 year

Female

Divorced

65+

$30K-$49.9K

College Graduate

5.8

6.25

6.75

197

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Yes

5 or more years

Yes

Male

Married

25-44

$20K - $29.9 K

College Graduate

4.8

4.5

198

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Yes

5 or more years

Female

Married

25-44

$30K-$49.9K

High School or Less

5.8

5.25

199

Agree

Strongly Agree

Agree

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Yes

5 or more years

Female

Divorced

65+

$30K-$49.9K

Some College

6.8

5.75

6.75

200

Agree

Strongly Agree

Agree

Neither Agree Nor Disagree

Agree

Agree Slightly

Agree

Strongly Agree

Agree

Agree Slightly

Agree

Strongly Agree

Agree

Yes

Less than 1 year

Male

Divorced

65+

$30K-$49.9K

High School or Less

6.2

5.4

6.5

5.75

6.25

201

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Female

Single

< 25

< $10K

High School or Less

6.4

6.75

202

Agree

Agree Slightly

Agree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

High School or Less

203

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Male

Married

25-44

College Graduate

6.6

6.5

204

Strongly Agree

Agree Slightly

Agree

Agree Slightly

Agree

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Yes

5 or more years

Yes

Male

Married

25-44

$20K - $29.9 K

High School or Less

6.6

5.75

6.75

6.5

205

Agree

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Neither Agree Nor Disagree

Agree

Strongly Agree

Agree Slightly

Agree

Agree Slightly

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Yes

5 or more years

Male

Divorced

65+

$30K-$49.9K

Some College

5.8

5.5

6.75

6.25

206

Strongly Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree Slightly

Agree

Agree Slightly

Agree

Yes

5 or more years

Female

Married

25-44

$30K-$49.9K

Some College

5.8

5.75

207

Disagree Slightly

Neither Agree Nor Disagree

Agree

Disagree Slightly

Agree

Neither Agree Nor Disagree

Agree Slightly

Agree

Agree Slightly

Yes

5 or more years

Male

Married

25-44

$50K-$64.9

Graduate School

4.2

5.4

5.25

208

Strongly Agree

Neither Agree Nor Disagree

Agree Slightly

Agree

Strongly Agree

Agree Slightly

Agree

Yes

5 or more years

Female

Married

25-44

$50K-$64.9

College Graduate

5.8

5.5

6.5

209

Strongly Agree

Yes

5 or more years

Female

Widowed

45-64

< $10K

High School or Less

210

Agree

Strongly Agree

Agree Slightly

Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Yes

1 to 2 years

Male

Married

25-44

$30K-$49.9K

High School or Less

5.8

5.6

5.75

211

Agree Slightly

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Male

Divorced

65+

$10K-$19.9 K

High School or Less

5.6

6.25

6.75

212

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Disagree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Agree Slightly

Disagree Slightly

Disagree

Disagree Slightly

Agree Slightly

Disagree Slightly

5 or more years

Female

Married

25-44

$20K - $29.9 K

College Graduate

4.2

3.4

3.75

3.5

213

Disagree

Neither Agree Nor Disagree

Strongly Disagree

Disagree

Neither Agree Nor Disagree

Strongly Disagree

Disagree

Strongly Disagree

Disagree

Neither Agree Nor Disagree

Strongly Disagree

Disagree

Neither Agree Nor Disagree

Disagree

Neither Agree Nor Disagree

Disagree

5 or more years

Yes

Male

Married

25-44

>$65K

College Graduate

2.5

214

Agree

Strongly Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Neither Agree Nor Disagree

Agree

Agree Slightly

Strongly Agree

Agree Slightly

Agree

Agree Slightly

Yes

Less than 1 year

Yes

Female

Married

25-44

$20K - $29.9 K

Some College

5.6

6.2

5.5

5.75

5.25

215

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Strongly Agree

Yes

5 or more years

Male

Married

25-44

>$65K

Some College

5.6

5.25

6.5

216

Agree Slightly

Disagree Slightly

Agree Slightly

Agree

Disagree

Neither Agree Nor Disagree

Disagree

Disagree Slightly

Neither Agree Nor Disagree

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Yes

5 or more years

Yes

Male

Married

25-44

$30K-$49.9K

High School or Less

4.8

2.8

4.75

4.25

217

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Yes

5 or more years

Female

Married

25-44

High School or Less

6.4

218

Agree

Strongly Agree

Agree

Agree Slightly

Agree

Disagree Slightly

Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

High School or Less

6.2

5.75

6.75

6.3333333333

219

Agree Slightly

Agree

Agree Slightly

Strongly Agree

Female

Divorced

65+

$20K - $29.9 K

Some College

5.8

220

Agree

Strongly Agree

Agree

Strongly Agree

Agree Slightly

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Agree

Strongly Agree

Yes

1 to 2 years

Female

Married

25-44

$30K-$49.9K

College Graduate

6.6

6.25

6.5

221

Strongly Agree

Yes

5 or more years

Female

Widowed

45-64

$20K - $29.9 K

Graduate School

222

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Yes

Less than 1 year

Male

Married

25-44

$30K-$49.9K

Some College

6.2

6.75

6.5

223

Strongly Disagree

Neither Agree Nor Disagree

Strongly Disagree

Disagree Slightly

Neither Agree Nor Disagree

Strongly Disagree

5 or more years

Yes

>$65K

1.6

3.5

224

Neither Agree Nor Disagree

Agree Slightly

Disagree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Strongly Disagree

Strongly Agree

Neither Agree Nor Disagree

Strongly Disagree

Agree

Agree Slightly

Agree

Strongly Agree

Agree

Agree Slightly

Yes

5 or more years

Male

Married

25-44

>$65K

Graduate School

3.75

3.2

5.5

4.5

225

Neither Agree Nor Disagree

Agree

Agree Slightly

Strongly Agree

Neither Agree Nor Disagree

Strongly Disagree

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Disagree Slightly

Strongly Disagree

Disagree

Strongly Disagree

Neither Agree Nor Disagree

Strongly Agree

Less than 1 year

Yes

Female

Divorced

65+

$20K - $29.9 K

Some College

4.4

4.8

4.75

1.75

5.5

226

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

Graduate School

6.6

6.5

227

Strongly Agree

Agree Slightly

Strongly Agree

Agree Slightly

Strongly Agree

Agree Slightly

Strongly Agree

Yes

Less than 1 year

Female

Single

< 25

$50K-$64.9

Some College

6.6

6.5

228

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Strongly Agree

Agree

Yes

5 or more years

5.4

5.75

6.25

229

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Yes

5 or more years

Female

Married

25-44

$50K-$64.9

Some College

5.5

230

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Agree

Yes

5 or more years

Yes

Male

Married

25-44

$50K-$64.9

College Graduate

4.6

5.25

231

Strongly Agree

Agree

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Male

$50K-$64.9

High School or Less

6.4

6.8

232

Agree

Agree Slightly

Agree

Strongly Agree

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Yes

5 or more years

Female

Married

25-44

$30K-$49.9K

Some College

5.4

6.4

5.75

233

Strongly Agree

Agree

Agree Slightly

Agree

Strongly Disagree

Neither Agree Nor Disagree

Agree Slightly

Agree

Agree Slightly

Agree

Yes

5 or more years

Female

Married

25-44

$20K - $29.9 K

Graduate School

6.2

5.6

5.5

234

Strongly Agree

Agree

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

Graduate School

6.6

6.5

6.25

235

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Yes

2 to 5 years

Female

Married

25-44

$30K-$49.9K

Some College

6.4

5.75

236

Strongly Agree

Yes

5 or more years

Yes

Male

Married

25-44

$30K-$49.9K

High School or Less

237

Disagree Slightly

Agree Slightly

Disagree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Agree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Agree Slightly

Neither Agree Nor Disagree

Yes

2 to 5 years

Male

Married

25-44

$30K-$49.9K

Graduate School

3.4

3.5

3.75

238

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Male

Widowed

45-64

$20K - $29.9 K

Some College

6.8

6.5

239

Strongly Disagree

Neither Agree Nor Disagree

Disagree Slightly

Neither Agree Nor Disagree

Agree Slightly

Strongly Agree

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Disagree

Strongly Disagree

Disagree Slightly

Disagree

Agree

Yes

5 or more years

Yes

Female

Divorced

65+

>$65K

Some College

3.2

5.25

2.75

240

Agree Slightly

Strongly Agree

Disagree Slightly

Strongly Agree

Agree Slightly

Strongly Agree

Yes

2 to 5 years

Female

Married

25-44

>$65K

College Graduate

5.6666666667

6.3333333333

241

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Agree Slightly

Agree

Yes

1 to 2 years

Female

Married

25-44

$20K - $29.9 K

Some College

5.25

4.5

242

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Yes

2 to 5 years

Yes

Male

Married

25-44

$20K - $29.9 K

High School or Less

5.2

4.4

5.5

5.75

243

Agree

Female

Married

25-44

$30K-$49.9K

College Graduate

244

Neither Agree Nor Disagree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$50K-$64.9

High School or Less

5.8

6.25

6.75

245

Strongly Agree

Agree

Strongly Agree

Agree Slightly

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Yes

5 or more years

Male

Single

< 25

$20K - $29.9 K

Some College

6.6

5.5

246

Strongly Agree

Disagree Slightly

Strongly Agree

Yes

Less than 1 year

Male

Married

25-44

$50K-$64.9

College Graduate

247

Disagree Slightly

Disagree

Neither Agree Nor Disagree

Agree

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Agree

Strongly Agree

Neither Agree Nor Disagree

Agree Slightly

Disagree

Neither Agree Nor Disagree

Yes

5 or more years

Yes

Female

Married

25-44

>$65K

High School or Less

2.8

5.4

6.75

4.5

3.75

248

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Agree

Strongly Agree

6.4

6.5

249

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Disagree Slightly

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Female

Married

25-44

$30K-$49.9K

Some College

6.6

5.6

6.75

250

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

High School or Less

6.6

6.8

251

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Neither Agree Nor Disagree

Agree Slightly

Agree

Agree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Neither Agree Nor Disagree

5 or more years

Yes

Female

Widowed

45-64

High School or Less

4.4

5.25

3.25

3.5

252

Agree

Strongly Agree

Agree

Agree Slightly

Strongly Agree

Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Yes

5 or more years

Male

Divorced

65+

>$65K

Graduate School

6.2

6.25

6.75

253

Agree

Strongly Agree

Agree

Neither Agree Nor Disagree

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$10K-$19.9 K

High School or Less

6.6

5.5

6.75

254

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Female

Divorced

65+

< $10K

High School or Less

6.75

255

Strongly Agree

Yes

5 or more years

Female

Widowed

45-64

$30K-$49.9K

High School or Less

256

Strongly Disagree

Disagree

Strongly Disagree

Disagree Slightly

Disagree

Strongly Disagree

Strongly Agree

Neither Agree Nor Disagree

Strongly Disagree

Disagree

Strongly Disagree

Disagree

Strongly Disagree

5 or more years

Yes

Male

Married

25-44

$30K-$49.9K

Some College

1.6

5.5

1.5

257

Strongly Agree

Agree Slightly

Strongly Agree

Yes

5 or more years

Female

Married

25-44

$20K - $29.9 K

High School or Less

6.5

258

Strongly Agree

Yes

Less than 1 year

Male

Married

25-44

>$65K

High School or Less

259

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Yes

5 or more years

Male

Married

25-44

$30K-$49.9K

Some College

5.6

5.25

5.5

260

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree

Disagree Slightly

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Strongly Disagree

Neither Agree Nor Disagree

Disagree

Less than 1 year

Yes

Female

Single

< 25

$10K-$19.9 K

College Graduate

4.8

4.4

4.25

2.75

261

Strongly Disagree

Disagree Slightly

Strongly Disagree

Disagree Slightly

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Strongly Disagree

Neither Agree Nor Disagree

Strongly Disagree

Neither Agree Nor Disagree

Agree

Strongly Disagree

5 or more years

Yes

Male

Married

25-44

$20K - $29.9 K

High School or Less

4.75

2.5

262

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree Slightly

Strongly Agree

Neither Agree Nor Disagree

Agree Slightly

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Agree Slightly

Agree

Strongly Agree

Agree

Strongly Agree

Agree Slightly

Strongly Agree

Yes

5 or more years

Female

Single

< 25

$30K-$49.9K

Some College

5.6

6.25

6.5

263

Strongly Agree

Neither Agree Nor Disagree

Agree

Strongly Agree

Yes

5 or more years

Female

Divorced

65+

$20K - $29.9 K

Some College

5.5

264

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

5 or more years

Female

Married

25-44

$30K-$49.9K

High School or Less

6.4

6.75

265

Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Yes

5 or more years

Yes

Male

Married

25-44

$20K - $29.9 K

College Graduate

5.4

4.5

4.75

266

Strongly Agree

Agree

Strongly Agree

Male

Married

25-44

$50K-$64.9

College Graduate

6.6

267

Agree Slightly

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree

Strongly Agree

Yes

5 or more years

Male

Married

25-44

$50K-$64.9

Some College

5.6

5.2

5.5

6.75

268

Strongly Disagree

Disagree

Strongly Disagree

Agree Slightly

Strongly Disagree

Agree Slightly

Strongly Disagree

Yes

Male

Married

25-44

$20K - $29.9 K

Graduate School

1.2

269

Disagree

Disagree Slightly

Disagree

Disagree Slightly

Agree Slightly

Agree

Strongly Disagree

Agree

Agree Slightly

Agree

Strongly Agree

Disagree

Disagree Slightly

Neither Agree Nor Disagree

Strongly Disagree

Disagree Slightly

Agree

Disagree Slightly

5 or more years

Yes

Male

Married

25-44

High School or Less

4.75

2.5

4.5

270

Strongly Agree

Agree Slightly

Strongly Agree

Yes

5 or more years

Yes

Male

Married

25-44

$30K-$49.9K

Some College

6.6

271

Agree

Agree Slightly

Disagree Slightly

Agree

Disagree Slightly

Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Agree

Agree Slightly

Agree

Yes

5 or more years

Yes

Female

Married

25-44

$30K-$49.9K

College Graduate

4.6

5.8

4.25

5.25

5.75

272

Agree Slightly

Agree

Strongly Agree

Disagree Slightly

Agree

Neither Agree Nor Disagree

Agree

Strongly Agree

Agree

Yes

5 or more years

Male

Married

25-44

$50K-$64.9

Graduate School

5.75

5.5

6.25

273

Neither Agree Nor Disagree

Disagree Slightly

Strongly Agree

Agree Slightly

Strongly Disagree

Agree

Disagree Slightly

Strongly Disagree

Disagree Slightly

Strongly Disagree

Strongly Agree

Neither Agree Nor Disagree

Disagree Slightly

Neither Agree Nor Disagree

Strongly Disagree

Neither Agree Nor Disagree

Disagree Slightly

Neither Agree Nor Disagree

Agree Slightly

Yes

Less than 1 year

Male

Single

< 25

$10K-$19.9 K

High School or Less

4.8

2.4

274

Disagree Slightly

Neither Agree Nor Disagree

Strongly Disagree

Disagree

Strongly Disagree

Agree Slightly

Disagree

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Strongly Agree

Agree

Neither Agree Nor Disagree

Strongly Disagree

Disagree

Agree

5 or more years

Female

Married

25-44

$30K-$49.9K

Some College

2.2

4.4

5.75

3.25

3.75

275

Agree

Agree Slightly

Agree

Agree Slightly

Agree

Neither Agree Nor Disagree

Agree Slightly

Disagree Slightly

Agree

Neither Agree Nor Disagree

Disagree Slightly

Neither Agree Nor Disagree

Agree

Agree Slightly

Agree

Strongly Agree

Yes

1 to 2 years

Male

Single

< 25

$20K - $29.9 K

High School or Less

5.4

4.8

3.75

5.75

6.25

276

Disagree

Disagree Slightly

Disagree

Disagree Slightly

Agree Slightly

Agree

Strongly Disagree

Agree

Agree Slightly

Agree

Female

Married

25-44

High School or Less

4.75

5.5

277

Disagree

Agree Slightly

Strongly Agree

Strongly Disagree

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Strongly Disagree

Strongly Agree

Neither Agree Nor Disagree

Disagree Slightly

Strongly Agree

Neither Agree Nor Disagree

Disagree

Strongly Agree

Neither Agree Nor Disagree

Yes

Less than 1 year

Female

Married

25-44

$30K-$49.9K

Some College

3.75

4.75

4.5

4.25

278

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree

Yes

5 or more years

Female

Married

25-44

$20K - $29.9 K

High School or Less

6.6

6.8

6.25

279

Disagree Slightly

Agree

Agree Slightly

Neither Agree Nor Disagree

Agree Slightly

Agree

Agree Slightly

Agree

5 or more years

Yes

Female

Married

25-44

$30K-$49.9K

Some College

3.6

5.2

5.5

280

Strongly Agree

Agree Slightly

Strongly Agree

Agree Slightly

Agree

Strongly Agree

Agree Slightly

Strongly Agree

Agree

Strongly Agree

Yes

1 to 2 years

Female

Married

25-44

>$65K

College Graduate

5.8

6.25

281

Agree

Strongly Agree

Neither Agree Nor Disagree

Strongly Agree

Agree Slightly

Yes

2 to 5 years

Male

Married

25-44

$30K-$49.9K

College Graduate

5.5

6.5

282

Strongly Agree

Agree

Neither Agree Nor Disagree

Agree

Neither Agree Nor Disagree

Strongly Agree

Agree

Yes

5 or more years

Male

Married

25-44

$20K - $29.9 K

Some College

6.2

4.5

6.25

283

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Agree

Strongly Agree

Yes

Less than 1 year

Male

Married

25-44

$30K-$49.9K

Graduate School

6.2

6.5

6.75

284

Neither Agree Nor Disagree

Disagree

Disagree Slightly

Agree Slightly

Neither Agree Nor Disagree

Strongly Disagree

Neither Agree Nor Disagree

Strongly Agree

Agree

Agree Slightly

Neither Agree Nor Disagree

Disagree Slightly

Neither Agree Nor Disagree

Agree Slightly

Disagree Slightly

1 to 2 years

Yes

Male

Married

25-44

>$65K

Graduate School

3.4

3.8

5.25

4.25

3.75

285

Agree

Agree Slightly

Agree

Agree Slightly

Strongly Agree

Agree Slightly

Agree

Agree Slightly

Strongly Agree

Agree Slightly

Strongly Agree

Yes

5 or more years

Female

Married

25-44

$20K - $29.9 K

High School or Less

5.2

5.5

5.75

6.5

Practice1

oq:resolve	oq:not resolve
5	1
5	9
9	6
5	1
5	3
9	3
10	1
5	2
9	5
8	6
8	1
3	3
9	7
2	6
	3
1	2
10	5	t-Test: Two-Sample Assuming Unequal Variances
8	5
7	8		oq:resolve	oq:not resolve
8	4	Mean	6.5238095238	4
8	2	Variance	5.231126597	6.4137931034
8	1	Observations	42	30
6	5	Hypothesized Mean Difference	0
8	5	df	59
9	1	t Stat	4.3388786524
3	6	P(T<=t) one-tail	0.0000284285
10	1	t Critical one-tail	1.6710930321
5	4	P(T<=t) two-tail	0.0000568569
8	10	t Critical two-tail	2.0009953781
8	4
5		conclusion:	p-value < alpha (0.05), so reject null. The average overall quality rating among respondents whose problems had been resolved is significantly higher than the average oq rating of those not resolved;
9
5
6
7
5
7
4
5
3
7
7
5

Practice question: Among respondents who ever encountered problems (prob=“Yes”), do those whose problems were resolved (variable “resolve”) have higher (or lower) overall service quality rating (oq) compared to those problems not resolved? Steps: 1. in "national" work sheet, use Data->Filter, select prob="Yes", select resolve="Yes", and copy and paste the remaining oq values as "oq:resolve" here 2. go back to "national" work sheet, select resolve="No", and copy and paste the remaining oq values as "oq:not resolve" here 3. run independent samples t-test (Data->Data Analysis -> t-test two-sample assuming unequal variances)

Practice2

prob	Yes
	Column Labels
Values	No	Yes	Grand Total
Average of reliavrg	3.4616666667	4.6930232558	4.1869863014
Average of empavrg	3.5372222222	5.0639534884	4.4365296804
Average of tangavrg	4.8563218391	5.4325396825	5.1971830986
Average of respavrg	2.9375	4.9476744186	4.1549295775
Average of assuravg	3.4375	5.1240310078	4.4589201878

Practice question: how to generate a bar chart that contrasts the average ratings along five service dimensions for resolve versus nonresolve? Steps: Steps: 1. Pivot table -> add "prob" to FILTERS, "resolve" to COLUMNS, the five service rating variables to VALUES. 2. Change count to average for each of the variable in VALUES 3. In the constructed pivot table, select "Yes" in "prob" and unselect "Blank" in Column Labels 4. Select any cell of the pivot table, click insert -> Insert Column or Bar Chart

No Average of reliavrg Average of empavrg Average of tangavrg Average of respavrg Average of assuravg 3.4616666666666664 3.5372222222222218 4.8563218390804588 2.9375 3.4375 Yes Average of reliavrg Average of empavrg Average of tangavrg Average of respavrg Average of assuravg 4.6930232558139533 5.0639534883720927 5.4325396825396828 4.9476744186046515 5.1240310077519382

Practice3

	Column Labels
Values	Female	Male	Grand Total
Average of resimp	23.452991453	21.9846153846	22.6801619433
Average of asrimp	20.0598290598	19.5	19.7651821862
Average of empimp	16.8034188034	18.2538461538	17.5668016194
Average of respavrg	5.56	5.7077294686	5.6375158428
Average of assuravg	5.7433333333	5.824940048	5.7863005051

Question: how to generate a bar chart that contrasts the average ratings along five service dimensions for female versus male? Steps: 1. Pivot table -> add "sex" to COLUMNS, the five service rating variables to VALUES. 2. Change count to average for each of the variable in VALUES 3. In the constructed pivot table, unselect "Blank" in Column Labels 4. Select any cell of the pivot table, click insert -> Insert Column or Bar Chart

Female Average of resimp Average of asrimp Average of empimp Average of respavrg Average of assuravg 23.452991452991451 20.05982905982906 16.803418803418804 5.56 5.7433333333333332 Male Average of resimp Average of asrimp Average of empimp Average of respavrg Average of assuravg 21.984615384615385 19.5 18.253846153846155 5.7077294685990347 5.82494004796163

Descriptive

reliavrg		empavrg		tangavrg		respavrg		assuravg
Mean	5.404181601	Mean	5.5240806643	Mean	5.6352657005	Mean	5.6041666667	Mean	5.7503097893
Standard Error	0.0885488818	Standard Error	0.0859034568	Standard Error	0.0654036119	Standard Error	0.0949979938	Standard Error	0.0874700322
Median	5.8	Median	5.8	Median	5.75	Median	6	Median	6.25
Mode	7	Mode	7	Mode	7	Mode	7	Mode	7
Standard Deviation	1.4790579256	Standard Deviation	1.4400043386	Standard Deviation	1.0865664064	Standard Deviation	1.5551841841	Standard Deviation	1.434615195
Sample Variance	2.1876123474	Sample Variance	2.0736124951	Sample Variance	1.1806265554	Sample Variance	2.4185978464	Sample Variance	2.0581207577
Kurtosis	0.9902307006	Kurtosis	0.846095809	Kurtosis	2.2852139874	Kurtosis	0.8904520876	Kurtosis	1.4755444623
Skewness	-1.1724703879	Skewness	-1.1556442874	Skewness	-1.1181943432	Skewness	-1.2590741819	Skewness	-1.4100420418
Range	6	Range	6	Range	6	Range	6	Range	6
Minimum	1	Minimum	1	Minimum	1	Minimum	1	Minimum	1
Maximum	7	Maximum	7	Maximum	7	Maximum	7	Maximum	7
Sum	1507.7666666667	Sum	1552.2666666667	Sum	1555.3333333333	Sum	1501.9166666667	Sum	1546.8333333333
Count	279	Count	281	Count	276	Count	268	Count	269

Histogram1

Row Labels	Count of inc
< $10K	12
$10K-$19.9 K	20
$20K - $29.9 K	59
$30K-$49.9K	106
$50K-$64.9	38
>$65K	32
Grand Total	267

Total < $10K $10K-$19.9 K $20K - $29.9 K $30K-$49.9K $50K-$64.9 > $65K 12 20 59 106 38 32

Frequency distribution / histogram for categorical data 1. Insert -> PivotTable 2. Put "inc" in both ROWS and VALUES, make sure to use count of "inc" in the VALUE field 3. Unselect "blank" in Row Labels in the pivot table, and move category "< $10K" to the top 4. Select a cell in the pivot table, insert -> PivotChart -> Column

Histogram2

oq	bin
10	1	<=1
1	2	(1,2]
10	3	(2,3]
10	4	(3,4]
	5	…
5	6
9	7		bin	Frequency
9	8		1	8
5	9		2	5
8	10	(9,10]	3	7
8			4	4
9			5	24
			6	14
9			7	24
5			8	47
			9	62
6			10	73
5			More	0
9
10
10
10
9
5
10
10
8
8
9
9
1
3
8
6
8
8
10
7
10
10
7
10
9
10
8
10
6
9
7
9
9
6
9
8
10
3
10
1
10
10
7
8
10
10
8
3
7
9
2
8
5
10
10
6
10
7
9
7
7
2
10
10
10
10
9
8
10
9
1
10
10
10
10
6
9
7
8
8
5
7
10
1
8
8
7
8
9
8
9
8
3
8
9
7
8
10
9
10
10
10
10
10
10
9
6
10
7
8
8
9
9
9
6
8
9
10
9
9
8
3
6
9
7
10
2
3
10
9
5
10
6
9
8
8
10
8
5
10
10
5
9
5
5
7
8
9
10
8
8
8
5
6
10
9
5
9
7
9
8
9
2
5
4
10
9
9
6
8
9
9
10
8
9
8
9
8
7
8
10
8
8
5
2
7
9
5
10
8
9
10
9
1
5
5
10
10
9
9
7
10
8
9
10
10
10
5
10
4
7
9
9
9
10
10
10
5
10
9
5
9
8
10
10
1
10
8
9
6
3
9
10
10
7
9
1
4
10
7
9
7
5
7
6
8
5
10
9
9
9
4
8

Histogram: Overall Quality Rating (oq)

Frequency 1 2 3 4 5 6 7 8 9 10 More 8 5 7 4 24 14 24 47 62 73 0

bin

Frequency

Frequency Distribution and Histogram for metric data 1. copy variable of insterest (oq) into one column 2. type the bin numbers in ascending order (look for natural intervals in the data) 3. (Analysis ToolPak required) Data -> Data Analysis -> Histogram, click OK 4. fill out Input and Output options as shown below

Chisquare Goodness of Fit

Construct Pivot Table then construct expected frequencies

Row Labels

Count of use

Observed

Percentage

Expected

1 to 2 years

0.09

24.39

=$I$9*J4

Note: press function key f4 to get the $

2 to 5 years

0.18

48.78

=$I$9*J5

5 or more years

193

5 or more years

193

5 or more years

0.65

176.15

=$I$9*J6

Less than 1 year

0.08

21.68

=$I$9*J7

(blank)

Grand Total

271

Sample Size

=SUM(H4:H7)

271

P-value

=CHITEST(H4:H7,L4:L7)

0.0000187666

Conclusion

Since p-value<0.05, reject null; Sample distribution significantly differs from the proposed distribution. Too many 5+ years and <1 year

Chisq-Association

Count of ID

Column Labels

Row Labels

Female

Male

Grand Total

177

Yes

Observed

Expected

Grand Total

124

130

254

Row Labels

Female

Male

Grand Total

Female

Male

Female

Male

177

86.4094488189

90.5905511811

=I$10*$K8/$K$10

=J$10*$K8/$K$10

Yes

37.5905511811

39.4094488189

Yes

=I$10*$K9/$K$10

=J$10*$K9/$K$10

Grand Total

124

130

254

P-value

0.3267841382

=CHITEST(I8:J9,O8:P9)

Conclusion

Since p-value>0.05, do not reject null; we do not find significant association between gender and prob

percent cross-tab

Female

Male

Female

Male

0.7258064516

0.6692307692

=I8/I$10

=J8/J$10

Yes

0.2741935484

0.3307692308

Yes

=I9/I$10

=J9/J$10

Steps: 1. construct observed cross-tab of "sex" and "prob" using pivot table (use count of "ID" in value area) 2. construct expected cross-tab

One Sample T-test

reliavrg
7
1	Sample mean	=AVERAGE(B2:B286)	5.404181601
6	Sample standard deviation	=STDEV(B2:B286)	1.4790579256
6.6	Sample size	=COUNT(B2:B286)	279
6.2	Standard error	=G4/SQRT(G5)	0.0885488818
5.2
6.2	test value in null hypothesis		4
6.4	t-stat	=(G3-G8)/G6	15.8576999749
4	p-value	=TDIST(G9,G5-1,2)	8.87499243860438E-41
6
5	conclusion	Since p-value < 0.05, reject null. Average reliability rating is significantly different from 4; in particular, it is higher than 4 (since the sample mean 5.4 > 4)
5.6
6.4
4
7
4.8
4.8
6
6.8
6.2
7
5.4
4.2
6
7
6
5.8
5.2
4.6
1
1
5.8
4.2
6.8
5.8
6.6
4.8
7
6.4
4.2
6.4
7
7
5.2
6
6.4
7
4.8
7
4.4
6.4
6.4
4.2
7
5.4
7
2.6
3.8
7
3.2
7
7
5.8
4.6
7
7
6
2.6
5.4
4.8
3.6
6
5.25
7
6.4
1
4.4
7
5.6
6.2
5.4
6
5.4
4
6
6.6
6.4
7
7
7
5.2
7
5.8
4.6
6
7
7
7
5.2
5.2
5.6
5.6
4.2
4.2
5.6
7
1.8
7
5.2
4.6
4.6
6
6.2
5.8
5.4
2.2
4.6
7
5.2
5.4
6
5.4
7
5.4
6.4
7
7
7
4.2
7
4.4
5.8
4.2
5.6
6
6.2
4.6
5.4
6.2
5.6
6.2
4.6
5.2
3.5
5.4
4.2
5.8
5.6
6
3
1.8
6.4
6
3.4
7
4.8
7
5
5.8
6.6
6.2
3.4
7
6.5
2.8
5.4
2
3.2
5.8
6
5.6
5.2
6.4
5.2
6.8
5.6
4.2
6
4.4
4.6
4.2
1
3.4
5.2
4.4
5.8
2
3.4
3.4
7
4.8
5.8
5
6
6.8
6.2
7
6
7
6
6
5.8
4.2
7
7
5.8
5.6
4.2
2
5.6
6
4.8
6.4
6.2
5.8
6.6
7
6.2
1
3.75
4.4
6.6
7
6
6
4.6
6.4
5.4
6.2
7
7
7
3.4
7
1
5.6666666667
4
5.2
6
5.8
6.6
2.8
6.4
6.6
6.6
4.4
6.2
6
7
7
1.6
7
5.6
4.8
2
6
7
6.4
5.4
6.6
5.6
1.2
3
7
4.6
5.75
4.8
2.2
5.4
3
3.75
6.6
3.6
5.8
6
7
6.2
3.4
6

Independent Samples T-test

oq: female	oq:male
10	10
5	10
9	9
5	8
	8
6	9
5
10	9
10	5
5	9
10	10
8	9
9	10
1	8
3	9
6	8
8	7
10	10
10	7
10	9
6	10
9	8	t-Test: Two-Sample Assuming Unequal Variances
9
9			oq: female	oq:male
8	10	Mean	7.8253968254	7.8686131387
10	7	Variance	5.3132698413	5.0855517389
1	9	Observations	126	137
10	6	Hypothesized Mean Difference	0
10	3	df	258
8		t Stat	-0.1534756694
3	10	P(T<=t) one-tail	0.4390715742
7	7	t Critical one-tail	1.6507811022
5	8	P(T<=t) two-tail	0.8781431483
10	10	t Critical two-tail	1.9692013862
	10
6	9	Conclusion:	p=0.878>0.05, do not reject null; males and females do not have significantly different perceptions on the overall service quality.
10	2
9	8
7	10
	7
	7
10	2
9	10
1	10
10	10
10	9
10	8
7	10
8	10
5	6
7	9
10	8
8	1
7	8
9	8
10	8
10	9
10	8
10	3
6	8
10	9
7	7
8	8
8	10
9	9
6	10
10	10
9	9
3	9
6	9
9	8
10	9
9	9
9	8
8
10	7
5	2
9	3
5	10
9	5
10	10
8	6
5	8
6	8
10	10
9	5
8	10
9	5
2	7
5	8
4
9	8
8	9
9	5
10	9
8	7
8	10
10	9
5	6
7	9
10	8
	9
9	8
10	9
5	7
10	8
9	8
8	2
9	9
10	5
4	8
7	9
9	5
9	10
5	7
10	10
5	10
10	10
10	5
10	10
6	9
9	10
10	10
10	10
7	9
5	9
	8
6	1
8	8
5	9
10	3
8	7
	9
	1
	4
	10
	9
	7
	7
	9
	9
	9
	4

Steps: 1. in "national" work sheet, use Data -> filter -> select "female" for variable "sex" 2. copy the "op" ratings by all females and paste under "oq:female" 3. go to "national" work sheet, select "male" for variable "sex" 4. copy the op ratings by all males and paste under "oq:male" 5. (Requires "Analysis ToolPak” add-in) Data -> Data Analysis -> t-Test: Two-Sample Assuming Unequal Variances 6. Specify input and output options as shown

Paired Sample T-test

reliavrg	empavrg
7	7
1	1.4
6	6.2
6.6	6.8
6.2	5.8
5.2	4.6
6.2	6.2
6.4	5.6
4	4.4
6	5
5	5.2
5.6	4.4
6.4	6.8
4	4.2
7	3.5
4.8	3.8
4.8	3.2
6	5.8
6.8	7
6.2	6.4
7	6.4
5.4	6.6
4.2	4.6
6	6.8
7	7	t-Test: Paired Two Sample for Means
6	6
5.8	6.4		reliavrg	empavrg
5.2	6.2	Mean	5.404181601	5.5135005974
4.6	5.4	Variance	2.1876123474	2.0727467345
1	1.8	Observations	279	279
1	4	Pearson Correlation	0.7995783169
5.8	6.6	Hypothesized Mean Difference	0
4.2	4	df	278
6.8	6.2	t Stat	-1.9746384346
5.8	6.2	P(T<=t) one-tail	0.0246493161
6.6	6.8	t Critical one-tail	1.6503532332
4.8	5.4	P(T<=t) two-tail	0.0492986321
7	7	t Critical two-tail	1.9685339746
6.4	6.2
4.2	4
6.4	7	Conclusion:	p=0.049<0.05, reject null hypothesis; on average, customers' satisfaction on reliability and empathy are different; empathy is significantly higher than reliability (5.51>5.4)
7	6.8
7	7
5.2	3.2
6	6.4
6.4	6.4
7	7
4.8	4.8
7	7
4.4	5.2
6.4	7
6.4	6
4.2	4.6
7	5.8
5.4	6.2
7	7
2.6	2.2
3.8	5.4
7	7
3.2	3.6
7	7
7	7
5.8	5.25
4.6	5.8
7	7
7	6.4
6	6.2
2.6	3.2
5.4	5.2
4.8	5.8
3.6	4.2
6	5.2
5.25	4.5
7	6.4
6.4	7
1	1
4.4	4
7	7
5.6	5
6.2	7
5.4	5.6
6	6.6
5.4	5.6
4	4.4
6	7
6.6	5.8
6.4	7
7	7
7	7
7	6.2
5.2	7
7	7
5.8	5.8
4.6	2.2
6	5.4
7	7
7	6.8
7	7
5.2	5.8
5.2	5.6
5.6	5.8
5.6	6.8
4.2	6.2
4.2	5.2
5.6	5.2
7	7
1.8	1.4
7	7
5.2	6.8
4.6	4
4.6	4
6	5.6
6.2	4.8
5.8	6.6
5.4	4.6
2.2	3.8
4.6	4.8
7	5.25
5.2	5.2
5.4	5.6
6	6.6
5.4	6.4
7	6.8
5.4	7
6.4	7
7	7
7	7
7	7
4.2	5.4
7	7
4.4	4.8
5.8	6
4.2	4.4
5.6	5.8
6	6.6
6.2	6.8
4.6	5.4
5.4	5.4
6.2	6
5.6	7
6.2	6.6
4.6	6.2
5.2	5.8
3.5	3.2
5.4	1.6666666667
4.2	4
5.8	6.2
5.6	6.25
6	6.8
3	2
1.8	2.6
6.4	7
6	6
3.4	4.6
7	7
4.8	2.8
7	6.5
5	6.4
5.8	5.6
6.6	4
6.2	5.2
3.4	1.6
7	7
6.5	6.6
2.8	3.8
5.4	5.6
2	5
3.2	4.2
5.8	6
6	4.4
5.6	5.8
5.2	5.2
6.4	6.6
5.2	4.8
6.8	5.6
5.6	5.2
4.2	5.8
6	5.6
4.4	6
4.6	5.8
4.2	4.2
1	1.4
3.4	2.8
5.2	5.8
4.4	2.4
5.8	5.6
2	3.2
3.4	5.4
3.4	3.4
7	7
4.8	6
5.8	7
5	4.8
6	5.8
6.8	6.8
6.2	5.4
7	6.4
6	6
7	6.6
6	6.6
6	5.8
5.8	5
4.2	5.4
7	5.8
7	7
5.8	5.6
5.6	6
4.2	3.4
2	2
5.6	6.2
6	5.6
4.8	2.8
6.4	6.4
6.2	5
5.8	7
6.6	6.6
7	7
6.2	6.2
1	1.6
3.75	3.2
4.4	4.8
6.6	7
7	6.6
6	5.4
6	6
4.6	4.6
6.4	6.8
5.4	6.4
6.2	5.6
7	6.6
7	6.4
7	7
3.4	3.4
7	6.8
1	3.2
5.6666666667	6
4	5.25
5.2	4.4
6	6
5.8	7
6.6	6.6
2.8	5.4
6.4	7
6.6	5.6
6.6	6.8
4.4	4
6.2	6.2
6	6.6
7	6
7	7
1.6	1.6
7	7
5.6	5.6
4.8	4.4
2	4.75
6	5.6
7	7
6.4	7
5.4	5
6.6	7
5.6	5.2
1.2	1
3	4.75
7	6.6
4.6	5.8
5.75	5.5
4.8	2.4
2.2	4.4
5.4	4.8
3	4.75
3.75	4.75
6.6	6.8
3.6	5.2
5.8	7
6	7
7	6.2
6.2	7
3.4	3.8
6	5.2

Steps: 1. copy columns (variable of interest, reliavrg and empavrg) 2. remove rows with empty cells (select relevant columns, Home->Find & Select->Go To Special->Blanks->OK, carefully right click on one of the blank cells -> Delete -> Entire row) 3. repeat step 2 to make sure all empty cells have been removed 4. (requires "Analysis ToolPak” add-in) Data -> Data Analysis -> t-Test: Paired Two Sample for Means 5. Specify input and output options as shown