Quiz 5
xlsx
keyboard_arrow_up
School
California State University, Bakersfield *
*We aren’t endorsed by this school
Course
20
Subject
Industrial Engineering
Date
Dec 6, 2023
Type
xlsx
Pages
4
Uploaded by DoctorSteelSnake28
Geo_FIPS County_Name
State
Total_population
6001 Alameda County
ca
1673133
6003 Alpine County
ca
1344
6005 Amador County
ca
40095
6007 Butte County
ca
217884
6009 Calaveras County
ca
45349
6011 Colusa County
ca
21780
6013 Contra Costa County
ca
1161643
6015 Del Norte County
ca
27655
6017 El Dorado County
ca
190568
6019 Fresno County
ca
1003150
6021 Glenn County
ca
28675
6023 Humboldt County
ca
137014
6025 Imperial County
ca
180051
6027 Inyo County
ca
18804
6029 Kern County
ca
905644
6031 Kings County
ca
151887
6033 Lake County
ca
67749
9. Make a
6035 Lassen County
ca
32949
6037 Los Angeles County
ca
10019635
10. Make
6039 Madera County
ca
156304
6041 Marin County
ca
262387
6043 Mariposa County
ca
17225
6045 Mendocino County
ca
91534
6047 Merced County
ca
279150
6049 Modoc County
ca
8723
6051 Mono County
ca
13291
6053 Monterey County
ca
438953
6055 Napa County
ca
138795
6057 Nevada County
ca
102090
6059 Orange County
ca
3182923
6061 Placer County
ca
400330
6063 Plumas County
ca
19631
6065 Riverside County
ca
2409331
6067 Sacramento County
ca
1571767
6069 San Benito County
ca
63329
6071 San Bernardino County
ca
2171071
6073 San Diego County
ca
3296317
6075 San Francisco County
ca
865933
6077 San Joaquin County
ca
771406
6079 San Luis Obispo County
ca
282771
6081 San Mateo County
ca
762488
6083 Santa Barbara County
ca
447651
1. What i
2. What i
3. What i
4. How m
5. What i
6. What i
7. In Colu
8. In Colu
6085 Santa Clara County
ca
1932022
6087 Santa Cruz County
ca
272138
6089 Shasta County
ca
181935
6091 Sierra County
ca
3079
6093 Siskiyou County
ca
44151
6095 Solano County
ca
451432
6097 Sonoma County
ca
492498
6099 Stanislaus County
ca
550842
6101 Sutter County
ca
99080
6103 Tehama County
ca
65345
6105 Trinity County
ca
15818
6107 Tulare County
ca
470999
6109 Tuolumne County
ca
55243
6111 Ventura County
ca
845255
6113 Yolo County
ca
216703
6115 Yuba County
ca
80404
a pivot table of the population on a new sheet and group them by 100,000 starting e chart of that pivot table. This is called a histogram. (0.4)
is the average population of counties in California? (0.1)
is the median population of counties in California? (0.1)
is the average population of those counties whose population is over 100,000? (0.2
many counties have populations over 100,000? (0.2)
is the highest population? (0.1)
is the lowest population? (0.1)
umn E, label the county with the highest population as 'highest' and leave all others umn F, label the county with the lowest population as 'lowest' and leave all others b
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
at zero. (0.4)
2)
blank. You must use the IF command to do this. (0.2)
blank. You must use the IF command to do this. (0.2)