it is an assignment with limit is 1000 words excluding graphs and figures.

it is an assignment with limit is 1000 words excluding graphs and figures.


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 corresponding 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 brands. 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 brands for the years 2019 and 2021, aiming to understand how the market shares of different brands have evolved. Data Sales data for the top 10 laptop brands in 2019 and 2021 are available in the file Electronics_Sales.xlsx. Adam ensured consistency by focusing on the same top 10 laptop brands, excluding certain brands affected by market shifts. Analysis (a) Identify the type of data Adam collected for various laptop brands (1 mark). (b) Comment on the total sales of laptops in 2019 and 2021(1 mark). (c) Present the sales of the top 10 laptop brands in 2019 and 2021 using a relevant chart. Offer a concise comparison of brand-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 brands in 2019. Discuss notable market leaders (1 mark). (e) Considering the market shares presented in part (d), advise Emily on the top 5 laptop brands based on the 2019 market share (1 mark). (f) Use an appropriate chart to showcase the market share of the top 10 laptop brands in 2021. Analyse changes in market share between 2019 and 2021. Provide insights into the top 5 brands 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] Carbon 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 urbanisation, demand for energy continues to rise, with fossil fuel combustion providing the majority of the supply. Because of this reliance on nonrenewable resources, carbon 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 carbon emissions. Understanding the complex relationship between carbon 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 carbon emissions and energy, your current 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 Brand20192021 Dell256000225874 HP (Hewlett-Packard)272000273427 Lenovo128000166434 Apple320000380420 Asus192000142657 Acer208000237762 Toshiba6400059441 LG6400047552 Samsung3200059441 Microsoft Surface64000106993 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 YearCO2 emissions (metric tons per capita)Energy use (kg of oil equivalent per capita) 19904.021658.98 19913.981644.51 19923.911617.47 19933.871610.09 19943.841596.09 19953.891610.35 19963.921627.21 19973.941620.07 19983.911604.60 19993.881616.53 20003.951629.10 20013.961627.57 20023.961639.80 20034.091678.53 20044.221729.16 20054.331755.98 20064.421785.22 20074.531812.17 20084.501817.72 20094.391784.37 20104.601862.02 20114.691868.50 20124.691878.23 20134.721880.28 20144.681905.86 1 2 3 4 5 A B C 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