# foundations data data everywhere course challenge answers

• Email a copy of the dataset to your company email address.
• Use Tableau to convert the data into a spreadsheet.
• Copy and paste the data into a spreadsheet.

• True
• False

#### 3. Scenario 1 continuedOnce 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 the attribute Average Percentage of Total Sales - Splashtastic.Fill in the blank: An attribute is a _______ or quality of data used to label a column.

• number
• characteristic
• response

#### 4. Scenario 1 continuedNext, 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. You input =AVERAGE(E2-E39), but this returns an error. What is the correct command?

• =AVERAGE(E2;E39)
• =AVERAGE(E2+E39)
• =AVERAGE(E2:E39)
• =AVERAGE(E2,E39)

#### 5. Scenario 1 continuedYou’ve reached the share phase of the data analysis process. What can you do in this phase to highlight the Splashtastic sales insights you've discovered?

• Mission statement
• Hypothesis
• Complaint

• zip_code = 81137
• WHERE zip_code = 81137
• WHERE 81137
• WHERE_zip code = 81137

#### 7. Scenario 2 continuedThe dataset your supervisor retrieved and imported into a spreadsheet includes a list of patients, their demographic information, dental procedure types, and whether they attended their follow-up appointment. To use the dataset for this scenario, click the link below and select “Use Template.”Course Challenge - Scenario 2OR If you don’t have a Google account, you can download the template directly from the attachment below.The patient demographic information includes data such as age, gender, and home address. The fact that the dataset includes people who all live in the same zip code might get in the way of what?

• Fairness
• Data visualization
• Future dental procedures

• recording
• defining
• sharing
• analyzing

• True
• False

#### 10. Scenario 2 continuedThe subject-matter experts are impressed by your analysis. The team agrees to move to the next step: data visualization. You know it’s important that stakeholders at NDS can quickly and easily understand that older people are less likely to attend important follow-up dental appointments than younger people. This will help them create an effective campaign for members.It’s time to create your presentation to stakeholders. It will include a data visualization that demonstrates the lifetime trend of people being less likely to attend follow-up appointments as they get older.Fill in the blank: The type of chart that would be most effective in visualizing this is a _____.

• line chart
• pie chart
• bar chart
• doughnut chart

• Analyze
• Destroy
• Process
• Copy