ICQ 2 group 2

The graph shows the performance of actual revenue vs budget. What kind of data visualisation is used here?

• Boxplot

• Line Chart

• Histogram

• Sparkline

There are 5 counters in Students Activities centre. At the end of a typical busy Monday, you obtain the data with number of students approaching each counter. How would you best summarize this data?

• Boxplot
• Histogram
• Scatterplot
• Line chart

Felicia has been asked by her supervisor to develop a prediction tool on excel that predicts solar radiance(amount of sunlight) in Singapore over a week(7 values) in the future. From the weather department, she obtains the weather data for the period between 1990-1992. Assuming the effects of global warming and gradual reduction in rainfall, would such a data be sufficient for her tool? Why or why not?

• No, as the data is not complete
• No, as the data is not unique
• No, as the data is not timely
• Yes, as the data is complete.

What is the purpose of the 5 Whys framework? (Select all that applies)

• To ask questions in a systematic way till the problem's root cause is found

• To prompt one to gather data in answering the 'Why' questions

• To help prevent one from focusing only on the symptom of the issue

Observe the excel table given below. What would the command "=VLOOKUP(D2, A3:B7,2, FALSE)" return us with?

• Blue

• 50

• 80

• Red

You wish to calculate the 55th percentile of number of visitors to the Singapore zoo. Which excel formula would would you use?

• PERCENTILE.INC(Singapore_zoo,0.4)
• PERCENTILE.INC(Singapore_zoo,0.5)
• PERCENTILE.INC(Singapore_zoo,0.55)
• PERCENTILE.INC(Singapore_zoo,0.9)