Excel Data Analysis

BUSN 7257X Global Communication: Automobile Survey Prof. Myles Bassell

Automotive Questionnaire

Informed Consent

Purpose: This questionnaire is for academic purposes and is part of a study regarding attitudes

and opinions regarding automobiles.

Methodology: You are asked to complete the questionnaire below regarding your attitudes and

opinions regarding automobiles and brands of automobiles.

Types of Questions: You are asked to answer several survey questions about automobiles and

we ask for some demographic information, such as gender, age, and education, so that we can

accurately describe the group of people who participate in the study. The survey will take less

than 15 minutes to complete.

Risks: No risks or discomforts are anticipated from taking part in this study. If you feel

uncomfortable with a question, you can skip that question or withdraw from the study altogether.

If you decide to quit at any time before you have finished the questionnaire, your answers will

NOT be recorded.

Participation: This questionnaire is for academic purposes. Your participation is voluntary,

and the extent of your participation is the completion of this survey. Your name will not be

shared.

If you have concerns or questions about this study please contact Professor Myles Bassell at

[email protected]

Consent

1) Indicate your willingness to complete the survey and your understanding of the informed

consent above which discusses the purpose, methodology, types of questions, risks, and

participation by checking either Willing or Not Willing.

(1) Willing: I agree to participate in this study by answering the survey questions.

(2) Not Willing: I do NOT agree participate in this study and will NOT answer the survey

questions.

BUSN 7257X Global Communication: Automobile Survey Prof. Myles Bassell

Automobiles: Last 4 weeks:

Select a value from 0 to 10. Zero (0) means you Never. Ten (10) means Very Often.

How often do you… 0

Never 1 2 3 4 5 6 7 8 9

10

Very

Often

2 drive your car?

3 wash your car?

4 change the oil in your car?

5 change the tires on your car?

6 change the wiper blades on your

car?

7 add air to your tires?

8 put gasoline in your car?

9 add a fuel cleaner to your gas

tank?

10 drive your car to work?

11 drive your car on short trips?

12 drive your car on long trips?

13 drive your car to pick up your

kids?

14 drive your car to the grocery

store?

15 visit the websites for cars?

BUSN 7257X Global Communication: Automobile Survey Prof. Myles Bassell

How satisfied are you with your car?

1

Not Very

Satisfied

2 3 4 5 6 7 8 9

10

Very

Satisfied

16

How important are the following factors in determining your level satisfaction with your car?

Factor

1

Not Very

Important

2 3 4 5 6 7 8 9

10

Very

Important

17 Mileage

18 Quality

19 Price

20 Level of emissions

21 Safety

22 Color

23 Accessories

24 Service

25 Brand

BUSN 7257X Global Communication: Automobile Survey Prof. Myles Bassell

Indicate the extent to which you agree… this brand of car is a high quality.

Brand

1

Strongly

Disagree

2 3 4 5 6 7 8 9

10

Strongly

Agree

26 Toyota

27 Renault

28 Nissan

29 Mitsubishi

Automobiles: Last 4 weeks:

Select a value from 0 to 5. Zero (0) means you Never. Five (5) means Very Often.

How often do you…

Never

0

Not Very

Often

1

Not

Often

2

Sometimes

3

Often

4

Very

Often

5

30 visit the Toyota website?

31 visit the Renault website?

32 visit the Nissan website?

33 visit the Mitsubishi website?

34 think about buying a new car?

35 think about the price of gasoline?

36 think about the fuel efficiency of

your car?

37 think about the level of carbon

emission of your car?

38 get your tires rotated?

39 Change the transmission fluid?

BUSN 7257X Global Communication: Automobile Survey Prof. Myles Bassell

How often during the last 4 weeks did you think about these topics?

Select a value from 0 to 10. Zero (0) means you Never. Ten (10) means Very Often.

0

Never 1 2 3 4 5 6 7 8 9

10

Very

Often

40 Discrimination

41 Bias

42 Stereotypes

43 Black Lives Matter

44 Islamophobia

45 Anti-Semitism

46 Gay Rights

47 Prejudics

48 How often do you drive a car?

(0) I do not drive a car

(1) Annually

(2 ) Quarterly

(3) Monthly

(4) Weekly

(5) Daily

Automobiles: Indicate the extent to which you agree with the following statements.

BUSN 7257X Global Communication: Automobile Survey Prof. Myles Bassell

If you were buying a car

what factors would be

important?

Not

Applicable

0

Strongly

Disagree

1

Disagree

2

Undecided

3

Agree

4

Strongly

Agree

5

49 the brand is important.

50 the miles per gallon is

important.

51 the warranty is important.

52 the reviews are important.

43 the price is important.

54 the level of carbon

emissions is important.

55) What is your sex?

(1) Male

(2) Female

56) Age: How old are you? Enter the number. For example, 37

___

57) Place of Birth: Were you born in the United States?

(1) Yes

(2) No

BUSN 7257X Global Communication: Automobile Survey Prof. Myles Bassell

58) Marital Status: Please indicate your current marital status

(1) Single (never married)

(2) Divorced

(3) Widowed

(4) Married

59) Employment Status: Please indicate your current employment status.

(1) Employed full-time

(2) Employed part-time

(3) Retired

(4) Not currently employed

Thank You!