ICQ 2 Quiz group 1

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 data containing the number of students approaching each counter. How would you best summarise this data?

• Box Plot

• 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 60th 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.6)

• =PERCENTILE.INC(Singapore_zoo,0.9)