Data Science For All Global Edition – Brennan Davis

We can represent them in several ways. Often, they simply have no value. However, sometimes they appear as NULL, Unknown, — , or N/A, which means “not avail- able” or “no value is available.” Dataset: Customers Suppose Zahava wants to see if any customer postal codes are missing.

She can ask for observations with no value for the PostalCode variable (i.e., the value is null , empty, or missing). Zahava asks you to retrieve all variables for observations where the postal code has no value. Query 5.7: What are the observations from the Customers table where the postal code ( PostalCode ) is missing? Questions Answer the following questions based on the results of Query 5.7.

1. How many customers have no postal code listed in their observations? 2. Which country has the most missing data in PostalCode ? Tool Time–Available in MyLab Statistics Excel Python StatCrunch Try It Yourself: Filter Missing Values Multiple Condition Filtering Sometimes, we want results based on several conditions. We may even like to filter observa- tions based on numerical and text variables.

We can use many operators to query results this way, including AND and OR. Dataset: Products Zahava’s products come in many sizes. A customer calls saying she cannot remember the name of a product that comes in 24 packs of 12 oz bottles and priced at $19 . Zahava asks you to query this. Query 5.8a: What are the observations from the Products table where the unit ( Unit ) is “ 24 – 12 oz bottles” and the price ( Price ) is $19 ?

She also wants to know the name of a product that comes in 24 packs of 12 oz bottles and priced at $14 . Query 5.8b: What are the observations from the Products table where the unit ( Unit ) is “ 24 – 12 oz bottles” and the price ( Price ) is $14 ? Try It Yourself: Filter Multiple Conditions Simultaneously Ordering Observations Frequently, our queries concern the highest or lowest values of variables.

Content Development: David Dietz, Thomas Atwater, Amit Verma, Ravi Indiver Content Management: Laura Briskman, Monique Bettencourt Content Production: Mahalakshmi Usha, Nupur Anand, Audra Walsh, Robert Carroll, Dominick Frank, Sandra Rodriguez, Scott Disanno, Rachel Reeve, Guadalupe Edgar Product Management: Karen Montgomery Product Marketing: Demetrius Hall Rights and Permissions: Ben Ferrini, Anjali Singh, Vignesh Murugamoorthy Please contact www.AskPearsonSupport.com with any queries on this content. Pearson puts care into the creation of our products. Our learning materials undergo content reviews to minimize bias and ensure the content is inclusive, accurate, and relevant.

Please use this link to report instances of bias and inaccuracies: https://www.pearson.com/ report-bias.html You can learn more about Pearson’s commitment to accessibility at https://www.pearson.com/us/accessibility.html Cover images from Shutterstock, D.R.3D/Shutterstock, AAVAA / Shutterstock, and NasonovVasiliy/Shutterstock. Microsoft and/or its respective suppliers make no representations about the suitability of the information contained in the documents and related graphics published as part of the services for any purpose.

All such documents and related graphics are provided “as is” without warranty of any kind. Microsoft and/or its respective suppliers hereby disclaim all warranties and conditions with regard to this information, including all warranties and conditions of merchantability, whether express, implied or statutory, fitness for a particular purpose, title and non-infringement. In no event shall Microsoft and/or its respective suppliers be liable for any special, indirect or consequential damages or any damages whatsoever resulting from loss of use, data or profits, whether in an action of contract, negligence or other tortious action, arising out of or in connection with the use or performance of information available from the services.

The documents and related graphics contained herein could include technical inaccuracies or typographical errors. Changes are periodically added to the information herein. Microsoft and/or its respective suppliers may make improvements and/or changes in the product(s) and/or the program(s) described herein at any time. Partial screen shots may be viewed in full within the software version specified.

Microsoft® and Windows® are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. This book is not sponsored or endorsed by or affiliated with the Microsoft Corporation. Copyright © 2026 by Pearson Education, Inc. or its affiliates. All Rights Reserved. This digital publication is protected by copyright, and permission should be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise except as authorized for use under the product subscription through which this digital application is accessed.

For information regarding permissions, request forms and the appropriate contacts within the Pearson Education Global Rights & Permissions department, please visit https://www. pearson.com/global-permission-granting.html. Acknowledgments of third-party content appear on the appropriate page within the text. PEARSON and ALWAYS LEARNING are exclusive trademarks in the U.S.

This is a short excerpt from the opening of “” by Unknown, quoted for review and introduction purposes. All rights belong to the copyright holders.

Book Information

• Unique ID: 6fb190930b1480c2
• File Extension: .pdf
• File Size: 88,650,302 bytes (84.544 MB)
• Title: –
• Author: Unknown
• ISBN: 9780138323141, 9780135311417, 0138323143, 0135311411
• Pages: 586
• Language: English (en)

Reading & Word Statistics

• Estimated Reading Time: 982.36 minutes
• Total Words: 196,471
• Total Characters: 1,260,604
• Average Words per Page: 335.27
• Average Characters per Page: 2151.2

Most Frequent Words

data (3495), dataset (1288), variable (1063), variables (794), values (784), figure (735), chapter (660), science (596), between (510), model (505), using (504), two (499), mean (498), learning (494), value (482), table (470), analysis (458), use (428), test (418), observations (401), cat (397), sample (394), new (393), results (371), example (368), one (364), questions (361), many (317), number (315), different (308), create (308), average (305), quantitative (295), following (287), categorical (271), compute (271), used (268), section (267), regression (263), based (263), random (258), plot (258), type (256), students (253), visualization (253), machine (251), missing (245), hypothesis (242), time (236), like (234), also (230), statistics (228), column (223), try (215), population (212), probability (211), select (211), click (209), countries (206), variability (203), models (200), bill (199), yourself (197), information (193), however (190), distribution (189), make (188), response (188), filter (187), text (186), histogram (186), answer (183), see (180), depth (176), higher (176), star (174), often (173), gpa (172), box (170), linear (169), decision (169), people (167), relationship (165), tables (165), describe (164), chart (164), predict (164), methods (163), method (162), framework (162), process (159), group (158), three (157), explanatory (154), clusters (153), available (152), clustering (152), consider (152), range (150), subset (150).

PDF Download