Week 5

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. Failing to reward customers for participating in the survey Failing to include diverse perspectives in data collection Failing to have a large enough sample size Failing to collect data anonymously

Failing to include diverse perspectives in data collection Failing to have a large enough sample size

Data analysts answer questions and solve problems. These are called business tasks. True False

True

Scenario 2 continued https://docs.google.com/document/d/1El-W-rC8YASg-gX8L3qquj2-OmyoCWUr7idP3V8-EZM/edit Changing the business task involves defining the new question or problem to be solved. True False

True

Describe the difference between a question and a problem in data analytics. A question is uncertain, whereas a problem is clearly specified. A question is a topic to investigate, whereas a problem is a subject to investigate. 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.

A question is designed to discover information, whereas a problem is an obstacle or complication that needs to be solved.

Next, you determine the average percentage of total store sales that Splashtastic sales represent. To do this, you use a function. Fill in the blank to complete the function correctly: =_____ (F:F). FROM WHERE AVERAGE SELECT

AVERAGE

What is the process of using facts to guide business strategy? Data-driven decision-making Data programming Data visualization Data ethics

Data-driven decision-making

Next, you create a slideshow, which includes a data visualization to highlight the Splashtastic sales insights you've discovered. You've reached which phase of the data analysis process? Analyze Manage Act Share

Share

https://docs.google.com/spreadsheets/d/1tJ877ewOmslnbBOwsGOOjBbOBKTb_TV0oONsN5uw3lM/edit?usp=sharing Now, it's time to process the data. As you know, this step involves finding and eliminating errors and inaccuracies that can get in the way of your results. While cleaning the data, you notice there's an issue you need to fix. Identify the problem. Column E is formatted for currency. The headers in row 1 are bold. The data in column A is sorted alphabetically. There is missing information in row 16.

There is missing information in row 16.

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. Analyze the number of patients seen per day compared to past years. Analyze a recent change in the average rating for the doctor's office on social media. Analyze how many doctors and nurses are on staff at a given time compared to the number of patients with appointments. Analyze the average length of an appointment this year compared to past years.

Analyze the number of patients seen per day compared to past years. Analyze how many doctors and nurses are on staff at a given time compared to the number of patients with appointments. Analyze the average length of an appointment this year compared to past years.

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. True False

False

https://docs.google.com/spreadsheets/d/1tJ877ewOmslnbBOwsGOOjBbOBKTb_TV0oONsN5uw3lM/edit?usp=sharing Please refer to Pharmacy Data - Part 2 tab. 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? A reference A headline An attribute A title

An attribute

Which of the following examples describe fairness in data analysis? Select all that apply. Factoring in social contexts that could create bias in conclusions Making sure a sample population represents all groups Considering systematic factors that may influence data Picking and choosing which data to include from a dataset

Factoring in social contexts that could create bias in conclusions Making sure a sample population represents all groups Considering systematic factors that may influence data

Scenario 2 continued https://docs.google.com/document/d/1El-W-rC8YASg-gX8L3qquj2-OmyoCWUr7idP3V8-EZM/edit The people who are familiar with a problem and help verify the results of data analysis include customers and competitors. True False

False

The 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. 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? Data visualization Spreadsheet formulas or functions Fairness Future dental procedures

Fairness

Scenario 2 continued https://docs.google.com/document/d/1El-W-rC8YASg-gX8L3qquj2-OmyoCWUr7idP3V8-EZM/edit It's time to create your presentation to stakeholders. It will include a data visualization that demonstrates the trend of people being less likely to attend follow-up appointments as they get older. Which type of chart will be most effective? A pie chart A doughnut chart A table A line chart

A line chart

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? Use the data on white onions instead, as they're both onion varieties. Exclude red onions from the analysis. Ask a teammate for help finding data on red onions. Exclude all onion varieties from the analysis.

Ask a teammate for help finding data on red onions.

Scenario 1, question 1-5 https://docs.google.com/document/d/1El-W-rC8YASg-gX8L3qquj2-OmyoCWUr7idP3V8-EZM/edit?usp=sharing Considering the size of your dataset, what's the best way to proceed with the process and analyze steps? 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. Use SQL to process and analyze the data.

Download the data, then use a spreadsheet to process and analyze it.

Scenario 2, questions 6-10 https://docs.google.com/document/d/1El-W-rC8YASg-gX8L3qquj2-OmyoCWUr7idP3V8-EZM/edit The table is dental_data_table, and the column name is zip_code. How do you complete the following query? SELECT * FROM dental_data_table WHERE_zip_code = 81137 zip_code = 81137 WHERE zip_code = 81137 WHERE = 81137

WHERE zip_code = 81137