Search.setIndex({"docnames": ["basic_descriptive_statistics/count_and_sum", "basic_descriptive_statistics/introduction", "basic_descriptive_statistics/measures_of_center", "basic_descriptive_statistics/measures_of_spread", "basic_descriptive_statistics/minimum_and_maximum", "basic_descriptive_statistics/outliers_and_skew", "basic_descriptive_statistics/summary", "basic_descriptive_statistics/toctree", "basic_descriptive_statistics/variables", "basic_descriptive_statistics/what_is_a_statistic", "filtering_and_grouping/filtering_data", "filtering_and_grouping/grouping_data", "filtering_and_grouping/introduction", "filtering_and_grouping/summary", "filtering_and_grouping/toctree", "importing_and_exporting_data/exporting_data", "importing_and_exporting_data/importing_data", "importing_and_exporting_data/summary", "importing_and_exporting_data/toctree", "index", "introduction_to_visualizations/creating_visualizations_checklist", "introduction_to_visualizations/example_visualizations", "introduction_to_visualizations/histograms_and_bar_charts", "introduction_to_visualizations/introduction", "introduction_to_visualizations/reading_visualizations_checklist", "introduction_to_visualizations/summary", "introduction_to_visualizations/toctree", "manipulating_data/introduction", "manipulating_data/joining_data", "manipulating_data/pivot_tables", "manipulating_data/summary", "manipulating_data/toctree", "module_a_preface", "module_b_preface", "module_c_preface", "projects/module_a", "projects/module_b", "projects/module_c", "projects/toctree", "regression_and_line_of_best_fit/creating_line_of_best_fit", "regression_and_line_of_best_fit/equation_of_a_line_refresher", "regression_and_line_of_best_fit/interpreting_slope", "regression_and_line_of_best_fit/introduction", "regression_and_line_of_best_fit/making_predictions_with_the_regression_line", "regression_and_line_of_best_fit/nonlinear_regression", "regression_and_line_of_best_fit/outliers", "regression_and_line_of_best_fit/summary", "regression_and_line_of_best_fit/toctree", "scatter_plots_and_correlation/correlation", "scatter_plots_and_correlation/correlation_and_college_data", "scatter_plots_and_correlation/correlation_and_filtering", "scatter_plots_and_correlation/correlation_versus_causation", "scatter_plots_and_correlation/creating_a_scatter_plot_in_sheets", "scatter_plots_and_correlation/describing_scatter_plots", "scatter_plots_and_correlation/introduction", "scatter_plots_and_correlation/motivating_scatterplots", "scatter_plots_and_correlation/scatter_plots", "scatter_plots_and_correlation/summary", "scatter_plots_and_correlation/toctree", "sheets_basics/errors", "sheets_basics/introduction", "sheets_basics/summary", "sheets_basics/toctree", "sheets_basics/what_is_a_formula", "sheets_basics/what_is_a_sheet", "sql/aggregating", "sql/filtering", "sql/how_to_run_sql", "sql/ifs_and_cases", "sql/introduction", "sql/joining", "sql/selecting", "sql/sorting", "sql/summary", "sql/toctree"], "filenames": ["basic_descriptive_statistics/count_and_sum.rst", "basic_descriptive_statistics/introduction.rst", "basic_descriptive_statistics/measures_of_center.rst", "basic_descriptive_statistics/measures_of_spread.rst", "basic_descriptive_statistics/minimum_and_maximum.rst", "basic_descriptive_statistics/outliers_and_skew.rst", "basic_descriptive_statistics/summary.rst", "basic_descriptive_statistics/toctree.rst", "basic_descriptive_statistics/variables.rst", "basic_descriptive_statistics/what_is_a_statistic.rst", "filtering_and_grouping/filtering_data.rst", "filtering_and_grouping/grouping_data.rst", "filtering_and_grouping/introduction.rst", "filtering_and_grouping/summary.rst", "filtering_and_grouping/toctree.rst", "importing_and_exporting_data/exporting_data.rst", "importing_and_exporting_data/importing_data.rst", "importing_and_exporting_data/summary.rst", "importing_and_exporting_data/toctree.rst", "index.rst", "introduction_to_visualizations/creating_visualizations_checklist.rst", "introduction_to_visualizations/example_visualizations.rst", "introduction_to_visualizations/histograms_and_bar_charts.rst", "introduction_to_visualizations/introduction.rst", "introduction_to_visualizations/reading_visualizations_checklist.rst", "introduction_to_visualizations/summary.rst", "introduction_to_visualizations/toctree.rst", "manipulating_data/introduction.rst", "manipulating_data/joining_data.rst", "manipulating_data/pivot_tables.rst", "manipulating_data/summary.rst", "manipulating_data/toctree.rst", "module_a_preface.rst", "module_b_preface.rst", "module_c_preface.rst", "projects/module_a.rst", "projects/module_b.rst", "projects/module_c.rst", "projects/toctree.rst", "regression_and_line_of_best_fit/creating_line_of_best_fit.rst", "regression_and_line_of_best_fit/equation_of_a_line_refresher.rst", "regression_and_line_of_best_fit/interpreting_slope.rst", "regression_and_line_of_best_fit/introduction.rst", "regression_and_line_of_best_fit/making_predictions_with_the_regression_line.rst", "regression_and_line_of_best_fit/nonlinear_regression.rst", "regression_and_line_of_best_fit/outliers.rst", "regression_and_line_of_best_fit/summary.rst", "regression_and_line_of_best_fit/toctree.rst", "scatter_plots_and_correlation/correlation.rst", "scatter_plots_and_correlation/correlation_and_college_data.rst", "scatter_plots_and_correlation/correlation_and_filtering.rst", "scatter_plots_and_correlation/correlation_versus_causation.rst", "scatter_plots_and_correlation/creating_a_scatter_plot_in_sheets.rst", "scatter_plots_and_correlation/describing_scatter_plots.rst", "scatter_plots_and_correlation/introduction.rst", "scatter_plots_and_correlation/motivating_scatterplots.rst", "scatter_plots_and_correlation/scatter_plots.rst", "scatter_plots_and_correlation/summary.rst", "scatter_plots_and_correlation/toctree.rst", "sheets_basics/errors.rst", "sheets_basics/introduction.rst", "sheets_basics/summary.rst", "sheets_basics/toctree.rst", "sheets_basics/what_is_a_formula.rst", "sheets_basics/what_is_a_sheet.rst", "sql/aggregating.rst", "sql/filtering.rst", "sql/how_to_run_sql.rst", "sql/ifs_and_cases.rst", "sql/introduction.rst", "sql/joining.rst", "sql/selecting.rst", "sql/sorting.rst", "sql/summary.rst", "sql/toctree.rst"], "titles": ["Count and Sum", "Introduction", "Measures of Center", "Measures of Spread", "Minimum and Maximum", "Outliers and Skew", "Summary", "Basic Descriptive Statistics", "Variables", "What Is A Statistic?", "Filtering Data", "Grouping Data", "Introduction", "Summary", "Filtering and Grouping", "Exporting Data", "Importing Data", "Summary", "Importing and Exporting Data", "Applied Computing 1 Textbook", "Checklist for Creating Visualizations", "Example Visualizations", "Histograms and Bar Charts", "Introduction", "Checklist for Reading Visualizations", "Summary", "Introduction To Visualizations", "Introduction", "Joining Data", "Pivot Tables", "Summary", "Manipulating Data", "Module A Preface", "Module B Preface", "Module C Preface", "Module A", "Module B", "Module C", "Projects", "Creating a Line of Best Fit", "Equation of a Line (Refresher)", "Interpreting Slope", "Introduction", "Making Predictions with the Regression Line", "Non-Linear Regression", "Outliers", "Summary", "Regression and \u201cLine of Best Fit\u201d", "Correlation", "Example: Correlation and College Data", "Correlation and Filtering", "Correlation versus Causation", "Creating a Scatter Plot in Sheets", "Describing Scatter Plots", "Introduction", "Motivating Scatterplots", "Scatter Plots", "Summary", "Scatter Plots and Correlation", "Errors", "Introduction", "Summary", "Sheets Basics", "What Is A Formula?", "What is a Sheet?", "Aggregating", "Filtering", "How to Run SQL Outside of This Textbook", "Ifs and Cases", "Introduction", "Joining", "Selecting", "Sorting", "Summary", "SQL"], "terms": {"count_and_sum": 0, "two": [0, 1, 2, 3, 4, 5, 8, 10, 11, 22, 28, 29, 33, 35, 36, 37, 40, 41, 42, 45, 48, 49, 51, 52, 54, 55, 56, 63, 65, 70], "most": [0, 1, 2, 3, 4, 5, 8, 9, 10, 11, 15, 16, 22, 23, 28, 29, 33, 36, 37, 41, 43, 49, 53, 54, 55, 63, 64, 65, 67, 68, 69, 70, 72], "basic": [0, 19, 32, 35, 60, 67, 68], "us": [0, 1, 2, 3, 4, 5, 8, 9, 10, 11, 12, 15, 16, 20, 23, 24, 26, 27, 28, 29, 32, 33, 34, 35, 36, 37, 39, 41, 42, 43, 45, 48, 49, 50, 52, 54, 55, 56, 59, 60, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72], "statist": [0, 1, 2, 3, 4, 5, 8, 11, 19, 21, 27, 31, 32, 33, 35, 36, 37, 45, 60, 65], "ar": [0, 1, 2, 3, 4, 5, 8, 9, 10, 11, 12, 15, 16, 20, 22, 24, 28, 29, 32, 33, 34, 35, 36, 37, 41, 42, 44, 45, 48, 50, 51, 53, 54, 55, 56, 59, 60, 63, 64, 65, 66, 67, 68, 70, 71, 72], "dataset": [0, 2, 3, 4, 5, 8, 9, 10, 11, 12, 15, 16, 28, 29, 33, 35, 36, 37, 41, 44, 45, 49, 50, 55, 56, 63, 64, 67, 69, 71], "The": [0, 1, 3, 4, 5, 8, 9, 10, 11, 15, 16, 20, 22, 24, 28, 29, 32, 35, 36, 37, 40, 41, 42, 43, 44, 45, 48, 49, 51, 53, 56, 59, 62, 64, 68, 70, 71, 72, 74], "i": [0, 1, 2, 3, 4, 5, 7, 8, 10, 11, 12, 15, 16, 19, 21, 22, 23, 26, 28, 29, 32, 33, 34, 35, 36, 37, 39, 40, 41, 42, 43, 44, 45, 48, 49, 50, 51, 52, 53, 54, 55, 56, 59, 60, 62, 65, 66, 68, 69, 70, 71, 72], "number": [0, 2, 4, 5, 8, 10, 11, 12, 22, 23, 28, 29, 32, 36, 41, 43, 44, 48, 50, 51, 53, 55, 63, 64, 66, 68, 70, 71, 72, 74], "observ": [0, 2, 5, 8, 11, 36, 37, 63, 64], "thi": [0, 2, 3, 4, 5, 8, 9, 10, 11, 12, 15, 16, 19, 20, 21, 22, 23, 24, 27, 28, 29, 32, 33, 34, 35, 36, 37, 39, 40, 41, 42, 43, 44, 45, 48, 49, 50, 51, 52, 53, 54, 55, 56, 59, 60, 63, 64, 65, 66, 68, 69, 70, 71, 72, 74], "appli": [0, 3, 4, 8, 10, 11, 12, 32, 49, 55, 66, 72], "all": [0, 2, 3, 4, 5, 8, 9, 10, 11, 20, 21, 22, 24, 28, 29, 32, 34, 36, 37, 40, 44, 45, 48, 49, 55, 59, 63, 64, 65, 66, 70, 71], "variabl": [0, 2, 3, 4, 5, 7, 19, 22, 28, 29, 33, 36, 37, 40, 41, 42, 43, 45, 48, 49, 50, 51, 52, 53, 54, 55, 56], "addit": [0, 20, 29, 36, 37, 40, 69, 70], "valu": [0, 2, 3, 4, 5, 8, 10, 11, 16, 22, 28, 29, 36, 37, 39, 40, 41, 42, 45, 48, 50, 53, 56, 59, 63, 64, 68, 70, 72, 74], "onli": [0, 2, 3, 4, 5, 8, 10, 11, 12, 26, 28, 29, 32, 35, 36, 37, 43, 44, 48, 49, 50, 56, 63, 65, 66, 68, 70], "quantit": [0, 2, 4, 5, 8, 29, 36, 37, 42, 45, 48, 50, 54, 56], "reason": [0, 28, 43, 44, 45, 51], "so": [0, 1, 3, 4, 8, 10, 11, 15, 20, 28, 29, 32, 33, 41, 42, 43, 44, 45, 49, 50, 51, 53, 55, 56, 59, 63, 64, 68, 69, 71, 72], "import": [0, 1, 8, 9, 15, 19, 20, 22, 24, 28, 32, 33, 36, 37, 45, 50, 51, 53, 63, 67], "can": [0, 2, 3, 4, 5, 8, 9, 10, 11, 12, 15, 16, 20, 22, 23, 24, 27, 28, 29, 32, 34, 35, 36, 37, 39, 40, 41, 42, 43, 44, 45, 48, 49, 50, 51, 53, 54, 55, 56, 59, 60, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72], "an": [0, 2, 3, 4, 5, 8, 10, 11, 12, 15, 21, 22, 23, 24, 28, 29, 35, 36, 37, 39, 40, 41, 42, 43, 45, 48, 49, 50, 51, 54, 55, 59, 63, 64, 65, 67, 68, 70, 71], "indic": [0, 2, 3, 4, 20, 22, 41, 44, 45, 53, 55, 59, 63, 68], "how": [0, 1, 2, 3, 4, 5, 8, 9, 10, 11, 12, 15, 19, 20, 21, 22, 23, 24, 27, 28, 29, 32, 33, 34, 35, 36, 37, 39, 41, 42, 43, 48, 49, 50, 53, 54, 55, 58, 59, 63, 65, 66, 69, 70, 71, 74], "For": [0, 3, 4, 5, 8, 9, 10, 11, 12, 15, 16, 20, 22, 24, 28, 29, 32, 33, 35, 36, 37, 40, 41, 44, 45, 49, 50, 51, 53, 55, 56, 63, 64, 65, 66, 68, 70, 71, 72], "suppos": [0, 3, 4, 8, 9, 10, 11, 28, 29, 41, 43, 49, 51, 63, 65, 68, 70, 71], "you": [0, 1, 2, 3, 4, 5, 8, 9, 10, 11, 12, 15, 16, 20, 21, 22, 23, 24, 27, 28, 29, 32, 33, 34, 35, 36, 37, 39, 40, 41, 42, 43, 44, 45, 48, 49, 50, 51, 52, 53, 54, 55, 56, 59, 60, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72], "re": [0, 4, 28, 35, 43, 48, 63], "try": [0, 3, 4, 10, 11, 20, 24, 28, 29, 33, 35, 41, 43, 44, 56, 59, 63, 65, 68, 71, 72], "find": [0, 3, 4, 5, 8, 10, 11, 23, 24, 28, 29, 32, 33, 35, 36, 37, 39, 42, 43, 44, 45, 48, 49, 50, 55, 59, 63, 65, 66, 70, 72], "averag": [0, 1, 2, 3, 5, 8, 9, 11, 23, 28, 29, 41, 42, 43, 45, 49, 51, 56, 70], "height": [0, 2, 5, 7, 8, 9, 22, 49, 53], "student": [0, 2, 4, 5, 7, 9, 22, 24, 34, 36, 41, 42, 49, 51, 60], "your": [0, 1, 2, 3, 4, 5, 8, 10, 11, 15, 16, 20, 22, 23, 24, 27, 28, 29, 32, 33, 34, 35, 36, 37, 39, 41, 42, 44, 45, 50, 51, 55, 56, 59, 63, 65, 67, 68, 71], "colleg": [0, 8, 19, 24, 32, 41, 51, 58], "800": 0, "peopl": [0, 3, 4, 9, 11, 12, 20, 22, 23, 24, 26, 28, 29, 35, 36, 37, 59, 63], "conduct": [0, 24, 71], "survei": [0, 32, 35], "collect": [0, 1, 2, 12, 32, 35, 44, 65], "If": [0, 2, 3, 10, 15, 28, 29, 35, 36, 37, 41, 42, 43, 45, 48, 50, 53, 56, 59, 63, 64, 65, 67, 68, 69], "contain": [0, 3, 4, 5, 8, 9, 10, 11, 23, 28, 35, 36, 37, 41, 45, 49, 52, 63, 64, 65, 66, 68, 70, 71], "2": [0, 2, 3, 4, 5, 8, 10, 11, 22, 28, 29, 35, 36, 37, 39, 41, 42, 45, 48, 49, 50, 51, 52, 53, 55, 56, 59, 63, 64, 65, 68], "result": [0, 4, 5, 10, 28, 29, 35, 36, 37, 39, 41, 59, 63, 65, 66, 70, 72], "calcul": [0, 2, 3, 4, 8, 11, 28, 29, 35, 36, 37, 45, 48, 49, 50, 55, 60, 63, 65, 70], "won": [0, 45], "t": [0, 3, 4, 8, 12, 28, 29, 32, 35, 36, 37, 39, 41, 43, 44, 45, 51, 53, 63, 64, 70, 71], "veri": [0, 3, 4, 11, 28, 29, 35, 36, 37, 41, 45, 51, 56, 60, 63], "sinc": [0, 1, 3, 4, 5, 8, 10, 16, 28, 32, 33, 44, 51, 55, 59, 63, 65, 68, 69, 70, 72], "summari": [0, 2, 3, 5, 7, 11, 14, 18, 19, 26, 27, 28, 29, 31, 35, 36, 37, 47, 58, 62, 65, 74], "repres": [0, 22, 29, 52, 56, 68], "howev": [0, 2, 3, 4, 8, 16, 20, 22, 28, 33, 41, 50, 51, 54, 56, 63, 67, 70, 71], "600": [0, 43], "from": [0, 2, 3, 4, 5, 8, 9, 10, 11, 12, 15, 16, 20, 23, 24, 28, 29, 32, 33, 35, 36, 37, 39, 41, 44, 45, 48, 51, 52, 53, 55, 56, 63, 64, 65, 67, 68, 69, 70, 71, 72], "more": [0, 1, 2, 3, 4, 5, 8, 9, 10, 11, 12, 15, 20, 21, 22, 23, 24, 27, 28, 29, 32, 33, 35, 36, 37, 41, 42, 43, 44, 48, 49, 50, 51, 53, 55, 56, 59, 63, 64, 66, 67, 68, 70], "reliabl": [0, 33, 36, 37, 42, 43, 44, 45, 56], "As": [0, 1, 3, 4, 8, 20, 22, 24, 28, 37, 41, 45, 48, 50, 51, 54, 63, 65, 68, 69, 72], "throw": [0, 59], "homework": 0, "parti": [0, 63], "ask": [0, 2, 4, 20, 21, 29, 35, 36, 37, 53, 56, 63, 71], "friend": [0, 34, 41, 50], "rsvp": 0, "thei": [0, 1, 2, 3, 4, 23, 28, 29, 36, 37, 50, 53, 63, 64, 65, 70], "attend": [0, 63], "submit": [0, 35, 36, 37], "mani": [0, 3, 4, 5, 8, 9, 11, 22, 29, 33, 36, 41, 53, 56, 63, 64, 65, 66, 67, 68, 69, 70], "pizza": 0, "slice": 0, "would": [0, 2, 3, 4, 5, 8, 10, 11, 22, 24, 28, 29, 35, 37, 44, 48, 49, 50, 51, 53, 56, 59, 63, 64, 65, 66, 67, 68, 69, 71], "like": [0, 2, 3, 4, 5, 8, 9, 11, 15, 16, 22, 23, 24, 29, 34, 35, 36, 37, 41, 42, 44, 45, 50, 51, 55, 59, 63, 64, 65, 67, 68, 71, 72], "eat": [0, 33, 51], "through": [0, 2, 8, 9, 10, 21, 32, 35, 37, 39, 41, 42, 44, 50, 52, 54, 60, 64, 65], "know": [0, 2, 3, 4, 8, 9, 11, 12, 15, 16, 20, 24, 28, 32, 41, 49, 51, 52, 55, 59, 63, 64, 69], "help": [0, 2, 3, 8, 12, 15, 28, 29, 32, 33, 35, 36, 37, 41, 42, 44, 49, 50, 59, 63, 65, 71], "when": [0, 2, 3, 4, 5, 8, 10, 11, 15, 16, 22, 23, 26, 28, 29, 32, 33, 36, 37, 41, 44, 45, 48, 50, 51, 53, 63, 64, 65, 67, 68, 69, 70, 71], "purchas": 0, "snack": 0, "guest": [0, 63], "could": [0, 2, 5, 8, 12, 22, 28, 29, 42, 43, 50, 53, 55, 56, 59, 63, 66, 68, 70, 71], "also": [0, 1, 3, 5, 8, 10, 12, 15, 20, 21, 22, 28, 29, 37, 40, 41, 45, 49, 51, 53, 63, 64, 65, 66, 68, 69, 70, 72], "take": [0, 2, 3, 5, 8, 21, 23, 28, 36, 37, 41, 55, 63, 67], "want": [0, 2, 3, 4, 8, 10, 11, 20, 22, 28, 29, 35, 36, 37, 49, 50, 55, 63, 64, 65, 66, 67, 70, 71, 72], "order": [0, 2, 4, 7, 10, 28, 29, 37, 39, 51, 55, 59, 64, 65, 67, 70, 72], "get": [0, 3, 8, 9, 22, 28, 35, 36, 37, 44, 49, 51, 53, 55, 63, 64, 69], "better": [0, 2, 3, 32, 40, 44, 51, 55, 56], "idea": [0, 3, 8, 45], "fairli": [0, 2, 22, 29, 45, 55], "straightforward": [0, 16, 22], "other": [0, 2, 3, 4, 5, 9, 10, 11, 15, 20, 22, 28, 29, 33, 34, 35, 36, 37, 41, 42, 44, 45, 49, 51, 53, 56, 63, 70], "ll": [0, 28, 29, 35, 36, 37, 42, 71], "need": [0, 4, 5, 8, 10, 11, 15, 20, 28, 29, 35, 36, 37, 39, 41, 63, 64, 67, 68, 69, 70, 71], "cell": [0, 2, 3, 4, 11, 28, 29, 52, 53, 59, 63, 64, 71], "rang": [0, 2, 3, 4, 8, 10, 11, 22, 28, 29, 43, 52, 56, 71], "notat": [0, 43, 65], "To": [0, 3, 4, 8, 11, 19, 22, 23, 28, 29, 35, 36, 37, 41, 44, 45, 49, 52, 55, 56, 63, 65, 67, 72], "refer": [0, 2, 3, 20, 22, 28, 29, 36, 37, 60, 63, 64, 65, 70], "type": [0, 2, 5, 8, 10, 15, 16, 20, 22, 24, 28, 29, 35, 36, 37, 44, 49, 50, 52, 54, 59, 63, 65, 68, 70], "first": [0, 1, 2, 3, 4, 10, 11, 22, 28, 29, 36, 37, 39, 41, 44, 45, 48, 49, 50, 52, 54, 63, 65, 68, 71, 72], "last": [0, 2, 4, 11, 29, 42, 48, 66], "separ": [0, 2, 3, 4, 12, 16, 28, 50, 55, 63], "colon": 0, "a1": [0, 2, 3, 4, 10, 28, 59, 63], "a6": 0, "mean": [0, 1, 2, 3, 4, 5, 8, 11, 23, 28, 32, 35, 36, 37, 41, 42, 45, 49, 51, 52, 53, 55, 56, 63, 64, 65, 70, 71], "A": [0, 2, 3, 5, 7, 8, 10, 19, 23, 24, 29, 34, 36, 38, 41, 42, 43, 45, 48, 50, 51, 53, 55, 62, 64, 72], "column": [0, 2, 3, 4, 8, 10, 11, 16, 22, 23, 28, 29, 34, 36, 50, 52, 55, 63, 64, 66, 68, 70, 71, 72, 74], "row": [0, 4, 10, 11, 12, 16, 28, 29, 34, 48, 50, 63, 64, 65, 66, 69, 70, 71, 72], "1": [0, 2, 3, 4, 5, 8, 9, 10, 11, 20, 21, 22, 24, 28, 29, 35, 36, 37, 40, 41, 42, 43, 45, 48, 49, 50, 51, 52, 53, 55, 56, 63, 64, 65, 68], "6": [0, 2, 3, 4, 5, 8, 11, 28, 29, 35, 36, 37, 41, 49, 53, 63, 64], "d1": 0, "d": [0, 2, 8, 29, 35, 53, 63, 71], "d6": 0, "function": [0, 2, 3, 4, 10, 12, 28, 48, 49, 50, 55, 59, 60, 65, 68, 70, 71], "return": [0, 2, 3, 4, 11, 28, 43, 45, 63, 65, 68, 70, 72], "non": [0, 8, 15, 19, 26, 28, 29, 32, 35, 36, 37, 47, 49], "empti": [0, 10, 11, 63], "roommat": 0, "have": [0, 2, 3, 5, 8, 9, 10, 11, 15, 16, 20, 22, 23, 24, 28, 29, 32, 34, 35, 36, 37, 39, 41, 42, 43, 44, 45, 48, 49, 50, 51, 52, 53, 54, 55, 56, 59, 63, 64, 66, 68, 69, 70, 71, 74], "been": [0, 5, 16, 20, 24, 28, 29, 36, 37, 41, 53, 63, 65], "famili": [0, 2], "plan": [0, 20, 67], "quit": [0, 55], "while": [0, 3, 5, 8, 11, 22, 23, 24, 28, 29, 34, 36, 37, 41, 51, 55, 60, 63, 65, 70, 71], "There": [0, 3, 4, 8, 9, 15, 20, 22, 28, 29, 35, 36, 37, 41, 51, 53, 56, 59, 60, 63, 67, 70], "five": [0, 1, 44], "allow": [0, 1, 2, 4, 10, 11, 12, 15, 29, 36, 37, 63, 65, 68, 69, 71], "up": [0, 2, 4, 10, 16, 28, 32, 34, 36, 44, 50, 53, 55, 63, 64, 67], "six": [0, 4], "account": [0, 2, 29, 36, 37], "15": [0, 28, 35], "per": [0, 1, 22, 28, 36, 37, 41, 53, 65], "month": [0, 2, 4, 8, 10, 51, 53, 55], "tight": 0, "budget": [0, 32], "littl": [0, 8, 36, 63], "cash": 0, "spare": 0, "each": [0, 2, 3, 4, 8, 10, 11, 16, 22, 23, 28, 29, 35, 36, 37, 41, 48, 49, 50, 54, 55, 56, 63, 64, 65, 67, 68, 70, 72], "gone": [0, 45], "expens": [0, 2, 4, 10], "narrow": 0, "down": [0, 4, 10, 28, 41, 53, 55, 63, 70], "exactli": [0, 3, 68], "much": [0, 1, 3, 5, 8, 15, 28, 29, 32, 33, 41, 42, 43, 44, 53, 55, 63, 69, 70], "monei": [0, 53], "now": [0, 2, 3, 4, 5, 10, 12, 20, 28, 29, 33, 36, 37, 39, 41, 45, 49, 52, 53, 55, 63, 71, 72], "pool": 0, "togeth": [0, 3, 28], "whether": [0, 2, 8, 11, 32, 35, 36, 37, 63, 68, 72], "enough": [0, 3, 22, 35, 36, 37, 51, 63], "prefer": [0, 5, 8, 22, 51], "store": [0, 16, 28, 34, 63, 64, 69, 70], "data": [0, 1, 2, 3, 4, 5, 7, 9, 12, 14, 19, 20, 22, 23, 24, 27, 29, 32, 33, 34, 35, 36, 37, 39, 41, 42, 43, 44, 45, 50, 52, 54, 55, 56, 58, 60, 63, 64, 65, 66, 68, 69, 70, 71, 72], "becaus": [0, 1, 4, 5, 8, 28, 41, 43, 44, 45, 48, 50, 51, 53, 56, 63], "ani": [0, 1, 3, 8, 9, 10, 11, 15, 16, 21, 23, 24, 29, 32, 36, 37, 41, 44, 45, 63, 64, 66, 68, 69], "were": [0, 3, 4, 10, 11, 24, 29, 36, 37, 51, 53, 56, 64, 65, 70], "chang": [0, 3, 5, 8, 10, 28, 29, 39, 41, 42, 44, 45, 53, 55, 63, 64, 69], "futur": [0, 4, 32, 35, 60], "easili": [0, 10, 12, 27, 55], "updat": [0, 15, 28, 29, 63, 64], "input": [0, 2, 3, 4, 16, 28, 59, 63], "note": [0, 2, 3, 8, 10, 11, 22, 28, 45, 48, 59, 63, 64, 65, 68, 70, 71], "click": [0, 10, 15, 16, 22, 29, 39, 52, 64, 71], "symbol": [0, 59, 63], "format": [0, 15, 16, 20, 24, 28, 36, 37], "currenc": 0, "verifi": [0, 37], "one": [0, 2, 3, 4, 5, 8, 10, 11, 22, 27, 28, 29, 33, 34, 35, 37, 39, 41, 42, 43, 45, 49, 50, 51, 55, 60, 63, 64, 65, 66, 67, 68, 69, 70, 71], "person": [0, 8, 20, 24, 33, 49, 50, 63], "add": [0, 3, 10, 28, 29, 37, 39, 45, 52, 55, 63, 64, 65], "ala": 0, "agonizingli": 0, "short": [0, 36, 37], "requir": [0, 4, 8, 63], "keep": [0, 22, 23, 26, 28, 37, 45, 63], "save": [0, 63], "just": [0, 1, 2, 3, 4, 5, 8, 10, 11, 15, 21, 22, 24, 28, 29, 32, 34, 36, 37, 41, 50, 51, 63, 65, 67, 68, 71, 72], "90": 0, "cent": [0, 28], "q": [0, 2, 3, 4, 5, 8, 9, 10, 11, 21, 22, 24, 28, 29, 41, 43, 45, 48, 49, 50, 51, 52, 53, 55, 56, 63, 64, 65, 68, 70], "who": [0, 2, 3, 10, 11, 12, 20, 22, 24, 28, 29, 32, 35, 36, 37, 41, 49, 50, 51, 63], "previous": [0, 3, 4, 10, 27, 66], "contribut": [0, 41], "ha": [0, 2, 3, 4, 5, 8, 10, 11, 12, 20, 21, 22, 24, 28, 29, 33, 35, 36, 37, 40, 41, 42, 43, 44, 45, 48, 49, 50, 53, 55, 56, 63, 65, 70, 71], "had": [0, 2, 10, 11, 12, 29, 41, 51, 53, 64, 65], "some": [0, 2, 3, 4, 5, 8, 9, 11, 12, 15, 20, 22, 23, 28, 29, 32, 34, 35, 36, 37, 41, 42, 44, 45, 48, 50, 59, 63, 65, 66, 67, 71, 72], "luck": 0, "her": [0, 50], "brother": 0, "decid": [0, 5, 29, 32, 35, 36, 37, 41, 63], "pai": [0, 10, 53], "netflix": 0, "membership": 0, "he": 0, "watch": [0, 1, 40, 49], "anywai": 0, "she": [0, 2, 41, 50], "50": [0, 3, 11, 32, 35, 36, 55, 56, 63, 64], "correct": [0, 2, 3, 4, 8, 10, 11, 22, 28, 36, 37, 41, 45, 50, 51, 52, 53, 55, 63, 64], "rememb": [0, 2, 10, 11, 28, 35, 39, 63], "decim": [0, 2, 3, 8, 11, 63], "place": [0, 8, 11, 29, 36, 37, 45, 63], "includ": [0, 4, 5, 8, 10, 20, 22, 23, 24, 28, 32, 34, 35, 36, 37, 44, 45, 56, 63, 65, 67], "incorrect": [0, 2, 3, 4, 8, 10, 11, 22, 28, 36, 37, 41, 45, 50, 51, 52, 53, 55, 63, 64], "b1": [0, 11, 59, 63], "amount": [0, 10, 23, 29, 49, 63], "between": [0, 2, 3, 5, 8, 11, 22, 28, 33, 35, 37, 40, 41, 42, 44, 45, 48, 49, 50, 51, 53, 54, 55, 56, 63], "write": [0, 2, 10, 24, 28, 36, 37, 43, 63, 65, 66, 68, 70, 71, 72], "formula": [0, 2, 10, 11, 19, 28, 29, 36, 55, 59, 62], "check": [0, 11, 15, 32, 36, 37, 44, 55, 63, 68], "should": [0, 3, 8, 10, 11, 16, 26, 28, 29, 35, 36, 37, 41, 44, 45, 51, 63, 67, 68, 71], "evalu": [0, 24, 63, 68], "true": [0, 3, 11, 28, 32, 45, 63, 68, 70, 71], "otherwis": [0, 36, 37], "fals": [0, 28, 63, 68], "print": [0, 63], "must": [0, 2, 4, 8, 28, 29, 36, 41, 63, 65, 68], "start": [0, 2, 4, 10, 16, 23, 28, 29, 36, 37, 41, 45, 50, 53, 63, 65, 66, 68, 70, 71, 72], "everywher": 1, "new": [1, 2, 3, 4, 8, 10, 11, 16, 24, 28, 29, 32, 33, 34, 37, 44, 50, 51, 52, 53, 55, 63, 64, 65, 68, 70, 71], "articl": [1, 2, 3, 5, 20, 21, 22, 23, 24, 32, 33, 51], "sport": [1, 33, 35], "govern": 1, "report": [1, 2, 5, 8, 32, 35, 36, 37, 45], "research": [1, 21, 28, 32, 35, 37, 71], "paper": [1, 36, 37], "name": [1, 8, 10, 28, 29, 32, 41, 63, 64, 65, 68, 70, 71, 72], "few": [1, 5, 10, 22, 28, 33, 35, 36, 37, 44, 53, 60, 63], "popular": [1, 4, 11, 15, 44, 67], "provid": [1, 5, 29, 36, 37, 65, 68], "evid": [1, 29], "credibl": 1, "claim": [1, 29], "here": [1, 2, 4, 5, 15, 16, 20, 22, 24, 35, 36, 37, 42, 43, 45, 48, 52, 55, 59, 63, 64, 65, 70], "exampl": [1, 7, 9, 12, 14, 15, 19, 20, 22, 23, 24, 26, 31, 32, 33, 34, 35, 36, 37, 42, 44, 45, 47, 48, 50, 51, 53, 54, 55, 56, 58, 59, 60, 62, 65, 66, 68, 70, 71, 72], "varieti": [1, 48], "field": [1, 4, 5, 11, 32, 33, 68, 69, 70], "journalist": 1, "substanti": [1, 5, 29], "polit": [1, 24], "leader": 1, "inform": [1, 2, 3, 4, 5, 9, 11, 12, 15, 20, 21, 23, 28, 29, 32, 34, 39, 41, 42, 49, 51, 64, 66, 69, 70, 71], "decis": [1, 32, 36, 37], "team": [1, 32], "busi": [1, 29], "lean": [1, 5], "heavili": 1, "algorithm": 1, "action": 1, "psychologist": 1, "give": [1, 2, 3, 11, 32, 40, 41, 43, 63, 68], "frequent": [1, 70], "misus": 1, "One": [1, 3, 28, 33, 41, 45, 56, 70], "medium": [1, 24], "which": [1, 2, 3, 4, 8, 10, 11, 15, 16, 20, 21, 22, 24, 28, 29, 32, 33, 34, 36, 37, 41, 44, 48, 49, 50, 51, 52, 53, 54, 55, 56, 60, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72], "often": [1, 5, 10, 23, 28, 29, 33, 41, 44, 50, 51, 64, 65, 70], "made": [1, 11, 45, 56, 63], "impact": [1, 20, 35, 36, 37, 41, 42, 53, 55], "world": [1, 3, 5, 16, 32, 36, 37], "around": [1, 3, 10], "": [1, 3, 4, 5, 8, 10, 20, 24, 26, 28, 29, 32, 33, 34, 35, 36, 37, 41, 43, 45, 50, 51, 53, 56, 63, 64, 65, 71], "abl": [1, 4, 20, 24, 36, 37, 49], "critic": [1, 33], "assess": [1, 32, 33, 35, 36, 37], "those": [1, 2, 3, 11, 28, 29, 32, 36, 51, 55], "consid": [1, 3, 4, 5, 8, 11, 20, 22, 24, 28, 29, 37, 44, 49, 53, 56, 63], "follow": [1, 4, 5, 8, 9, 11, 16, 20, 21, 22, 24, 28, 32, 35, 36, 37, 41, 42, 45, 48, 49, 51, 53, 55, 63, 64, 65, 67, 68, 70, 71, 72], "sentenc": [1, 35], "american": [1, 28, 29], "spend": [1, 63], "lot": [1, 3, 22, 34, 56, 63, 64, 70, 71], "time": [1, 2, 3, 4, 8, 10, 11, 20, 21, 22, 23, 24, 29, 31, 32, 33, 35, 36, 41, 43, 49, 53, 63, 64], "tv": 1, "adult": [1, 28, 53], "hour": [1, 29, 53, 65, 66, 68], "four": [1, 28, 41, 63], "minut": [1, 22, 53, 66, 68], "dai": [1, 4, 8, 29, 32], "although": [1, 50, 55], "both": [1, 3, 20, 22, 28, 36, 37, 51, 55, 63, 70], "make": [1, 2, 3, 8, 10, 16, 19, 21, 22, 23, 24, 26, 28, 29, 32, 34, 35, 36, 37, 39, 41, 42, 44, 45, 47, 50, 51, 53, 55, 56, 58, 59, 63, 64, 71], "same": [1, 2, 3, 4, 5, 10, 11, 12, 22, 28, 32, 39, 41, 43, 53, 56, 60, 63, 65, 68, 70, 71, 72], "point": [1, 2, 3, 4, 5, 16, 20, 21, 24, 28, 34, 36, 37, 40, 41, 42, 43, 44, 45, 48, 52, 53, 54, 56, 64, 71], "second": [1, 4, 22, 28, 59, 63, 65, 66, 68, 72], "specif": [1, 8, 10, 11, 20, 22, 24, 28, 29, 35, 36, 37, 41, 55, 63, 64, 65, 68], "than": [1, 2, 3, 4, 5, 8, 9, 10, 11, 15, 20, 21, 23, 28, 29, 35, 36, 37, 41, 43, 44, 45, 48, 51, 56, 63, 68, 71], "power": [1, 10, 36, 37, 60, 63], "tool": [1, 3, 4, 10, 15, 27, 28, 29, 32, 34, 55, 60], "support": [1, 8, 29, 35, 51, 59, 65], "own": [1, 3, 8, 20, 32, 33, 35, 51, 63, 64, 67], "drive": [1, 16, 53], "work": [1, 8, 16, 28, 29, 32, 35, 36, 37, 41, 42, 50, 52, 53, 54, 63], "studi": [1, 2, 24, 28, 32, 33, 35, 63], "measures_of_cent": 2, "wide": [2, 3, 15, 36, 60, 69], "describ": [2, 3, 8, 19, 36, 37, 44, 50, 58], "where": [2, 3, 5, 8, 10, 15, 16, 21, 24, 28, 32, 35, 36, 37, 40, 41, 45, 48, 49, 52, 54, 55, 56, 63, 64, 65, 66, 68, 69, 70, 72], "extrem": [2, 3, 5, 16, 45, 60, 63, 65], "summar": [2, 29, 32, 36, 37, 65], "categori": [2, 5, 8, 22, 23, 37, 50, 56], "kei": [2, 20, 21, 32, 36, 37, 64, 70, 72], "aspect": [2, 20], "call": [2, 3, 4, 5, 8, 11, 16, 22, 28, 34, 40, 42, 43, 45, 48, 51, 56, 63, 64, 70, 71], "think": [2, 3, 5, 8, 20, 21, 34, 36, 37, 41, 44, 45, 49, 50, 55, 63], "best": [2, 3, 11, 16, 19, 20, 22, 32, 36, 37, 41, 42, 44, 45, 49, 50, 63, 68], "guess": [2, 3, 45, 55, 56], "e": [2, 3, 4, 8, 11, 20, 24, 37, 43, 49, 53, 63, 64], "g": [2, 3, 4, 8, 20, 37, 63, 64], "join": [2, 19, 27, 31, 36, 37, 74], "class": [2, 3, 4, 5, 8, 9, 11, 22, 32, 35], "what": [2, 3, 4, 5, 7, 8, 10, 11, 15, 19, 22, 23, 26, 28, 29, 32, 33, 35, 36, 37, 41, 42, 45, 49, 50, 51, 52, 55, 59, 62, 65, 68, 70, 72], "standard": [2, 4, 5, 7, 8, 11, 12, 23, 35, 36, 37, 49], "form": [2, 3, 10, 20, 23, 24, 32, 35, 36, 37, 40, 49, 64], "ad": [2, 5, 29, 39, 41, 44, 45, 63], "divid": [2, 28, 29, 53, 59, 63], "defin": [2, 3, 49, 53, 64], "sometim": [2, 3, 4, 10, 22, 28, 36, 52, 54, 63, 65, 70], "simpli": [2, 3, 64, 65, 70, 71], "median": [2, 5, 28, 29, 35, 36, 37, 41, 49, 51, 65], "middl": [2, 53, 55], "lowest": [2, 10, 55, 72], "highest": [2, 4, 8, 10, 28, 29, 55, 72], "sit": 2, "directli": [2, 22, 37, 41, 51, 67], "occur": [2, 5], "even": [2, 3, 4, 15, 32, 33, 43, 45, 50, 51, 55, 60, 68], "halfwai": 2, "half": [2, 3, 8, 9], "below": [2, 3, 5, 12, 16, 20, 22, 23, 24, 28, 29, 34, 41, 43, 44, 50, 52, 53, 54, 55, 56, 59, 60, 63, 64, 65, 66, 67, 71], "abov": [2, 3, 4, 5, 8, 9, 11, 12, 15, 22, 24, 28, 29, 35, 36, 37, 40, 41, 43, 45, 48, 55, 59, 63, 64, 65, 70, 71, 72], "mode": [2, 8], "commonli": [2, 22, 29], "count": [2, 4, 7, 8, 11, 12, 19, 22, 29, 36, 68, 70, 71, 74], "common": [2, 3, 8, 9, 15, 16, 34, 36, 48, 59, 65, 70], "multipl": [2, 11, 32, 33, 36, 37, 60, 63, 65, 66, 70, 71, 72], "higher": [2, 3, 5, 11, 41, 51, 53], "categor": [2, 5, 7, 22, 37, 50, 56], "handl": [2, 32], "differ": [2, 3, 4, 5, 8, 10, 11, 16, 20, 21, 22, 23, 24, 27, 28, 29, 32, 35, 36, 37, 41, 42, 44, 50, 55, 56, 60, 63, 64, 68, 69], "tell": [2, 3, 4, 28, 41, 55, 59, 63, 64, 68], "whenev": [2, 60, 63, 65, 70, 71], "choic": [2, 20, 22, 24, 35, 44, 55], "either": [2, 3, 4, 5, 8, 10, 16, 28, 29, 35, 36, 37, 41, 48, 52, 56, 64, 65, 70], "begin": [2, 8, 28, 29, 35, 36, 37, 53, 54], "build": [2, 8], "intuit": [2, 3, 10, 51, 54], "about": [2, 3, 4, 5, 8, 11, 20, 21, 22, 23, 28, 29, 32, 33, 35, 36, 37, 41, 42, 43, 45, 48, 49, 50, 51, 53, 54, 55, 56, 63, 64, 67, 70, 71], "appropri": [2, 22, 36, 37, 51], "birth": 2, "countri": [2, 22, 23, 24, 29], "come": [2, 3, 10, 24, 35, 54, 55, 59], "kind": [2, 10, 32, 34, 69], "do": [2, 3, 4, 5, 10, 11, 20, 21, 22, 24, 27, 28, 29, 33, 35, 36, 37, 39, 45, 49, 50, 55, 59, 60, 63, 65, 67, 68, 71], "rent": 2, "apart": [2, 3], "seattl": [2, 3, 45], "york": [2, 4, 11, 24, 28], "citi": [2, 3, 4, 8, 11, 12, 44, 45, 52, 53, 55, 56], "answer": [2, 3, 4, 8, 11, 28, 29, 32, 35, 36, 37, 41, 42, 45, 50, 52, 55, 63, 64, 65, 68, 70, 72], "question": [2, 4, 8, 11, 20, 21, 28, 29, 32, 35, 36, 37, 41, 42, 45, 48, 50, 52, 55, 63, 64, 65, 68, 70, 72], "exact": [2, 4, 10, 56], "syntax": [2, 4, 11, 60, 63, 68], "min": [2, 4, 65], "max": [2, 4, 65], "earlier": [2, 3, 11, 22, 28, 37, 53], "relev": [2, 4, 29, 35, 36, 37], "comma": [2, 3, 4, 11, 16, 63], "latter": 2, "far": [2, 3, 4, 5, 9, 36, 37, 45, 49], "conveni": [2, 11, 65], "case": [2, 3, 4, 5, 8, 10, 11, 19, 22, 28, 33, 36, 37, 41, 44, 50, 63, 65, 70, 71, 72, 74], "set": [2, 4, 8, 9, 10, 11, 12, 16, 29, 36, 44, 50, 53, 54, 59, 64, 67, 68], "sever": [2, 3, 4, 8, 20, 28, 29, 35, 36, 37, 59, 65, 68], "value1": [2, 3, 4], "value2": [2, 3, 4], "value3": [2, 3, 4], "a10": [2, 3, 4], "It": [2, 3, 4, 8, 15, 20, 22, 24, 28, 29, 32, 36, 37, 44, 45, 48, 50, 51, 63, 64, 65, 66, 68, 70], "nevertheless": 2, "recommend": [2, 22, 37], "term": [2, 3, 22, 28, 32, 35, 56, 70], "wherev": 2, "possibl": [2, 3, 4, 8, 28, 29, 35, 51, 56, 66], "disambigu": 2, "see": [2, 4, 5, 10, 12, 16, 20, 27, 29, 32, 36, 37, 41, 44, 45, 48, 50, 54, 55, 59, 63, 71], "longer": [2, 28, 51, 68], "discuss": [2, 9, 11, 21, 33, 35, 36, 37, 53], "sai": [2, 8, 36, 45, 55, 56, 63, 71], "grade": [2, 22, 34, 38], "professor": 2, "given": [2, 8, 11, 24, 28, 29, 35, 37, 39, 53, 55, 64, 71, 72], "list": [2, 10, 11, 16, 20, 24, 31, 34, 36, 37, 59, 63, 65, 67, 70, 71], "exam": [2, 5], "3": [2, 3, 4, 5, 10, 11, 22, 28, 29, 35, 36, 37, 41, 43, 48, 49, 53, 55, 63, 64, 65, 68, 70], "4": [2, 3, 4, 5, 10, 11, 28, 29, 35, 36, 37, 49, 53, 55, 63, 64], "practic": [2, 3, 4, 16, 41, 45, 59, 70], "creat": [2, 10, 11, 19, 22, 26, 27, 29, 35, 36, 37, 42, 45, 47, 54, 55, 56, 58, 63, 64, 68, 71], "mai": [2, 3, 10, 11, 15, 20, 24, 28, 34, 35, 36, 37, 41, 42, 44, 51, 55, 60, 63, 69, 71], "someon": [2, 20, 36, 45, 51], "advic": 2, "move": [2, 28, 29, 41, 44], "after": [2, 12, 16, 22, 28, 32, 35, 36, 37, 39, 41, 42, 44, 49, 53, 59, 68, 71, 72], "graduat": [2, 41, 42, 43, 49, 51], "wa": [2, 3, 5, 8, 10, 11, 20, 21, 24, 28, 29, 32, 36, 37, 44, 45, 48, 49, 55, 56, 63, 64, 67, 72], "major": [2, 22, 32, 35, 36, 37, 69], "concern": [2, 8], "them": [2, 4, 8, 10, 22, 23, 28, 29, 32, 37, 52, 53, 59, 69], "accur": [2, 5, 35, 36, 37, 45, 49, 55, 56], "might": [2, 3, 4, 5, 8, 20, 22, 24, 28, 29, 49, 51, 56, 63, 64, 66, 69, 70, 71], "respect": [2, 4, 10, 52, 72], "locat": [2, 16, 24, 28, 49, 51, 55, 70], "sens": [2, 3, 8, 28, 36, 37, 43, 50, 51, 64, 71], "next": [2, 3, 4, 28, 29, 33, 35, 39, 63], "understand": [2, 3, 15, 20, 22, 23, 24, 28, 32, 40, 41, 45, 51, 53, 54], "versu": [2, 19, 36, 37, 52, 58], "compar": [2, 3, 5, 11, 22, 28, 29, 35, 36, 37, 44, 45, 53, 55, 63, 68, 70], "maximum": [2, 3, 5, 7, 8, 9, 19, 65], "daili": [2, 3, 8, 32], "temperatur": [2, 3, 4, 8, 44, 45, 51, 52, 53, 55, 56], "nyc": [2, 3, 4], "actual_max_temp": [2, 4], "simpl": [2, 4, 10, 20, 32, 63, 66], "shown": [2, 20, 22, 50, 54, 55], "imag": [2, 5, 15, 34, 64], "64": [2, 28, 29, 36], "degre": [2, 3, 8, 44, 45, 55, 56], "switch": [2, 44], "5": [2, 3, 4, 5, 11, 28, 29, 35, 36, 37, 40, 49, 53, 63, 68], "over": [2, 3, 8, 10, 11, 22, 29, 31, 41, 50, 51, 52, 55, 63, 65, 66, 68], "cours": [2, 8, 28, 32, 59, 60, 63, 65, 67], "twelv": [2, 4], "similar": [2, 3, 28, 35, 36, 37, 41, 50, 52, 56, 63, 68, 71], "doe": [2, 5, 8, 10, 21, 23, 24, 28, 33, 35, 36, 37, 41, 42, 44, 51, 59, 63, 69, 70, 71], "seem": [2, 4, 36, 37, 44, 63], "right": [2, 3, 5, 8, 10, 15, 22, 29, 35, 36, 37, 39, 41, 44, 52, 53, 67], "In": [2, 3, 4, 5, 8, 10, 11, 16, 20, 22, 23, 27, 28, 29, 32, 33, 35, 36, 37, 39, 41, 42, 44, 49, 51, 52, 53, 54, 56, 59, 60, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72], "realiti": 2, "year": [2, 3, 4, 8, 28, 29, 41, 49, 50, 53, 64], "usual": [2, 3, 8, 33, 53, 63, 64, 71], "significantli": [2, 5, 10, 16, 29, 45], "winter": [2, 53], "consider": [2, 5, 20, 36, 45], "colder": [2, 44, 53, 55], "summer": [2, 53], "tend": [2, 5, 28], "warmer": [2, 44, 51], "effect": [2, 3, 5, 23, 32, 36, 50, 69], "cancel": 2, "out": [2, 3, 4, 11, 15, 20, 28, 29, 32, 36, 37, 40, 41, 49, 51, 53, 64, 71], "look": [2, 3, 4, 5, 8, 10, 11, 15, 20, 21, 23, 26, 28, 29, 32, 36, 37, 41, 42, 44, 45, 49, 50, 54, 55, 59, 63, 66, 68, 70, 71], "round": [2, 3, 8, 11, 55, 65], "learn": [2, 3, 12, 22, 23, 27, 28, 32, 33, 36, 37, 41, 42, 43, 49, 50, 52, 53, 54, 55, 63, 66, 67, 69, 71], "section": [2, 3, 8, 10, 16, 22, 27, 29, 35, 36, 37, 39, 41, 42, 43, 50, 52, 53, 54, 55, 59, 60, 63, 65, 66, 67, 69, 71], "spread": [2, 7, 19, 35, 36, 37, 53, 70, 71], "meantim": 2, "closer": [2, 42, 45, 48, 55, 63], "investig": [2, 29, 33, 45, 55], "stori": [2, 32, 33, 34], "why": [2, 3, 11, 20, 24, 28, 29, 36, 37, 43, 49, 54, 56, 59, 63], "outlier": [2, 7, 19, 36, 37, 43, 44, 47, 53], "explain": [2, 28, 36, 41, 42, 44, 48, 50, 51, 52, 53, 56, 65, 68], "incom": [2, 7, 8, 11, 22, 41, 43, 51], "measures_of_spread": 3, "center": [3, 5, 7, 19, 28, 31, 35, 36, 37], "But": [3, 4, 10, 29, 32, 42, 43, 44, 55], "These": [3, 4, 11, 12, 16, 22, 32, 34, 37, 41, 53], "predict": [3, 19, 32, 36, 37, 39, 41, 42, 44, 45, 47, 49, 55, 56, 60, 63], "doesn": [3, 8, 28, 32, 36, 37, 41, 43, 44, 51, 63], "easier": [3, 10, 15, 21, 23, 29, 35, 36, 37, 54, 56], "drastic": [3, 5], "consistentvil": 3, "everyon": [3, 4, 5, 9, 20, 53], "yearli": 3, "salari": [3, 42, 49, 53], "000": [3, 5], "wonkytown": 3, "100": [3, 10, 28, 41, 42, 65], "unemploi": 3, "town": 3, "dollar": [3, 41], "resid": [3, 66], "0": [3, 4, 5, 11, 22, 28, 41, 43, 45, 48, 49, 50, 51, 55, 63, 68], "random": [3, 24], "expect": [3, 11, 28, 29, 33, 50, 63, 65], "everi": [3, 4, 21, 28, 33, 41, 50, 53, 70], "singl": [3, 24, 28, 35, 37, 70], "did": [3, 4, 11, 21, 35, 36, 37, 56, 63, 64], "wrong": [3, 8, 36, 37], "Not": [3, 28, 35, 36, 37, 59], "wai": [3, 4, 5, 10, 15, 20, 22, 24, 27, 28, 29, 32, 34, 35, 36, 37, 41, 43, 45, 50, 54, 55, 56, 59, 63, 64, 65, 70], "off": [3, 36, 37, 45], "pretti": [3, 16, 28, 41, 55], "hard": [3, 11, 22, 29, 50, 63], "That": [3, 11, 28, 63, 70], "refin": [3, 32], "low": [3, 32, 43], "gener": [3, 4, 8, 11, 16, 20, 22, 32, 35, 41, 51, 55, 59, 60, 63, 64, 71], "close": [3, 28, 29, 36, 37, 44, 50, 53, 55, 68, 70], "high": [3, 5, 8, 29, 35, 45], "By": [3, 37, 54, 56], "itself": [3, 10, 36, 37, 50, 51, 63], "estim": [3, 43, 49, 53], "good": [3, 8, 16, 35, 36, 44, 45, 52, 56, 70], "alon": [3, 55], "side": [3, 5, 33], "red": [3, 44, 51, 59], "blue": [3, 8], "cluster": [3, 53], "comparison": [3, 35, 36, 37, 63, 67], "show": [3, 10, 22, 23, 28, 29, 36, 37, 41, 43, 48, 50, 54, 55, 56, 63, 65, 71, 72], "again": [3, 41, 63, 65, 70], "stdevp": 3, "previou": [3, 10, 28, 33, 36, 37, 41, 48, 63, 69], "variant": 3, "alwai": [3, 8, 15, 22, 44, 48, 52, 65, 70], "interest": [3, 10, 24, 29, 35, 36, 37, 48, 63, 65, 68], "thread": 3, "goe": [3, 11, 22, 51, 63], "detail": [3, 11, 20, 22, 24, 35, 36, 37, 48, 51], "mathemat": [3, 59, 63], "theori": [3, 32], "behind": 3, "numer": [3, 8, 10, 11, 22, 28, 36, 65, 72], "almost": [3, 36, 65], "except": [3, 5, 35, 41, 63], "12": [3, 5, 8, 45, 53, 63], "9": [3, 11, 29, 41, 63], "alreadi": [3, 5, 10, 36, 41, 54, 66, 69, 70], "seen": [3, 4, 32, 44, 45, 59, 65, 66, 70], "7": [3, 8, 11, 28, 29, 37, 56, 63], "illustr": [3, 4, 8, 10, 11, 43, 60, 63, 68], "isn": [3, 28], "believ": 3, "alongsid": [3, 65], "knowledg": [3, 44], "minimum": [3, 5, 7, 8, 19, 65], "season": 3, "materi": [3, 35, 70], "intend": [3, 20, 63], "curiou": 3, "crucial": [3, 20, 24, 36, 37], "concept": [3, 8, 49, 60, 65, 68], "mathematician": [3, 32], "actual": [3, 9, 22, 42, 56, 63, 71], "deriv": 3, "anoth": [3, 8, 15, 28, 29, 34, 37, 41, 43, 49, 51, 63, 70], "precis": [3, 22, 41, 43], "squar": [3, 48], "root": 3, "probabl": [3, 11, 51, 55], "distribut": [3, 5, 36, 37, 55], "explan": [3, 28, 36, 37, 67], "its": [3, 8, 11, 22, 41, 42, 55, 63, 64], "word": [3, 8, 10, 11, 21, 23, 32, 41, 49, 63], "outlin": [3, 5, 35, 36, 37, 41], "procedur": 3, "b": [3, 8, 11, 19, 38, 40, 41, 53, 63], "c": [3, 8, 11, 19, 28, 38, 53, 63, 64, 71], "posit": [3, 4, 7, 8, 36, 37, 40, 41, 45, 48, 49, 50, 51, 53, 63], "sure": [3, 10, 22, 28, 29, 36, 37, 39, 45], "equal": [3, 4, 10, 11], "Then": [3, 21, 29, 35, 44, 52, 55], "varp": 3, "caveat": 3, "therefor": [3, 36, 37, 41, 63], "zero": [3, 8, 40, 59, 63], "happen": [3, 5, 22, 45, 63], "awai": [3, 5, 36, 37], "500": [3, 11], "unit": [3, 5, 22, 36, 55, 64, 65], "downsid": 3, "involv": [3, 28, 35, 37, 70], "initi": [3, 63], "came": [3, 4], "purpos": [3, 11, 32, 63, 65, 67], "express": [3, 8, 20], "manual": [3, 4, 52, 63, 68], "method": [3, 28, 35, 40, 43, 55], "confirm": [3, 41], "among": 3, "real": [3, 5, 9, 16, 32, 53, 63], "exercis": [3, 10, 53], "explor": [3, 5], "profession": [3, 8], "athlet": 3, "well": [3, 8, 11, 12, 33, 34, 35, 36, 37, 44, 45, 63], "experi": [3, 4, 53], "minimum_and_maximum": 4, "rel": [4, 5, 8, 16, 28, 63], "smallest": [4, 29, 64], "greater": [4, 5, 10, 29, 45, 53, 63], "largest": [4, 48, 55], "less": [4, 5, 8, 10, 15, 16, 41, 53, 70], "univers": [4, 41, 43, 49], "organ": [4, 12, 24, 29, 54, 63], "trip": [4, 23, 28, 65, 66, 68, 70, 71, 72], "concert": 4, "event": [4, 22], "21": [4, 63], "venu": 4, "under": [4, 8, 10, 29, 36, 37, 39, 59], "ag": [4, 8, 24, 28, 49, 53], "suffici": [4, 36, 37, 68], "least": [4, 10, 33, 35, 37, 66], "member": [4, 65, 66, 68, 70], "go": [4, 32, 41, 43, 44, 50, 51, 52, 53, 63, 68], "face": [4, 59], "land": 4, "label": [4, 22, 28, 52, 55], "unnecessari": 4, "thousand": 4, "instead": [4, 10, 11, 28, 51, 55, 63, 65, 70], "necess": 4, "logic": [4, 36, 70], "state": [4, 5, 8, 10, 11, 24, 29, 31, 32, 36, 37, 45, 49, 50, 52, 55], "altern": [4, 51], "specifi": [4, 15, 24, 28, 37, 70, 71, 72], "effici": [4, 70], "actual_min_temp": 4, "record": [4, 8, 11, 28, 34, 45], "coldest": 4, "remov": [4, 10, 36, 37, 45], "month_text": [4, 8], "reach": [4, 37], "warmest": 4, "365": [4, 8], "consum": 4, "imposs": 4, "scan": 4, "visual": [4, 10, 19, 22, 23, 29, 32, 35, 36, 37, 41, 45, 54, 55], "imagin": [4, 28, 45, 50, 69], "cover": [4, 10, 59, 65], "hundr": [4, 63], "quickli": [4, 60], "error": [4, 19, 28, 35, 36, 37, 45, 62, 63, 65], "prone": [4, 28], "fun": 4, "spreadsheet": [4, 10, 15, 16, 34, 41, 60, 63, 64, 69, 70], "situat": [4, 28], "item": [4, 28], "we": [4, 8, 34, 36, 51, 60, 63, 70], "three": [4, 10, 11, 29, 32, 39, 53, 55, 56, 70], "search_kei": [4, 28], "search_typ": 4, "search": [4, 59], "ex": 4, "a5": 4, "manner": 4, "caus": [4, 29, 31, 45, 51], "assum": [4, 8, 10, 11, 63], "sort": [4, 14, 19, 28, 32, 65, 70, 74], "ascend": [4, 70, 72], "descend": [4, 65, 72], "compani": [4, 29, 53], "candydata": 4, "hand": [4, 8, 15, 28, 35, 63, 69], "halloween": 4, "candi": 4, "fivethirtyeight": [4, 21, 32, 36, 37], "variou": [4, 28, 34], "price": [4, 28, 32, 69], "percent": [4, 29, 35], "fill": [4, 10, 28, 45], "c2": [4, 11], "c86": 4, "part": [4, 11, 16, 22, 24, 59], "someth": [4, 8, 24, 41, 42, 55, 64, 71], "c1": 4, "notic": [4, 11, 41, 50, 55, 71], "shift": [4, 29], "53": 4, "54": [4, 55], "omit": [4, 28, 36, 37], "bug": 4, "smaller": [4, 53, 55, 71], "popul": [4, 8, 22, 24, 28, 29, 36, 37, 50, 63, 65], "aren": [4, 28, 29, 45], "final": [4, 63], "46": 4, "back": [4, 24, 36, 37, 50, 63, 68], "nik": 4, "l": [4, 63], "nip": 4, "sugar": 4, "percentag": [4, 11, 28, 29, 41, 42, 49, 70], "outliers_and_skew": 5, "alter": [5, 63, 64], "replac": [5, 43], "60": [5, 66, 68], "affect": [5, 24, 28, 36, 37], "measur": [5, 7, 19, 36, 37, 42, 48], "classroom": [5, 8], "basketbal": 5, "player": [5, 32], "taller": 5, "rest": [5, 35, 45], "whose": [5, 10, 11, 12], "lia": 5, "188": 5, "centimet": [5, 8], "cm": 5, "katrina": 5, "193": 5, "168": 5, "45": [5, 45, 55, 56], "mislead": [5, 28], "school": [5, 8, 9, 34, 35, 41, 42, 43, 49, 51], "desk": 5, "too": [5, 29, 44, 63], "small": [5, 35, 36, 44, 53], "asymmetri": 5, "fewer": [5, 10, 35, 41, 59, 63, 70], "distanc": 5, "neg": [5, 8, 40, 41, 43, 48, 50, 53], "pertain": 5, "notion": 5, "score": [5, 7, 22, 42, 43, 47, 49, 51], "81": 5, "larg": [5, 22, 28, 29, 36, 37, 41, 50, 67, 69, 71], "lower": [5, 28, 41, 43, 45, 71], "group": [5, 12, 19, 21, 22, 27, 28, 29, 32, 34, 35, 36, 37, 50, 55, 56, 64, 65, 68], "left": [5, 8, 10, 11, 15, 35, 41, 44, 53, 67], "tail": 5, "similarli": [5, 53], "mirror": 5, "li": 5, "interv": [5, 22], "none": [5, 68], "Will": 5, "still": [5, 29, 36, 37, 63], "yet": 5, "contrast": [5, 8, 37], "robust": [5, 67], "becom": [5, 12, 22, 33, 41, 44, 50, 54], "introduc": [5, 53, 60, 65], "10": [5, 11, 22, 29, 37, 41, 49, 55, 63, 65, 68, 71, 72], "300": 5, "especi": [5, 24, 33, 63, 65, 71], "toward": [5, 29, 51], "read": [5, 19, 20, 21, 22, 23, 26, 32, 33, 35, 36, 37, 43, 48, 49, 51, 54, 63, 67, 70, 71], "excerpt": 5, "u": [5, 8, 21, 28, 32, 45, 53], "censu": 5, "2003": 5, "wealth": [5, 51], "household": 5, "hold": [5, 12, 15, 23], "proport": [5, 23, 48], "central": [5, 55], "tendenc": 5, "sensit": [5, 15, 44, 45], "represent": [5, 23], "asset": 5, "typic": [5, 8, 28], "net": [5, 41, 49], "worth": 5, "55": [5, 28, 41, 56], "182": 5, "381": 5, "earn": [5, 41, 49], "context": [5, 29, 36], "present": [5, 15, 22, 24, 29, 32, 35, 36, 37, 40, 63], "econom": 5, "financi": [5, 41, 49], "market": [5, 69], "financ": 5, "toctre": [7, 14, 18, 26, 31, 38, 47, 58, 62, 74], "introduct": [7, 11, 14, 19, 31, 47, 56, 58, 62, 74], "weather": [7, 32, 52, 55, 56], "extens": [7, 74], "discret": [7, 22], "continu": [7, 15, 36], "sum": [7, 9, 11, 19, 28, 29, 63, 65, 68, 70], "applic": [7, 12, 37], "spotifi": [7, 11], "premium": [7, 53], "dice": 7, "roll": 7, "option": [7, 10, 15, 16, 22, 28, 29, 35, 36, 37, 39, 44, 67], "match": [7, 11, 28, 48, 53, 70], "test": 7, "skew": [7, 19, 36, 37], "histogram": [7, 8, 19, 26, 54, 55], "further": [7, 27, 32, 41, 44, 63], "deviat": [7, 35, 36, 37], "varianc": [7, 35, 36, 37], "relat": [8, 28, 29, 34, 35, 41, 48, 55, 64, 67], "hair": [8, 22], "color": [8, 20, 22, 23, 29, 35, 37, 39], "shoe": [8, 36, 49], "size": [8, 20, 22, 35, 36, 37, 49, 51], "determin": [8, 36, 37, 39, 41, 42, 48, 55], "educ": [8, 53, 55], "certain": [8, 11, 12, 21, 36, 44, 71], "black": 8, "brown": 8, "blond": 8, "etc": 8, "handed": [8, 35], "ambidextr": 8, "transport": 8, "train": [8, 22, 32, 50], "car": [8, 28, 53], "bicycl": 8, "classifi": [8, 63], "complet": [8, 22, 28, 29, 35, 36, 37, 41, 42, 43, 44, 49, 51], "plot": [8, 19, 22, 28, 36, 37, 39, 41, 42, 43, 45, 48, 49, 50, 54, 55], "bar": [8, 19, 26, 28, 29, 54, 55, 56, 64], "chart": [8, 19, 20, 24, 26, 28, 29, 35, 39, 41, 44, 52, 54, 55, 56], "distinct": [8, 22, 51, 65, 70], "found": [8, 10, 36, 37, 51, 55, 56, 64], "identifi": [8, 20, 35, 36, 37, 45, 49, 50, 53, 68, 70], "miss": [8, 35, 36, 37], "california": [8, 10, 11, 28, 29], "respons": [8, 29, 35, 56], "enter": [8, 10, 11, 45, 63], "incorrectli": 8, "undergradu": [8, 22], "annual": [8, 53], "europ": 8, "20": [8, 28, 41, 53, 55], "birthdai": 8, "fix": [8, 32, 45], "fahrenheit": 8, "juli": [8, 29, 44, 52, 55], "2014": 8, "june": 8, "30": [8, 35, 68], "2015": 8, "clear": [8, 10, 20, 22, 29, 35, 51], "f": [8, 53, 56], "januari": [8, 44, 45, 53, 55, 56], "decemb": [8, 53], "natur": [8, 63], "unord": [8, 10], "date": [8, 29, 35, 36, 37, 50, 65, 72], "trickier": 8, "encod": [8, 11, 63], "whole": [8, 11, 22, 36, 55, 65], "map": [8, 11, 21, 23, 34, 55], "argu": [8, 33], "timefram": 8, "choos": [8, 15, 16, 22, 35, 36, 37, 44, 49, 51, 52, 71], "depend": [8, 20, 23, 43, 56], "graph": [8, 20, 22, 23, 28, 29, 37, 39, 41, 43, 44, 45, 50, 54, 56, 60], "x": [8, 22, 29, 40, 41, 43, 50, 52, 53, 56], "axi": [8, 22, 29, 40, 50, 52, 56], "subset": [8, 10, 11, 21, 24, 29, 35, 36, 50, 65, 66, 72], "mondai": 8, "overarch": 8, "fall": [8, 28, 32], "umbrella": 8, "stair": 8, "children": [8, 11, 64], "within": [8, 10, 16, 29, 32, 36, 37, 41, 49, 63, 64, 65, 70, 72], "necessari": [8, 11, 35, 36], "datapoint": 8, "moreov": [8, 10], "172": 8, "9532145": 8, "nearest": [8, 11, 55, 65], "feet": 8, "inch": [8, 53], "5ft": 8, "8in": 8, "173cm": 8, "234": 8, "exist": [8, 16, 20, 22, 29, 32, 33, 36, 37, 63, 64, 71], "rank": 8, "ey": 8, "obviou": 8, "couldn": 8, "level": [8, 51], "No": [8, 35, 59], "diploma": 8, "master": 8, "doctor": 8, "equival": [8, 65, 70], "clearli": [8, 45, 48, 53], "beyond": [8, 35], "ordin": [8, 22], "advanc": 8, "model": [8, 36], "scope": 8, "what_is_a_statist": 9, "fact": [9, 20, 24], "piec": [9, 27, 54], "shortest": [9, 65], "146cm": 9, "tallest": [9, 28], "192cm": 9, "19": 9, "166": 9, "16cm": 9, "3157cm": 9, "96cm": 9, "life": [9, 11, 28, 29, 32, 33, 63], "chapter": [9, 10, 23, 33, 69], "guid": [9, 15, 23, 39, 48], "descript": [9, 19, 22, 24, 38, 43, 52, 53, 70], "travel": 9, "filtering_data": 10, "entir": [10, 11, 15, 16, 29, 56, 65], "usa": [10, 11, 28, 29, 49, 55, 66], "analysi": [10, 11, 27, 33, 35, 36, 37, 41, 64, 69], "select": [10, 11, 15, 16, 19, 28, 29, 35, 36, 37, 39, 44, 50, 51, 52, 64, 65, 67, 68, 70, 74], "base": [10, 11, 21, 22, 29, 37, 50, 55, 56, 63, 65, 66, 68], "condit": [10, 11, 50, 63, 65, 66, 68], "statement": [10, 63, 65, 68, 70], "restrict": [10, 28, 29, 36, 37], "letter": [10, 22, 64], "code": [10, 59, 71], "correspond": [10, 28, 36, 41, 48, 68], "ca": 10, "header": 10, "discourag": 10, "ago": 10, "french": [10, 11, 63, 64], "paint": [10, 11, 63], "200": [10, 63], "simplic": 10, "nation": [10, 11, 31, 63, 64], "recreat": [10, 63], "solut": [10, 28], "extend": [10, 63], "step": [10, 35, 36, 37, 63, 70], "navig": [10, 16, 28, 29, 69], "cursor": 10, "anywher": [10, 11, 65], "h51": 10, "icon": 10, "press": 10, "scroll": [10, 21], "ok": 10, "rather": [10, 28, 29, 36, 45, 48, 56, 63, 71], "box": [10, 59], "being": [10, 28, 50, 56, 63, 65], "onc": [10, 22, 36, 37, 39, 45, 50, 51, 63], "done": [10, 11, 29, 32, 36, 37, 41, 63, 68, 70], "green": [10, 45], "renoir": [10, 63], "dega": [10, 63], "gauguin": [10, 63], "italian": [10, 11, 63, 64], "exclus": [10, 11, 63], "raphael": 10, "caravaggio": 10, "michelangelo": 10, "eugen": 10, "delacroix": 10, "complic": [10, 20, 32], "easi": [10, 21, 23, 28, 35, 45], "whom": 10, "alfr": 10, "sislei": 10, "british": 10, "text": [10, 11, 21, 22, 28, 40, 41, 43, 56, 72], "associ": [10, 11, 45, 51], "impression": [10, 11], "post": [10, 21, 34], "full": [10, 21, 22, 49], "spell": [10, 28, 35, 36, 37], "id": [10, 64], "hint": [10, 11, 35, 36, 37, 68, 71], "artist": [10, 11, 23, 63, 64], "difficult": [10, 20, 29, 36, 37, 43], "examin": [10, 20, 41, 50, 53], "across": [10, 11, 36, 37, 49, 55, 59, 60, 69, 70, 71], "alphabet": [10, 28], "z": [10, 72], "top": [10, 11, 29, 39, 44, 67, 71, 72], "bottom": [10, 29, 44, 72], "bill": 10, "total": [10, 11, 28, 29, 35, 36, 65, 70, 71], "ow": 10, "cost": [10, 28], "free": [10, 36, 37], "genr": [10, 11, 64], "act": 10, "sorter": 10, "denot": [10, 48, 71], "born": 10, "earliest": [10, 65], "appear": [10, 11, 21, 24, 39, 44, 63, 70], "fewest": 10, "tabl": [10, 11, 12, 19, 20, 24, 26, 27, 28, 31, 34, 36, 37, 59, 63, 64, 65, 70, 71], "grouping_data": 11, "filter": [11, 12, 19, 27, 28, 29, 36, 37, 58, 65, 70, 72, 74], "countif": [11, 29], "satisfi": [11, 63, 66], "saw": [11, 27, 45, 56], "util": 11, "b26": 11, "lo": [11, 12], "angel": [11, 12], "sumif": [11, 29], "b2": [11, 63], "e2": [11, 63], "e26": 11, "pictur": [11, 21, 23, 53, 60], "screenshot": [11, 50, 54, 55], "averageif": [11, 29, 55], "song": 11, "2019": 11, "c4": [11, 29, 64], "c53": 11, "ed": 11, "sheeran": 11, "e4": 11, "e53": 11, "themselv": [11, 63], "third": [11, 29, 63, 68], "argument": 11, "leav": 11, "limit": [11, 24, 70, 71], "copi": [11, 28, 52, 63], "past": [11, 50, 63], "behav": [11, 63], "via": [11, 37, 65], "h5": 11, "h48": 11, "13": [11, 28, 63], "48": [11, 51], "44": 11, "definit": [11, 32, 63], "forum": 11, "produc": [11, 37, 56, 63, 65], "romantic": 11, "simplifi": 11, "passeng": 11, "ship": 11, "sank": 11, "journei": 11, "southampton": 11, "england": 11, "1912": 11, "kill": 11, "tragedi": 11, "women": 11, "prioriti": [11, 29], "access": [11, 22, 23, 26, 29, 37, 44], "raft": 11, "emerg": 11, "surviv": 11, "rate": [11, 31, 33, 41, 42, 43, 49, 51], "men": 11, "raw": [11, 28, 29, 63], "dead": 11, "aliv": 11, "deal": [11, 16], "transform": 11, "insert": [11, 22, 28, 29, 52, 64], "IF": [11, 55, 68], "8": [11, 29, 35, 36, 37, 63, 64, 66], "overal": [11, 49, 50, 55], "man": 11, "perfect": [11, 59], "2209": 11, "11": [11, 41, 63], "crew": 11, "line": [11, 16, 19, 23, 28, 29, 36, 37, 41, 42, 44, 45, 48, 53, 55, 59, 70, 71], "sheet": [12, 15, 16, 19, 26, 27, 28, 29, 32, 33, 35, 36, 37, 39, 42, 43, 44, 48, 58, 59, 60, 63, 65, 66, 68, 69, 70, 71, 72], "familiar": [12, 63], "displai": [12, 22, 28, 29, 39, 65, 70, 71], "23": [12, 28, 63], "fiction": [12, 32], "don": [12, 32, 35, 36, 37, 39, 41, 44, 63, 64, 71], "worri": [12, 29, 36, 37, 39, 63, 71], "confus": [12, 51, 63], "meant": 12, "painter": [14, 62], "titan": 14, "exporting_data": 15, "file": [15, 16, 28, 67], "readi": [15, 36, 37], "download": [15, 16, 67], "xlsx": 15, "compat": 15, "microsoft": [15, 34], "excel": [15, 35, 36, 37], "od": 15, "linux": 15, "libreoffic": 15, "pdf": 15, "readabl": [15, 35, 36, 37, 71], "system": [15, 34, 67], "edit": [15, 52], "csv": [15, 16, 28], "storag": 15, "tsv": [15, 16], "publish": 15, "onlin": [15, 16, 24, 36, 37, 59, 67], "web": 15, "page": [15, 64], "share": [15, 29, 35, 51, 71], "On": [15, 72], "pane": 15, "care": [15, 44, 45, 51], "ensur": [15, 20, 23, 24, 37, 45], "privat": [15, 49], "instanc": [15, 35], "law": 15, "regul": 15, "privaci": [15, 32, 36], "plenti": 15, "publicli": 15, "avail": [15, 28, 34, 36, 65], "2018": [15, 28], "importing_data": 16, "tackl": 16, "problem": [16, 32, 36, 56], "fetch": 16, "yourself": [16, 21, 28], "repositori": 16, "github": 16, "googl": [16, 32, 33, 34, 59, 60, 64], "delimit": 16, "charact": [16, 63], "tab": [16, 28], "space": 16, "uncommon": 16, "luckili": 16, "80": 16, "brand": 16, "cereal": 16, "comput": [16, 32, 59], "instruct": [16, 37, 67], "upload": 16, "drag": [16, 63, 71], "drop": [16, 41, 45, 67], "local": [16, 29], "automat": [16, 28, 29, 63], "pars": [16, 63], "suit": 16, "index": [19, 28], "modul": [19, 38, 45, 50], "prefac": [19, 69], "pie": [19, 20, 24, 26], "checklist": [19, 26, 35], "export": [19, 32, 37], "scatter": [19, 28, 36, 37, 39, 41, 42, 43, 45, 48, 49, 50, 54], "correl": [19, 28, 36, 37, 41, 42, 45], "motiv": [19, 58], "scatterplot": [19, 48, 53, 58], "causat": [19, 28, 36, 37, 45, 58], "regress": [19, 36, 37, 42], "fit": [19, 36, 37, 41, 42, 44, 45], "equat": [19, 36, 37, 39, 41, 42, 43, 47, 55], "refresh": [19, 36, 47], "interpret": [19, 21, 23, 24, 29, 32, 36, 37, 45, 47, 59, 63, 67], "slope": [19, 39, 40, 43, 45, 47], "linear": [19, 36, 41, 42, 47, 48, 49, 53], "manipul": [19, 27, 32, 63, 64], "pivot": [19, 27, 28, 31, 36, 65], "sql": [19, 34, 37, 65, 66, 68, 69, 70, 71, 72], "aggreg": [19, 70, 74], "Ifs": [19, 74], "run": [19, 41, 74], "outsid": [19, 43, 45, 74], "project": [19, 29, 67], "creating_visualizations_checklist": 20, "content": [20, 34], "physic": [20, 63], "billion": [20, 69], "disabl": 20, "exclud": [20, 29, 45], "anyon": 20, "blind": 20, "simul": 20, "dyslex": 20, "languag": [20, 34, 68, 69], "simplest": 20, "technic": [20, 28, 37], "audienc": [20, 23], "viewer": [20, 29], "opinion": [20, 24], "convei": [20, 21, 24, 35, 37], "showcas": 20, "everyth": [20, 35, 63, 70], "graphic": [20, 23], "style": 20, "compet": 20, "unless": [20, 44], "example_visu": 21, "titl": [21, 22, 52], "author": [21, 24], "media": [21, 24, 33, 35], "site": [21, 59], "drawn": 21, "attent": 21, "citizen": [21, 66], "befor": [21, 29, 32, 36, 37, 41, 44, 45, 50, 59, 65, 71], "without": [21, 29, 37, 45, 49, 65], "took": 21, "enjoy": 21, "got": 21, "histograms_and_bar_chart": 22, "vertic": [22, 52, 64], "thing": [22, 24, 33, 63, 69], "human": 22, "frequenc": [22, 51], "arriv": 22, "station": [22, 65, 66, 68, 70, 71, 72], "horizont": [22, 29, 52, 64], "aesthet": 22, "textbook": [22, 32, 37, 56, 60, 64, 74], "consist": [22, 28, 35], "interchang": 22, "principl": 22, "occurr": 22, "industri": 22, "distinguish": [22, 29], "nuanc": 22, "gap": 22, "bin": 22, "sat": [22, 42, 43, 47, 49, 51], "never": [22, 32, 65, 71], "neighbor": 22, "favorit": [22, 34, 63], "ic": [22, 51], "cream": [22, 51], "shop": [22, 32, 63], "marathon": 22, "bracket": [22, 63], "bucket": [22, 56], "custom": [22, 39, 44, 52, 63], "highlight": [22, 64], "mind": [22, 23, 26, 37, 45], "main": [22, 37], "big": [22, 28, 29, 59], "fast": 22, "rule": [22, 28], "forefront": 22, "ax": 22, "width": 22, "avoid": [22, 28], "pattern": [23, 29], "ever": [23, 36, 37], "infograph": 23, "commun": [23, 24], "review": [23, 24, 32, 36, 40, 41, 50], "element": [23, 28], "background": 23, "influenti": 23, "figur": [23, 32, 40, 48], "fare": 23, "durat": [23, 65, 66, 68, 70, 71, 72], "taxi": 23, "ride": [23, 72], "chicago": 23, "reading_visualizations_checklist": 24, "Being": 24, "fundament": [24, 33, 63, 64], "skill": [24, 32], "scienc": [24, 32, 36, 37], "potenti": [24, 35, 36, 37], "bias": 24, "behalf": 24, "experienc": [24, 32], "statistician": 24, "writer": 24, "platform": [24, 60], "unconsci": 24, "consciou": 24, "bia": [24, 32, 35], "racial": [24, 32], "product": 24, "promot": 24, "sell": 24, "core": [24, 60], "global": 24, "region": [24, 45, 55, 56], "demograph": 24, "race": 24, "gender": [24, 26, 32], "sampl": [24, 36, 37, 44, 53], "chosen": [24, 36, 37], "dorm": 24, "rigor": 24, "thoroughli": 24, "wherea": 24, "blog": [24, 32], "accentu": 24, "hollywood": 26, "imbal": 26, "white": [26, 70], "vote": 26, "With": 27, "joining_data": 28, "analyz": [28, 33, 34, 35, 36, 37, 39, 41, 45, 50, 54, 55, 64, 67, 69], "relationship": [28, 33, 35, 36, 37, 40, 41, 42, 44, 45, 48, 49, 50, 51, 53, 54, 55, 56, 63], "bring": [28, 63], "quantiti": [28, 50], "tediou": [28, 56], "thankfulli": 28, "vlookup": [28, 36, 70], "is_sort": 28, "appl": 28, "a2": [28, 29, 63], "b21": 28, "area": [28, 29, 36, 37], "mous": 28, "exclam": 28, "properli": 28, "seach_kei": 28, "output": [28, 71], "default": 28, "79": 28, "c3": 28, "c8": 28, "loaf": 28, "bread": 28, "dozen": 28, "egg": 28, "correctli": [28, 32, 36, 37, 52], "great": [28, 29, 50, 55], "absolut": [28, 29, 59, 63], "finish": 28, "multipli": [28, 41, 63], "40": [28, 55], "33": [28, 29, 55, 56], "93": 28, "31": [28, 45, 56], "benefit": 28, "subtot": 28, "recalcul": 28, "sale": 28, "39": [28, 55], "37": [28, 41], "75": [28, 55], "77": [28, 55], "32": 28, "25": [28, 45, 55, 56], "22": [28, 65], "profit": [28, 29, 49], "improv": [28, 29, 35, 50], "lead": [28, 29, 51, 63], "nonprofit": [28, 29], "stack": 28, "against": 28, "heart": [28, 29, 51], "healthier": 28, "florida": [28, 50], "texa": [28, 56, 66], "convert": [28, 56], "di": [28, 29], "state_popul": 28, "2010": [28, 44], "nch": [28, 29], "arkansa": 28, "west": [28, 36], "virginia": 28, "97": 28, "grand": [28, 29], "58": [28, 56], "49": [28, 32, 63], "62": 28, "variat": [28, 37, 48], "younger": 28, "older": [28, 53], "age_by_st": 28, "Of": [28, 63], "impli": [28, 36, 51], "necessarili": [28, 51], "alaska": [28, 45, 56], "turn": [28, 63], "live": 28, "send": [28, 32], "teammat": [28, 29], "brief": [28, 36], "sourc": [28, 33, 34, 35, 36, 37], "week": 28, "flexibl": 28, "larger": [28, 33, 44, 51, 54, 55, 63, 69], "increas": [28, 29, 33, 41, 44, 45, 50, 51, 53, 55], "due": [28, 29, 35, 36, 37, 63], "cancer": [28, 29, 32], "unintend": 28, "injuri": [28, 29], "alzheim": [28, 29], "diseas": [28, 29], "period": 28, "growth": [28, 29, 44, 63], "construct": [28, 29], "2016": [28, 29], "a18": 28, "h28": 28, "unintent": [28, 29], "clariti": [28, 35, 36, 37], "modifi": 28, "dash": 28, "though": [28, 35, 51, 53], "control": [28, 29], "prevent": [28, 29, 51, 63], "track": 28, "cdc": 28, "suggest": 28, "mostli": 28, "addition": 28, "physician": 28, "fatal": [28, 33], "accid": 28, "drug": 28, "overdos": 28, "pivot_t": 29, "cowork": 29, "schedul": 29, "assign": [29, 45, 52], "employe": [29, 53], "open": [29, 34, 36, 37, 39, 67, 68, 70], "fair": 29, "pull": 29, "built": [29, 63], "autom": [29, 63, 69], "process": [29, 36, 37, 52, 63], "menu": [29, 44, 64], "editor": [29, 39, 44, 52], "repeat": [29, 53], "doubl": [29, 53, 55], "entri": [29, 45], "jan": 29, "branch": 29, "death": [29, 31], "ten": [29, 50], "1999": 29, "nevada": 29, "2007": 29, "4331": 29, "target": 29, "healthcar": 29, "enabl": 29, "opportun": 29, "simpler": [29, 53], "astonishingli": 29, "effort": 29, "reduc": [29, 33, 45, 51], "amelior": 29, "symptom": 29, "suicid": 29, "stroke": 29, "63": [29, 43], "coloumn": 29, "seri": [29, 39, 44, 52], "delet": 29, "s12": 29, "along": [29, 41, 53, 65, 70], "vari": [29, 34, 37, 43, 56], "ver": 29, "certainli": [29, 41], "issu": [29, 35, 36, 37, 41], "differenti": 29, "colorblind": 29, "essenti": [29, 32], "unread": 29, "address": [29, 36, 37], "perhap": [29, 51, 68], "clrd": 29, "diabet": 29, "kidnei": 29, "decreas": [29, 41, 51, 53, 55, 72], "influenza": 29, "pneumonia": 29, "steadili": 29, "ratio": [29, 41, 63], "4532": 29, "15570": 29, "manag": [29, 32, 67], "rise": [29, 41], "dramat": [29, 44, 45], "health": [31, 51], "groceri": 31, "module_a_prefac": 32, "encount": [32, 59], "mayb": [32, 71], "ve": [32, 36, 37, 41, 44, 45, 49, 55, 71], "heard": 32, "nate": 32, "silver": 32, "hi": 32, "elector": 32, "2008": 32, "feder": [32, 41, 42, 49], "elect": 32, "2012": 32, "book": 32, "hidden": 32, "movi": 32, "katherin": 32, "johnson": 32, "mari": 32, "jackson": 32, "dorothi": 32, "vaughan": 32, "groundbreak": 32, "engin": [32, 67], "career": [32, 53], "nasa": 32, "segreg": 32, "discrimin": 32, "pervas": 32, "Or": [32, 41], "pathologist": 32, "machin": [32, 67], "detect": 32, "deepmind": 32, "neural": 32, "network": [32, 34], "beat": 32, "moneybal": 32, "billi": 32, "bean": 32, "leagu": 32, "basebal": 32, "oakland": 32, "sabermetr": 32, "assembl": 32, "divis": [32, 59], "win": 32, "realm": 32, "encompass": 32, "artifici": 32, "intellig": 32, "astronaut": 32, "moon": 32, "wear": 32, "shirt": 32, "bui": 32, "hit": 32, "advantag": [32, 33], "flaw": 32, "usag": 32, "todai": [32, 34, 69], "preced": 32, "formul": [32, 37], "driven": 32, "approach": 32, "databas": [32, 34, 37, 66, 67, 69, 70, 71], "ethic": [32, 36, 37], "gather": 32, "design": [32, 35, 63], "prepar": [32, 36, 37], "capac": 32, "module_b_prefac": 33, "techniqu": [33, 50], "draw": [33, 36, 37, 51], "conclus": [33, 36, 37, 50, 51], "link": [33, 35, 37, 67], "chocol": [33, 62], "vaccin": 33, "chanc": [33, 59], "autism": 33, "gun": 33, "ownership": 33, "home": 33, "realli": 33, "harri": 33, "potter": 33, "prejudic": 33, "divers": 33, "increasingli": [33, 72], "deciph": 33, "trustworthi": [33, 36], "legitim": 33, "pair": [33, 65, 72], "module_c_prefac": 34, "interact": [34, 67], "social": [34, 35], "newspap": 34, "websit": [34, 36, 37, 44], "contact": 34, "mobil": 34, "phone": 34, "bit": [34, 63, 64, 71], "postgresql": [34, 67], "mysql": [34, 67], "sqlite": [34, 67, 71], "commerci": 34, "bigqueri": [34, 67], "oracl": 34, "server": [34, 37, 65], "amazon": 34, "aurora": 34, "proprietari": 34, "bigtabl": 34, "facebook": 34, "haystack": 34, "object": 34, "mechan": 34, "extract": 34, "structur": [34, 36, 37, 68, 69], "queri": [34, 37, 65, 66, 67, 68, 69, 70, 71, 72], "pronounc": 34, "sequel": 34, "teach": [34, 69], "module_a": 35, "attribut": [35, 64], "plai": [35, 41], "dog": 35, "walk": [35, 60], "inadequ": [35, 36, 37], "deploi": 35, "elicit": 35, "troubl": 35, "particip": [35, 50], "insight": 35, "clean": [35, 36, 37], "unsur": [35, 36, 37], "whatev": [35, 68, 72], "slide": 35, "deck": 35, "visit": 35, "faculti": [35, 36, 37], "self": [35, 36, 37], "folder": 35, "meet": 35, "criteria": [35, 66, 72], "develop": [35, 36, 37], "na": [35, 36, 37], "minor": [35, 36, 37], "unclear": 35, "inappropri": [35, 37], "irrelev": 35, "29": 35, "recruit": 35, "insuffici": 35, "depth": [35, 36, 37, 59], "mention": [35, 36, 37, 41, 60, 69], "attempt": [35, 36, 37, 51], "inconsist": [35, 36, 37], "incomplet": [35, 36, 37], "broadli": 35, "inaccuraci": [35, 37], "unrel": 35, "lack": [35, 36, 37], "signific": 35, "minim": 35, "font": 35, "grammar": [35, 36, 37], "neglig": 35, "module_b": 36, "sub": [36, 37], "bullet": [36, 37], "topic": 36, "copyright": 36, "licens": [36, 37], "fine": [36, 37], "republish": [36, 37], "instructor": [36, 37], "proceed": [36, 37], "deliver": [36, 37], "particular": [36, 37, 39, 44], "bank": [36, 37], "kaggl": [36, 37, 64], "revisit": 36, "rare": [36, 37], "overwhelm": [36, 37], "maintain": [36, 37], "integr": [36, 37], "spot": [36, 37], "unwant": [36, 37], "trade": [36, 37], "tradeoff": [36, 37], "consolid": 36, "overview": 36, "split": [36, 55], "chose": [36, 37], "subsect": 36, "trend": [36, 41, 44, 50, 53, 54], "coast": [36, 53], "east": 36, "particularli": [36, 37], "disadvantag": 36, "strong": [36, 37, 41, 44, 45, 49, 51, 53], "lurk": [36, 37, 41, 51], "coeffici": [36, 37, 39, 41, 42, 45, 48, 49, 50], "paragraph": [36, 37], "surpris": [36, 37], "v": [36, 37], "conclud": [36, 37, 51], "reflect": [36, 37, 50], "meaning": [36, 37, 68], "takeawai": [36, 37], "societi": [36, 37], "moment": [36, 37], "broader": [36, 37], "implic": [36, 37], "proofread": [36, 37], "rational": 36, "approv": 36, "unclean": [36, 37], "taken": [36, 37, 41, 63, 65], "ambigu": [36, 37], "chunk": [36, 37], "untreat": [36, 37], "independ": [36, 37, 55, 56], "successfulli": [36, 65], "execut": [36, 65], "comment": [36, 37], "referenc": [36, 37, 63], "extra": [36, 37], "dimens": [36, 37], "wrongli": [36, 37], "proper": [36, 37], "suitabl": [36, 37], "pro": 36, "con": 36, "struggl": 36, "unsuccess": 36, "usabl": 36, "concis": [36, 37], "head": [36, 37, 63], "module_c": 37, "null": 37, "perspect": 37, "resourc": [37, 41, 51], "primari": 37, "focu": [37, 51, 60, 71], "led": 37, "influenc": [37, 51], "guidelin": 37, "Be": [37, 45], "At": 37, "implement": [37, 50], "merg": 37, "complex": [37, 70], "BY": [37, 65, 68, 72], "pose": 37, "justif": 37, "poor": 37, "rubric": 38, "creating_line_of_best_fit": 39, "dot": [39, 45], "corner": [39, 63], "checkbox": 39, "trendlin": [39, 44], "thick": 39, "r": [39, 41, 42, 45, 48, 49, 50, 51], "y": [39, 40, 41, 43, 52, 53, 56], "intercept": [39, 40, 41, 43], "equation_of_a_line_refresh": 40, "mx": 40, "m": 40, "cross": 40, "steep": [40, 41], "depict": [40, 41], "video": [40, 48, 49], "interpreting_slop": 41, "straight": [41, 42, 44, 48, 53], "written": [41, 59, 63, 71], "frac": 41, "magnitud": 41, "confid": 41, "math": [41, 49, 59], "explanatori": [41, 48, 49, 51, 52, 53, 56], "scorecard": 41, "exhibit": 41, "upward": 41, "118": 41, "95": 41, "20347": 41, "constant": 41, "end": [41, 53, 65, 66, 68, 70, 71, 72], "break": [41, 55, 71], "quantifi": [41, 49, 55], "regard": 41, "incorpor": 41, "11895": 41, "895": 41, "accept": 41, "receiv": [41, 42, 49], "direct": [41, 45, 48, 53], "371": 41, "775": 41, "71": [41, 55], "proportion": 41, "factor": [41, 53, 63], "endow": [41, 51], "scholarship": [41, 49], "debt": [41, 49], "209": 41, "tuition": [41, 49], "19043": 41, "1200": [42, 43, 49], "loan": [42, 47, 49], "throughout": [42, 59, 64], "making_predictions_with_the_regression_lin": 43, "recal": [43, 50, 71], "0011x": 43, "7116": 43, "0011": 43, "wonder": [43, 63, 69], "scientif": 43, "freshmen": 43, "carefulli": 43, "portion": [43, 71], "6386": 43, "86": 43, "1400": [43, 49], "0365": 43, "65": [43, 53], "extrapol": [43, 45, 56], "nonlinear_regress": 44, "exponenti": 44, "polynomi": 44, "logarithm": 44, "dropdown": 44, "user": 44, "grew": 44, "2004": 44, "curv": [44, 53], "latitud": [44, 45, 52, 53, 55, 56, 70], "juneau": [44, 45, 56], "north": [44, 55], "overfit": 44, "fourth": 44, "nice": 44, "appar": [44, 50], "pass": 44, "domain": 44, "1x": 45, "116": 45, "blank": [45, 63], "__": 45, "85": 45, "331": 45, "identif": 45, "wouldn": 45, "unusu": 45, "43": 45, "portland": [45, 53], "northern": [45, 55], "steeper": 45, "shallow": 45, "boston": 45, "accident": 45, "678": 45, "strength": [48, 50, 53], "ly": 48, "uniqu": [48, 70, 74], "shape": [48, 53], "nonlinear": [48, 53], "thu": 48, "stronger": 48, "correlation_and_college_data": 49, "whichev": [49, 71], "strongest": 49, "metric": 49, "institut": 49, "public": [49, 70], "paid": [49, 53], "aid": 49, "enrol": 49, "pell": 49, "grant": 49, "emploi": 49, "transfer": 49, "proxi": 49, "closest": [49, 52], "84": 49, "correlation_and_filt": 50, "2017": 50, "trainer": 50, "regim": 50, "client": [50, 67], "routin": 50, "push": 50, "perform": [50, 63], "progress": 50, "pushup": 50, "treat": 50, "41": 50, "individu": [50, 54, 63, 71], "simpson": 50, "paradox": 50, "opposit": 50, "correlation_versus_caus": 51, "tempt": 51, "confound": 51, "causal": 51, "cone": 51, "sold": 51, "highli": 51, "sunburn": 51, "consumpt": 51, "awar": 51, "preval": [51, 63], "cooler": 51, "establish": 51, "wine": 51, "incid": 51, "attack": 51, "drink": 51, "reduct": 51, "risk": 51, "dine": 51, "dental": 51, "ate": 51, "diet": [51, 63], "activ": [51, 53], "floss": 51, "creating_a_scatter_plot_in_sheet": 52, "afterward": 52, "setup": [52, 67], "put": [52, 65], "furthest": 52, "describing_scatter_plot": 53, "18": [53, 63], "commut": 53, "st": 53, "loui": 53, "missouri": 53, "cold": [53, 55], "warm": [53, 55], "mile": 53, "gallon": 53, "highwai": 53, "mpg": 53, "coli": 53, "petri": 53, "dish": 53, "insur": 53, "driver": 53, "safer": 53, "riskier": 53, "uniform": 53, "adject": 53, "featur": 53, "weak": 53, "moder": 53, "weaker": 53, "northwest": 53, "temper": 53, "OR": 53, "onto": 54, "motivating_scatterplot": 55, "south": [55, 56], "pole": 55, "longitud": [55, 70], "noth": [55, 63], "hemispher": 55, "southern": [55, 56], "continent": 55, "35": [55, 56], "somewhat": 55, "arbitrari": 55, "36": 55, "27": [55, 56], "68": 55, "bigger": 55, "dayton": 55, "ohio": 55, "memphi": 55, "tennesse": 55, "07": 55, "handi": 55, "scatter_plot": 56, "charleston": 56, "carolina": 56, "52": 56, "26": 56, "aka": 56, "synonym": 56, "disciplin": 56, "predictor": 56, "coordin": 56, "el": 56, "paso": 56, "unreli": 56, "cannot": [59, 63], "entitl": 59, "undoubtedli": 59, "normal": 59, "inde": 59, "suspici": 59, "foolproof": 59, "debug": 59, "tip": 59, "messag": 59, "paramet": 59, "infinit": [59, 63], "undefin": 59, "broken": 59, "stackoverflow": 59, "million": 59, "matter": [59, 63], "softwar": 60, "slightli": 60, "cake": 62, "fibonacci": 62, "sequenc": 62, "what_is_a_formula": 63, "combin": [63, 65, 70], "forget": 63, "87": 63, "bake": 63, "quick": 63, "recip": 63, "serv": [63, 65], "host": [63, 71], "ingredi": 63, "fraction": 63, "cup": 63, "veget": 63, "oil": 63, "scale": [63, 69], "flour": 63, "upsiz": 63, "cocoa": 63, "powder": 63, "771": 63, "24": 63, "desir": 63, "hardcod": 63, "d2": 63, "d3": 63, "b3": 63, "e3": 63, "implicit": 63, "semi": 63, "magic": 63, "teaspoon": 63, "vanilla": 63, "origin": [63, 70], "challeng": 63, "miscalcul": 63, "hang": 63, "oper": [63, 65], "special": 63, "art": 63, "rabbit": 63, "flower": 63, "leaf": 63, "stop": 63, "consecut": 63, "golden": 63, "pure": 63, "sculptur": 63, "architectur": 63, "mona": 63, "lisa": 63, "classic": 63, "modern": 63, "50th": 63, "mental": 63, "arithmet": 63, "long": 63, "let": 63, "mistak": 63, "a3": 63, "a4": 63, "a50": 63, "778": 63, "742": 63, "049": 63, "recurs": 63, "brainpow": 63, "digit": 63, "100th": 63, "1st": 63, "daunt": 63, "prolif": [63, 64], "lifetim": 63, "amedeo": 63, "modigliani": 63, "h": 63, "h2": 63, "remain": 63, "j": 63, "our": 63, "statement1": 63, "statement2": 63, "i2": 63, "j2": 63, "k": 63, "digest": 63, "succinct": 63, "k2": 63, "titian": 63, "pierr": 63, "august": 63, "paul": 63, "diego": 63, "rivera": 63, "claud": 63, "monet": 63, "edgar": 63, "wrap": [63, 70], "isol": 63, "14": 63, "400": 63, "what_is_a_sheet": 64, "known": 64, "matrix": 64, "dimension": 64, "view": [64, 71], "terminologi": 64, "singular": 64, "document": [64, 67], "convent": 64, "current": 64, "sheet1": 64, "abstract": 64, "edouard": 64, "manet": 64, "e8": 64, "salvador": 64, "dali": 64, "spanish": 64, "pablo": 64, "picasso": 64, "belgian": 64, "leonardo": 64, "da": 64, "vinci": 64, "die": 64, "andi": 64, "warhol": 64, "mix": 64, "keyword": [65, 66, 68, 70, 71, 72], "bike": [65, 66, 71, 72], "subscrib": 65, "member_typ": [65, 66, 68, 71], "n_trip": 65, "avg": [65, 68, 70], "aggreat": 65, "casual": [65, 68, 70], "w01274": 65, "31111": [65, 66, 68, 72], "start_stat": [65, 68, 70, 72], "AS": [65, 68, 70, 71], "mean_dur": [65, 70], "trip_data": [65, 68, 70, 71], "3600": [65, 66, 68], "desc": [65, 72], "alia": [65, 70], "ident": 65, "immedi": 65, "ridden": 65, "longest": [65, 72], "shorthand": [65, 71], "els": [65, 67, 68], "end_stat": [65, 68, 72], "append": 66, "column_condit": 66, "w00153": 66, "how_to_run_sql": 67, "command": [67, 72], "version": 67, "somewher": 67, "db": 67, "drown": 67, "webpag": 67, "ultim": 67, "ones": 67, "pick": 67, "feel": 67, "ifs_and_cas": 68, "bikeshar": [68, 70], "shorter": 68, "familar": 68, "over_one_hour": 68, "not_over_one_hour": 68, "is_over_one_hour": 68, "inbuilt": 68, "th": 68, "column_1": 68, "column_2": 68, "claus": [68, 70, 72, 74], "versatil": 68, "ifs": 68, "compris": 68, "THEN": 68, "met": 68, "duration_group": 68, "2468": 68, "soon": 68, "AND": 68, "casual_same_st": 68, "member_same_st": 68, "casual_different_st": 68, "member_different_st": 68, "ride_classif": 68, "proportion_trips_over_one_hour": 68, "IN": 68, "stand": 69, "program": [69, 71], "anyth": 69, "stock": 69, "patient": 69, "hospit": 69, "reorgan": 69, "cumbersom": 69, "bikeshare_st": 70, "station_id": 70, "statu": 70, "wish": 70, "ON": 70, "van": 70, "ness": 70, "metro": 70, "udc": 70, "unpack": 70, "alias": [70, 74], "accord": 70, "inner": 70, "12345": 70, "convers": 70, "trips_data": 70, "adam": 70, "mill": 70, "columbia": 70, "rd": 70, "nw": 70, "hous": 70, "rider": 70, "accomplish": [70, 71], "outer": 70, "internship": 71, "washington": 71, "capit": 71, "2011": 71, "behavior": 71, "english": 71, "upper": 71, "eas": 71, "start_dat": 71, "block": 71, "n_row": 71, "primarili": 72, "decreasingli": 72, "asc": 72, "forth": 72, "recent": 72, "subqueri": 74}, "objects": {}, "objtypes": {}, "objnames": {}, "titleterms": {"count": [0, 65], "sum": 0, "definit": [0, 3, 4, 5, 8, 9, 64], "applic": [0, 3, 5], "exampl": [0, 2, 3, 4, 5, 8, 10, 11, 21, 28, 29, 41, 49, 63, 64], "sheet": [0, 2, 3, 4, 10, 11, 22, 52, 62, 64], "syntax": 0, "spotifi": 0, "premium": 0, "introduct": [1, 12, 23, 26, 27, 42, 54, 60, 69], "measur": [2, 3], "center": [2, 29], "The": [2, 63, 65], "three": 2, "test": 2, "score": [2, 41], "weather": [2, 3, 4, 8], "spread": 3, "standard": 3, "deviat": 3, "histogram": [3, 5, 22], "extens": [3, 8, 65, 70], "varianc": 3, "student": [3, 8], "height": 3, "further": [3, 5], "minimum": 4, "maximum": 4, "dice": [4, 5], "roll": [4, 5], "option": 4, "match": 4, "outlier": [5, 45], "skew": 5, "posit": 5, "incom": 5, "summari": [6, 13, 17, 25, 30, 46, 57, 61, 73], "basic": [7, 62, 64], "descript": [7, 35, 36, 37], "statist": [7, 9, 29], "content": [7, 14, 18, 19, 26, 31, 47, 58, 62, 74], "variabl": 8, "data": [8, 10, 11, 15, 16, 18, 28, 31, 49], "discret": 8, "continu": 8, "order": 8, "categor": 8, "what": [9, 20, 21, 24, 63, 64], "i": [9, 20, 24, 63, 64], "A": [9, 32, 35, 63], "filter": [10, 14, 50, 66], "painter": [10, 11, 63, 64], "sort": [10, 72], "group": [11, 14], "function": [11, 63], "titan": 11, "export": [15, 18], "import": [16, 18], "appli": 19, "comput": 19, "1": 19, "textbook": [19, 67], "checklist": [20, 24], "creat": [20, 39, 52], "visual": [20, 21, 24, 26], "make": [20, 43, 52], "access": 20, "should": [20, 24], "keep": 20, "mind": 20, "when": [20, 24], "hollywood": 21, "": 21, "gender": 21, "imbal": 21, "onli": 21, "non": [21, 44], "white": 21, "peopl": 21, "vote": 21, "bar": [22, 23], "chart": [22, 23], "us": 22, "pie": 23, "tabl": [23, 29], "read": 24, "look": 24, "To": 26, "join": [28, 70], "groceri": 28, "list": 28, "death": 28, "rate": 28, "state": 28, "caus": 28, "over": 28, "time": 28, "pivot": 29, "nation": 29, "health": 29, "manipul": 31, "modul": [32, 33, 34, 35, 36, 37], "prefac": [32, 33, 34], "b": [33, 36], "c": [34, 37], "project": [35, 36, 37, 38], "grade": [35, 36, 37], "rubric": [35, 36, 37], "line": [39, 40, 43, 47], "best": [39, 47], "fit": [39, 47], "equat": 40, "refresh": 40, "interpret": 41, "slope": 41, "sat": 41, "loan": 41, "predict": 43, "regress": [43, 44, 47], "linear": 44, "correl": [48, 49, 50, 51, 58], "colleg": 49, "versu": 51, "causat": 51, "scatter": [52, 53, 56, 58], "plot": [52, 53, 56, 58], "how": [52, 67], "describ": 53, "motiv": 55, "scatterplot": 55, "error": 59, "formula": 63, "chocol": 63, "cake": 63, "fibonacci": 63, "sequenc": 63, "AND": 63, "IF": 63, "aggreg": 65, "uniqu": 65, "valu": 65, "have": 65, "claus": 65, "number": 65, "column": 65, "alias": 65, "run": 67, "sql": [67, 74], "outsid": 67, "thi": 67, "Ifs": 68, "case": 68, "subqueri": 70, "select": 71}, "envversion": {"sphinx.domains.c": 2, "sphinx.domains.changeset": 1, "sphinx.domains.citation": 1, "sphinx.domains.cpp": 8, "sphinx.domains.index": 1, "sphinx.domains.javascript": 2, "sphinx.domains.math": 2, "sphinx.domains.python": 3, "sphinx.domains.rst": 2, "sphinx.domains.std": 2, "sphinx": 57}, "alltitles": {"Count and Sum": [[0, "count-and-sum"]], "Count Definitions": [[0, null]], "Sum Definition": [[0, null]], "Applications and Examples": [[0, "applications-and-examples"]], "Count and Sum Sheets Syntax": [[0, null]], "Example: Spotify Premium": [[0, "example-spotify-premium"]], "Introduction": [[1, "introduction"], [12, "introduction"], [23, "introduction"], [27, "introduction"], [42, "introduction"], [54, "introduction"], [60, "introduction"], [69, "introduction"]], "Measures of Center": [[2, "measures-of-center"]], "The Three Measures of Center": [[2, null]], "Measures of Center in Sheets": [[2, null]], "Example: Test Scores": [[2, "example-test-scores"]], "Example: Weather": [[2, "example-weather"], [3, "example-weather"], [4, "example-weather"], [8, "example-weather"]], "Measures of Spread": [[3, "measures-of-spread"]], "Standard Deviation Definition": [[3, null]], "Standard Deviation in a Histogram": [[3, "standard-deviation-in-a-histogram"]], "Standard Deviation in Sheets": [[3, null]], "Extension: Variance": [[3, "extension-variance"]], "Variance Definition": [[3, null]], "Variance in Sheets": [[3, null]], "Example: Student Heights": [[3, "example-student-heights"]], "Further Application": [[3, "further-application"], [5, "further-application"]], "Minimum and Maximum": [[4, "minimum-and-maximum"]], "Minimum Definition": [[4, null]], "Maximum Definition": [[4, null]], "Example: Dice Roll": [[4, "example-dice-roll"], [5, "example-dice-roll"]], "Minimum and Maximum in Sheets": [[4, null]], "Optional: Match": [[4, "optional-match"]], "Match Definition": [[4, null]], "Outliers and Skew": [[5, "outliers-and-skew"]], "Outlier Definition": [[5, null]], "Outliers in a Histogram": [[5, "outliers-in-a-histogram"]], "Skew Definition": [[5, null]], "Skew in a Histogram": [[5, "skew-in-a-histogram"]], "Example: Positive Skew": [[5, "example-positive-skew"]], "Example: Income": [[5, "example-income"]], "Summary": [[6, "summary"], [13, "summary"], [17, "summary"], [25, "summary"], [30, "summary"], [46, "summary"], [57, "summary"], [61, "summary"], [73, "summary"]], "Basic Descriptive Statistics": [[7, "basic-descriptive-statistics"]], "Contents": [[7, null], [14, null], [18, null], [19, "contents"], [26, null], [31, null], [47, null], [58, null], [62, null], [74, null]], "Variables": [[8, "variables"]], "Variable Definition": [[8, null]], "Example: Student Data": [[8, "example-student-data"]], "Extension: Discrete and Continuous Variables": [[8, "extension-discrete-and-continuous-variables"]], "Extension: Ordered Categorical Variables": [[8, "extension-ordered-categorical-variables"]], "What Is A Statistic?": [[9, "what-is-a-statistic"]], "Statistic Definition": [[9, null]], "Filtering Data": [[10, "filtering-data"]], "Filters in Sheets": [[10, null]], "Example: Painters": [[10, "example-painters"], [11, "example-painters"], [63, "example-painters"], [64, "example-painters"]], "Sorting Data": [[10, "sorting-data"]], "Grouping Data": [[11, "grouping-data"]], "Grouping Functions in Sheets": [[11, null]], "Example: Titanic": [[11, "example-titanic"]], "Filtering and Grouping": [[14, "filtering-and-grouping"]], "Exporting Data": [[15, "exporting-data"]], "Importing Data": [[16, "importing-data"]], "Importing and Exporting Data": [[18, "importing-and-exporting-data"]], "Applied Computing 1 Textbook": [[19, "applied-computing-1-textbook"]], "Checklist for Creating Visualizations": [[20, "checklist-for-creating-visualizations"]], "Making Accessible Visualizations": [[20, "making-accessible-visualizations"]], "What should I keep in mind when creating a visualization?": [[20, "what-should-i-keep-in-mind-when-creating-a-visualization"]], "Example Visualizations": [[21, "example-visualizations"]], "\u201cHollywood\u2019s Gender Imbalance\u201d": [[21, "hollywood-s-gender-imbalance"]], "\u201cWhat if only non-white people voted?\u201d": [[21, "what-if-only-non-white-people-voted"]], "Histograms and Bar Charts": [[22, "histograms-and-bar-charts"]], "Using Sheets": [[22, "using-sheets"]], "Pie Chart": [[23, "pie-chart"]], "Table": [[23, "table"]], "Bar Chart": [[23, "bar-chart"]], "Checklist for Reading Visualizations": [[24, "checklist-for-reading-visualizations"]], "What should I look for when reading a visualization?": [[24, "what-should-i-look-for-when-reading-a-visualization"]], "Introduction To Visualizations": [[26, "introduction-to-visualizations"]], "Joining Data": [[28, "joining-data"]], "Example: Grocery List": [[28, "example-grocery-list"]], "Example: Death Rate by State": [[28, "example-death-rate-by-state"]], "Example: Cause of Death over Time": [[28, "example-cause-of-death-over-time"]], "Pivot Tables": [[29, "pivot-tables"]], "Example: National Center for Health Statistics": [[29, "example-national-center-for-health-statistics"]], "Manipulating Data": [[31, "manipulating-data"]], "Module A Preface": [[32, "module-a-preface"]], "Module B Preface": [[33, "module-b-preface"]], "Module C Preface": [[34, "module-c-preface"]], "Module A": [[35, "module-a"]], "Project Description": [[35, "project-description"], [36, "project-description"], [37, "project-description"]], "Grading Rubric": [[35, "grading-rubric"], [36, "grading-rubric"], [37, "grading-rubric"]], "Module B": [[36, "module-b"]], "Module C": [[37, "module-c"]], "Projects": [[38, "projects"], [38, null]], "Creating a Line of Best Fit": [[39, "creating-a-line-of-best-fit"]], "Equation of a Line (Refresher)": [[40, "equation-of-a-line-refresher"]], "Interpreting Slope": [[41, "interpreting-slope"]], "Example: SAT Scores and Loans": [[41, "example-sat-scores-and-loans"]], "Making Predictions with the Regression Line": [[43, "making-predictions-with-the-regression-line"]], "Non-Linear Regression": [[44, "non-linear-regression"]], "Outliers": [[45, "outliers"]], "Regression and \u201cLine of Best Fit\u201d": [[47, "regression-and-line-of-best-fit"]], "Correlation": [[48, "correlation"]], "Example: Correlation and College Data": [[49, "example-correlation-and-college-data"]], "Correlation and Filtering": [[50, "correlation-and-filtering"]], "Correlation versus Causation": [[51, "correlation-versus-causation"]], "Creating a Scatter Plot in Sheets": [[52, "creating-a-scatter-plot-in-sheets"]], "How to make a scatter plot": [[52, "how-to-make-a-scatter-plot"]], "Describing Scatter Plots": [[53, "describing-scatter-plots"]], "Motivating Scatterplots": [[55, "motivating-scatterplots"]], "Scatter Plots": [[56, "scatter-plots"]], "Scatter Plots and Correlation": [[58, "scatter-plots-and-correlation"]], "Errors": [[59, "errors"]], "Sheets Basics": [[62, "sheets-basics"]], "What Is A Formula?": [[63, "what-is-a-formula"]], "Example: Chocolate Cake": [[63, "example-chocolate-cake"]], "Example: The Fibonacci Sequence": [[63, "example-the-fibonacci-sequence"]], "The AND Function": [[63, null]], "The IF Function": [[63, null]], "What is a Sheet?": [[64, "what-is-a-sheet"]], "Basic Definitions": [[64, null]], "Aggregating": [[65, "aggregating"]], "Extension: Counting Unique Values": [[65, "extension-counting-unique-values"]], "Extension: The HAVING Clause": [[65, "extension-the-having-clause"]], "Extension: Numbered Column Aliases": [[65, "extension-numbered-column-aliases"]], "Filtering": [[66, "filtering"]], "How to Run SQL Outside of This Textbook": [[67, "how-to-run-sql-outside-of-this-textbook"]], "Ifs and Cases": [[68, "ifs-and-cases"]], "Joining": [[70, "joining"]], "Extension: Subqueries": [[70, "extension-subqueries"]], "Selecting": [[71, "selecting"]], "Sorting": [[72, "sorting"]], "SQL": [[74, "sql"]]}, "indexentries": {}})