Description
IF YOU DO NOT USE Excel and Excel functions to solve problems as demonstrated, YOUR HW report WILL NOT BE GRADED and Zero points will be recorded. There will be no exceptions.This HW MUST be Solved in a SINGLE Microsoft Excel. Solve Each problem on a separate tab. Copy-Paste the problem description into worksheet and solve it. Problem Description and Solution both must be on the same worksheet. There must be as many sheets in the file as the number of problems on the HW.
Unformatted Attachment Preview
Metropolitan_Area
Abilene, TX
Akron, OH
Albany, GA
Albany-Schenectady-Troy, NY
Albuquerque, NM
Alexandria, LA
Allentown-Bethlehem-Easton, PA
Altoona, PA
Amarillo, TX
Ames, IA
Anchorage, AK
Anderson, IN
Anderson, SC
Ann Arbor, MI
Anniston-Oxford, AL
Appleton, WI
Asheville, NC
Athens-Clarke County, GA
Atlanta-Sandy Springs-Marietta, GA
Atlantic City, NJ
Auburn-Opelika, AL
Augusta-Richmond County, GA-SC
Austin-Round Rock, TX
Bakersfield. CA
Baltimore-Towson, MD
Bangor, ME
Barnstable Town, MA
Baton Rouge, LA
Battle Creek, MI
Bay City, MI
Beaumont-Port Arthur, TX
Bellingham, WA
Bend, OR
Bethesda-Gaithersburg-Frederick, MD
Billings, MT
Binghamton, NY
Birmingham-Hoover, AL
Bismarck, ND
Blacksburg-Christiansburg-Radford, VA
Bloomington, IN
Bloomington-Normal, IL
Boise City-Nampa, ID
Boston-Quincy, MA
Boulder, CO
Bowling Green, KY
Bremerton-Silverdale, WA
Commute Time
37.57
49.38
44.52
48.37
48.85
54.63
53.55
43.37
39.68
35.97
47.98
49.92
51.22
47.00
50.72
38.93
46.83
46.92
66.33
51.07
44.45
52.13
54.13
49.75
63.42
45.88
50.18
55.03
42.92
46.62
47.50
43.40
38.52
68.47
38.90
43.17
57.97
33.85
43.65
46.75
36.13
43.53
64.60
46.13
44.68
68.22
Bridgeport-Stamford-Norwalk, CT
Brownsville-Harlingen, TX
Brunswick, GA
Buffalo-Niagara Falls, NY
Burlington, NC
Burlington-South Burlington, VT
Cambridge-Newton-Framingham, MA
Camden, NJ
Canton-Massillon, OH
Carson City, NV
Casper, WY
Cedar Rapids, IA
Champaign-Urbana, IL
Charleston, WV
Charleston-North Charleston, SC
Charlotte-Gastonia-Concord, NC-SC
Charlottesville, VA
Chattanooga, TN-GA
Cheyenne, WY
Chicago-Naperville-Joliet, IL
Chico, CA
Cincinnati-Middletown, OH-KY-IN
Clarksville, TN-KY
Cleveland, TN
Cleveland-Elyria-Mentor, OH
Coeur d’Alene, ID
College Station-Bryan, TX
Colorado Springs, CO
Columbia, MO
Columbia, SC
Columbus, GA-AL
Columbus, IN
Columbus, OH
Corpus Christi, TX
Corvallis, OR
Cumberland, MD-WV
Dallas-Plano-Irving, TX
Dalton, GA
Danville, IL
Danville, VA
Davenport-Moline-Rock Island, IA-IL
Dayton, OH
Decatur, AL
Decatur, IL
Deltona-Daytona Beach-Ormond Beach, FL
Denver-Aurora, CO
Des Moines-West Des Moines, IA
58.92
44.30
48.67
45.47
46.67
45.00
58.10
60.12
46.68
37.72
35.48
40.40
37.23
54.08
52.80
56.28
49.32
51.20
34.65
67.57
44.08
52.23
51.27
47.28
51.98
45.72
39.80
47.62
38.77
52.38
46.52
40.45
49.73
44.75
37.40
52.97
59.13
47.52
43.60
49.35
41.35
45.40
52.15
39.00
54.22
56.33
41.67
Detroit-Livonia-Dearborn, MI
Dothan, AL
Dover, DE
Dubuque, IA
Duluth, MN-WI
Durham, NC
Eau Claire, WI
Edison, NJ
El Centro, CA
Elizabethtown, KY
Elkhart-Goshen, IN
Elmira, NY
El Paso, TX
Erie, PA
Essex County, MA
Eugene-Springfield, OR
Evansville, IN-KY
Fairbanks, AK
Fargo, ND-MN
Framington, NM
Fayetteville, NC
Fayetteville-Springdale-Rogers, AR-MO
Flagstaff, AZ
Flint, MI
Florence, SC
Florence-Muscle Shoals, AL
Fond du Lac, WI
Fort Collins-Loveland, CO
Fort Lauderdale-Pompano Beach-Deerfield Beach, FL
Fort Smith, AR-OK
Fort Walton Beach-Crestview-Destin, FL
Fort Wayne, IN
Fort Worth-Arlington, TX
Fresno, CA
Gadsden, AL
Gainesville, FL
Gainesville, GA
Gary, IN
Glens Falls, NY
Goldsboro, NC
Grands Fork, ND-MN
Grand Junction, CO
Grand Rapids-Wyoming, MI
Great Falls, MT
Greeley, CO
Green Bay, WI
Greensboro-High Point, NC
55.65
47.30
48.40
32.73
42.25
48.43
39.45
69.37
43.27
49.93
39.12
41.45
48.82
39.78
57.57
41.57
44.73
36.70
34.35
50.80
48.00
43.47
40.28
55.13
50.98
51.30
39.67
44.58
58.47
48.18
47.13
44.67
57.32
47.27
52.88
46.35
56.17
57.83
48.27
46.38
31.85
38.45
47.43
33.73
49.98
39.93
48.22
Greenville, NC
Greenville, SC
Gulfport-Biloxi, MS
Hagerstown-Martinsburg, MD-WV
Hanford-Corcoran, CA
Harrisburg-Carlisle, PA
Harrisonburg, VA
Hartford-West Hartford-East Hartford, CT
Hattiesburg, MS
Hickory-Morganton-Lenoir, NC
Hinesville-Fort Stewart, GA
Holland-Grand Haven, MI
Honolulu, HI
Hot Springs, AR
Houma-Bayou Cane-Thibodaux, LA
Houston-Sugar Land-Baytown, TX
Huntington-Ashland, WV-KY-OH
Huntsville, AL
Idaho Falls, ID
Indianapolis-Carmel, IN
Iowa City, IA
Ithaca, NY
Jackson, MI
Jackson, MS
Jackson, TN
Jacksonville, FL
Jacksonville, NC
Janesville, WI
Jefferson City, MO
Johnson City, TN
Johnstown, PA
Jonesboro, AK
Joplin, MO
Kalamazoo-Portage, MI
Kankakee-Bradley, IL
Kansas City, MO-KS
Kennewick-Richland-Pasco, WA
Killeen-Temple-Fort Hood, TX
Kingsport-Bristol-Bristol, TN-VA
Kingston, NY
Knoxville, TN
Kokomo, IN
La Crosse, WI-MN
Lafayette, IN
Lafayette, LA
Lake Charles, LA
Lake County-Kenosha County, IL-WI
46.23
48.02
51.78
58.03
44.50
47.00
41.85
48.73
51.57
45.80
48.68
41.33
58.38
45.07
55.90
61.80
50.45
47.10
42.98
51.28
38.55
37.10
49.50
51.55
43.13
57.37
45.43
43.40
44.02
46.75
47.00
41.43
40.83
44.02
50.68
49.08
45.27
46.07
49.12
56.32
49.22
39.10
37.63
39.15
53.43
44.67
61.70
Lakeland, FL
Lancaster, PA
Lansing-East Lansing, MI
Laredo, TX
Las Cruces, NM
Las Vegas-Paradise, NV
Lawrence, KS
Lawton, OK
Lebanon, PA
Lewiston, ID-WA
Lewiston-Auburn, ME
Lexington-Fayette, KY
Lima, OH
Lincoln, NE
Little Rock-North Little Rock, AR
Logan, UT-ID
Longview, TX
Longview, WA
Los Angeles-Long Beach-Glendale, CA
Louisville-Jefferson County, KY-IN
Lubbock, TX
Lynchburg, VA
Macon, GA
Madera, CA
Madison, WI
Manchester-Nashua, NH
Mansfield, OH
McAllen-Edinburg-Mission, TX
Medford, OR
Memphis, TN-AR-MS
Merced, CA
Miami-Miami Beach-Kendall, FL
Michigan city-La Porte, IN
Midland, TX
Milwaukee-Waukesha-Weat Allis, WI
Minneapolis-St. Paul-Bloomington, MN-WI
Missoula, MT
Mobile, AL
Modesto, CA
Monroe, LA
Monroe, MI
Montgomery, AL
Morgantown, WV
Morristown, TN
Mount Vernon-Anacortes, WA
Muncie, IN
Muskegon-Norton Shores, MI
54.73
45.50
45.13
46.42
45.25
52.25
41.18
36.42
45.95
34.45
49.98
44.53
39.73
38.05
50.10
36.45
47.03
45.43
62.37
50.20
36.95
49.62
52.52
55.45
43.35
54.10
43.22
44.92
39.17
53.33
55.32
64.50
47.22
39.67
47.33
50.07
36.82
54.38
57.15
46.95
51.78
49.87
48.82
50.58
52.70
42.37
44.43
Myrtle Beach-Conway-North Myrtle Beach, SC
Napa, CA
Naples-Marco Island, FL
Nashville-Davidson-Murfreesboro, TN
Nassau-Suffolk, NY
Newark-Union, NJ-PA
New Haven-Milford, CT
New London-Norwich, CT-RI
New Orleans-Metairie-Kenner, LA
New York-White Plains-Wayne, NY-NJ
Niles-Benton Harbor, MI
Norwich-New London, CT
Oakland-Fremont-Hayward, CA
Ocala, FL
Ocean City, NJ
Odessa, TX
Odgen-Clearfield, UT
Oklahoma City, OK
Olympia, WA
Omaha-Council Bluffs, NE-IA
Orlando-Kissimmee, FL
Oshkosh-Neenah, WI
Owensboro, KY
Oxnard-Thousand Oaks-Ventura, CA
Palm Bay-Melbourne-Titusville, FL
Panama City-Lynn Haven, FL
Parkersburg-Marietta-Vienna, WV-OH
Pascagoula, MS
Pensacola-Ferry Pass-Brent, FL
Peoria, IL
Philadelphia, PA
Phoenix-Mesa-Scottsdale, AZ
Pine Bluff, AR
Pittsburgh, PA
Pittsfield, MA
Pocatello, ID
Portland-South Portland-Biddeford, ME
Portland-Vancouver-Beavertown, OR-WA
Port St. Lucie-Fort Pierce, FL
Poughkeepsie-Newburgh-Middletown, NY
Prescott, AZ
Providence-New Bedford-Fall River, RI-MA
Provo-Orem, UT
Pueblo, CO
Punta Gorda, FL
Racine, WI
Raleigh-Cary, NC
50.73
50.68
50.35
55.65
70.60
66.30
42.90
49.78
57.32
79.38
42.63
47.60
68.13
54.90
49.67
40.00
46.82
47.48
51.68
41.98
57.43
38.13
44.43
53.47
52.38
46.42
46.13
54.10
53.15
42.82
61.72
55.38
49.50
54.42
40.77
36.65
49.35
51.45
54.75
66.78
46.52
50.72
39.48
43.93
50.32
47.37
55.48
Rapid City, SD
Reading, PA
Redding, CA
Reno-Sparks, NV
Richmond, VA
Riverside-San Bernardino-Ontario, CA
Roanoke, VA
Rochester, MN
Rochester, NY
Rockford, IL
Rockingham County-Strafford County, NH
Rocky Mount, NC
Rome, GA
Sacramento-Arden-Arcade-Roseville, CA
Saginaw-Saginaw Township, MI
St. Cloud, MN
St. George, UT
St. Joseph, MO-KS
St. Louis, MO-IL
Salem, OR
Salinas, CA
Salisbury, MD
Salt Lake City, UT
San Angelo, TX
San Antonio, TX
San Diego-Carlsbad-San Marcos, CA
Sandusky, OH
San Francisco-San Mateo-Redwood City, CA
San Jose-Sunnyvale-Santa Clara, CA
San Luis Obispo-Paso Robles, CA
Santa Ana-Anaheim-Irvine, CA
Santa Barbara-Santa Maria, CA
Santa Cruz-Watsonville, CA
Santa Fe, NM
Santa Rosa-Petaluma, CA
Sarasota-Bradenton-Venice, FL
Savannah, GA
Scranton-Wilkes Barre, PA
Seattle-Bellevue-Everett, WA
Sebastian-Vero Beach, FL
Sheboygan, WI
Sherman-Denison, TX
Shreveport-Bossier City, LA
Sioux City, IA-NE-SD
Sioux Falls, SD
South Bend-Mishawaka, IN-MI
Spartanburg, SC
36.95
47.75
44.15
41.27
54.10
65.98
47.60
37.55
44.88
46.65
57.83
47.65
51.00
54.08
46.17
40.95
36.03
42.80
54.80
49.23
49.18
45.95
48.52
38.57
53.45
53.25
40.40
61.62
56.10
43.92
57.55
40.45
57.87
45.05
55.83
47.42
51.95
45.07
57.42
42.93
36.02
53.15
47.38
37.78
37.55
44.60
48.50
Spokane, WA
Springfield, IL
Springfield, MA
Springfield, MO
Springfield, OH
State College, PA
Stockton, CA
Sumter, SC
Syracuse, NY
Tacoma, WA
Tallahassee, FL
Tampa-St. Petersburg-Clearwater, FL
Terre Haute, IN
Texarkana, TX-Texarkana, AR
Toledo, OH
Topeka, KS
Trenton-Ewing, NJ
Tucson, AZ
Tulsa, OK
Tuscaloosa, AL
Tyler, TX
Utica-Rome, NY
Valdosta, GA
Vallejo-Fairfield, CA
Victoria, TX
Vineland-Millville-Bridgeton, NJ
Virginia Beach-Norfolk-Newport News, VA-NC
Visalia-Porterville, CA
Waco, TX
Warner Robins, GA
Warren-Troy-Farmington Hills, MI
Washington-Arlington-Alexandria, DC-MD-VA-WV
Waterloo-Cedar Falls, IA
Wausau, WI
Weirton-Steubenville, WV-OH
Wenatchee, WA
West Palm Beach-Boca Raton-Boynton Beach, FL
Wheeling, WV-OH
Wichita, KS
Wichita Falls, TX
Williamsport, PA
Wilmington, DE-MD-NJ
Wilmington, NC
Winchester, VA-WV
Winston-Salem, NC
Worcester, MA
Yakima, WA
44.72
41.78
47.07
45.85
46.50
41.37
62.32
46.43
43.98
60.35
50.93
54.52
45.47
43.72
44.30
44.02
57.70
50.68
46.55
47.43
47.65
43.98
43.50
67.67
46.58
49.68
51.82
46.42
42.87
43.75
58.22
69.88
34.92
38.42
48.30
37.98
54.25
48.93
41.17
38.95
42.12
53.20
48.67
59.10
49.27
55.32
41.27
York-Hanover, PA
Youngstown-Warren-Boardman, OH-PA
Yuba City, CA
Yuma, AZ
51.93
44.98
54.62
40.23
Employee
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
Gender
1
0
0
1
0
1
1
0
1
0
0
1
0
1
1
0
1
0
1
1
1
0
0
1
0
1
0
0
1
0
1
1
1
0
0
1
0
1
1
0
1
0
1
1
0
0
Age
39
44
24
25
56
41
33
37
51
23
31
27
47
35
29
46
50
30
34
42
51
63
28
32
55
45
34
33
23
40
48
27
36
58
31
21
47
35
52
29
42
60
50
33
26
38
Prior Experience
5
12
0
2
5
9
6
11
12
0
5
0
11
5
5
4
10
3
10
11
10
16
0
4
11
20
2
2
0
4
6
0
5
9
1
0
5
3
12
3
11
10
8
1
0
6
Beta Experience Education
12
4
8
6
2
4
1
4
25
8
10
4
2
6
6
4
16
6
1
4
4
6
8
0
9
4
5
6
4
0
15
6
17
4
6
4
1
4
8
4
15
8
20
4
5
4
1
4
16
6
2
4
12
2
7
4
1
4
13
6
15
4
6
0
5
6
22
4
1
6
1
2
16
4
7
4
14
8
3
2
7
4
21
4
13
4
2
6
5
2
6
6
Annual Salary
57700
76400
44000
41600
163900
72700
60300
63500
131200
39200
62900
26200
74500
64800
21600
81900
115400
57800
55800
76100
135700
140400
55400
49700
134800
76900
28700
58800
43100
82400
80100
27000
58800
133100
53700
26700
81300
55400
139900
33200
75000
128200
76800
54200
32600
59200
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
1
0
1
0
0
1
1
1
1
0
1
0
0
1
1
0
1
1
1
0
1
0
1
1
0
1
1
1
0
1
1
1
1
1
0
1
1
0
0
0
1
0
1
1
1
1
0
44
25
37
53
46
20
34
60
36
41
33
29
48
43
61
30
36
48
29
26
49
28
44
48
50
48
30
41
35
28
33
61
53
48
47
48
55
32
60
50
49
22
51
22
47
41
24
7
0
8
13
7
0
5
12
6
6
3
3
11
0
10
5
5
7
5
11
5
10
20
0
0
12
16
20
11
3
8
0
10
4
9
4
11
1
11
10
16
4
9
0
8
10
3
12
3
5
13
18
1
1
13
7
3
1
8
9
4
5
1
19
23
6
23
11
2
5
13
21
14
12
23
5
3
5
7
8
4
1
7
3
19
4
2
12
3
10
3
13
10
1
4
4
4
6
4
0
6
4
4
6
6
4
4
6
0
6
4
4
4
4
2
6
6
6
2
4
4
4
4
4
4
4
4
4
4
6
6
6
8
4
4
4
4
8
4
6
0
74800
45500
46500
136300
86900
23900
52700
92700
59500
69400
46600
61700
88200
45000
52200
61400
87500
103700
54000
125100
45900
79300
108600
68200
65200
95600
103100
143500
78200
40200
60500
40500
73800
45300
61400
64800
75600
95800
126700
67000
102600
52000
76000
83000
80800
91100
30100
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
1
1
0
1
0
1
0
1
0
1
1
0
0
1
1
0
1
0
0
0
0
0
0
0
1
0
1
1
1
1
0
0
0
0
1
1
1
1
1
1
0
1
1
0
0
1
1
64
43
22
59
32
45
47
29
61
57
65
34
54
30
39
32
24
40
52
28
53
43
30
46
38
28
46
30
43
29
48
42
18
35
22
44
47
34
37
49
32
37
29
24
43
54
26
5
0
3
0
10
8
0
6
9
3
4
6
6
5
6
7
2
10
13
11
20
0
5
3
10
0
11
5
6
11
11
7
10
6
0
4
20
10
11
0
0
5
10
7
20
11
0
7
11
1
1
15
5
1
18
15
1
9
7
13
5
16
8
7
3
4
5
9
24
6
3
13
16
19
5
14
1
4
17
19
2
1
15
4
8
4
4
18
8
19
15
18
17
4
4
4
4
4
2
2
2
4
6
4
4
4
6
6
4
6
2
4
4
4
6
4
6
4
6
4
6
0
4
8
4
4
6
4
0
4
4
4
4
2
6
4
6
2
0
4
6
55700
51400
43800
25000
80600
39600
13400
88200
109100
34200
57800
68100
94900
63200
82700
85600
27100
69800
81300
78400
127300
93700
74400
48300
98900
73300
117300
37800
77400
111200
75300
96900
123600
55200
12400
73900
94100
74300
66900
12500
90200
59000
114700
71700
125500
100200
45400
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
0
1
0
0
1
1
1
1
1
1
0
1
0
1
0
1
0
1
1
1
0
0
1
0
0
1
1
1
0
1
0
0
1
1
0
1
1
1
1
1
1
1
0
0
0
1
1
47
31
33
42
34
59
43
30
45
50
23
44
48
47
20
31
30
42
25
24
36
32
27
55
36
22
25
47
43
53
38
39
35
23
43
33
44
33
31
36
45
45
39
45
25
34
53
10
5
11
2
2
0
5
2
7
0
0
5
10
4
11
0
0
5
9
2
13
6
2
12
0
0
0
5
16
0
5
12
5
3
10
3
10
0
0
7
13
12
2
5
1
0
0
4
12
1
7
1
10
4
2
12
4
15
7
6
12
4
16
18
13
7
15
13
15
1
12
2
4
14
14
11
7
7
14
18
10
7
3
1
16
13
8
19
1
7
11
1
7
6
4
4
4
6
4
2
6
4
6
2
8
4
2
4
4
2
4
4
6
2
4
6
0
6
4
6
6
4
8
6
4
4
4
8
4
4
4
4
6
4
4
4
4
2
4
4
6
72200
69500
67900
67500
31800
27800
60200
34500
87000
12500
122700
56200
56900
66000
76000
44100
78500
71800
80700
47800
105000
100700
18300
110600
36800
45500
71400
74300
160600
52500
65000
104500
85000
110200
80100
40000
55900
64600
68600
65100
111700
62000
55800
54600
37600
41200
49900
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
0
1
1
1
1
1
1
1
1
0
0
0
1
1
1
0
0
35
52
33
49
59
35
44
61
43
30
32
57
44
44
45
43
33
4
3
10
0
6
16
11
11
11
0
11
10
10
2
0
0
11
6
13
3
3
17
9
11
18
1
5
2
4
18
4
7
12
19
4
4
6
4
4
4
4
4
4
4
4
6
4
4
2
6
4
59400
65500
73200
30500
84800
95200
84900
102600
59000
44800
70500
83700
100000
39300
20400
74300
114500
QMB 3200
Homework #1
Instructions:
1) Before attempting this assignment, you should have done reading assignments as indicated
under Week 1. Doing so will prepare you to answer, completely and relevantly, the problems
assigned below.
It is the beginning of the course and now is the time to become familiar with Excel (if you are not
already). This course will quickly become very difficult if Excel skills are not developed and
utilized.
Excel functions and formulas MUST be used to complete this assignment. This assignment
will not be accepted if Excel functions, and formulas are not used. IF YOU DON’T USE
Excel and Excel functions to solve problems as demonstrated, YOUR HW report WILL
NOT BE GRADED and Zero points will be recorded. There will be no exceptions.
2) Solve all the problems. Problems 1-6 carry 10 points each. Problems 7-8 carry 20 points
each. Maximum score possible for this Homework is 100 points.
3) Please download an Excel file “QMB3200–Homework#1Data.xlsx” to find data for
problems 7-8, use the data to solve the problems and answer the questions.
4) You can download the above file; rename it to show your Full Name and the HW Number.
Add additional tabs solve the problems and submit it. Organize your solutions on the Excel
worksheet properly. Solve each problem on a separate tab. Show where your answers are for
each problem and the sections of the problem. Use proper formatting. Upload your report file on
Canvas and verify if everything is fine by opening up the uploaded file. It is your responsibility
to ensure your report is uploaded properly.
5) Do not wait until the last minute. The deadline is strictly enforced by Canvas. No hardcopy
submissions are accepted. No e-mail submissions are accepted. If your file does not appear on
Canvas by the deadline, zero points will be recorded for you for that HW. No exceptions are
entertained for any reason under any circumstance in this regard.
HW Problems:
1) For the following data on Year-end Audit times (in days),
17, 20, 25, 27, 19, 19, 20, 32, 26, 23, 24, 23, 27, 38, 21, 23, 22, 28, 33, 18, 27, 20, 23, 27, 31
Prepare a table showing in columns Audit Time Intervals (days), Frequencies, Cumulative
Frequencies, Relative Frequencies, Cumulative Relative Frequencies, Percent Frequencies,
and Cumulative Percent Frequencies.
2) The following table shows a data set containing information for 5 of the shadow stocks
tracked by the American Association of Individual Investors. Shadow stocks are common
stocks of smaller companies that are not closely followed by Wall Street analysts.
1
a. How many variables are in the data set? List them.
b. List the variables and identify which of the variables are categorical and which are
quantitative?
c. Find the average values for: Market Cap, Price/Earnings Ratio, and Gross Profit Margin.
Company
DeWolfe Companies
North Coast Energy
Hansen Natural Corp.
MarineMax, Inc.
Nanometrics, Inc.
Exchange
AMEX
OTC
OTC
NYSE
OTC
Ticker
Symbol
DWL
NCEB
HANS
HZO
NANO
Market Cap
($ millions)
36.4
52.5
41.1
111.5
228.6
Price/Earnings
Ratio
8.4
6.2
14.6
7.2
38.0
Gross Profit
Margin (%)
36.7
59.3
44.8
23.8
53.3
3) A sample of midterm grades for five students showed the results: 72, 65, 82, 90, and 76.
Based on the data, which of the following statements are correct, and which should be
challenged as being too generalized? Justify your answer.
a. The average midterm grade for the sample of five students is 77.
b. The average midterm grade for all students who took the exam is 77.
c. An estimate of the average midterm grade for all students who took the exam is 77.
d. More than half of the students who take this exam will score between 70 and 85.
e. If five other students are included in the sample, their grades will be between 65 and 90.
4) In automobile mileage and gasoline-consumption testing, 6 automobiles were road tested for
300 miles in both city and highway driving conditions. The following data were recorded for
miles-per-gallon performance.
City
16.2 16.7 15.9 14.4
16 16.2
Highway 19.4 20.6 18.3 18.6 18.6 18.7
Use mean, median, and mode to make a statement about the difference in performance for
city and highway driving. Which area of Statistics helps you to either validate or disprove
such a statement and why?
5) Consider a sample with data values of 12, 17, 10, 16, and 20. Compute mean, median, range,
variance, and standard deviation.
6) Consider a sample with data values of 12, 17, 10, 16, and 20. Compute the z-scores for the
dataset.
7) The first sheet on QMB3200–Homework#1Data.xlsx is named CommuteTime. It lists the
average commute time (in minutes) it takes citizens of 379 metropolitan areas to travel to
work and back home each day.
a. Using Excels statistical functions such as =AVERAGE(), =SUM() etc., give the mean,
median, mode, max, min, variance (sample) and standard deviation (sample) of the
average commute times, 10th percentile, 20th percentile, 40th percentile, 50th percentile,
2
b.
c.
d.
e.
f.
g.
60th percentile, 80th percentile, 1st quartile, 2nd quartile, 3rd quartile. Look at the values of
the median and the 2nd quartile and the 50th percentile and comment.
Find the frequency of commute times between 30-39.99, 40-49.99, 50-59.99, 60-69.99
and 70-79.99.
Find the relative frequency of the commute times for the above intervals.
Find the cumulative relative frequency of the commute times for the above intervals.
Plot a line chart of the relative frequencies obtained in part c above.
Plot a pie-chart of the relative frequencies.
Make three statements about the data from the cumulative relative frequency table or the
plots.
8) The second sheet on QMB3200–Homework#1Data.xlsx is named BetaEmployees. It gives
data about some employees at Beta Corporation.
a. For each of the variables, state the type of each of the six variables as either Numeric or
Categorical.
b. For the Gender variable, find the number of males and females and their proportions.
Assume 0 denotes Male and 1 denotes Female.
c. Create a frequency table for annual salary by creating frequencies for groups of intervals
of 10,000. Create the groups as 0 to 9999, 10,000 to 19,999, 20,000 to 29,999, and so on
up to 169,999.
d. Create a relative frequency column
e. Create a cumulative frequency column
f. Create a cumulative relative frequency column
g. Plot a chart of the relative frequencies
h. Guess if the shape is skewed or not and if so, in what direction.
i. Find the skewness of annual salary column and interpret its value.
j. Find the kurtosis of annual salary column and interpret its value.
k. Make three statements about the data.
3
Purchase answer to see full
attachment
