ETF1100 Group Assignment S1 2025 – Business Statistics

ETF1100 Problem background: 

Energy Consumer Australia is an independent organization representing energy consumers from the residential and small business owners. One of its projects is to conduct bi-annual Energy Consumer Sentiment survey. This data can be used to help retail energy providers to understand the attitudes of energy consumers and the drivers of their intention to switch companies. 

In your tutorial exercises, you would have conducted some simple analysis of the driver of the intention to switch. One key driver identified is that customers who intend to switch respond with low overall customer satisfaction score (OverallCSE). In this assignment, your task is to investigate and report how the overall customer satisfaction score is associated with other aspects of customer satisfaction (bill, value for money), as well as some basic customer demographics. 

ETF1100 Data definition: 

In the file “Group Assignment Data.xlsx”, you are provided with both numeric and categorical data that were collected as part of the survey. Note that this data has already been cleaned for you, and any missing records are removed. Only residential energy consumer responses are provided.

The following table contains the data definition.

Are You Looking for Answer of ETF1100 Assignment

Order Non Plagiarized Assignment

ETF1100 Assignment tasks:

[Note that you will be conducting a number of these analyses as part of the tutorial exercises from week 7 onwards.] 

ETF1100 Task 1: (Week 7 tutorial) 

Segment your data into two groups: Customers who indicated that they intend to switch providers and customers who reported that they did not intend to switch providers. 

1a Conduct a hypothesis test to assess whether the mean overall satisfaction of customers who do not intend to switch provider is smaller than 8.25. 
1b Conduct a hypothesis test to assess whether the mean overall satisfaction of customers who intend to switch provider is smaller than 8.25. 
1c Compare your results from 1a and 
1b. Provide an analysis of how overall customer satisfaction score is related to their intention to switch.

ETF1100 Task 2: (Week 8 tutorial) 

Use the appropriate Excel tool (Data filter or pivot tables) to analyze the relationship between “Switch” and “BillLargerThanExp”. 

2a Calculate the proportions of customers who responded “Yes” to “BillLargerThanExp”, segmented by whether or not they intend to switch providers. Comment on the difference in the two proportions. You may use the concept of confidence intervals to aid your analysis. 

2b From past surveys, the typical observation is that 1/3 of customers find their bill larger than expected. Is there statistical evidence to suggest that this proportion is underestimated in those who intend to switch providers? How does this compare to those who do not intend to switch providers? Support your answer with hypothesis tests of proportions.

ETF1100 Task 3: (Week 9 tutorial) 

Investigate the relationship between the overall satisfaction score (OverallCSE6mth) and the other satisfaction scores (VoMSat and BillSat) using correlation statistics and single regression models. 

Note that while the satisfaction scores are strictly ordinal categorical variables, we treat them as numerical in a regression setting as the number of categories is large and we can interpret the results according to the data definition scale. 

3a Estimate the single regression model of OverallCSE6mth on VoMSat. Interpret the slope of VoMSat. 
3b Estimate the single regression model of OverallCSE6mth on BillSat. Interpret the slope of BillSat. 

ETF1100 Task 4: (Week 10 tutorial) 

For this task, focus on the following variables as explanatory variables to the overall satisfaction score:

• VoMSat 
• BillSat
• OwnorRent
• Gender
• Bill LargerThanExp

4a Convert the variables “OwnorRent”, “Gender” and “Bill LargerThanExp” into dummy variables. Construct the dummy variables using the following definitions:

• Renter (1 if Rent, and 0 of owned)
• Female (1 if female, and 0 otherwise
• Large Bill (1 if “Yes” to BillLarger Than Exp, 0 if “No”)

4b Estimate the multiple regression model with “Overall CSE6mth” as the dependent variable (Y), with the following explanatory variables (X):

• VoMSat
• BillSat
• Renter (1 if Rent, and 0 of owned)
• Female (1 if female, and 0 otherwise
• Large Bill (1 if “Yes” to Bill Larger Than Exp, O if “No”)

4c Analyze the slope coefficients from the model you estimated in 4b. Interpret and report on the slope coefficients of this model. including commentary on the statistical significar Why is this page out of focus?n the model to analyze the key drivers of Overall CSE6mth. Because this is a premium document. Subscribe to unlock this document and more.

Are they different? If so, why do you think they are different? Comment on the goodness of fit of the multiple regression model compared to the simple regression models from Task 3 based on the regression model statistics.

ETF1100 Task 5: (Group to manage)

Based on your statistical analysis from Tasks 1-4 above, write a report discussing the following items:

• Customer’s attitude to switching providers and its relationship to overall customer satisfaction score.
• Customer’s attitude to switching providers and its relationship with their perception of the bill size.
• The relationship between overall customer satisfaction, value of money satisfaction, bill satisfaction, bill expectation, and some basic demographics included in the multiple regression in Task 4. Discuss the potential drivers of OverallCSE6mth from your analysis.
• Provide a recommendation, based on your statistical analysis, of how an energy provider may be able to improve overall customer satisfaction to lessen the tendency of customers to switch providers.
• Discuss the limitation of your analysis.

ETF1100 Assignment marks

The maximum total mark for the assignment is 100. Your total score will be composed of two parts:

• The report: maximum marks of 80.
• Excel working file: you must submit this alongside your report. We refer to the files to allow carry on marks when applicable.
• Peer evaluation via Feedback Fruits: maximum marks of 20. You will be required to fill in the peer evaluation on Feedback Fruits to be eligible for this component.

The Chief Examiner reserves the rights to adjust individual report marks based on the peer evaluation. Should the feedback indicate that an individual did not contribute to the group assignment, the report mark will be adjusted to zero, implying that the individuals group assignment contribution to their final grade will be 0%.

Report requirements:

• The report must not be longer than 10 pages long, with font size 12pt and 1.5 spacing.
• Plots and tables must be legible, with appropriate labels to aid readers.
• Statistical results need to be summarized in succinct table formats.
• The report must contain section headings that are consistent with the report template below