Foundations: Data, Data, Everywhere By Google, Coursera All Quiz Answers

Foundations: Data, Data, Everywhere By Google, Coursera All Quiz Answers With Explanation. A company defines a problem it wants to solve. Then, a data analyst gathers relevant data, analyzes it, and uses it to draw conclusions. The analyst shares their analysis with subject-matter experts, who validate the findings. Finally, a plan is put into action. What does this scenario describe? 1/ 1 point O Data-driven decision-making ¥ O Identification of trends O Data science O Customer service Correct This company has put data at the heart of its business strategy in order to achieve data-driven decision-making. A company takes insights provided by its data analytics team, validates them, and finalizes a strategy. They then implement a plan to solve the original business problem. This describes the share step of the data analysis process. 1/ 1 point O True O False ¥ A company takes insights provided by its data analytics team, validates them, and finalizes a strategy. They then implement a plan to solve the original business problem. This describes which step of the data analysis process? 1/ 1 point O Process ¥ O Act ¥ O Share X O Analyze X A data analyst creates the following visualization to clearly demonstrate how much more populous Charlotte is than the next-largest North Carolina city, Raleigh. What type of chart is 1t? |,A bar graph showing the Populations of the 10 largest North Carolina Cities 1/ 1 point O A line chart O A pie chart © A column, or bar, chart O A scatter chart Correct The chart is a column chart. A column chart is effective at demonstrating the differences between several items in a specific range of values. A data analyst finishes analyzing data for a marketing project. The results are clear, so they present findings and recommendations to the client. What should they have done before that presentation? 1/ 1 point O Created a model based on the results of the analysis O Archived the datasets in order to keep them secure O Shared the results with subject-matter experts from the marketing team for their input ¥ O Surveyed customers about results, conclusions, and recommendations Correct Including insights from people who are familiar with the business problem is an example of data-driven decision-making. A data analyst has finished an analysis project that involved private company data. They erase the digital files in order to keep the information secure. This describes which stage of the data life cycle? 1/ 1 point O Manage O Plan O Archive O Destroy ¥ Correct This describes the destroy phase, during which data analysts use secure data-erasure software and shred paper files to protect private information. A data analyst uses a spreadsheet function to aggregate data. Then, they add a pivot table to show totals from least to greatest. This would happen during which stage of the data life cycle? 1/ 1 point O Analyze ¥ O Capture O Manage O Plan Correct The analyze stage is when data is used to make good decisions, and a spreadsheet is a very useful tool for supporting that objective. A data analyst wants to demonstrate a trend of how something has changed over time. What type of chart 1s best for this task? 1/ 1 point O Column @ Line O Bar O Area Correct Line charts are effective for illustrating trends and patterns, such as how something changes over time. A data analyst wants to demonstrate how the population in Charlotte has increased over time. They create the chart below. What is this type of chart called? |,2A line graph of the population of Charlotte, NC from 1/ 1 point O Bar chart O Column chart O Area chart O Line chart ¥ Correct This is a line chart. Line charts are effective for demonstrating trends and patterns, such as how population changes over time. A data analyst wants to demonstrate how the population in Charlotte has increased over time. They create this data visualization. This is an example of an area chart. |,2A line graph of the population of Charlotte, NC from 1/ 1 point O True O False ¥ Correct This is a line chart. Line charts are effective for illustrating trends and patterns, such as how population changes over time. A data analyst wants to retrieve information from a database. Select the correct tool from the data analyst’s toolkit. 1/ 1 point O Visualization O Spreadsheet O Dashboard O Query ¥ Correct A query enables data analysts to request, retrieve, and update information from a database. A data analyst works for an appliance manufacturer. Last year, the company’s profits were down. Lower profits can be a result of fewer people buying appliances, higher costs to make appliances, or a combination of both. The analyst recognizes that those are big issues to solve, so they break down the problems into smaller pieces to analyze them in an orderly way. Which analytical skill are they using? 1/ 1 point O Curiosity O A technical mindset ¥ O Understanding context O Data strategy Correct They are using a technical mindset, which involves the ability to break things down into smaller steps or pieces and work with them in an orderly and logical way. A furniture manufacturer wants to find a more environmentally friendly way to make its products. A data analyst helps solve this problem by gathering relevant data, analyzing it, and using it to draw conclusions. The analyst then shares their analysis with subject-matter experts from the manufacturing team, who validate the findings. Finally, a plan is put into action. This scenario describes data science. 1/ 1 point O True O False ¥ Correct This company has put data at the heart of its business strategy in order to achieve data-driven decision-making. A junior data analyst is seeking out new experiences in order to gain knowledge. They watch videos and read articles about data analytics. They ask experts questions. Which analytical skill are they using? 1/ 1 point O Curiosity ¥ O Data strategy © Understanding context O Having a technical mindset Correct Curious people seek out new experiences, which leads to knowledge. Adding descriptive headers to columns of data in a spreadsheet is an example of which analytical skill? 1/ 1 point O Data strategy O Understanding context ¥ O Big-picture thinking O Curiosity Correct Context is the condition in which something exists, such as a structure. Labeling the top row in a spreadsheet column provides context about the data below. An airport wants to make its luggage-handling process faster and simpler for travelers. A data analyst examines and evaluates how the process works currently in order to achieve the goal of a more efficient process. What methodology do they use? 1/ 1 point O The five whys O Gap analysis ¥ O Data visualization O Strategy Correct Gap analysis is a method for examining and evaluating how a process works currently in order to get where you want to be in the future. Billings Upholstery has defined a problem it needs to solve: Find a more environmentally friendly way to produce its furniture. A data analyst gathers relevant data, analyzes it, and uses it to draw conclusions. The analyst then shares their analysis with subject-matter experts from the manufacturing team, who validate the findings. Finally, a plan is put into action. This scenario describes what process? 1/ 1 point O Customer service O Data science O Identification of trends O Data-driven decision-making ¥ Correct This company has put data at the heart of its business strategy in order to achieve data-driven decision-making. Correlation is the aspect of analytical thinking that involves figuring out the specifics that help you execute a plan. 1/ 1 point O True O False ¥ Correct Correlation involves being able to identify a relationship between two or more pieces of data. Curiosity is an analytical skill that involves which of the following? 1/ 1 point O Using your gut instinct O Collaborating to solve a problem O Working with facts in an orderly manner O Seeking out new challenges and experiences ¥ Correct Curious people usually seek out new challenges and experiences which leads to knowledge. Data analysis is the various elements that interact with one another in order to provide, manage, store, organize, analyze, and share data. 1/ 1 point O True O False ¥ Correct Data analysis is the collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making. Data analysts ask, “Why?” five times in order to get to the root cause of a problem. 1/ 1 point O True ¥ O False Correct Data analysts ask, “Why?” five times in order to get to the root cause of a problem. Data analysts use queries to request, retrieve, and update information within a database. 1/ 1 point O True ¥ O False Correct Data analysts use queries to request, retrieve, and update information within a database. Data design is how you organize information; data strategy is the management of the people, processes, and tools used in data analysis. 1/ 1 point O True O False ¥ Correct Data design is how you organize information; data strategy is the management of the people, processes, and tools used in data analysis. Data-driven decision-making involves the five analytical skills: curiosity, understanding context, having a technical mindset, data design, and data strategy. Each plays a role in data-driven decision-making. 1/ 1 point O True ¥ O False Correct Data-driven decision-making involves curiosity, understanding context, having a technical mindset, data design, and data strategy. Describe how the data life cycle differs from data analysis. 1/ 1 point O The data life cycle deals with identifying the best data to solve a problem; data analysis is about asking effective questions. O The data life cycle deals with making informed decisions; data analysis is using tools to transform data. O The data life cycle deals with the stages that data goes through during its useful life; data analysis is the process of analyzing data. ¥ O The data life cycle deals with transforming and verifying data; data analysis is using the insights gained from the data. Correct The data life cycle involves stages for identifying needs and managing data. Data analysis involves process steps to make meaning from data. During the capture stage of the data life cycle, a data analyst may use spreadsheets to aggregate data. 1/ 1 point O True O False ¥ Correct Using spreadsheets to aggregate data would happen during the analyze stage. Fill in the blank: involves the ability to break things down into smaller steps or pieces and work with them in an orderly and logical way. 1/ 1 point O Curiosity O Context O Data strategy O A technical mindset ¥ Correct Having a technical mindset involves the ability to break things down into smaller steps or pieces and work with them in an orderly and logical way. Fill in the blank: A business decides what kind of data it needs, how the data will be managed, and who will be responsible for it during the stage of the data life cycle. 1/ 1 point O analyze O capture O manage O plan ¥ Correct A business decides what kind of data it needs, how the data will be managed, and who will be responsible for it during the plan stage of the data life cycle. Fill in the blank: A data analyst creates a table, but they realize this isn’t the best visualization for their data. To fix the problem, they decide to use the feature to change it to a column chart. 1/ 1 point O filter view O image O rename O chart editor ¥ Correct The chart editor enables data analysts to choose the type of chart you're making and customize its appearance. Fill in the blank: A formula is a set of instructions used to perform a specified calculation; whereas a function is . 1/ 1 point Oa particular value O a question written by the user O a computer programming language O a predefined operation ¥ Correct A formula is a set of instructions used to perform a specified calculation; a function is a preset command that automatically performs a specified process. Fill in the blank: A function is a predefined operation, whereas a formula is 1/ 1 point Oa set of instructions used to perform a specified calculation. V © a computer programming language Oa particular value O a predefined statement Correct A function is a preset command that automatically performs a specified process; a formula is a set of instructions used to perform a specified calculation. Fill in the blank: A query is used to information from a database. Select all that apply. 1/ 1 point U retrieve ¥ Copy Correct A query enables data analysts to request, retrieve, and update information from a database. C update ¥ Copy Correct A query enables data analysts to request, retrieve, and update information from a database. Fill in the blank: Being able to identify a relationship between two or more pieces of data describes 1/ 1 point O problem-orientation O detail-oriented thinking O correlation O visualization Correct Being able to identify a relationship between two or more pieces of data describes correlation. Fill in the blank: Data involves creating new ways of modeling and understanding the unknown by using raw data. 1/ 1 point O engineering O science O analysis ¥ O design Correct This is because it is the definition of data analysis. Fill in the blank: Data analysts use the five analytical skills of curiosity, understanding context, having a technical mindset, data design, and data strategy to make decisions. O/ 1 point O intuitive O forward-looking O more efficient X¥ O data-driven ¥ Fill in the blank: Data ecosystems are made up of elements that with each other. This makes it possible for them to produce, manage, store, organize, analyze, and share data. 1/ 1 point O gain insights O unite O interact ¥ O problem-solve Copy Correct Data ecosystems are made up of various elements that interact with one another in order to produce, manage, store, organize, analyze, and share data. Fill in the blank: Data strategy involves the people, processes, and tools used in data analysis. 1/ 1 point O managing ¥ O supervising O choosing O visualizing Correct Data strategy is the management of the people, processes, and tools used in data analysis. Fill in the blank: In row 8 of the following spreadsheet, you can find the of Cary. | |A__|B llc [D | | 1 [Rank [Name [Population ||County | 2 i 1 ||Charlotte ||885,708 [Mecklenburg 3. |j2 [Raleigh ||474,069 Wake (seat), Durham l4. 3 ||Greensboro ||296,710 |Guilf ord | 5 4 [Durham ||278,993 [Durham (seat), Wake, Orange lo [5 [Winston-Salem ||247,945 |[Forsyth | 7 lo Fayetteville |21 1,657 '|Cumberland Ig. |i7 [Cary ||170,282 ||Wake, Chatham | 9 8 [Wilmington I 123,784 |New Hanover 110 i) [High Point {]112,791 ||Guilford, Randolph, Davidson, Forsyth | laa lla Aw aned llag 24 WA heen | Fill in the blank: In the following spreadsheet, the feature was used to alphabetize the city names in column B. [Ap Ie Pp | | 1 [Rank [Name [Population ||County | 2 |7 |Cary ||170,282 Wake, Chatham 3 i 1 ||Charlotte ||885,708 [Mecklenburg l4 10 ——||Concord 196,341 '|Cabarrus 5 4 [Durham ||278,993 [Durham (seat), Wake, Orange lo IG [Fayetteville |21 1,657 '|Cumberland | 7 iB '|Greensboro ||296,710 |Guilford Ig i [High Point [112,791 |Guilford, Randolph, Davidson, Forsyth | 9 |/2 [Raleigh ||474,069 Wake (seat), Durham 110 lg Wilmington ||123.784 [New Hanover | Fill in the blank: The data life cycle has six stages, whereas data analysis has six . 1/ 1 point O key questions O process steps ¥ O data types O data analytics tools Correct Although both the data life cycle and the data analysis process have six elements, the life cycle involves stages and analysis involves process steps. Fill in the blank: The people very familiar with a business problem are called . They are an important part of data-driven decision-making. 1/ 1 point O stakeholders O competitors O customers O subject-matter experts ¥ Correct Subject-matter experts are very familiar with the business problem and can look at the results of data analysis to validate the choices being made. Fill in the blank: The primary goal of a data is to create new questions using data. 1/ 1 point O engineer O designer O analyst ¥ O scientist Fill in the blank: The primary goal of a data is to find answers to existing questions by creating insights from data sources. 1/ 1 point O engineer ¥ O designer O scientist O analyst Fill in the blank: To request, retrieve, and update information in a database, data analysts use a ___. 1/ 1 point O formula O dashboard O query ¥ O calculation Correct A query enables data analysts to request, retrieve, and update information from a database. Gap analysis is a method for examining and evaluating how a process works currently in order to get where you want to be in the future. 1/ 1 point O True ¥ O False Correct Gap analysis is a method for examining and evaluating how a process works currently in order to get where you want to be in the future. Identifying the motivation behind data collection and gathering additional information are examples of which analytical skill? 1/ 1 point O Data strategy O Data design O Understanding context ¥ OA technical mindset Correct Identifying the motivation behind data collection and gathering additional information are examples of understanding context. Context is the condition in which something exists. If a data analyst wants to list the cities in this spreadsheet alphabetically, instead of numerically, what feature can they use in column B? A B Cc ID 1 Rank ||Name Population County 2 WWI Charlotte 885,708 Mecklenburg 3 ||2 Raleigh 474,069 Wake (seat), Durham 4 |B Greensboro 296,710 Guilford 5 4 Durham 278,993 Durham (seat), Wake, Orange 6 5 Winston-Salem 247,945 Forsyth 7 I6 Fayetteville 211,657 Cumberland le l7 Cary liz IRI Ihvate Chatham In data analytics, what term describes a collection of elements that interact with one another? 1/ 1 point O A modelling system O A database O The cloud environment O A data ecosystem Correct Data ecosystems are made up of elements that interact to produce, manage, store, organize, analyze, and share data. In row 1 of the following spreadsheet, the words rank, name, population, and county are called what? A B Cc ID 1 Rank ||Name Population County 2 WWI Charlotte 885,708 Mecklenburg 3 ||2 Raleigh 474,069 Wake (seat), Durham 4 |B Greensboro 296,710 Guilford 5 4 Durham 278,993 Durham (seat), Wake, Orange 6 5 Winston-Salem 247,945 Forsyth 7 I6 Fayetteville 211,657 Cumberland 8 7 Cary 170,282 Wake, Chatham In the analyze stage of the data life cycle, what might a data analyst do? Select all that apply. 1/ 1 point () Use a formula to perform calculations ¥ Copy Correct In the analyze stage of the data life cycle, a data analyst might use formulas to perform calculations, create a report from the data, or use spreadsheets to aggregate data. C) Choose the format of spreadsheet headings C) Use spreadsheets to aggregate data V Copy Correct In the following query, FROM 1s telling the database to filter out data from the Orders table. l» SELECT * FROM Orders 1/ 1 point O True O False ¥ Correct In a query, data analysts use FROM to indicate the table from which the data will be retrieved. In the following query, what does FROM tell the database? |» SELECT * FROM Orders 1/ 1 point O From which field data should be updated © From which field data should be stored ¥ © From which filter data should be selected © From which table to select data Correct In a query, data analysts use FROM to indicate the table from which the data will be retrieved. In the following spreadsheet, the column labels in row 1 are called what? | |A__|B llc [D | | 1 [Rank [Name [Population ||County | 2 i 1 ||Charlotte ||885,708 [Mecklenburg 3. |j2 [Raleigh ||474,069 Wake (seat), Durham l4. 3 ||Greensboro ||296,710 |Guilf ord | 5 4 [Durham ||278,993 [Durham (seat), Wake, Orange lo [5 [Winston-Salem ||247,945 |[Forsyth | 7 lo Fayetteville |21 1,657 '|Cumberland Ig. |i7 [Cary ||170,282 ||Wake, Chatham | 9 8 [Wilmington I 123,784 |New Hanover 110 i) [High Point {]112,791 ||Guilford, Randolph, Davidson, Forsyth | laa lla Aw aned llag 24 WA heen | In the following spreadsheet, the observation of Greensboro describes all of the data in row 4. A B Cc ID 1 Rank ||Name Population County 2 WWI Charlotte 885,708 Mecklenburg 3 ||2 Raleigh 474,069 Wake (seat), Durham 4 |B Greensboro 296,710 Guilford 5 4 Durham 278,993 Durham (seat), Wake, Orange 6 5 Winston-Salem 247,945 Forsyth 7 I6 Fayetteville 211,657 Cumberland 8 7 Cary 170,282 Wake, Chatham In the following spreadsheet, where can you find all of the attributes — also known as the observation — of Fayetteville? [Ap Ie Pp | | 1 [Rank [Name [Population ||County | 2 i 1 ||Charlotte ||885,708 [Mecklenburg 3. |j2 [Raleigh ||474,069 Wake (seat), Durham i4 iB '|Greensboro ||296,710 '|Guilford 5 4 [Durham ||278,993 [Durham (seat), Wake, Orange lo [5 [Winston-Salem ||247,945 |[Forsyth | 7 lo Fayetteville |21 1,657 '|Cumberland Ig. |l7 ||Cary ||170,282 '|Wake, Chatham | 9 8 [Wilmington I 123,784 |New Hanover 110 |lo [High Point 112.791 |Guilford, Randolph, Davidson. Forsyth | In which stage of the data life cycle does a business decide what kind of data it needs, how the data will be managed, and who will be responsible for it? 1/ 1 point O Manage O Capture O Analyze O Plan ¥ Correct During planning, a business decides what kind of data it needs, how it will be managed throughout its life cycle, who will be responsible for it, and the optimal outcomes. Seeking out new challenges and experiences in order to learn is an example of which analytical skill? 1/ 1 point O Understanding context O Data strategy O Having a technical mindset O Curiosity ¥ Correct Curious people seek out new challenges, which leads to knowledge. Select the best description of gut instinct. 1/ 1 point O Using your innate ability to analyze results O Choosing facts that complement your personal experiences O Manipulating data to match your intuition O An intuitive understanding of something with little or no explanation ¥ Correct Gut instinct is an intuitive understanding of something with little or no explanation. Sharing the results of your analysis with colleagues who are very familiar with the business problem supports what practice? 1/ 1 point O Data-driven decision-making ¥ O Data science O Data analytics O Data management Copy Correct Sharing the results of your analysis with people who are familiar with the business problem is an example of data-driven decision-making. Data-driven decision-making is using facts to guide business strategy. Structured query language (SQL) enables data analysts to communicate with a database. 1/ 1 point © True Vv O False Correct SQL allows a data analyst to communicate with a database in order to retrieve and manipulate data. The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making describes what? 1/ 1 point O Data analysis V © Data science O Data life cycle O Data analytics Correct The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making describes data analysis. The column attributes for rank, name, population, and county are located in which row of the following spreadsheet? [A _p Ie Pp | | 1 [Rank [Name [Population ||County | 2 i 1 ||Charlotte ||885,708 [Mecklenburg 3. |j2 [Raleigh ||474,069 Wake (seat), Durham i4 iB '|Greensboro ||296,710 '|Guilford 5 4 [Durham ||278,993 [Durham (seat), Wake, Orange lo [5 [Winston-Salem ||247,945 |[Forsyth | 7 lo Fayetteville |21 1,657 '|Cumberland Ig. |l7 ||Cary ||170,282 '|Wake, Chatham | 9 8 [Wilmington I 123,784 |New Hanover | 110 |l9 [High Point 112.791 |Guilford, Randolph, Davidson, Forsyth The data life cycle deals with the stages that data goes through; data analysis involves following a process to analyze data. 1/ 1 point O True O False Correct The data life cycle deals with the stages that data goes through during its useful life; data analysis involves following a process to analyze data. The destroy stage of the data life cycle might involve which of the following actions? Select all that apply. 1/ 1 point C) Storing data for future use C) Shredding paper files ¥ Copy Correct The destroy stage of the data life cycle might involve shredding paper files or using data-erasure software. C) Using data-erasure software ¥ Copy Correct The destroy phase of the data life cycle might involve shredding paper The five whys is a technique that involves asking, “Why?” five times in order to achieve what goal? 1/ 1 point O Use facts to guide business strategy O Puta plan into action O Identify the root cause of a problem ¥ © Visualize how a process should look in the future Correct In the five whys, you ask, “Why?” five times to reveal the root cause of a problem. The manage stage of the data life cycle is when a business decides what kind of data it needs, how the data will be handled, and who will be responsible for it. 1/ 1 point O True O False ¥ The manager at a music shop notices that more trombones are repaired on the days when Alex and Jasmine work the same shift. After some investigation, the manager discovers that Alex is excellent at fixing slides, and Jasmine is great at shaping mouthpieces. Working together, Alex and Jasmine repair trombones faster. The manager is happy to have discovered this relationship and decides to always schedule Alex and Jasmine for the same shifts. In this scenario, the manager used which quality of analytical thinking? 1/ 1 point O Correlation ¥ O Problem-orientation O Visualization O Big-picture thinking Correct The manager used correlation, which involves being able to identify a relationship between two or more pieces of data. To find the average population of the cities in this spreadsheet, what is the correct AVERAGE function syntax? [AB Ie Pp | | 1 [Rank [Name [Population ||County | 2 i 1 ||Charlotte ||885,708 [Mecklenburg 3. |j2 [Raleigh ||474,069 Wake (seat), Durham i4 iB '|Greensboro ||296,710 '|Guilford 5 4 [Durham ||278,993 [Durham (seat), Wake, Orange lo [5 [Winston-Salem ||247,945 |[Forsyth | 7 lo Fayetteville |21 1,657 '|Cumberland Ig. |l7 ||Cary ||170,282 '|Wake, Chatham | 9 8 [Wilmington I 123,784 |New Hanover 110 |lo [High Point 112.791 |Guilford, Randolph, Davidson. Forsyth | To find the average population of the cities in this spreadsheet, you type =AVERAGE. What is the proper way to type the range that will complete your function? [Ap Ic p | | 1 [Rank [Name [Population ||County | 2 i 1 ||Charlotte ||885,708 [Mecklenburg 3. |j2 [Raleigh ||474,069 Wake (seat), Durham i4 iB '|Greensboro ||296,710 '|Guilford 5 4 [Durham ||278,993 [Durham (seat), Wake, Orange lo [5 [Winston-Salem ||247,945 |[Forsyth | 7 lo Fayetteville |21 1,657 '|Cumberland Ig. |l7 ||Cary ||170,282 '|Wake, Chatham | 9 8 [Wilmington I 123,784 |New Hanover 110 |lo [High Point 112.791 |Guilford, Randolph, Davidson. Forsyth | To get the most out of data-driven decision-making, it’s important to include insights from people very familiar with the business problem. Identify what these people are called. 1/ 1 point O Customers O Stakeholders O Competitors O Subject-matter experts V Correct Subject-matter experts are very familiar with the business problem and can look at the results of data analysis to validate the choices being made. Understanding context is an analytical skill best described by which of the following? Select all that apply. 1/ 1 point _) Gathering additional information about data to understand the broader picture ¥ Copy Correct Context is the condition in which something exists, such as a structure. Gathering extra information about data to understand the broader picture provides context. ©) Working with facts in an orderly manner C) Identifying the motivation behind the collection of a dataset ¥ Copy Correct What actions might a data analytics team take in the act phase of the data analysis process? Select all that apply. 1/ 1 point C) Finalizing a strategy based on the analysis ¥ Copy Correct During the act phase, a data analytics team might validate insights, finalize a strategy, and put a plan into action. C Validating insights provided by analysts ¥ Copy Correct During the act phase, a data analytics team might validate insights, What do subject-matter experts do to support data-driven decision-making? Select all that apply. 1/ 1 point L) Review the results of data analysis and identify any inconsistencies ¥ Copy Correct Subject-matter experts can offer insights into the business problem, identify inconsistencies in the analysis, and validate the choices being made. C) Validate the choices made as a result of the data insights V Copy Correct Subiect-matter experts can offer insights into the business problem. What is the main difference between a formula and a function? 1/ 1 point O A formula is a set of instructions used to perform a specified calculation; a function is a preset command that automatically performs a specified process. ¥ © A formula is used to add or subtract; a function is used to multiply or divide. © A formula can be used multiple times in a spreadsheet; a function can only be used once. O A formula begins with an equal sign (=); a function begins with an asterisk (*). Correct A formula is a set of instructions used to perform a specified calculation; a function is a preset command that automatically performs a specified process. What method involves asking numerous questions in order to get to the root cause of a problem? 1/ 1 point O Strategizing O Inquiry O Curiosity O The five whys ¥ Correct The five whys involves asking numerous questions in order to get to the root cause of a problem? What method involves examining and evaluating how a process works currently in order to get it where you want it to be in the future? 1/ 1 point O The five whys O Gap analysis O Strategy O Data visualization Correct Gap analysis is a method for examining and evaluating how a process works currently in order to get where you want to be in the future. What tactics can a data analyst use to effectively blend gut instinct with facts? Select all that apply. 1/ 1 point C) Use their knowledge of how their company works to better understand a business need. ¥ C Apply their unique past experiences to their current work, while keeping in mind the story the data is telling. ¥ C Ask how to define success for a project, but rely most heavily on their own personal perspective. C) Focus on intuition to choose which data to collect and how to analyze it. When writing a query, what word does a data analyst use to indicate the table from which the data will be retrieved? 1/ 1 point @ FROM O TABLE O WHERE O SELECT Correct In a query, data analysts use FROM to indicate the table from which the data will be retrieved. Which of the following options describes data analysis? 1/ 1 point O Creating new ways of modeling and understanding the unknown by using raw data © The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making ¥ O Using facts to guide business strategy © The various elements that interact with one another in order to provide, manage, store, organize, analyze, and share data Correct : Data analysis is the collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making. You are writing a query that asks a database to retrieve data about the customer with identification number 244. The column name for customer identification numbers is customer_id. What is the correct SQL clause? 1/ 1 point O WHERE customer_id = 244 ¥ O WHERE. customer_id=244 O WHERE customer_id 244 O WHERE customer_id is 244 Correct The correct WHERE clause syntax is WHERE customer _id = 244. WHERE is used to extract only those records that meet a specified criteria. customer _id = 244 tells the database to return only information about the customer whose ID is 244. A data analyst is analyzing fruit and vegetable sales at a grocery store. They’re able to find data on everything except red onions. If they exclude red onions from the analysis, this would be an example of creating or reinforcing bias. 1/ 1 point O True ¥ O False Correct Fairness means ensuring that your analysis doesn't create or reinforce bias. Being inclusive, not exclusive, is an important part of fairness. A data analyst is analyzing fruit and vegetable sales at a grocery store. They’re able to find data on everything except red onions. What’s the best course of action? 1/ 1 point O Exclude red onions from the analysis. © Use the data on white onions instead, as they’ re both onion varieties. O Ask a teammate for help finding data on red onions. ¥ O Exclude all onion varieties from the analysis. A doctor’s office discovers that patients are waiting 20 minutes longer for their appointments than in past years. In what ways could a data analyst help solve this problem? Select all that apply. 1/ 1 point C) Analyze the number of patients seen per day compared to past years. V Copy Correct Analyzing appointment length, staffing numbers, and patient numbers are likely to provide useful insights to illustrate why this is happening and help solve this problem. C) Analyze a recent change in the average rating for the doctor’s office on social media. OC Analyze the average length of an appointment this year compared to past years. V Copy Correct Analyzing appointment length, staffing numbers, and patient numbers are likely to provide useful insights to illustrate why this is happening and help solve this problem. C) Analyze how many doctors and nurses are on staff at a given time compared to the number of patients with appointments. ¥ Correct Analyzing appointment length, staffing numbers, and patient numbers are likely to provide useful insights to illustrate why this is happening and help solve this problem. A gym wants to start offering exercise classes. A data analyst plans to survey 10 people to determine which classes would be most popular. To ensure the data collected is fair, what steps should they take? Select all that apply. 1 / 1 point O) Ensure participants represent a variety of profiles and backgrounds. ¥ Copy Correct Ensuring participants represent a variety of profiles and backgrounds, collecting data anonymously, and surveying more than just 10 people would all help ensure the data analysis is fair. O) Collect data anonymously. ¥ Copy Correct Ensuring participants represent a variety of profiles and backgrounds, collecting data anonymously, and surveying more than just 10 people would all help ensure the data analysis is fair. OC Increase the number of participants. ¥ Copy Correct Ensuring participants represent a variety of profiles and backgrounds, collecting data anonymously, and surveying more than just 10 people would all help ensure the data analysis is fair. CO) Survey only people who don’t currently go to the gym. A large hotel chain sees about 500 customers per week. A data analyst working there is gathering data through customer satisfaction surveys. They are anxious to begin analysis, so they start analyzing the data as soon as they receive 50 survey responses. This is an example of what? Select all that apply. 1/ 1 point C Failing to include diverse perspectives in data collection ¥ Copy Correct This is an example of failing to include diverse perspectives and failing to have a large enough sample size. The first 50 survey responses are unlikely to represent the general population and may produce biased results. C Failing to have a large enough sample size ¥ Copy Correct This is an example of failing to include diverse perspectives and failing to have a large enough sample size. The first 50 survey responses are unlikely to represent the general population and may produce biased results. C) Failing to reward customers for participating in the survey. OC) Failing to collect data anonymously A magazine wants to understand why its subscribers have been increasing. A data analyst could help answer that question with a report that predicts the result of a half-price sale on future subscription rates. 1/ 1 point O True O False ¥ Correct Predicting the effect of future sales will not answer the question of why there’s been an increase in subscribers. This type of question requires historical data to provide useful insights. A problem is an obstacle to be solved, an issue is a topic to investigate, and a question is designed to discover information. 1/ 1 point O True ¥ O False Correct A problem is an obstacle or complication to be solved, whereas a question is designed to discover information. These two things are the foundation of business tasks. An online gardening magazine wants to understand why its subscriber numbers have been increasing. A data analyst discovers that significantly more people subscribe when the magazine has its annual 50%-off sale. This is an example of what? 1/ 1 point O Analyzing consumer preferences using artificial intelligence O Analyzing social media engagement O Analyzing the number of customers by calculating daily foot traffic O Analyzing customer buying behaviors ¥ Correct Data analysts help companies learn from historical data in order to make predictions. A sale’s affect on subscription purchases is an example of customer buying behavior analysis. An online gardening magazine wants to understand why its subscriber numbers have been increasing. What kind of reports can a data analyst provide to help answer that question? Select all that apply. 1/ 1 point C) Reports that describe how many customers shared positive comments about the gardening magazine on social media in the past year ¥ Copy Correct Analyzing historical data such as weather patterns, social media comments, and past sales would provide useful insights into the increase in subscription numbers. OC Reports that examine how a recent 50% -off sale affected the number of subscription purchases ¥ Copy Correct Analyzing historical data such as weather patterns, social media comments, and past sales would provide useful insights into the increase in subscription numbers. C) Reports that predict the success of sales leads to secure future subscribers _) Reports that compare past weather patterns to the number of people asking gardening questions to their social media ¥ Correct Analyzing historical data such as weather patterns, social media comments, and past sales would provide useful insights into the increase in subscription numbers. Scenario 2 continued As you’re reviewing the dataset, you notice that there are a disproportionate number of senior citizens. So, you investigate further and find out that this zip code represents a rural community in Colorado with about 800 residents. In addition, there’s a large assisted-living facility in the area. Nearly 300 of the residents in the 81137 zip code live in the facility. You recognize that’s a sizable number, so you want to find out if age has an effect on a patient’s likelihood to attend a follow-up dental appointment. You analyze the data, and your analysis reveals that older people tend to miss follow-ups more than younger people. So, you do some research online and discover that people over the age 60 are 50% more likely to miss dentist appointments. Sometimes this is because they’re on a fixed income. Also, many senior citizens lack transportation to get to and from appointments. With this new knowledge, you write an email to your supervisor expressing your concerns about the dataset. He agrees with your concerns, but he’s also impressed with what you’ve learned and thinks your findings could be very important to the project. He asks you to change the business task. Now, the NDS campaign will be about educating dental offices on the challenges faced by senior citizens and finding ways to help them access quality dental care. Changing the business task involves defining the new question or problem to be solved. 1/ 1 point O True ¥ O False Correct A business task is the question or problem data analysis answers for a business. Scenario 2 continued As you’re reviewing the dataset, you notice that there are a disproportionate number of senior citizens. So, you investigate further and find out that this zip code represents a rural community in Colorado with about 800 residents. In addition, there’s a large assisted-living facility in the area. Nearly 300 of the residents in the 81137 zip code live in the facility. You recognize that’s a sizable number, so you want to find out if age has an effect on a patient’s likelihood to attend a follow-up dental appointment. You analyze the data, and your analysis reveals that older people tend to miss follow-ups more than younger people. So, you do some research online and discover that people over the age 60 are 50% more likely to miss dentist appointments. Sometimes this is because they’re on a fixed income. Also, many senior citizens lack transportation to get to and from appointments. With this new knowledge, you write an email to your supervisor expressing your concerns about the dataset. He agrees with your concerns, but he’s also impressed with what you’ve learned and thinks your findings could be very important to the project. He asks you to change the business task. Now, the NDS campaign will be about educating dental offices on the challenges faced by senior citizens and finding ways to help them access quality dental care. Changing the business task involves which of the following? 1/ 1 point © Conducting a gap analysis O Creating a graphical representation of the data © Using a database instead of a spreadsheet @ Defining the new question or problem to be solved Correct A business task is the question or problem data analysis answers for a business. Collaborating with a social scientist to provide insights into human bias and social contexts is an effective way to avoid bias in your data. 1/ 1 point O True O False Correct Collaborating with a social scientist to provide insights into human bias and social contexts is an effective way to avoid bias in your data. Social scientists can help data analysts better understand human bias and social contexts. Scenario 1, question 1-5 You’ve just started a new job as a data analyst. You’re working for a midsized pharmacy chain with 38 stores in the American Southwest. Your supervisor shares a new data analysis project with you. She explains that the pharmacy is considering discontinuing a bubble bath product called Splashtastic. Your supervisor wants you to analyze sales data and determine what percentage of each store’s total daily sales come from that product. Then, you’ll present your findings to leadership. You know that it’s important to follow each step of the data analysis process: ask, prepare, process, analyze, share, and act. So, you begin by defining the problem and making sure you fully understand stakeholder expectations. One of the questions you ask is where to find the dataset you’ll be working with. Your supervisor explains that the company database has all the information you need. Next, you continue to the prepare step. You access the database and write a query to retrieve data about Splashtastic. You notice that there are only 38 rows of data, representing the company’s 38 stores. In addition, your dataset contains five columns: Store Number, Average Daily Customers, Average Daily Splashtastic Sales (Units), Average Daily Splashtastic Sales (Dollars), and Average Total Daily Sales (All Products). Considering the size of your dataset, what’s the best way to proceed with the process and analyze steps? 1/ 1 point O Use SQL to process and analyze the data. @ Download the data, then use a spreadsheet to process and analyze it. © Continue using the company database to process and analyze the data. © Upload the data, then process and analyze it using Tableau. Correct Spreadsheets work well for processing and analyzing a small dataset, such as the one you’re using. Scenario 1, question 1-5 You’ve just started a new job as a data analyst. You’re working for a midsized pharmacy chain with 38 stores in the American Southwest. Your supervisor shares a new data analysis project with you. She explains that the pharmacy is considering discontinuing a bubble bath product called Splashtastic. Your supervisor wants you to analyze sales data and determine what percentage of each store’s total daily sales come from that product. Then, you’ll present your findings to leadership. You know that it’s important to follow each step of the data analysis process: ask, prepare, process, analyze, share, and act. So, you begin by defining the problem and making sure you fully understand stakeholder expectations. One of the questions you ask is where to find the dataset you’ll be working with. Your supervisor explains that the company database has all the information you need. Next, you continue to the prepare step. You access the database and write a query to retrieve data about Splashtastic. You notice that there are only 38 rows of data, representing the company’s 38 stores. In addition, your dataset contains five columns: Store Number, Average Daily Customers, Average Daily Splashtastic Sales (Units), Average Daily Splashtastic Sales (Dollars), and Average Total Daily Sales (All Products). Considering the size of your dataset, you decide a spreadsheet will be the best tool for your project. You proceed by downloading the data from the database. Describe why this is the best choice. 1/ 1 point O Spreadsheets work well for processing and analyzing a small dataset, like the one you’re using. O Only spreadsheets let you download and upload data. O Spreadsheets are most effective when working with queries. O Databases can’t be used for analysis. Correct A spreadsheet is a smart choice when working with a dataset of 38 rows and five columns. Data analysts answer questions and solve problems. These are called business tasks. 1/ 1 point O True ¥ O False Correct Data analysts answer questions and solve problems, which are called business tasks. Data analysts ensure their analysis is fair for what reason? 1/ 1 point O Fairness helps them communicate with stakeholders. O Fairness helps them stay organized. @ Fairness helps them avoid biased conclusions. O Fairness helps them pick and choose which data to include from a dataset. Correct Data analysts ensure their analysis is fair in order to ensure their analysis doesn't create or reinforce bias. Data-driven decision-making is using facts to guide business strategy. The benefits include which of the following? Select all that apply. 1/ 1 point C) Making the most of intuition and gut instinct Combining observation with objective data Copy Correct Data-driven decision-making enables companies to use data analytics to find the best possible solution to a problem, complement observation with objective data, and get a complete picture of a problem and its causes. Getting a complete picture of a problem and its causes Copy Correct Data-driven decision-making enables companies to use data analytics to find the best possible solution to a problem, complement observation with objective data, and get a complete picture of a problem and its causes. Using data analytics to find the best possible solution to a problem Correct Data-driven decision-making enables companies to use data analytics to find the best possible solution to a problem, complement observation with objective data, and get a complete picture of a problem and its causes. Describe the difference between a question and a problem in data analytics. 1/ 1 point O A question is uncertain, whereas a problem is clearly specified. O A question can have many answers, whereas a problem only has one solution. @ A question is designed to discover information, whereas a problem is an obstacle or complication that needs to be solved. O A question is a topic to investigate, whereas a problem is a subject to investigate. Correct A question is designed to discover information, whereas a problem is an obstacle or complication to be solved. These two things are the foundation of business tasks. Scenario | continued Once you’ve found the missing information, you analyze your dataset. During analysis, you create a new column F. At the top of the column, you add: Average Percentage of Total Sales — Splashtastic. What is this column label called? 1/ 1 point OA title O A headline O An attribute ¥ O A reference Correct An attribute is a characteristic or quality of data used to label a column. Scenario | continued Next, you determine the average total daily sales over the past 12 months at all stores, The range that contains these sales is E2:E39. To do this, you use a function. Fill in the blank to complete the function correctly: = (E2:E39). 1/ 1 point O TOTAL @ AVERAGE O SALES O SUM Correct The function begins with an equal sign (=), then the word AVERAGE. The range is all of column E, represented by E:E. Fill in the blank: A business task is described as the problem or a data analyst answers for a business. 1/ 1 point O complaint O comment O solution O question ¥ Correct A business task is described as the problem or question a data analyst answers for a business. Fill in the blank: A doctor’s office has discovered that patients are waiting 20 minutes longer for their appointments than in past years. To help solve this problem, a data analyst could investigate how many nurses are on staff at a given time compared to the number of 1/ 1 point O doctors seeing new patients O doctors on staff at the same time @ patients with appointments O negative comments about the wait times on social media Correct Analyzing staffing and patient numbers would likely provide useful insights about why patients are waiting longer for their appointment times and to help solve this problem. Fill in the blank: A problem is an obstacle to be solved, an issue is a topic to investigate, and a is designed to discover information. 1/ 1 point O breakthrough O question ¥ O business task O theme Correct A problem is an obstacle or complication to be solved, whereas a question is designed to discover information. These two things are the foundation of business tasks. Scenario 2 continued As you’re reviewing the dataset, you notice that there are a disproportionate number of senior citizens. So, you investigate further and find out that this zip code represents a rural community in Colorado with about 800 residents. In addition, there’s a large assisted-living facility in the area. Nearly 300 of the residents in the 81137 zip code live in the facility. You recognize that’s a sizable number, so you want to find out if age has an effect on a patient’s likelihood to attend a follow-up dental appointment. You analyze the data, and your analysis reveals that older people tend to miss follow-ups more than younger people. So, you do some research online and discover that people over the age 60 are 50% more likely to miss dentist appointments. Sometimes this is because they’re on a fixed income. Also, many senior citizens lack transportation to get to and from appointments. With this new knowledge, you write an email to your supervisor expressing your concerns about the dataset. He agrees with your concerns, but he’s also impressed with what you’ve learned and thinks your findings could be very important to the project. He asks you to change the business task. Now, the NDS campaign will be about educating dental offices on the challenges faced by senior citizens and finding ways to help them access quality dental care. Fill in the blank: Changing the business task involves defining a new 1/ 1 point O gap analysis plan O question or problem to be solved ¥ O data-cleaning strategy O graphical representation of the data Correct A business task is the question or problem data analysis answers for a business. Fill in the blank: Fairness is achieved when data analysis doesn’t create or bias. 1/ 1 point O constrain O reinforce ¥V O resolve O highlight Correct Fairness is achieved when data analysis doesn’t create or reinforce bias.