전체 글 (23) 썸네일형 리스트형 [Coursera] Course 5. Analyze Data to Answer Questions WEEK1 - Organizing data to begin analysis [Definition] -Filtering: Showing only the data that meets a specific criteria while hiding the rest -Sorting: When you arrange data into a meaningful order to make it easier to understand, analyze, and visualize Sort sheet: All of the data in a spreadsheet is sorted by the ranking of a specific sorted column - data across rows is kept together Sort range.. Margin of error calculator https://goodcalculators.com/margin-of-error-calculator/ Margin of Error (MOE) Calculator | Good Calculators This simple margin of error (MOE) calculator can be employed to compute the MOE of a survey in accordance with the sample proportion and size, and the desired confidence level. You can use the calculator to compute the MOE in four simple steps: Use the dro goodcalculators.com https://www.c.. Sample size calculator https://www.surveymonkey.com/mp/sample-size-calculator/ Sample Size Calculator: Understanding Sample Sizes | SurveyMonkey Find out if you have enough people to take your survey. Our sample size calculator can help determine if you have a statistically significant sample size. www.surveymonkey.com http://www.raosoft.com/samplesize.html Sample Size Calculator by Raosoft, Inc. If 50% of all the peo.. [Coursera] Course 4. Process Data from Dirty to Clean WEEK 1 - The importance of integrity [Definition] -Data integrity: The accuracy, completeness, consistency, and trustworthiness of data throughout its lifecycle -Data replication: The process of storing data in multiple locations -Data transfer: The process of copying data from a storage device to memory, or from one computer to another -Data manipulation: The process of changing data to make it.. Regular Expression [Tutorial] https://www.regular-expressions.info/tutorialcnt.html Regular Expression Tutorial Table of Contents Regular Expressions Tutorial Table of Contents This regular expressions tutorial teaches you every aspect of regular expressions. Each topic assumes you have read and understood all previous topics. If you are new to regular expressions, you should read th www.regular-expressions.info [.. Sites for open data U.S. government data: https://data.gov/ Data.gov Home - Data.gov data.gov U.S. Census Bureau: https://www.census.gov/data.html Data Access demographic, economic and population data from the U.S. Census Bureau. Explore census data with visualizations and view tutorials. www.census.gov Open Data Network: https://www.opendatanetwork.com/ Open Data Network Open Data Network Publish data and share. F.. [Coursera] Course 3. Prepare Data for Exploration WEEK 1 - Data types and structures [Definition] First-party data Second-party data Third-party data Data collected by an individual or group using their own resources Data collected by a group directly from its audience and the sold Data collected from outside sources who did not collect it directly Discrete data Continuous data Data that is counted and has a limited number of values Data that i.. 새로 알게 된 기능 =TEXT(B2, "mmmm") Convert a number into text according to a specified format. In this case, you want to list the months of the year. You can use the format “mmmm” for the full name of the month. =COUNTIF('raw data'!G:G,A2) Count how many items in a range of cells meet a given criterion. In cell B2, type =COUNTIF('raw data'!G:G,A2). The first entry ('raw data'!G:G) refers to the range where you a.. 이전 1 2 3 다음
