Assessment 2
Assignment 1
(worth 30% of the overall assessment)
Instructions
Word limit is 1000 words excluding graphs and figures.
Submission deadline: at 9am
Please provide your responses beneath each question. You can also paste Excel graphs, figures, and any other relevant excel output directly into each co
esponding question.
Answer all Questions.
QUESTION 1 [10 marks]
Introduction
Established in 2005 in Western Sydney, Portable Electronics is a well-known technology retailer that offers a diverse range of products, including smartphones, laptops, tablets, smartwatches, and gaming consoles. Over the years, the company has noticed fluctuations in the sales of specific laptop
ands. In response, the CEO, Emily Wooldridge, decided to strategize and analyse market dynamics.
To conduct a comprehensive analysis, Emily collaborated with her newly recruited graduate trainee, Adam. Together, they gathered nationwide sales data for the top 10 laptop
ands for the years 2019 and 2021, aiming to understand how the market shares of different
ands have evolved.
Data
Sales data for the top 10 laptop
ands in 2019 and 2021 are available in the file Electronics_Sales.xlsx. Adam ensured consistency by focusing on the same top 10 laptop
ands, excluding certain
ands affected by market shifts.
Analysis
(a) Identify the type of data Adam collected for various laptop
ands (1 mark).
(b) Comment on the total sales of laptops in 2019 and XXXXXXXXXXmark).
(c) Present the sales of the top 10 laptop
ands in 2019 and 2021 using a relevant chart. Offer a concise comparison of
and-specific sales changes between 2019 and 2021 (max 150 words) (2 marks).
(d) Utilize a suitable chart to illustrate the market share of the top 10 laptop
ands in 2019. Discuss notable market leaders (1 mark).
(e) Considering the market shares presented in part (d), advise Emily on the top 5 laptop
ands based on the 2019 market share (1 mark).
(f) Use an appropriate chart to showcase the market share of the top 10 laptop
ands in 2021. Analyse changes in market share between 2019 and 2021. Provide insights into the top 5
ands for Emily to consider, considering potential differences between the two years (max 150 words) (3 marks).
(g) Assess the appropriateness of making business decisions based on the 2021 sales data (1 mark).
QUESTION 2 [10 marks]
Portable Electronics computer retail dealer claims that the average battery life of laptops in their store is at least 10 hours. To test this claim, a random sample of 30 laptops is selected, and their battery lives are recorded. The sample mean battery life is found to be 9.5 hours with a standard deviation of 1.2 hours.
Conduct a hypothesis test at a 5% significance level to determine if there is enough evidence to support the dealer's claim.
QUESTION 3 [10 marks]
Ca
on emissions and energy consumption are critical components of the global conversation about environmental sustainability and climate change. As the world grapples with the repercussions of rapid industrialisation and u
anisation, demand for energy continues to rise, with fossil fuel combustion providing the majority of the supply. Because of this reliance on nonrenewable resources, ca
on emissions have increased significantly, contributing to the greenhouse effect and eventual climate change. As a result, there is a rising need to shift towards cleaner, more sustainable energy sources in order to reduce the global impact of ca
on emissions. Understanding the complex relationship between ca
on emissions and energy consumption is critical for developing successful policies to combat climate change, boost renewable energy adoption, and encourage a more sustainable and resilient society.
Assuming the role of a Research Analyst in an international business policy research institute dedicated to investigating the nexus between ca
on emissions and energy, your cu
ent assignment involves analysing data to ascertain the relationship between energy usage and CO2 emissions. You have been granted access to a comprehensive global time series dataset compiled by the World Bank, conveniently available in an Excel file (Energy_data.xlsx) accessible through the assessment section on the course website. Your specific tasks include:
(a) Use a suitable graphical technique to depict the behaviour of the data (or each variable) over time (3 marks).
(b) Use a graphical technique to determine whether there is a linear relationship between Energy use and CO2 emissions. On the plot, insert the trend line and the coefficient of determination R2. Interpret the slope coefficient of the trend line and comment on the fitness of the model (7 marks).
END OF THE ASSIGNMENT
Page 1 of 2
Page 2 of 2
Sheet1
Number of units sold
Brand 2019 2021
Dell 256000 225874
HP (Hewlett-Packard) 272000 273427
Lenovo 128000 166434
Apple 320000 380420
Asus 192000 142657
Acer 208000 237762
Toshiba 64000 59441
LG 64000 47552
Samsung 32000 59441
Microsoft Surface 64000 106993
1
2
3
4
5
6
7
8
A
B
C
Brand
2019
2021
Dell
256000
225874
HP (Hewlett-Packard)
272000
273427
Lenovo
128000
166434
Apple
320000
380420
Asus
192000
142657
Number of units sold
Sheet1
Data from database: World Development Indicators
Year CO2 emissions (metric tons per capita) Energy use (kg of oil equivalent per capita)
1990 4.02 1658.98
1991 3.98 1644.51
1992 3.91 1617.47
1993 3.87 1610.09
1994 3.84 1596.09
1995 3.89 1610.35
1996 3.92 1627.21
1997 3.94 1620.07
1998 3.91 1604.60
1999 3.88 1616.53
2000 3.95 1629.10
2001 3.96 1627.57
2002 3.96 1639.80
2003 4.09 1678.53
2004 4.22 1729.16
2005 4.33 1755.98
2006 4.42 1785.22
2007 4.53 1812.17
2008 4.50 1817.72
2009 4.39 1784.37
2010 4.60 1862.02
2011 4.69 1868.50
2012 4.69 1878.23
2013 4.72 1880.28
2014 4.68 1905.86
1
2
3
4
5
A
B
C
Data from database: World Development Indicators
Yea
CO2
emissions
(metric tons
per capita)
Energy use
(kg of oil
equivalent
per capita)
1990
4.02
1658.98
1991
3.98
1644.51