BUS508 Business Analytics Assignment

BUS508 Business Analytics

Written Assignment: Computer Application Project

(worth 45% of the overall assessment)

Instructions:

• This assignment has 2 Questions.

• You will need to download Assignment Question file (this file) and data fileto complete your assignment.

• All numerical calculations and graphs/plots should be done using EXCEL as much as possible.

• Only typed assessments in a Word document will be marked. Hand-written equations and symbols are accepted if scanned and pasted into the word document. You have to copy and paste Excel outputs (e.g., plots, tables etc) into your main assignment, which is a Word document. Any answer in the Excel document, but not in the main document, will NOT be marked.

• The completed assignment (Word document, Excel file) must be submitted electronically via Submission point in Assessment 3 Assignment folder.

• Word files that are not accompanied by Excel files will NOT be marked.

• You are required to keep a hard copy of the submitted assignment to re-submit, in case the original submission is lost for some reason.

Important Notice:

As this is an individual assessment item, students should submit their individual assignment. All assignments submitted will go through a matching process. If found to have plagiarised, all submissions involved would receive a mark of zero for this assessment item.

Description of Marking Criterion

1. All outputs are generated using the correct data otherwise they will not be marked.
2. All outputs are formatted appropriately for readability although no marks will be allocated for the advanced formatting of outputs.
3. The outputs have been pasted in the word file under the corresponding question numbers.
4. All answers should include any information needed to appropriately facilitate the interpretation of outputs.
5. You may use the Excel workbooks provided, with weekly learning materials, for hypothesis testing and confidence interval estimate questions, if required and appropriate
6. All sub-questions in the main questions have been answered.
7. The suitability of the graphical or numerical descriptive measures used according to the requirements in the question.
8. Where the question saysto explain,provide reasons-why,what information you can get from the output, a correct and concise explanation/interpretation has been provided.
9. The output that has been generated using incorrect data will not be accepted.
10. The correctness and readability of output have been ensured, and the basic information to facilitate the interpretation of outputs is provided.
11. Answers to Question 1 should be generated using the Question 1 Parts A-C Excel sheets in the Assignment 3 Data file. You have to develop your own answer template for this question (hence its empty sheet at the moment).

Report writing with data analytics

12. The report in Part 2C is a standalone report that includes appropriate components such as introduction, description of data analytics techniques used and reasons for selecting such techniques, discussion of results and conclusion. Any outputs generated in previous sections of the question should be reproduced in the report (or integrated into the discussions in the report).
13. Remember that Part 2C is a complete Research Report you might submit to your manager.
14. You are not expected to do additional research to complete this assignment. However, if you do so, include the list of references used.
15. See the BUS508 Rubrics document for detailed explanation on marking criterion in Assessment 2 folder.

QUESTION 1 (15 marks)

A manufacturer makes two products, widget A and widget B, each requiring time on each of two machines. These requirements, along with the limitations on the available labour-hours are given in the following table. Using Excel Solver, answer the following questions.

Part 1A [5 marks]

Determine how many units of widget A and widget B must be produced each week to maximize the total profit. (fractional units allowed)

1. Units of widget A
2. Units of widget B
3. Maximum Profit

Part 1B [5 marks]

Suppose that a single order is received for 16 units of widget A per week, and if it is decided that this order must be filled, determine the new values below (fractional units allowed).

1. Units of A
2. Units of B
3. Maximum Profit

Part 1C [5 marks]

In addition to the above, the company estimates that at most 25 units of widgets can be handled by its distribution network each week. Determine the new values below (fractional units allowed).

1. Units of A
2. Units of B
3. Maximum Profit

QUESTION 2: Global warming and a possible cause (30 marks)

Preamble

In the last part of the 20th century, scientists developed the theory that the planet was warming and that the primary cause was the increasing amounts of atmospheric carbon dioxide (CO₂), which are the product of burning oil, natural gas, and coal (fossil fuels). Although many climatologists believe in the so-called greenhouse effect, many others do not subscribe to this theory. Further, Earths temperature has increased and decreased many times in its long history. We have had higher temperatures and we have had lower temperatures, including various ice ages. In fact, a period called the little ice age ended around the middle to the end of the nineteenth century. Then the temperature rose until about 1940, at which point it decreased until 1975. In fact, a Newsweek article published 28 April 1975, discussed the possibility of global cooling, which seemed to be the consensus among scientists at the time. There are two critical questions that need to be answered in order to resolve the issue.

1. Is Earth actually warming?
2. If the planet is warming, is CO₂ the cause?

In terms of data, the generally accepted procedure is to record monthly temperature anomalies. To do so, we calculate the average for each month over many years. We then calculate any deviations between the latest months temperature reading and its average. A positive anomaly would represent a months temperature that is above the average. A negative anomaly indicates a month where the temperature is less than the average.

Part 2A [15 = 5 + 5+ 5 marks] (300 words)

Is Earth actually warming?

GLOBAL_A1.xlsx sheet in Assignment 3 Data file contains the monthly temperature anomalies (C) from 1880 to 2016. Sheet GLOBAL_A2.xlsx stores the monthly temperature anomalies (C) and time period from 1880 to 1940, GLOBAL_A3.xlsx stores the data from 1941 to 1975, GLOBAL_A4.xlsx stores the sample data from 1976 to 1997 and GLOBAL_A5.xlsx stores the data from 1998 to 2016. Using these data answer the following:

1. Considering the monthly temperature anomalies data over the data period 1880-2016 in GLOBAL_A1.xlsx, use a graphical technique to display whether there are signs of global warming. Discuss the trend in data.
2. Considering the average of the temperature anomalies in GLOBAL_A1.xlsx, test to show that, on average, there is global warming at the 5 percent level of significance.
3. To investigate the relationship between temperature anomalies and time, depict this relationship in appropriate graph(s), estimate the least squares line and the coefficient of determination for each of the four time period data in GLOBALA2 to GLOBALA5 files. Report your findings. Has there been global warming in each of the four periods? Discuss.

Part 2B [5 = 4 + 1 marks] (200 words)

If the planet is warming, is CO₂ the cause?

Data for CO₂ levels (ppm) in the atmosphere together with the temperature anomalies for March 1958 to May 2016 are stored in file GLOBALB.xlsx.

1. Use a graphical technique to determine whether there is a linear relationship between temperature anomalies and CO₂ levels. On the plot, insert the trend line. Estimate and interpret the intercept and the slope coefficient of the estimated linear trend line equation and comment on the fitness of the model.
2. Using the estimated trend line equation, predict the temperature anomaly if the CO₂ level reaches 400ppm?

Part 2C [10 marks] (500 words)

Consolidating the answers in Part 2A and Part 2B, and using any other information generated from the same data using the appropriate data analytics techniques studied in this unit, write a report answering the two critical questions; Is Earth actually warming? and if the planet is warming, is CO₂ the cause?

END OF ASSIGNMENT QUESTIONS