Crowdly
Додати до Chrome
ETF1100 - Business statistics - S2 2025
Шукаєте відповіді та рішення тестів для ETF1100 - Business statistics - S2 2025? Перегляньте нашу велику колекцію перевірених відповідей для ETF1100 - Business statistics - S2 2025 в learning.monash.edu.
Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!
Which chart type is appropriate for intention to switch?
What percentage of customers replied with 11, the highest level of satisfaction? Enter your answer in percentage, to two decimal places. E.g. for 10.11%, enter 10.11 in the answer box.
Return to the “Consumer Survey” worksheet. Use the =COUNTIF() function to count the number of customers who intend to switch their provider. Enter your answer in whole numbers.
Is this statement True or False?
Most of the consumers surveyed intended to
switch energy provider.
In worksheet “Consumer Survey”, use the Data Filter to obtain a subset of data where customers found their bill to be larger than expected. Paste this subset of data onto a new worksheet. How many observations belong to this subset? Enter your answer in whole numbers.
In worksheet “Lookups & Matching”, use vlookup to obtain profit of store 29. Paste your Excel formula in the answer box below.
In worksheet “Lookups & Matching”, use index() and match() to obtain profit of store 29. Paste your Excel formula in the answer box below.
In worksheet “Consumer Survey”, use the pivot table to summarize the frequency table of “OwnOrRent”. How many customers in this sample own their property? Enter your answer in whole numbers.