### Create a StudySoup account

#### Be part of our community, it's free to join!

Already have a StudySoup account? Login here

# QuantitativeAnalysisin Geography GEOG 247

UWM

GPA 3.86

### View Full Document

## 24

## 0

## Popular in Course

## Popular in Geography

This 10 page Class Notes was uploaded by Holly Hahn on Tuesday October 27, 2015. The Class Notes belongs to GEOG 247 at University of Wisconsin - Milwaukee taught by Staff in Fall. Since its upload, it has received 24 views. For similar materials see /class/230278/geog-247-university-of-wisconsin-milwaukee in Geography at University of Wisconsin - Milwaukee.

## Similar to GEOG 247 at UWM

## Popular in Geography

## Reviews for QuantitativeAnalysisin Geography

### What is Karma?

#### Karma is the currency of StudySoup.

#### You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!

Date Created: 10/27/15

K Quantitative Analysis in Geography Geography 247 Quantitative Analysis in Geography Fall 2008 Overview and Essentials of Excel Instructor Rama Prasada Mohapatra Department of Geography University of WisconsinMilwaukee email ramauwmedu J University of WisconsinMilwaukee Quantitative Analysis in Geography Outline 1 Introduction 2 Interface 3 Data input 4 Data presentation 5 Output from Excel University of WisconsinMilwaukee1 K Quantitative Analysis in Geography 1 Introduction What is Microsoft Excel It is a computer program used to manage and analyze data stored in electronic spreadsheets What can we do in Excel Store and organize data create charts perform statistical analysis etc Advantage It allows us to create and manage large electronic data sets can have reference to data between many worksheets present data in graphical form etc University of WisconsinMilwaukee Quantitative Analysis in Geography 2 Interface Bonmli39omp iiiiii i iiiii delr cccccccccc el v x V i i 39ll 1 l 3 u I n n m F l El l l W University of WisconsinMilwaukee 2 Heir gt Funman re rente penam Tnanak Help gt what Marveli5 HElD gt Funmnn race gt Funcnan re rence has far hzrler searm resulls other Dlics to look or quotn All aniUusa Of ce amine All aeei Interface austlcal lunnmns rererenee Slanshcal or us arwmksneeuunmans alphabetical 1 llsk afwmksneeuunmans by eategory Heir m Mon Page 31 a 3 an t nd 27 University of WisconsinMilwaukee Quantitative Analysis in Geography Help material earen WEST function lZlSluwll ReturnsmeDrnhahilityzssuciztedwi asluuemsrresl Use Tl39EGHuaeterminewhetherrwuszm eszrelikewrunzyecume rmmmesamemaunnervinguepuialmnsmanmemesamemean Syntax WESTlarr H arrayZlailS lypev Array1 isthe rsmztzszt ArrayZ is me second data set Tails speci esthenunmerufdistrmutiuntails irlalis rrgsr useslhe unsrtziled distribution Nails 2 WESTusestlietwnrtziled distribution Type is the ma ultrTesHD permrm WEvrelHElp x r g m n Quantitative Analysis in Geography 2 Interface K H quot 39 a Li Workbook g F j New RKentDommzuls l a woven lll Workbook l3 Aworkbook the H main application consists of number i of worksheets lquot New l 39 Open 39 Save 1 l Emu y lg Qase Extel Ugl L jt tel l University of WisconsinMilwaukee 2 Worksheet Interface Worksheet Quantitative Analysis in Geography Worksheets are composed of Rows and Columns Inserting a new worksheet Namingdeletingcopying a worksheet University of WisconsinMilwaukee Quantitative Analysis in Geography 2 Interface Formula Bar J Microsoft Evcel Ham Insert Page Layam Fammlas Dara Renew View E 1 w a 4 l l j 1J1 a El FarmulaBar 1 1m awrs l A J Gnannes J Headings a Page PageBrEzk Custom Full l 7 Zoom man 1110th New Anange Layout Prewew mews sueen H39rquot Seiemon Window Lll Workbook Vltwi l Shaw Hide Zoom I 029 39 Formula Bay L A H i vlemherarmmeaar lawmmau Wm H a revlenanararmmasmee D E r cell income J i Mizms hEh El insert Paqelayam uglg Did meulas um Renew Vraw Funnula ar r 73L E EDENquot w l J Grldllnes 7 r J Hea mgs Hmz 39w a a Page Pagz reak usram mu Zoom 1mm Znamta new Arrange Frieze rayaux Premew fliwf Srreen Selimun window All Panas39 7 Wauaaou View 5mm Hrde aam Windsz zaou l Zumraflbalm mace E c E F G H l J K L M N be 1 in l University of WisconsinMilwaukee Quantitative Analysis in Geography 2 Interface Insert Chart A gistr duff r a 1 v Q i Microsoft Excel 3 Home Insert Page Layout Formulas Data Quantitative Analysis in Geography 2 Interface Statistical analysis tools 3 MlUDSD Excel Home Insert Pagelayuur l Formulas l Data Review View view Jail Review View 7 7 lw gaaneanoimmoeaar j z m l m l ig i z PivutTahie Tania Pizture ail WI Checking v insert lAutoSum Recently Flnanzial Logical Text Datea Luukupamp Math iror Name a A h Function v Ussd v nme Referama39 ampTrig39 FmeiIoni39 Manager Elf AVEDEV H M Farmula Clip shapes SmartAn Calumn Lin PIE Bar Area Scatter other Hyperlink Text Header WordArt Signal Function Library Art v v v v v v Charts39 Bax ampFoater v Lme 7 Tables Illustrations Charts n Links Text lnsen Function Ll Insert Chart 7 Temnlates meanned Or select a gategory Most Recently Used ll 1 c E 7 7 7 7 7 Select a Function ial 5 Li 7 SAVEIRAQ 53m r 3 392 tit IF 7 MMQMQ L A HYPERLINK ad Surface icount lgll Pi RANDO lg Daughm r w a V 7 x m Returns a random number greater than or equal to U and less than 1J evenly tr Bubble amp W Q54 distributed changes on recalculation a Radar Ba m Egl lljil Lil 7 E Eil rjl ail ii WEQ WP B ESr l emmmm l El Help onthisfunction 39 University of WisconsinMilwaukee University of WisconsinMilwaukee Quantitative Analysis in Geography Quantitative Analysis in Geography 7 l 3 Data input 3 Data Input W a Microsoft Excel l Home Insert Page iame Farmuras Data Review Vicw 9 Cut Labels Values Anal 10 is i i ggriv Em mp r General 7 Cop ate 7 g V 0110 V ormmm in 1 g ii A i i glassware is x Vila Cllphaam 7 Font 7 Allgnrilenl l l 7 7 ri Number W7 l roRxAc v ll V Labels aromaminer me h E F G H J4 Formula Bar Labels are alphabetic alphanumeric or numeric text on which you do not perform 1 mathematical calculations 1 1 Values 1 Values are numbers on which you perform 1 mathematical calculations on the left side of the Formula bar Cell entries are displayed on the right side of the K J k Formula bar window J University of WisconsinMilwaukee University of WisconsinMilwaukee Cell Data range Cell A column and row intersection is referred as a cell Data Range A data range consists of several cells for example A1 D10 Quantitative Analysis in Geography 3 Data input PUnwerSny of WisconsinMilwaukee a v 3 J Hamel lnsm 3 Data input J Anal A i PaglLayaul in A i i n I i ia h39Aquot 5 ram xgx mmuias LLLk Quantitative Analysis in Geography Microsufr Ems um Realm Vim avi gwrapvm Genuai il39i l ilii ungsaamV is I v new uranium Numbu Data Range Starting from cell A1 to cell D10 A1D10 Cell address Example Cell C10 is located where column C and row 10 intersect each other Quantitative Analysis in Geography 3 Data input Data format i am i Fi Pratecllun Number itgnmentr Font Number Number of decimal 332quot places could be Time 232 controlled Text In text format numbers are also treated as text umber is used for general display or numbers twenty and mounting offer Specialized annatting for monetary value Date amp Currency Several types University of WisconsinMilwaukee Importing data Importing data from text files example Quantitative Analysis in Geography Vi University of WisconsinMilwaukee Quantitative Analysis in Geography Quantitative Analysis in Geography 4 Data presentation 4 Data presentation Sorting data I Filtering data em J a Custom Auto filter Home Insert Page Layout Formulas Dara Rcvrew wew C ustom Auto Fille r 3 5 n i39 1 393 5 lza39JCGrmemW A 39 shuwrnwswhere a V A 4 id do u an i W3 4 ur l r r lrrum From From FlomOthEr Exrslinq Reiresh Sari arm I iAuess Web Taxt Suurr s39 Cannedrons Arr 1 equals m ll ill GelExtemalData nnnemam sortsmiter And our M M Use to represent any srngle charatter Use m represent any series of characters Advanced Filter e e H Sorting alphabetically numerically etc 39 Liquot gt AgZilterthelismnplace mar Cagfents o D ascend n g 0 cm to another lncation Easte my List range m r 39 giteria range Insencamment 1 sgnrargesnu Smallest Earmariellsm Putseleded geii alarOnTup Lmlir Picg From Dropdown List Put Selected font Colur On tau J g E a Elumuuerecordsonly I f Z2 ZZZ quot quot J K i m J University of WisconsinMilwaukee m University of WisconsinMilwaukee Ir Er Quantitative Analysis in Geography 5 Output from Excel Quantitative Analysis in Geography 4 Data presentation Tables Data organized in form of tables Moving around is not easy Printing Meaningful interpretation of long data tables is Graphs very difficult Summary tables are beneficial Tables Set the print area H q a i Microsoft Excel Home Insert l Page Layuut i Formulas Data Revrlw View cmurs E3 Fonts 39 Heading row Adding borders l 7 quot imam Autumatiz39 Grialmes gt l 7 El 9y Height Automatit v I Vle Formattlng text lThernesEJE anS wrargrnsOrrenfarron SIZE greats Background 58 100 mm 1 I I I Theme 7 i 7 pa x EtP A r Salet0Fli r SneetC nghllghtlng Cells want 39 Eooli Commenmirn Mode j k E C I D l E F G H l J V J University of WisconsinMilwaukee University of WisconsinMilwaukee K Quantitative Analysis in Geography Geography 247 Quantitative Analysis in Geography Fall 2008 Overview and Essentials of Excel Instructor Rama Prasada Mohapatra Department of Geography University of WisconsinMilwaukee email ramauwmedu J University of WisconsinMilwaukee Quantitative Analysis in Geography Outline 1 Introduction 2 Interface 3 Data input 4 Data presentation 5 Output from Excel University of WisconsinMilwaukee1 K Quantitative Analysis in Geography 1 Introduction What is Microsoft Excel It is a computer program used to manage and analyze data stored in electronic spreadsheets What can we do in Excel Store and organize data create charts perform statistical analysis etc Advantage It allows us to create and manage large electronic data sets can have reference to data between many worksheets present data in graphical form etc University of WisconsinMilwaukee Quantitative Analysis in Geography 2 Interface Bonmli39omp iiiiii i iiiii delr cccccccccc el v x V i i 39ll 1 l 3 u I n n m F l El l l W University of WisconsinMilwaukee 2 Heir gt Funman re rente penam Tnanak Help gt what Marveli5 HElD gt Funmnn race gt Funcnan re rence has far hzrler searm resulls other Dlics to look or quotn All aniUusa Of ce amine All aeei Interface austlcal lunnmns rererenee Slanshcal or us arwmksneeuunmans alphabetical 1 llsk afwmksneeuunmans by eategory Heir m Mon Page 31 a 3 an t nd 27 University of WisconsinMilwaukee Quantitative Analysis in Geography Help material earen WEST function lZlSluwll ReturnsmeDrnhahilityzssuciztedwi asluuemsrresl Use Tl39EGHuaeterminewhetherrwuszm eszrelikewrunzyecume rmmmesamemaunnervinguepuialmnsmanmemesamemean Syntax WESTlarr H arrayZlailS lypev Array1 isthe rsmztzszt ArrayZ is me second data set Tails speci esthenunmerufdistrmutiuntails irlalis rrgsr useslhe unsrtziled distribution Nails 2 WESTusestlietwnrtziled distribution Type is the ma ultrTesHD permrm WEvrelHElp x r g m n Quantitative Analysis in Geography 2 Interface K H quot 39 a Li Workbook g F j New RKentDommzuls l a woven lll Workbook l3 Aworkbook the H main application consists of number i of worksheets lquot New l 39 Open 39 Save 1 l Emu y lg Qase Extel Ugl L jt tel l University of WisconsinMilwaukee 2 Worksheet Interface Worksheet Quantitative Analysis in Geography Worksheets are composed of Rows and Columns Inserting a new worksheet Namingdeletingcopying a worksheet University of WisconsinMilwaukee Quantitative Analysis in Geography 2 Interface Formula Bar J Microsoft Evcel Ham Insert Page Layam Fammlas Dara Renew View E 1 w a 4 l l j 1J1 a El FarmulaBar 1 1m awrs l A J Gnannes J Headings a Page PageBrEzk Custom Full l 7 Zoom man 1110th New Anange Layout Prewew mews sueen H39rquot Seiemon Window Lll Workbook Vltwi l Shaw Hide Zoom I 029 39 Formula Bay L A H i vlemherarmmeaar lawmmau Wm H a revlenanararmmasmee D E r cell income J i Mizms hEh El insert Paqelayam uglg Did meulas um Renew Vraw Funnula ar r 73L E EDENquot w l J Grldllnes 7 r J Hea mgs Hmz 39w a a Page Pagz reak usram mu Zoom 1mm Znamta new Arrange Frieze rayaux Premew fliwf Srreen Selimun window All Panas39 7 Wauaaou View 5mm Hrde aam Windsz zaou l Zumraflbalm mace E c E F G H l J K L M N be 1 in l University of WisconsinMilwaukee Quantitative Analysis in Geography 2 Interface Insert Chart A gistr duff r a 1 v Q i Microsoft Excel 3 Home Insert Page Layout Formulas Data Quantitative Analysis in Geography 2 Interface Statistical analysis tools 3 MlUDSD Excel Home Insert Pagelayuur l Formulas l Data Review View view Jail Review View 7 7 lw gaaneanoimmoeaar j z m l m l ig i z PivutTahie Tania Pizture ail WI Checking v insert lAutoSum Recently Flnanzial Logical Text Datea Luukupamp Math iror Name a A h Function v Ussd v nme Referama39 ampTrig39 FmeiIoni39 Manager Elf AVEDEV H M Farmula Clip shapes SmartAn Calumn Lin PIE Bar Area Scatter other Hyperlink Text Header WordArt Signal Function Library Art v v v v v v Charts39 Bax ampFoater v Lme 7 Tables Illustrations Charts n Links Text lnsen Function Ll Insert Chart 7 Temnlates meanned Or select a gategory Most Recently Used ll 1 c E 7 7 7 7 7 Select a Function ial 5 Li 7 SAVEIRAQ 53m r 3 392 tit IF 7 MMQMQ L A HYPERLINK ad Surface icount lgll Pi RANDO lg Daughm r w a V 7 x m Returns a random number greater than or equal to U and less than 1J evenly tr Bubble amp W Q54 distributed changes on recalculation a Radar Ba m Egl lljil Lil 7 E Eil rjl ail ii WEQ WP B ESr l emmmm l El Help onthisfunction 39 University of WisconsinMilwaukee University of WisconsinMilwaukee Quantitative Analysis in Geography Quantitative Analysis in Geography 7 l 3 Data input 3 Data Input W a Microsoft Excel l Home Insert Page iame Farmuras Data Review Vicw 9 Cut Labels Values Anal 10 is i i ggriv Em mp r General 7 Cop ate 7 g V 0110 V ormmm in 1 g ii A i i glassware is x Vila Cllphaam 7 Font 7 Allgnrilenl l l 7 7 ri Number W7 l roRxAc v ll V Labels aromaminer me h E F G H J4 Formula Bar Labels are alphabetic alphanumeric or numeric text on which you do not perform 1 mathematical calculations 1 1 Values 1 Values are numbers on which you perform 1 mathematical calculations on the left side of the Formula bar Cell entries are displayed on the right side of the K J k Formula bar window J University of WisconsinMilwaukee University of WisconsinMilwaukee Cell Data range Cell A column and row intersection is referred as a cell Data Range A data range consists of several cells for example A1 D10 Quantitative Analysis in Geography 3 Data input PUnwerSny of WisconsinMilwaukee a v 3 J Hamel lnsm 3 Data input J Anal A i PaglLayaul in A i i n I i ia h39Aquot 5 ram xgx mmuias LLLk Quantitative Analysis in Geography Microsufr Ems um Realm Vim avi gwrapvm Genuai il39i l ilii ungsaamV is I v new uranium Numbu Data Range Starting from cell A1 to cell D10 A1D10 Cell address Example Cell C10 is located where column C and row 10 intersect each other Quantitative Analysis in Geography 3 Data input Data format i am i Fi Pratecllun Number itgnmentr Font Number Number of decimal 332quot places could be Time 232 controlled Text In text format numbers are also treated as text umber is used for general display or numbers twenty and mounting offer Specialized annatting for monetary value Date amp Currency Several types University of WisconsinMilwaukee Importing data Importing data from text files example Quantitative Analysis in Geography Vi University of WisconsinMilwaukee Quantitative Analysis in Geography Quantitative Analysis in Geography 4 Data presentation 4 Data presentation Sorting data I Filtering data em J a Custom Auto filter Home Insert Page Layout Formulas Dara Rcvrew wew C ustom Auto Fille r 3 5 n i39 1 393 5 lza39JCGrmemW A 39 shuwrnwswhere a V A 4 id do u an i W3 4 ur l r r lrrum From From FlomOthEr Exrslinq Reiresh Sari arm I iAuess Web Taxt Suurr s39 Cannedrons Arr 1 equals m ll ill GelExtemalData nnnemam sortsmiter And our M M Use to represent any srngle charatter Use m represent any series of characters Advanced Filter e e H Sorting alphabetically numerically etc 39 Liquot gt AgZilterthelismnplace mar Cagfents o D ascend n g 0 cm to another lncation Easte my List range m r 39 giteria range Insencamment 1 sgnrargesnu Smallest Earmariellsm Putseleded geii alarOnTup Lmlir Picg From Dropdown List Put Selected font Colur On tau J g E a Elumuuerecordsonly I f Z2 ZZZ quot quot J K i m J University of WisconsinMilwaukee m University of WisconsinMilwaukee Ir Er Quantitative Analysis in Geography 5 Output from Excel Quantitative Analysis in Geography 4 Data presentation Tables Data organized in form of tables Moving around is not easy Printing Meaningful interpretation of long data tables is Graphs very difficult Summary tables are beneficial Tables Set the print area H q a i Microsoft Excel Home Insert l Page Layuut i Formulas Data Revrlw View cmurs E3 Fonts 39 Heading row Adding borders l 7 quot imam Autumatiz39 Grialmes gt l 7 El 9y Height Automatit v I Vle Formattlng text lThernesEJE anS wrargrnsOrrenfarron SIZE greats Background 58 100 mm 1 I I I Theme 7 i 7 pa x EtP A r Salet0Fli r SneetC nghllghtlng Cells want 39 Eooli Commenmirn Mode j k E C I D l E F G H l J V J University of WisconsinMilwaukee University of WisconsinMilwaukee

### BOOM! Enjoy Your Free Notes!

We've added these Notes to your profile, click here to view them now.

### You're already Subscribed!

Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'

## Why people love StudySoup

#### "Knowing I can count on the Elite Notetaker in my class allows me to focus on what the professor is saying instead of just scribbling notes the whole time and falling behind."

#### "Selling my MCAT study guides and notes has been a great source of side revenue while I'm in school. Some months I'm making over $500! Plus, it makes me happy knowing that I'm helping future med students with their MCAT."

#### "Knowing I can count on the Elite Notetaker in my class allows me to focus on what the professor is saying instead of just scribbling notes the whole time and falling behind."

#### "Their 'Elite Notetakers' are making over $1,200/month in sales by creating high quality content that helps their classmates in a time of need."

### Refund Policy

#### STUDYSOUP CANCELLATION POLICY

All subscriptions to StudySoup are paid in full at the time of subscribing. To change your credit card information or to cancel your subscription, go to "Edit Settings". All credit card information will be available there. If you should decide to cancel your subscription, it will continue to be valid until the next payment period, as all payments for the current period were made in advance. For special circumstances, please email support@studysoup.com

#### STUDYSOUP REFUND POLICY

StudySoup has more than 1 million course-specific study resources to help students study smarter. If you’re having trouble finding what you’re looking for, our customer support team can help you find what you need! Feel free to contact them here: support@studysoup.com

Recurring Subscriptions: If you have canceled your recurring subscription on the day of renewal and have not downloaded any documents, you may request a refund by submitting an email to support@studysoup.com

Satisfaction Guarantee: If you’re not satisfied with your subscription, you can contact us for further help. Contact must be made within 3 business days of your subscription purchase and your refund request will be subject for review.

Please Note: Refunds can never be provided more than 30 days after the initial purchase date regardless of your activity on the site.