{"product_id":"data-skills-for-media-professionals-9781119118961","title":"Data Skills for Media Professionals","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp\u003e\u003cb\u003eTeaches the basic, yet all-important, data skills required by today's media professionals\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe authors of \u003ci\u003eData Skills for Media Professionals\u003c\/i\u003e have assembled a book that teaches key aspects of data analysis, interactive data visualization and online map-making through an introduction to Google Drive, Google Sheets, and Google My Maps, all free, highly intuitive, platform-agnostic tools available to any reader with a computer and a web connection. Delegating the math and design work to these apps leaves readers free to do the kinds of thinking that media professionals do most often: considering what questions to ask, how to ask them, and how to evaluate and communicate the answers.\u003c\/p\u003e \u003cp\u003eAlthough focused on Google apps, the book draws upon complementary aspects of the free QGIS geographic information system, the free XLMiner Analysis ToolPak Add-on for Google Sheets, and the ubiquitous Microsoft Excel spreadsheet application. Worked examples rely on frequently upd\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003ePreface ix\u003c\/p\u003e \u003cp\u003e\u003cb\u003e1 Basic Data Analysis 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSome Example Data 1\u003c\/p\u003e \u003cp\u003eAn Introductory Tool: Google Sheets 3\u003c\/p\u003e \u003cp\u003eGetting the Data into a Google Sheet 4\u003c\/p\u003e \u003cp\u003eGetting a Fixed Copy of the Data 9\u003c\/p\u003e \u003cp\u003eFormatting the Data 11\u003c\/p\u003e \u003cp\u003eCleaning the Data 12\u003c\/p\u003e \u003cp\u003ePlanning your Analysis 13\u003c\/p\u003e \u003cp\u003eFiltering 14\u003c\/p\u003e \u003cp\u003eCalculating 17\u003c\/p\u003e \u003cp\u003eLabeling and Tidying Up 21\u003c\/p\u003e \u003cp\u003eSorting 22\u003c\/p\u003e \u003cp\u003eWhere’s the “Save” Button? 24\u003c\/p\u003e \u003cp\u003eWriting About the Analysis Results 24\u003c\/p\u003e \u003cp\u003eRecap 26\u003c\/p\u003e \u003cp\u003eReferences 26\u003c\/p\u003e \u003cp\u003e\u003cb\u003e2 Data Visualization 27\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePreparing Your Data 28\u003c\/p\u003e \u003cp\u003eMaking a Column Chart 29\u003c\/p\u003e \u003cp\u003ePublishing the Chart to the Web 33\u003c\/p\u003e \u003cp\u003eChoosing the Right Type of Chart 35\u003c\/p\u003e \u003cp\u003eRecap 41\u003c\/p\u003e \u003cp\u003eReferences 41\u003c\/p\u003e \u003cp\u003e\u003cb\u003e3 Making Online Maps 43\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDownloading a Shapefile 44\u003c\/p\u003e \u003cp\u003eImporting the Shapefile into QGIS 45\u003c\/p\u003e \u003cp\u003eExamining the Shapefile and Joining it with the Unemployment Data 47\u003c\/p\u003e \u003cp\u003eCustomizing and Publishing the Map File with Google My Maps 54\u003c\/p\u003e \u003cp\u003eMapping Specific Points with Latitude and Longitude Coordinates 64\u003c\/p\u003e \u003cp\u003eMapping Specific Points with Addresses 73\u003c\/p\u003e \u003cp\u003eMaking a Map When You Have no Geolocation Data to Import 77\u003c\/p\u003e \u003cp\u003eRecap 83\u003c\/p\u003e \u003cp\u003eReferences 84\u003c\/p\u003e \u003cp\u003e\u003cb\u003e4 Microsoft Excel and PivotTables 85\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing PivotTables 85\u003c\/p\u003e \u003cp\u003eGetting Started: Aggregating Contributions by City 89\u003c\/p\u003e \u003cp\u003eUsing the PivotTable Tool’s “Filters” Box 92\u003c\/p\u003e \u003cp\u003eUsing the PivotTable Tool’s “Columns” Box 94\u003c\/p\u003e \u003cp\u003eInvestigating Relatedness 96\u003c\/p\u003e \u003cp\u003eSpotting the Absence of a Relationship 105\u003c\/p\u003e \u003cp\u003eDownloading Campaign Finance Data from the Federal Election Commission 107\u003c\/p\u003e \u003cp\u003eExcel vs. Google Sheets 111\u003c\/p\u003e \u003cp\u003eRecap 112\u003c\/p\u003e \u003cp\u003eReferences 113\u003c\/p\u003e \u003cp\u003e\u003cb\u003e5 Matching Records with Excel’s VLOOKUP 115\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOverview 118\u003c\/p\u003e \u003cp\u003eAggregating each Candidate’s Donations by Source 119\u003c\/p\u003e \u003cp\u003eUsing VLOOKUP 122\u003c\/p\u003e \u003cp\u003eUsing Filters to Create a Classification Column 127\u003c\/p\u003e \u003cp\u003eVLOOKUP Pitfalls 129\u003c\/p\u003e \u003cp\u003eRecap 131\u003c\/p\u003e \u003cp\u003eReferences 131\u003c\/p\u003e \u003cp\u003e\u003cb\u003e6 Google Sheets and Inferential Statistics 133\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSampling and Assumptions of Inferential Statistics 134\u003c\/p\u003e \u003cp\u003eGetting the Data and Installing the XLMiner Google Sheets Add‐on 136\u003c\/p\u003e \u003cp\u003eComputing and Understanding Basic Inferential Statistics 138\u003c\/p\u003e \u003cp\u003eDescriptive Statistics and Confidence Intervals 140\u003c\/p\u003e \u003cp\u003eThe One‐sample T‐test 143\u003c\/p\u003e \u003cp\u003eThe One‐sample Chi‐square Test 148\u003c\/p\u003e \u003cp\u003eKnowing which Test to Use 152\u003c\/p\u003e \u003cp\u003eComputing and Understanding Basic Bivariate Statistics 154\u003c\/p\u003e \u003cp\u003eTwo‐sample T‐tests 154\u003c\/p\u003e \u003cp\u003eChi‐square Analysis of a PivotTable 158\u003c\/p\u003e \u003cp\u003eCorrelation Between Two Continuous Variables: Regression 164\u003c\/p\u003e \u003cp\u003eRecap 169\u003c\/p\u003e \u003cp\u003eReferences 170\u003c\/p\u003e \u003cp\u003e\u003cb\u003e7 Other Functions, Tools and Techniques 171\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDATE, NOW, and DATEDIF 171\u003c\/p\u003e \u003cp\u003eAVERAGE, STDEV, MEDIAN, MIN, MAX 173\u003c\/p\u003e \u003cp\u003eRAND 175\u003c\/p\u003e \u003cp\u003eLEFT, MID, and RIGHT 175\u003c\/p\u003e \u003cp\u003eThe “Text to Columns” Wizard 177\u003c\/p\u003e \u003cp\u003eCONCATENATE 179\u003c\/p\u003e \u003cp\u003eIF and IFS 180\u003c\/p\u003e \u003cp\u003eIFERROR 182\u003c\/p\u003e \u003cp\u003eCOMBIN and PERMUT 183\u003c\/p\u003e \u003cp\u003eGoogle Forms 184\u003c\/p\u003e \u003cp\u003eComparing Numbers Over Time 187\u003c\/p\u003e \u003cp\u003eAdjusting for Inflation 187\u003c\/p\u003e \u003cp\u003eAdjusting for Population Changes 188\u003c\/p\u003e \u003cp\u003eRecap 190\u003c\/p\u003e \u003cp\u003eReferences 190\u003c\/p\u003e \u003cp\u003eIndex 191\u003c\/p\u003e","brand":"John Wiley and Sons Ltd","offers":[{"title":"Default Title","offer_id":49406991171927,"sku":"9781119118961","price":27.5,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781119118961.jpg?v=1730497807","url":"https:\/\/bookcurl.com\/products\/data-skills-for-media-professionals-9781119118961","provider":"Book Curl","version":"1.0","type":"link"}