Newsroom math and statistics Calculate and use: percentage change, medians, rates, ranges, averages, quartiles.Use standard deviation to identify outliers.Know what correlation and linear regression are.Looking for patterns Data analysis is finding patterns.Finding evidence beyond anecdotes.And finding anecdotes too. Newsroom math Bad news: Mathematical mistakes harm your credibility.Good news: Newsroom math is easy: add, s.. 더보기 Scraping a webpage table with a Google Drive spreadsheet Scraping a webpage table with a Google Drive spreadsheet:The address or URL in quotation marks.What you want to scrape – a table or list – in quotation marks.Which one you want to scrape.=ImportHtml("URL","query",index)A FIFA webpage that publishes information on football agents in CyprusFormula for the first table on the page:=ImportHtml(“http://www.fifa.com/aboutfifa/organisation/footballgover.. 더보기 Improve your Google searches The focus of this section is advanced search techniques:What sort of information you want.Where information might be.Improve your Google searchesImagine what the page you are searching for, might look like. 1) Search operators Search with an exact phrase Quotation marks – crime statistics versus “crime statistics”Narrow your search A minus sign to exclude – “crime statistics” versus “crime stati.. 더보기 이전 1 ··· 39 40 41 42 43 44 45 ··· 57 다음