ETF1100 Group Assignment S1 2025 - Business Statistics

Published: 09 Jun, 2025
Category Assignment Subject Business
University Monash University (MU) Module Title ETF1100 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.

ETF1100 Business Statistics Assignment

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.

Buy Answer of ETF1100 Assignment & Raise Your Grades

Order Non Plagiarized Assignment

Looking for the solution of the ETF1100 Business Statistics Assignment? Look no further! There are specialized professionals for all categories of assignments who offer you plagiarism-free and superior content. You are assured that our Business Management Assignment Help service will make you productive and help you achieve high grades in your academic year. A free list of assignment samples written by PhD experts is also provided here that can help you boost your study power and check the quality of the assignment. So contact us today and get your top-notch assignment!

Workingment Unique Features

Hire Assignment Helper Today!


BBSC4103 Assignment: Strategic Supply Chain Management Question Semester 2025 | OUM

BBSC4103 Part 1: The purpose of this assignment is to help learners study the important of strategic alliances by focusing on inter-organisational relationships and the challenges in managing them.

BBHI4103 Industrial Relation Assignment Question | Open University Malaysia

BBHI4103 Part 1: The purpose of this assignment is to enhance learners' ability to discuss the perspectives in industrial relations and evaluate which perspective is the best for the selected organisation

Scientific Research Review Assignment 4 | USM

You are required to write an individual review paper on a topic of advancements in your area of study. This paper must demonstrate your ability to plan, execute, and present a scholarly task ethically and professionally.

BTEC Level 5 Unit 16: Computing Research Project Assignment Part 1 Brief

BTEC Level 5 Unit 16: Assignment Brief: Artificial intelligence is at the forefront of innovation within Computer Science that uses a combination of logic, algorithms and large data sets to produce an AI model.

ACC210 Accounting for Decision Making and Control TMA Assignment Question | SUSS

ACC210 Question 1  Cool Strokes Pte Ltd ("CS") manufactures white board markers for educational use. The company's markers are sold by the box at $50 each in 20x3.

BM414 Financial Decision Making CW1 Assignment Brief (SIG) | BNU

Suppose you are part of the Accounting and Finance team at Sheffield Insulation Group (SIG) plc. You are required to write a report to the senior management team of SIG plc, discussing the importance of accounting and finance functions.

7167EXQ Environmental Management Systems and Auditing CW1 Brief | CU

7167EXQ Assignment Task: Essay on the relevance of organisational behaviour on environmental management in an organisation You may approach this essay in one of two ways depending on your experience and knowledge.

BENV1015 History of Design Thinking Assignment 1 Brief Term 2 2025 | UNSW

The assignment develops your knowledge of historical design ideas and communication skills corresponding to the course learning outcomes below. It aims to give an appreciation of the implications of past movements, practitioners, and projects for current challenges.

7ME500 Advanced Mechanical Design and Manufacturing Engineering CW1 Report Assessment Brief | UoD

An integrated design, material selection, and manufacturing approach provides one of the key enabling capabilities needed to effectively evaluate specific areas of initial concept development and perform detailed engineering design and analysis throughout a product development cycle.

Atomic Structure & Bonding Assignment : Lab-Based Element Analysis and Molecular Case Study

Atmospheric ions are electrically charged particles that occur naturally in the atmosphere. They form in the upper atmospheric layers mainly because of the action of ultraviolet radiation from the sun, as well as in lower atmospheric layers as a result of radioactive radiation and cosmic rays.

Online Assignment Help in UK