ICQ2 group 4

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

The image shows two graphs. What are they?(left-right)

• Barchart, Histogram

• Histogram, Barchart

• Histogram, boxplot

• Line chart, Barchart

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.

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

VLOOKUP can only look for value on which side of identifier column?(the third argument in the VLOOKUP function)

• Left
• Right
• Either
• Neither

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)