Crowdly
Add to Chrome
ETF1100 - Business statistics - S2 2025
Looking for ETF1100 - Business statistics - S2 2025 test answers and solutions? Browse our comprehensive collection of verified answers for ETF1100 - Business statistics - S2 2025 at learning.monash.edu.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
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.