Making Sense of Data Unit 2 - part 1

Unit 2 Activity, Part 1

Welcome to the Unit 2 Activity!

In this activity, you are going to practice using basic analysis techniques-- formulas, summaries, charts, and filters-- in order to grow your hot beverage company. You will practice:

• Deciding which tools to use for analysis
• Creating new columns with formulas

You are the proud owner of a Hot Chocolate, Tea, and Coffee distribution company, and your business is thriving. As a next step in your growth, you want to increase your hot beverage sales in Russia.

Question 1 of 5

The data process begins by asking questions. In this scenario, the primary question is: how should you invest your resources in order to grow your business in Russia?

What are the crucial pieces of information you should collect in order to answer this question?

Note: this is a critical thinking question, there are many correct answers.

주관식 답을 제출하게 되어 있음.. 나는 명확한 타겟시장의 설정과 KPI라고 썼음.. 답을 제출 하고 나면 나오는 문구가..

There are many potential pieces of information you can collect. 

For this activity, the information you want to know is: what hot beverages are being sold, and how much profit is brought in by those hot beverages.

Question 2 of 5

Which of these secondary questions will likely be the most helpful for answering your primary question?

 A) Which cities are selling the most units?

 B) Which brands are bringing in the least profit?

 C) Which types of hot beverages are costing the most to produce?

 D) Which types of hot beverages are bringing in the most profit?

Question 3 of 5

Recall the secondary question: which types of hot beverages are bringing in the most profit?

Which Fusion Tables tool could be used to answer this question using the Hot Beverage Sales Log data?

이 첨부파일을 보면서 문제를 풀어야 합니다

making sense of data unit 2_hot beverage sales log.xlsx

 A) Summaries: create a table displaying the total profits brought in by each hot beverage type.

 B) Charts: create a bar graph displaying the total profits brought in by each brand.

 C) Filters: restrict the data set to caffeinated beverages.

 D) Any of the above could be used to answer the question.

Question 4 of 5

Now that you have your question and your data, you need to calculate the profits using the available information.

PricePerUnit tells you how much a customer paid for each unit.

CostPerUnit tells you how much it cost us to produce each unit.

UnitsSold tells you how many units were sold in a particular sale.

Using this information, you are going to calculate ProfitPerUnit and TotalProfits for each sale.

What formula will you need to enter in order to compute the ProfitPerUnit for each sale?

 A) PricePerUnit + CostPerUnit

 B) CostPerUnit - PricePerUnit

 C) PricePerUnit - CostPerUnit

 D) CostPerUnit + PricePerUnit

Question 5 of 5

Instruction: 

Create a new formula column. Set the name to ProfitPerUnit. Set the formula to PricePerUnit - CostPerUnit. Then create another new formula column. Set the name toTotalProfit. Set the formula to ProfitPerUnit * UnitsSold.

Important: Make sure there are no spaces in the variable names. Total Profit is not the same as TotalProfit. Formulas might not work if you have spaces in the variable names.

You should now have two new formula columns added to the table: ProfitPerUnit andTotalProfit. Were you able to successfully add these two variables to the table?

 A) Yes, I successfully added ProfitPerUnit and TotalProfit to my table.

 B) No, I was not able to add ProfitPerUnit and TotalProfit to my table.