Assignment 2 @ AUGUST 7th

I have Uploaded instructions.

I have uploaded Excel file.

I have Uploaded the question that need to be answered.

This assignment will give you some basic practice analyzing an Excel datafile.  The file contains a set of data collected from the students taking BA 301 in multiple classroom sections (for example, Section 1, Section 2, etc. in Column B of the spreadsheet) in a single term.  Assume that the goal of the survey was to better understand the demographic characteristics of the students in BA 301, and to analyze the differences in the various sections.  Load the attached Excel file and answer the questions listed below. 

Use Excel to answer the following questions from the results of the BA 301 demographic Survey.

2

>BA_

3 0 1

_Spring_

20

1

6

_Survey

1 3

3 1

agement

2 3

3 1

Portland city/urban area, not on campus

Man

3 6

Junior 3 1 20

Portland city/urban area, not on campus Car Woman

3 23

Junior 4 1

Portland city/urban area, not on campus

Man

5 3

Toyota Junior 4 1

0

Finance

Walk Woman

6 3 23 Volvo Junior 4 1 15 Finance Portland city/urban area, not on campus Bike Man

3

None Junior 4 1 50

On campus Walk Woman

3 19

4 1 50 Marketing

Car Woman

9 3

Sophomore 1 1 20 Finance West suburbs (Beaverton, Hillsboro, etc.) Car Man

10 3 25 None Sophomore 4 1 50

West suburbs (Beaverton, Hillsboro, etc.) Car Woman

3

Ford Senior 3 1 50

TriMet (bus or Max) Woman

3 20

Sophomore 4 1

0

Human Resources

TriMet (bus or Max) Woman

3 26

Senior 3 1 20 Accounting

Car Woman

3

Senior 4 2

Marketing Portland city/urban area, not on campus Walk Woman

15 3

Junior 3 1 20 Accounting West suburbs (Beaverton, Hillsboro, etc.) Car Woman

3 23 None Junior 4 1 15 Accounting Portland city/urban area, not on campus TriMet (bus or Max) Woman

3 23

Senior 4 1 10 Accounting

Car Woman

6

Junior 3 1 50 Human Resources On campus Walk Woman

19 3

Toyota Sophomore 3 1 10 Accounting Portland city/urban area, not on campus Car Man

20 6 19

Sophomore 4 1

Accounting On campus Car Woman

6

None Junior 3 0 30 Marketing Portland city/urban area, not on campus Car Woman

6 19 Honda Junior 4 1 30 Human Resources South suburbs (Lake Oswego, West Linn, etc.) Car Woman

23 3 23 None Junior 3 1 0 Marketing Portland city/urban area, not on campus Walk Man
24 3 18 None Sophomore 4 1

Finance On campus Walk Woman

25 6 20 Toyota Junior 4 1 200 Accounting West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Woman
26 6 25 None Senior 3 1 30 Marketing Portland city/urban area, not on campus TriMet (bus or Max) Woman

6 24 Mazda Junior 4 1 20 Management West suburbs (Beaverton, Hillsboro, etc.) Car Man

3 23 Subaru Senior 4 1 20 Accounting Portland city/urban area, not on campus TriMet (bus or Max) Woman

29 3 25

Junior 4 1 2 Finance West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Man

30 3 20 Ford Sophomore 4 0 20 Management Other Car Woman
31 6 21 None Senior 4 1 50 Accounting Portland city/urban area, not on campus TriMet (bus or Max) Woman

6 21 None Senior 4 1 50 Accounting Portland city/urban area, not on campus TriMet (bus or Max) Woman

6

None Senior 3 1 30 Finance On campus Walk Woman

3 25 Hyundai Junior 4 1

Accounting South suburbs (Lake Oswego, West Linn, etc.) Car Woman

3 20 None Sophomore 4 1 30 Accounting Portland city/urban area, not on campus Walk Woman

36 3 20 Volkswagen Junior 3 1 20 Marketing On campus Walk Woman
37 3 20 None Sophomore 4 1 40 Accounting Portland city/urban area, not on campus Walk Woman

6

Honda

3 0 5 Accounting Other Car Woman

3 19 None Junior 4 1 100 Supply & Logistics On campus Walk Woman

40 6 20 None Junior 3 1 50 Supply & Logistics Other TriMet (bus or Max) Man

6

Junior 3 1

Finance Portland city/urban area, not on campus TriMet (bus or Max) Woman

42 3 21 None Senior 3 1 70 Management Portland city/urban area, not on campus TriMet (bus or Max) Woman

6 22 None Junior 3 1

Marketing On campus Walk Woman

6 24 None Senior 3 1 10 Marketing On campus Walk Woman

6 44 Toyota Senior 1 3 10 Marketing On campus Walk Woman

46 3 24

Junior 4 0 20 Management South suburbs (Lake Oswego, West Linn, etc.) Car Woman

3 24 Honda Senior 3 1 10

West suburbs (Beaverton, Hillsboro, etc.) Car Woman

48 3 28 Volvo Junior 4 1 200 Marketing East suburbs (Gresham, Milwaukie, etc.) Car Woman

3 24 None Post-Bac 3 1 10 Accounting On campus TriMet (bus or Max) Man

50 3 46

Senior 4 1 10 Supply & Logistics South suburbs (Lake Oswego, West Linn, etc.) Car Man

3 24

Junior 3 2 5 Human Resources On campus Walk Man

6 21 Volkswagen Junior 4 1 50 Management Portland city/urban area, not on campus Walk Woman

3 26 Toyota Senior 3 2 30 Supply & Logistics Portland city/urban area, not on campus TriMet (bus or Max) Man

54 3 20

Junior 3 1 20 Accounting East suburbs (Gresham, Milwaukie, etc.) TriMet (bus or Max) Woman

6 21 Honda Junior 4 0 20 Advertising Portland city/urban area, not on campus Car Woman

3 26 Toyota Senior 3 2 30 Supply & Logistics Portland city/urban area, not on campus TriMet (bus or Max) Man

3 38 Toyota Post-Bac 3 1 25 Supply & Logistics East suburbs (Gresham, Milwaukie, etc.) Car Man

3 38 Toyota Post-Bac 3 1 20 Supply & Logistics East suburbs (Gresham, Milwaukie, etc.) Car Man

6 19 Ford Junior 4 2

Marketing On campus Walk Woman

3 38 Toyota Post-Bac 3 1 20 Supply & Logistics East suburbs (Gresham, Milwaukie, etc.) Car Man

6 20 Nissan Sophomore 4 1

Marketing East suburbs (Gresham, Milwaukie, etc.) Car Man

6 20 None Junior 3 1 10 Advertising Portland city/urban area, not on campus TriMet (bus or Max) Woman

3 23 None Junior 3 1 20 Accounting On campus Walk Woman

3 23 Kia Junior 3 1 100 Marketing Portland city/urban area, not on campus Car Woman

65 6 23 None Senior 4 1 10 Finance Portland city/urban area, not on campus Walk Woman

3 25 Kia Junior 3 1 50 Marketing West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Woman

3 21

Junior 3 1 18 Marketing Vancouver area Car Woman

6 21 Honda Junior 3 1 40 Human Resources Portland city/urban area, not on campus TriMet (bus or Max) Woman

3 24 Lexus Junior 3 2 5 Human Resources On campus Walk Man

70 3 19 Nissan Junior 4 1 25 Management Portland city/urban area, not on campus Bike Man

3 22 None Junior 3 1 50 Marketing South suburbs (Lake Oswego, West Linn, etc.) TriMet (bus or Max) Woman

72 6 25 None Senior 3 1 40 Marketing Portland city/urban area, not on campus TriMet (bus or Max) Woman

6 24 Mercedes Junior 4 1 20 Management West suburbs (Beaverton, Hillsboro, etc.) Car Man

6 19 None Sophomore 4 1 60 Accounting South suburbs (Lake Oswego, West Linn, etc.) TriMet (bus or Max) Woman

75 6 27 Volkswagen Junior 3 1 100 Marketing West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Man

6 21 Mazda Junior 3 1 150 Human Resources West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Woman

3 27 Pontiac Junior 3 1 20 Accounting East suburbs (Gresham, Milwaukie, etc.) TriMet (bus or Max) Woman

3 28 Toyota Junior 4 1 10 Marketing Portland city/urban area, not on campus Bike Man

3 28 Toyota Junior 4 1 10 Marketing Portland city/urban area, not on campus Bike Man

6 25 None Senior 4 1 25 Finance Portland city/urban area, not on campus TriMet (bus or Max) Woman

6 19 None Sophomore 6 1 50 Accounting West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Woman

6 22 Subaru Sophomore 3 2 100 Accounting Portland city/urban area, not on campus Bike Woman

3 22 None Sophomore 3 1 100 Finance Portland city/urban area, not on campus Walk Woman

3 46 Dodge Senior 3 1 20 Supply & Logistics South suburbs (Lake Oswego, West Linn, etc.) Car

3 29 Mazda Senior 3 1 20 Management Portland city/urban area, not on campus TriMet (bus or Max) Man

3 24 Jeep Senior 4 0 25 Management South suburbs (Lake Oswego, West Linn, etc.) Car Woman

6 45 Nissan Junior 3 1 100 Accounting On campus Other Woman

6 21 None Junior 4 2 10 Accounting Portland city/urban area, not on campus TriMet (bus or Max) Woman

6 21 None Junior 4 2 10 Accounting Portland city/urban area, not on campus TriMet (bus or Max) Woman

3 23 Lexus Sophomore 4 1 5 Accounting On campus Walk Man

2 23 Lexus Sophomore 4 1 5 Accounting On campus Walk Man

6 24 BMW Senior 3 1 20 Marketing West suburbs (Beaverton, Hillsboro, etc.) Car Woman

6 21

Junior 3 1 25 Accounting Portland city/urban area, not on campus Walk Man

6 20 Nissan Sophomore 4 1 75 Marketing East suburbs (Gresham, Milwaukie, etc.) Car Man

2 21 Ford Junior 3 1 40 Marketing East suburbs (Gresham, Milwaukie, etc.) TriMet (bus or Max) Woman

6 22 None Senior 4 1 2 Accounting Portland city/urban area, not on campus Walk Woman

6 52 None Senior 4 1 2 Accounting Portland city/urban area, not on campus Walk Woman

6 22 None Senior 4 1 2 Accounting Portland city/urban area, not on campus Walk Woman

3 28 Honda Senior 3 1 15 Finance Vancouver area TriMet (bus or Max) Man

100 6 21 Volkswagen Junior 3 0 200 Marketing Portland city/urban area, not on campus TriMet (bus or Max) Woman

6 22 None Senior 4 1 2 Accounting Portland city/urban area, not on campus Walk Woman

3 23 None Junior 3 1 0 Marketing Portland city/urban area, not on campus Walk Man

6 20 Jeep Sophomore 3 1 20 Marketing Portland city/urban area, not on campus Walk Man

6 19 Toyota Sophomore 4 1 25 Marketing On campus Walk Woman

6 55 None Senior 4 1 20 Finance Portland city/urban area, not on campus TriMet (bus or Max) Woman

6 19 Toyota Sophomore 2 0 30 Management On campus Walk Woman

3 22

Senior 3 1 40 Management Portland city/urban area, not on campus TriMet (bus or Max) Man

6 40 Honda Junior 3 1 200 Accounting East suburbs (Gresham, Milwaukie, etc.) Car Woman

3 29

Senior 3 1

Accounting On campus Walk Man

3 22 Subaru Junior 3 0 20 Human Resources Portland city/urban area, not on campus TriMet (bus or Max) Woman

6 20 None Junior 4 0 20 Accounting West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Man

6 25 None Senior 4 1 20 Finance Portland city/urban area, not on campus TriMet (bus or Max) Man

6 22 Volkswagen Senior 4 0 20 Marketing West suburbs (Beaverton, Hillsboro, etc.) Car Woman

6 46 Honda Post-Bac 3 0 5 Accounting Other Car Woman

2 21 Honda Junior 3 1 20 Accounting Portland city/urban area, not on campus TriMet (bus or Max) Woman

6 32 Toyota Senior 3 1 75 Marketing On campus Walk Woman

3 28 Honda Junior 3 1 15 Accounting West suburbs (Beaverton, Hillsboro, etc.) Car Man

6 43 Chevrolet Senior 1 1 20 Management Portland city/urban area, not on campus TriMet (bus or Max) Man

6 25 None Senior 4 1 20 Finance Portland city/urban area, not on campus TriMet (bus or Max) Woman

6 35 None Senior 3 1 40 Accounting Portland city/urban area, not on campus Walk Woman

6 23

Junior 3 1 20 Marketing West suburbs (Beaverton, Hillsboro, etc.) Car Man

3 31 Volkswagen Junior 3 1 30 Marketing On campus Walk Woman

3 21 Mazda Junior 4 1 200 Management West suburbs (Beaverton, Hillsboro, etc.) Car Man

3 28 Nissan Junior 4 1 100 Finance Portland city/urban area, not on campus Car Woman

6 22 Toyota Senior 3 1 25 Marketing Portland city/urban area, not on campus Walk Woman

3 24 Volkswagen Junior 4 2 30 Finance Portland city/urban area, not on campus Car Man

3 28 Jeep Junior 3 1 50 Accounting South suburbs (Lake Oswego, West Linn, etc.) Car Woman

6 38 Toyota Senior 3 0 30 Accounting East suburbs (Gresham, Milwaukie, etc.) Car Man

6 21 None Junior 3 1 20 Finance On campus Walk Man

130 2 21 Toyota Junior 2 2 80 Accounting West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Woman

2 25 Mazda Senior 3 1 10 Management Portland city/urban area, not on campus Other Man

6 27 Volkswagen Junior 3 1 53 Marketing West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Man

6 46 Ford Junior 3 1 30 Finance On campus Walk Man

6 20 Ford Junior 3 1 30 Finance On campus Walk Man

6 20 Jeep Sophomore 3 1 20 Marketing On campus Walk Man

6 21 Volkswagen Senior 3 1 20 Accounting Portland city/urban area, not on campus Walk Man

6 35 Jeep Sophomore 3 1 20 Marketing On campus Walk Man

6 22 Honda Senior 3 1 15 Finance Vancouver area TriMet (bus or Max) Man

6 22 Subaru Sophomore 3 1 100 Accounting Portland city/urban area, not on campus Car Woman

2 25 Hyundai Junior 3 2 100 Finance Portland city/urban area, not on campus Car Woman

2 26

Junior 2 2 150 Management East suburbs (Gresham, Milwaukie, etc.) Car Woman

2 20 Subaru Junior 3 2 100 Management West suburbs (Beaverton, Hillsboro, etc.) Car Woman

2 32 Mercedes Junior 3 3 5 Supply & Logistics West suburbs (Beaverton, Hillsboro, etc.) Car Man

2 35 Chevrolet Sophomore 1 1 1 Supply & Logistics East suburbs (Gresham, Milwaukie, etc.) TriMet (bus or Max) Woman

2 37 Toyota Junior 3 2 10 Accounting West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Man

2 26 Mitsubishi Post-Bac 2 2 20 Human Resources Portland city/urban area, not on campus Car Woman

2 33 Honda Post-Bac 3 3 100 Human Resources Portland city/urban area, not on campus TriMet (bus or Max) Woman

3 30 Volkswagen Junior 3 1 40 Marketing Portland city/urban area, not on campus Car Man

2 23 Honda Junior 3 2 15 Management East suburbs (Gresham, Milwaukie, etc.) Car Woman

150 2 21

Junior 3 2 200 Management West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Woman

2 20 Acura Junior 4 2 200 Marketing Portland city/urban area, not on campus TriMet (bus or Max) Woman

3 39 Nissan Senior 1 1 10 Accounting East suburbs (Gresham, Milwaukie, etc.) TriMet (bus or Max) Woman

2 23

Junior 2 2 30 Management West suburbs (Beaverton, Hillsboro, etc.) Car Man

2 26 Dodge Junior 3 3 20 Accounting Other Car Man

2 19 Mazda Sophomore 4 1 200 Marketing Portland city/urban area, not on campus Walk Man

2 19 None Junior 3 1 40 Accounting Portland city/urban area, not on campus TriMet (bus or Max) Man

2 19 None Junior 3 1 45 Accounting Portland city/urban area, not on campus TriMet (bus or Max) Man

6 23

Sophomore 4 2 5 Accounting On campus Walk Man

2 23 Volkswagen Junior 3 1 50 Marketing Portland city/urban area, not on campus Car Man

2 20 Toyota Sophomore 3 2 200 Supply & Logistics Portland city/urban area, not on campus TriMet (bus or Max) Man

2 40 Ford Post-Bac 2 2 5 Supply & Logistics West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Man

2 26 Mazda Junior 2 2 50 Management Portland city/urban area, not on campus Car Woman

2 19 None Sophomore 3 1 50 Marketing Portland city/urban area, not on campus Walk Man

2 21 Volkswagen Junior 2 1 1 Finance West suburbs (Beaverton, Hillsboro, etc.) Car Man

3 22 Ford Junior 3 3 20 Finance West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Man

2 26 BMW Junior 3 2 5 Management West suburbs (Beaverton, Hillsboro, etc.) Car Man

2 25 Toyota Sophomore 3 3 200 Accounting Portland city/urban area, not on campus Car Man

2 33 Ford Junior 2 2 60 Accounting Portland city/urban area, not on campus Walk Man

2 26 Hyundai Junior 3 2 100 Finance Portland city/urban area, not on campus Car Woman

2 25 None Senior 3 1 6 Accounting West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Woman

2 21 None Junior 3 2 5 Management Portland city/urban area, not on campus TriMet (bus or Max) Woman

2 42 Subaru Senior 3 2 25 Supply & Logistics Portland city/urban area, not on campus Car Man

2 28 Honda Senior 3 2 40 Management Portland city/urban area, not on campus Car Woman

2 22 Volkswagen Junior 4 3 80 Finance On campus TriMet (bus or Max) Woman

2 22 BMW Junior 4 3 80 Finance On campus TriMet (bus or Max) Woman

2 20

Sophomore 5 2 500 Marketing West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Woman

2 42 Toyota Senior 3 2 25 Supply & Logistics Portland city/urban area, not on campus Car Man

2 26 Chevrolet Junior 4 1 4 Finance Other Car Man

2 20 Lexus Sophomore 4 1 40 Marketing On campus Man

2 19 Mazda Sophomore 4 1 150 Marketing Portland city/urban area, not on campus Other Man

2 19 Toyota Sophomore 3 2 100 Supply & Logistics Portland city/urban area, not on campus TriMet (bus or Max) Man

2 23 Subaru Junior 3 3 30 Finance West suburbs (Beaverton, Hillsboro, etc.) Car Man

2 26 BMW Junior 3 2 10 Management West suburbs (Beaverton, Hillsboro, etc.) Car Man

2 24 Volkswagen Senior 3 2 50 Finance South suburbs (Lake Oswego, West Linn, etc.) Car Man

2 20 None Junior 3 1 20 Marketing Portland city/urban area, not on campus TriMet (bus or Max) Woman

2 23 Volkswagen Junior 2 2 3 Accounting Portland city/urban area, not on campus Car Woman

2 25 Subaru Junior 3 3 40 Finance West suburbs (Beaverton, Hillsboro, etc.) Car Man

2 21 None Junior 3 3 10 Management Portland city/urban area, not on campus TriMet (bus or Max) Woman

2 21 Ford Junior 3 3 25 Finance West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Man

2 21 Ford Junior 3 2 100 Finance West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Man

2 22 None Junior 3 2 40 Marketing Portland city/urban area, not on campus TriMet (bus or Max) Man

2 21 None Junior 3 2 100 Finance West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Man

2 40 Toyota Junior 4 1 30 Accounting Other Car Woman

6 45 Nissan Junior 3 1

Accounting On campus Other Woman

2 19 Mazda Sophomore 4 1

Marketing South suburbs (Lake Oswego, West Linn, etc.) Car Woman

2 20 Honda Junior 3 2 15 Accounting South suburbs (Lake Oswego, West Linn, etc.) TriMet (bus or Max) Man

3 19 Toyota Junior 3 0 25 Management West suburbs (Beaverton, Hillsboro, etc.) Car Woman

2 33 Subaru Junior 3 1 10 Management West suburbs (Beaverton, Hillsboro, etc.) Car Man

	Record	Section	Age																																																																							Car	Class	Courses	Night	Texts	Major	Live	Transport	Gender
2													5												Ford																																																	Senior																			50																																																																																						Man																																																																																			Portland city/urban area, not on campus																																																																					TriMet (bus or Max)																																																																																																																Woman
																				23																																																		None																																																																																																									Junior																					10																																															Marketing																																																Walk
	36																									Toyota																																																									Accounting
																																																																				4			Volvo									15																																		Finance						Bike
																										25		9																																		On campus
7																				19																	Supply & Logistics
8	Jaguar																																			Sophomore																																								West suburbs (Beaverton, Hillsboro, etc.)
	48			Kia
										Human Resources
11													26																												Management																East suburbs (Gresham, Milwaukie, etc.)
12																Honda																	40				Vancouver area
13										Subaru													South suburbs (Lake Oswego, West Linn, etc.)
14														24												Volkswagen			70
																		30				Hyundai
16
17			Mercedes												Other
		18		54										Mazda
			29
				Volkswagen											200
																									21			31
																	22
																100
			27
								28
							Nissan
		32
			33			37
34					150
			35
				38						46									Post-Bac
	39
41				42		Mitsubishi		130
	43		65
	44
			45
					Jeep
47			Advertising
49
		Dodge
51					Lexus
	52
	53
	Pontiac
	55
56
57
58
59				75
		60
61		72
62
63
64
66
67					BMW
68
69
71
73
74
76
77
78
79
			80
81
82
83
84	Not Listed
85
86
87
88
89
90
91
92
93	Holden
94
95
96
97
98
99
101
102
103
104
105
106
107	Audi
108
109				Chevrolet		500
110
111
112
113
114
115
116
117
118
119
120
121	Buick
122
123
124
125
126
127
128
129
131
132
133
134
135
136
137
138
139
140
141		Acura
142
143
144
145
146
147
148
149
Honda
151
152
153	Subaru
154
155
156
157
158	Lexus
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176	Scion
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194	456
195	400
196
197
198

 The questions and results are included again below:

1. Which of the sections has the highest average (mean) age?  Provide that average and the average for each of the other sections.  What is the Standard Deviation for the section with the highest mean?

2. Which of the sections has the highest median age?  Provide that median and the median for each of the other sections.  Which is a “better” average, and why?

3. Find a significant descriptive statistical difference between the different sections and describe it?  How might it be useful in deciding how to teach that class differently?

4. What is the most common car brand in Section 002?  Create a column chart showing the number of owners of each car brand in Section 002.  Include the chart in your submission, and include the “none” category in your data.