Making Sense of Data Unit 2 - part 2

Unit 2 Activity, Part 2

Welcome to the Unit 2 Activity, Part 2.

In the Unit 2 Activity, Part 1, you collected data and added formula columns in order to expand your hot beverage company in Russia. In this part of the activity, you will practice:

• Selecting the right charts to use for analysis
• Creating and analyzing charts

파트2는 파트1에서 ProfitPerUnit과 TotalProfit을 구한 엑셀파일을 가지고 시작해야 합니다.

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

Question 1 of 5

Now that you have collected the data and computed the total profits, you are ready to answer questions about the data. 

You will begin by creating a chart showing how many times each brand appears in the data set.

Which chart do you need to use to show how many times each brand was purchased?

 A) Scatter Plot

 B) Line Graph

 C) Bar Chart

 D) Both A and C

Question 2 of 5

Instruction: Create a bar chart showing how many times each brand was purchased.

Hint: Make sure you check the Summarize data? box when creating the bar chart, and make sure the count box is selected for the Brand variable. Make sure that you are looking at thecount of Brand, and not the sum of UnitsSold.

You should now have a bar chart showing how many times each brand was purchased. Were you able to successfully create this bar chart?

 A) Yes, I was able to create this bar chart.

 B) No, I was not able to create this bar chart.

Question 3 of 5

Looking at the bar chart you generated, which three brands were purchased the most?

 A) Fenwick, Leamington, Uluru

 B) Fenwick, Jackys, Uluru

 C) Grub, Pugh, Spencers

 D) Grylls, Uluru, Parly M Grew

Question 4 of 5

Instruction: Change the chart so that instead of looking at the count of each brand, you are looking at the sum of TotalProfit brought in by each brand. 

Looking at the bar chart you generated, how much TotalProfit was made on the most profitable brand?

Hint: You can hover your mouse over the bars in the bar chart to see more information about them.

 A) 11,275,640.45

 B) 10,777,859.83

 C) 11,571,544.36

 D) 10,672,042.76

브랜드는 맞는데 왜 계속 합계 금액이 틀리게 나오는지? 아직도 정답이 왜 A인지 모르겠음..

Question 5 of 5

Instructions: Create a bar chart that displays the total profits for each category.

Which category brought in the least amount of profit?

 A) Coffee

 B) Tea

 C) Malt

 D) Whiteners