Forum Discussion
Urgent for geography Coursework help (due tonight)
I compared 2 different areas using a visual housing survey and used 4 different categories - including exterior appearance, noise level, cleanliness and house plot size - I want to use statistical test to help my conclusion but i don't know which one and how
1 Reply
1. quick data organization skills
geographic coordinates processing:
latitude and longitude will be split into two columns (using "Data" > "Breakdown")
set the cell format for the "number" to retain 6 decimal
2. population data visualization:
select the data > Insert a "three-dimensional map"
will be dragged and dropped into the height / color area of the population field
3. commonly used geographic functions
excel
= GOOGLEMAPS (A2,"" distance",B2) // calculate the distance between two points = CONVERT(C2, "mi", "km") // unit conversion 3. emergency problem solutions ▸ map chart to display Windows area settings whether to check the distance of two points = C2, "mi", "km") // units conversion 3. distance",B2) // Calculate distance between two points
=CONVERT(C2, "mi", "km") // Convert units
4. Emergency problem solutions
Map charts don't show
Check Windows region settings for supported regions
File > Options > Add-ons > Enable "3D Maps"
5. Pivot table summarization errors
Right-click on the pivot table > "Data Source Settings"
Check that Include all data ranges
Set geographic field to "Region" instead of "Value"
6. Template resources
Download geographic data analysis templates
Include preset formulas
Automatically generate chart structure
Standard report format
7. Time management tips
Prioritize completion of the core analyses (70% of the points)
Use the "Quick Analysis" button (Ctrl+Q) to quickly generate charts
Save multiple versions (save a new file for each section completed) Save multiple versions (save as a new file for each section completed)
