+1(978)310-4246 credencewriters@gmail.com
  

Description

z53845 30
THE UNIVERSITY OF NEW SOUTH WALES
SCHOOL OF INFORMATION SYSTEMS AND TECHNOLOGY MANAGEMENT
TERM 3 2021
COMM5011: DATA ANALYSIS FOR BUSINESS
FINAL EXAMINATION
1.
Time Allowed: 24 Hours.
2.
This is a Take-Home Exam, your responses must be your own original work.
You must attempt this Take-Home Exam by yourself without any help from
others. Thus, you have NOT worked, collaborated or colluded with any other
persons in the formulation of your responses. The work that you are submitting
for your Take-Home Exam is your OWN work.
3.
Release date/time (via Moodle): Tuesday, 7 December 2021, 9:00am
(Australian Eastern Time Zone)
4.
Submission date/time (Via Turnitin): Wednesday, 8 December 2021, 9:00am
(Australian Eastern Time Zone)
5.
Failure to upload the exam by the submission time will result in a penalty of 15%
of the available marks per hour of lateness.
6.
This Examination Paper has 10 pages, including the cover page.
7.
This Examination Paper has 2 sections: Section A = Qualitative and Section B
= Quantitative.
8.
Total number of Questions: 2 in Section A, 2 in Section B, each with sub-parts.
9.
Answer all 4 Questions.
10.
Total marks available: 100 marks. This examination is worth 50% of the total
marks for the course.
11.
Questions are not of equal value. Marks available for question sub-parts are
shown on this examination paper.
12.
Some questions have word limits as indicated on the question. These word limits
must be adhered to. Text in excess of the specified word limit(s) may not be
considered in the marking process.
z53845 30
13.
Candidates must submit a signed Declaration Form together with the TakeHome Exam answer document. Failure to submit the signed Declaration Form
may result in your Take-Home Exam answer sheet not being marked.
14.
Answers to questions are to be written in the template provided. Please ensure
that you provide the following details on your Take-Home Exam answer sheet:
•
Student ID:
15.
In accordance with the Declaration Form, this Take-Home Exam paper cannot
be copied, forwarded or shared.
16.
Students are reminded of UNSW’s rules regarding Academic Integrity and
Plagiarism. Plagiarism is a serious breach of ethics at UNSW and is not taken
lightly. For details see Examples of plagiarism.
17.
This Take-Home Exam is an open book/open web, further information is
available “Here”.
•
You are permitted to refer to your course notes, any materials provided by
the course convenor or lecturer, books, journal articles, or tutorial materials.
•
It is sufficient to use in-text citations that include the following information:
the name of the author or authors; the year of publication; the page number
(where the information/idea can be located on a particular page when
directly quoted), For example, (McConville, 2011, p.188).
•
You are required to cite your sources and attribute direct quotes
appropriately when using external sources (other than your course
materials).
•
When citing Internet sources, please use the following format: website/page
title and date.
•
If you provide in-text citations, you MUST provide a Reference List. The
Reference list will NOT BE counted towards your word limit.
18.
Students are advised to read the Take-Home Exam paper thoroughly before
commencing.
19.
The Lecturer-in-Charge (LiC) / Exam Referee will be available online (via
Moodle) after the Take-Home Exam paper is released for a period of two hours.
PAGE 2 OF 10
z53845 30
IMPORTANT Answer all questions from Section A (Qualitative) and all questions from
Section B (Quantitative) using separate templates.
You must answer Q1 to Q2 using the Template provided for SECTION A and Q3 to
Q4 using the Template provided for SECTION B. DO NOT MIX questions from Section
A with those from Section B in the same Template. The templates have to be uploaded
on separate Turnitin links.
SECTION A: QUALITATIVE QUESTIONS (50 MARKS)
QUESTION 1
20 MARKS
“A case study examines a phenomenon in its natural setting, employing multiple
methods of data collection to gather information from one or a few entities.”
You conducted an in-depth case study on GoGet, a car-sharing service company. You
have collected both primary data and secondary data. You did thirty (30) interviews,
and each interview lasted two hours. You also collected documents, customers’
feedback, and text data from the social media platforms such as Facebook.
REQUIRED:
With reference to the above scenario, answer the following question:
Compare and contrast the two data collection and analysing methods – in particular,
outline the benefits and limitations of each. You can use examples to justify your
argument.
(20 marks)
[Answer Word limit – 800 words]
PAGE 3 OF 10
z53845 30
QUESTION 2
30 MARKS
Airbus SAS – France
Project name: A380
Project type: Commercial aircraft development
Date: Dec 2000 – Oct 2007
Cost: $6.1B in additional costs due to project delays
Case Study:
I’ve often written about decision-making in the project environment and how the
decisions made in a project shape the outcomes the project achieves. Often when a
project gets into trouble it is the result of the interaction of many poorly made decisions.
Occasionally it is a single decision that can be isolated out as the source of trouble.
The Airbus A380 is one such project.
As the world’s largest commercial aircraft, the Airbus A380 is a feat of engineering.
With two full decks, a wingspan wider than a football pitch and space for up to 850
passengers (in high density mode), the A380 is the most complex aircraft flying today.
While the aircraft has now been in operational service for 6 years, the project that
created this behemoth suffered its fair share of problems and delays. Originally
scheduled for delivery in 2006, the aircraft’s entry into service was delayed by almost
2 years and the project was several billion dollars over budget.
At the heart of the problems were difficulties integrating the complex wiring system
needed to operate the aircraft with the metal airframe through which the wiring needed
to thread. With 530Km of wires, cables and wiring harnesses weave their way
throughout the airframe. With more than 100,000 wires and 40,300 connectors
performing 1,150 separate functions, the Airbus A380 has the most complex electrical
system Airbus had ever designed. As the first prototype (registration F-WWOW) was
being built in Toulouse France, engineers began to realize that they had a problem.
Wires and their harnesses had been manufactured to specification, but during
installation the wires turned out to be too short. Even though the cables were at times
just a few centimetres too short, in an aircraft you can’t simply tug a cable to make it
fit. As construction of the prototype continued Airbus management slowly came to the
realization that the issue was not an isolated problem and that short wires was a
pervasive issue throughout the design.
Internal reviews identified that the heart of the problem was the fact that the different
design groups working on the project had used different Computer Aided Design (CAD)
software to create the engineering drawings. The development of the aircraft was a
collaboration between 16 sites spread across 4 different countries. German and
Spanish designers had used one version of the software (CATIA version 4), while
British and French teams had upgraded to version 5. In theory, the fact that the design
centers were sharing their drawings meant that the electrical system designed in
Germany would be compatible with the airframe components designed in France. Part
way through the project the design centres also started integrating their diagrams into
a single 3D Digital Mock-up Unit (DMU) that should further have validated compatibility.
Unfortunately, the construction of F-WWOW demonstrated that theory and practice are
not always the same thing.
PAGE 4 OF 10
z53845 30
In part the problem was the CATIA version 5 was not a simple evolution from version
4, it was a complete rewrite. Reports indicate that the calculations used to establish
bend radii for wires as they wove through the airframe were inconsistent across the
different versions of the software and that inconsistency resulted in the problem.
Stripping out the wiring from the prototype, redesigning the wiring, making new
harnesses and then rethreading the wiring into the airframe became a monumental
task. Taking months to complete the project was delayed multiple times as hundreds
of engineers tried to overcome the problems. At one point more than 1,100 German
engineers were camped out at the Toulouse production facility trying to rectify the
problems.
The root of the problem can be traced back to a single decision: the decision to proceed
with the project despite the fact that two CAD systems were in use. That decision
resulted in design inconsistencies, mismatched calculations, and configuration
management failures.
The entry of above has been extracted from a record in the “Catalogue of Catastrophe” – a
list of failed or troubled projects from around the word.
Source: http://calleam.com/WTPF/?p=4700 Access: 08 November, 2021 23:00.
REQUIRED:
With reference to the above scenario, answer the following three questions:
a) If you were a researcher who are interested in studying certain aspects of Airbus
SAS, propose a research question (RQ) that is appropriate for a qualitative inquiry
into Airbus SAS. From the scenario, explain your motivation for proposing such a
RQ.
(5 marks)
[Answer Word limit – 200 words]
b) Using the context of the scenario, explain to which category of research design
(Exploratory, Descriptive, Explanatory, or Emancipatory) does your RQ belong?
(5 marks)
[Answer Word limit – 200 words]
c) Discuss two (2) qualitative research methods you would use to answer your
RQ. Explain why they are appropriate to your RQ in this scenario.
(20 marks)
[Answer Word limit – 800 words]
PAGE 5 OF 10
z53845 30
IMPORTANT Answer all questions from Section A (Qualitative) and all questions from
Section B (Quantitative) using separate templates.
You must answer Q1 to Q2 using the Template provided for SECTION A and Q3 to
Q4 using the Template provided for SECTION B. DO NOT MIX questions from Section
A with those from Section B in the same Template. The templates have to be uploaded
on separate Turnitin links.
SECTION B: QUANTITATIVE QUESTIONS (50 MARKS)
QUESTION 3
25 MARKS
Part A
The following chart and accompanying text are reproduced from the “Why Australia:
Benchmark Report 2021” prepared by Australian Trade Commission, Australian
Government. (If you have trouble viewing the chart, you can access it through the
following website: https://www.austrade.gov.au/benchmark-report/innovation-skills)
a. Discuss the purpose of Chart 1 and critically assess how well it meets this
purpose.
(3 marks)
b. Would you recommend that the data be presented in a different way? If not, why
not? If so, explain how you would present the data in a better way. (3 marks)
“A big spender on research and development:
Australia’s annual gross domestic expenditure on research and development (GERD)
reached A$34 billion in 2018–19. This places Australia alongside the UK, Singapore
and France as one of the highest spenders on research and development (R&D).
Australia’s trend in R&D is upwards. GERD rose by around 7% per year from 2000–
01 to 2018–19 and it now represents 1.8% of Australian GDP. This creates a pool of
skilled researchers who are globally competitive.”
PAGE 6 OF 10
z53845 30
CHART 1:
Part B
a.
After a change in the process for managing customer enquiries posted to their
website, a company is concerned that it is taking too long to respond. It collects
data on the time taken to respond for a sample of 400 customer enquiries. If
the true population mean response time is 27.6 minutes with the standard
deviation being 16 minutes, what is the probability that the mean of this
sample will be less than 25.6 minutes?
(3 marks)
b.
How are we able to answer a. above without knowing whether the population
call time distribution is skewed or not?
(3 marks)
c.
The company randomly selects a number of registered customers. It calls
these customers asking them to complete a customer satisfaction survey by
phone. From previous surveys, the company knows that the chance of a
selected customer agreeing to complete the survey is 20%. If in one day it calls
14 selected customers, what is the chance that exactly 4 customers complete
the survey?
(3 marks)
PAGE 7 OF 10
z53845 30
d.
What assumptions did you need to make to answer c.? Answer in relation to
this particular situation.
(3 marks)
e.
The company has a complaints telephone line. The company is concerned that
because of changes to their website, more lengthy complaints calls are being
received. A sample of 100 calls is taken. Their average is 7.25 minutes. The
population mean is known to have been 7 minutes with a standard deviation
of 2.1 minutes. Use a hypothesis test to test if the mean call time has changed
from 7 minutes at the 1% level of significance. Show all steps (hypotheses,
test statistic, decision rule) and explain your conclusion.
(7 marks)
PAGE 8 OF 10
z53845 30
QUESTION 4
25 MARKS
Part A
An online retailer has checked the expenditures of 100 customers in one week and
found the average total spent is $151.16. Assume that the standard deviation of
expenditure for all customers is $55 and find a 95% confidence interval for the average
amount spent by all customers in this week.
(5 marks)
Part B
Shengyu is an analyst for a company that provides clients with advice about economic
conditions. He notes that the United States (US) is experiencing high inflation at the
moment. He wonders if high inflation in the US somehow feeds through to cause high
inflation in China. To start his analysis, he downloads data on inflation from the OECD
website and runs a simple regression of Chinese inflation on US inflation for data from
Quarter 1 2005 to Quarter 2 2021 (each quarter’s data on inflation is in terms of annual
percentage change). The Excel output for this is as follows:
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.533126
R Square
0.284223
Adjusted R Square 0.273039
Standard Error
1.614377
Observations
66
ANOVA
df
Regression
Residual
Total
Intercept
X Variable 1
a.
1
64
65
SS
MS
F
Significance F
66.23271501 66.23272 25.41338 4.0545E-06
166.7977302 2.606215
233.0304453
Coefficients Standard Error t Stat
P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
0.823257 0.397429191 2.071456 0.042352 0.02930082 1.617213 0.02930082 1.61721298
0.977674 0.193938053 5.041168 4.05E-06 0.59023857 1.365110 0.59023857 1.36511017
How well does the regression line fit the observed data? Explain.
(3 marks)
b.
What is the sample correlation coefficient between the two variables in this
model and how can it be interpreted?
(5 marks)
c.
Write the sample regression equation clearly defining the variables used.
(5 marks)
d.
If these regression results were used to predict Chinese inflation, what would
the inflation rate in China be if US inflation is 6.2% in Quarter 3 2021? Explain
the rate of increase thereafter if US inflation continues to rise.
(7 marks)
PAGE 9 OF 10
z53845 30
— END OF EXAMINATION PAPER —
PAGE 10 OF 10
z53845 30
THE UNIVERSITY OF NEW SOUTH WALES
SCHOOL OF INFORMATION SYSTEMS AND TECHNOLOGY MANAGEMENT
TERM 3 2021
COMM5011: DATA ANALYSIS FOR BUSINESS
FINAL EXAMINATION
1.
Time Allowed: 24 Hours.
2.
This is a Take-Home Exam, your responses must be your own original work.
You must attempt this Take-Home Exam by yourself without any help from
others. Thus, you have NOT worked, collaborated or colluded with any other
persons in the formulation of your responses. The work that you are submitting
for your Take-Home Exam is your OWN work.
3.
Release date/time (via Moodle): Tuesday, 7 December 2021, 9:00am
(Australian Eastern Time Zone)
4.
Submission date/time (Via Turnitin): Wednesday, 8 December 2021, 9:00am
(Australian Eastern Time Zone)
5.
Failure to upload the exam by the submission time will result in a penalty of 15%
of the available marks per hour of lateness.
6.
This Examination Paper has 10 pages, including the cover page.
7.
This Examination Paper has 2 sections: Section A = Qualitative and Section B
= Quantitative.
8.
Total number of Questions: 2 in Section A, 2 in Section B, each with sub-parts.
9.
Answer all 4 Questions.
10.
Total marks available: 100 marks. This examination is worth 50% of the total
marks for the course.
11.
Questions are not of equal value. Marks available for question sub-parts are
shown on this examination paper.
12.
Some questions have word limits as indicated on the question. These word limits
must be adhered to. Text in excess of the specified word limit(s) may not be
considered in the marking process.
z53845 30
13.
Candidates must submit a signed Declaration Form together with the TakeHome Exam answer document. Failure to submit the signed Declaration Form
may result in your Take-Home Exam answer sheet not being marked.
14.
Answers to questions are to be written in the template provided. Please ensure
that you provide the following details on your Take-Home Exam answer sheet:
•
Student ID:
15.
In accordance with the Declaration Form, this Take-Home Exam paper cannot
be copied, forwarded or shared.
16.
Students are reminded of UNSW’s rules regarding Academic Integrity and
Plagiarism. Plagiarism is a serious breach of ethics at UNSW and is not taken
lightly. For details see Examples of plagiarism.
17.
This Take-Home Exam is an open book/open web, further information is
available “Here”.
•
You are permitted to refer to your course notes, any materials provided by
the course convenor or lecturer, books, journal articles, or tutorial materials.
•
It is sufficient to use in-text citations that include the following information:
the name of the author or authors; the year of publication; the page number
(where the information/idea can be located on a particular page when
directly quoted), For example, (McConville, 2011, p.188).
•
You are required to cite your sources and attribute direct quotes
appropriately when using external sources (other than your course
materials).
•
When citing Internet sources, please use the following format: website/page
title and date.
•
If you provide in-text citations, you MUST provide a Reference List. The
Reference list will NOT BE counted towards your word limit.
18.
Students are advised to read the Take-Home Exam paper thoroughly before
commencing.
19.
The Lecturer-in-Charge (LiC) / Exam Referee will be available online (via
Moodle) after the Take-Home Exam paper is released for a period of two hours.
PAGE 2 OF 10
z53845 30
IMPORTANT Answer all questions from Section A (Qualitative) and all questions from
Section B (Quantitative) using separate templates.
You must answer Q1 to Q2 using the Template provided for SECTION A and Q3 to
Q4 using the Template provided for SECTION B. DO NOT MIX questions from Section
A with those from Section B in the same Template. The templates have to be uploaded
on separate Turnitin links.
SECTION A: QUALITATIVE QUESTIONS (50 MARKS)
QUESTION 1
20 MARKS
“A case study examines a phenomenon in its natural setting, employing multiple
methods of data collection to gather information from one or a few entities.”
You conducted an in-depth case study on GoGet, a car-sharing service company. You
have collected both primary data and secondary data. You did thirty (30) interviews,
and each interview lasted two hours. You also collected documents, customers’
feedback, and text data from the social media platforms such as Facebook.
REQUIRED:
With reference to the above scenario, answer the following question:
Compare and contrast the two data collection and analysing methods – in particular,
outline the benefits and limitations of each. You can use examples to justify your
argument.
(20 marks)
[Answer Word limit – 800 words]
PAGE 3 OF 10
z53845 30
QUESTION 2
30 MARKS
Airbus SAS – France
Project name: A380
Project type: Commercial aircraft development
Date: Dec 2000 – Oct 2007
Cost: $6.1B in additional costs due to project delays
Case Study:
I’ve often written about decision-making in the project environment and how the
decisions made in a project shape the outcomes the project achieves. Often when a
project gets into trouble it is the result of the interaction of many poorly made decisions.
Occasionally it is a single decision that can be isolated out as the source of trouble.
The Airbus A380 is one such project.
As the world’s largest commercial aircraft, the Airbus A380 is a feat of engineering.
With two full decks, a wingspan wider than a football pitch and space for up to 850
passengers (in high density mode), the A380 is the most complex aircraft flying today.
While the aircraft has now been in operational service for 6 years, the project that
created this behemoth suffered its fair share of problems and delays. Originally
scheduled for delivery in 2006, the aircraft’s entry into service was delayed by almost
2 years and the project was several billion dollars over budget.
At the heart of the problems were difficulties integrating the complex wiring system
needed to operate the aircraft with the metal airframe through which the wiring needed
to thread. With 530Km of wires, cables and wiring harnesses weave their way
throughout the airframe. With more than 100,000 wires and 40,300 connectors
performing 1,150 separate functions, the Airbus A380 has the most complex electrical
system Airbus had ever designed. As the first prototype (registration F-WWOW) was
being built in Toulouse France, engineers began to realize that they had a problem.
Wires and their harnesses had been manufactured to specification, but during
installation the wires turned out to be too short. Even though the cables were at times
just a few centimetres too short, in an aircraft you can’t simply tug a cable to make it
fit. As construction of the prototype continued Airbus management slowly came to the
realization that the issue was not an isolated problem and that short wires was a
pervasive issue throughout the design.
Internal reviews identified that the heart of the problem was the fact that the different
design groups working on the project had used different Computer Aided Design (CAD)
software to create the engineering drawings. The development of the aircraft was a
collaboration between 16 sites spread across 4 different countries. German and
Spanish designers had used one version of the software (CATIA version 4), while
British and French teams had upgraded to version 5. In theory, the fact that the design
centers were sharing their drawings meant that the electrical system designed in
Germany would be compatible with the airframe components designed in France. Part
way through the project the design centres also started integrating their diagrams into
a single 3D Digital Mock-up Unit (DMU) that should further have validated compatibility.
Unfortunately, the construction of F-WWOW demonstrated that theory and practice are
not always the same thing.
PAGE 4 OF 10
z53845 30
In part the problem was the CATIA version 5 was not a simple evolution from version
4, it was a complete rewrite. Reports indicate that the calculations used to establish
bend radii for wires as they wove through the airframe were inconsistent across the
different versions of the software and that inconsistency resulted in the problem.
Stripping out the wiring from the prototype, redesigning the wiring, making new
harnesses and then rethreading the wiring into the airframe became a monumental
task. Taking months to complete the project was delayed multiple times as hundreds
of engineers tried to overcome the problems. At one point more than 1,100 German
engineers were camped out at the Toulouse production facility trying to rectify the
problems.
The root of the problem can be traced back to a single decision: the decision to proceed
with the project despite the fact that two CAD systems were in use. That decision
resulted in design inconsistencies, mismatched calculations, and configuration
management failures.
The entry of above has been extracted from a record in the “Catalogue of Catastrophe” – a
list of failed or troubled projects from around the word.
Source: http://calleam.com/WTPF/?p=4700 Access: 08 November, 2021 23:00.
REQUIRED:
With reference to the above scenario, answer the following three questions:
a) If you were a researcher who are interested in studying certain aspects of Airbus
SAS, propose a research question (RQ) that is appropriate for a qualitative inquiry
into Airbus SAS. From the scenario, explain your motivation for proposing such a
RQ.
(5 marks)
[Answer Word limit – 200 words]
b) Using the context of the scenario, explain to which category of research design
(Exploratory, Descriptive, Explanatory, or Emancipatory) does your RQ belong?
(5 marks)
[Answer Word limit – 200 words]
c) Discuss two (2) qualitative research methods you would use to answer your
RQ. Explain why they are appropriate to your RQ in this scenario.
(20 marks)
[Answer Word limit – 800 words]
PAGE 5 OF 10
z53845 30
IMPORTANT Answer all questions from Section A (Qualitative) and all questions from
Section B (Quantitative) using separate templates.
You must answer Q1 to Q2 using the Template provided for SECTION A and Q3 to
Q4 using the Template provided for SECTION B. DO NOT MIX questions from Section
A with those from Section B in the same Template. The templates have to be uploaded
on separate Turnitin links.
SECTION B: QUANTITATIVE QUESTIONS (50 MARKS)
QUESTION 3
25 MARKS
Part A
The following chart and accompanying text are reproduced from the “Why Australia:
Benchmark Report 2021” prepared by Australian Trade Commission, Australian
Government. (If you have trouble viewing the chart, you can access it through the
following website: https://www.austrade.gov.au/benchmark-report/innovation-skills)
a. Discuss the purpose of Chart 1 and critically assess how well it meets this
purpose.
(3 marks)
b. Would you recommend that the data be presented in a different way? If not, why
not? If so, explain how you would present the data in a better way. (3 marks)
“A big spender on research and development:
Australia’s annual gross domestic expenditure on research and development (GERD)
reached A$34 billion in 2018–19. This places Australia alongside the UK, Singapore
and France as one of the highest spenders on research and development (R&D).
Australia’s trend in R&D is upwards. GERD rose by around 7% per year from 2000–
01 to 2018–19 and it now represents 1.8% of Australian GDP. This creates a pool of
skilled researchers who are globally competitive.”
PAGE 6 OF 10
z53845 30
CHART 1:
Part B
a.
After a change in the process for managing customer enquiries posted to their
website, a company is concerned that it is taking too long to respond. It collects
data on the time taken to respond for a sample of 400 customer enquiries. If
the true population mean response time is 27.6 minutes with the standard
deviation being 16 minutes, what is the probability that the mean of this
sample will be less than 25.6 minutes?
(3 marks)
b.
How are we able to answer a. above without knowing whether the population
call time distribution is skewed or not?
(3 marks)
c.
The company randomly selects a number of registered customers. It calls
these customers asking them to complete a customer satisfaction survey by
phone. From previous surveys, the company knows that the chance of a
selected customer agreeing to complete the survey is 20%. If in one day it calls
14 selected customers, what is the chance that exactly 4 customers complete
the survey?
(3 marks)
PAGE 7 OF 10
z53845 30
d.
What assumptions did you need to make to answer c.? Answer in relation to
this particular situation.
(3 marks)
e.
The company has a complaints telephone line. The company is concerned that
because of changes to their website, more lengthy complaints calls are being
received. A sample of 100 calls is taken. Their average is 7.25 minutes. The
population mean is known to have been 7 minutes with a standard deviation
of 2.1 minutes. Use a hypothesis test to test if the mean call time has changed
from 7 minutes at the 1% level of significance. Show all steps (hypotheses,
test statistic, decision rule) and explain your conclusion.
(7 marks)
PAGE 8 OF 10
z53845 30
QUESTION 4
25 MARKS
Part A
An online retailer has checked the expenditures of 100 customers in one week and
found the average total spent is $151.16. Assume that the standard deviation of
expenditure for all customers is $55 and find a 95% confidence interval for the average
amount spent by all customers in this week.
(5 marks)
Part B
Shengyu is an analyst for a company that provides clients with advice about economic
conditions. He notes that the United States (US) is experiencing high inflation at the
moment. He wonders if high inflation in the US somehow feeds through to cause high
inflation in China. To start his analysis, he downloads data on inflation from the OECD
website and runs a simple regression of Chinese inflation on US inflation for data from
Quarter 1 2005 to Quarter 2 2021 (each quarter’s data on inflation is in terms of annual
percentage change). The Excel output for this is as follows:
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.533126
R Square
0.284223
Adjusted R Square 0.273039
Standard Error
1.614377
Observations
66
ANOVA
df
Regression
Residual
Total
Intercept
X Variable 1
a.
1
64
65
SS
MS
F
Significance F
66.23271501 66.23272 25.41338 4.0545E-06
166.7977302 2.606215
233.0304453
Coefficients Standard Error t Stat
P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
0.823257 0.397429191 2.071456 0.042352 0.02930082 1.617213 0.02930082 1.61721298
0.977674 0.193938053 5.041168 4.05E-06 0.59023857 1.365110 0.59023857 1.36511017
How well does the regression line fit the observed data? Explain.
(3 marks)
b.
What is the sample correlation coefficient between the two variables in this
model and how can it be interpreted?
(5 marks)
c.
Write the sample regression equation clearly defining the variables used.
(5 marks)
d.
If these regression results were used to predict Chinese inflation, what would
the inflation rate in China be if US inflation is 6.2% in Quarter 3 2021? Explain
the rate of increase thereafter if US inflation continues to rise.
(7 marks)
PAGE 9 OF 10
z53845 30
— END OF EXAMINATION PAPER —
PAGE 10 OF 10
COMM5011: Data Analysis for Business
SECTION B – QUANTITATIVE
Take-Home Exam Answer Sheet
Term 3 2021
By submitting your Take-Home Exam Answer sheet for assessment, you agree that:
•
•
•
•
•
•
•
•
•
•
•
1
This is a Take-Home Exam, your responses are your own original work.
You have attempted this Take-Home Exam by yourself without any help from others. Thus, you have
NOT worked, collaborated or colluded with any other persons in the formulation of your responses.
The work that you are submitting for your Take-Home Exam is your OWN work.
In accordance with the Declaration form, this Take-Home Exam paper cannot be copied, forwarded or
shared.
Students are reminded of UNSW’s rules regarding Academic Integrity and Plagiarism. Plagiarism is a
serious breach of ethics at UNSW and is not taken lightly. For details see Examples of plagiarism.
This Take-Home Exam is an open book/open web, further information is available “Here”.
o You are permitted to refer to your course notes, any materials provided by the course convenor
or lecturer, books, journal articles, or other material/s from the Internet.
o It is sufficient to use in-text citations that include the following information: the name of the author
or authors; the year of publication; the page number (where the information/idea can be located
on a particular page when directly quoted), For example, (McConville, 2011, p.188).
o You are required to cite your sources and attribute direct quotes appropriately when using
external sources (other than your course materials).
o When citing Internet sources, please use the following format: website/page title and date.
o If you provide in-text citations, you must provide a Reference List. The Reference list will NOT be
counted towards your word limit.
The work that you are submitting for your Take-Home Exam has NOT been previously submitted for
academic credit in this, or any other course, at UNSW or elsewhere.
The examiner may, for examination and grading purposes, reproduce and provide a copy of your
submission to another member of the University.
Turnitin may retain a copy of this Take-Home Exam submission on its database for the purpose of
future plagiarism checking.
You have NOT used third-party essay/writing services. These are NOT permitted by UNSW and where
detected, your submission WILL be treated as plagiarism in accordance with applicable policies and
procedures.
Plagiarism detected in submitted work will be treated as a failure to act responsibly, ethically and with
academic integrity and in accordance with student responsibilities found in Student Code of Conduct.
The University may take disciplinary action under the Student Misconduct Procedures.
Reproducing, publishing, posting, distributing or translating this Take-Home Exam is an infringement of
copyright and will be referred to the Student Conduct & Integrity Unit for action.
COMM5011: Data Analysis for Business (Term 3 2021) Section B – Quantitative
Student ID: z5384530
By signing below, you acknowledge and agree with each of the above statements.
Student ID: z5384530
Signature (this can be either your digital signature or simply type your Full Name):
__________________________________________________
2
COMM5011: Data Analysis for Business (Term 3 2021) Section B – Quantitative
Student ID: z5384530
COMM5011 T3 2021
Student Name: ___________________________ Student ID: ____________________________
•
•
•
•
•
•
You may handwrite all or part of your solutions and upload a scan (as PDF only) to Moodle.
You must include your Student ID: and your Student Name: on the Declaration page and on the top
of each page which you submit
Your submission to Moodle MUST include the Declaration on page 1 as the first page of your
submission.
Your submission to Moodle should be directly readable by the marker. Please do not include computer
files such as Excel files.
You need to show your calculations and demonstrate how you obtain your results.
Please name your file as follows:
QUANT_yourfirstname_zID_your last name_COMM5011.pdf
(for example, QUANT_John_z5011234_Smith_COMM5011.pdf).
3
COMM5011: Data Analysis for Business
SECTION A – QUALITATIVE
Take-Home Exam Answer Sheet
Term 3 2021
By submitting your Take-Home Exam Answer sheet for assessment, you agree that:
•
•
•
•
•
•
•
•
•
•
•
1
This is a Take-Home Exam, your responses are your own original work.
You have attempted this Take-Home Exam by yourself without any help from others. Thus, you have
NOT worked, collaborated or colluded with any other persons in the formulation of your responses.
The work that you are submitting for your Take-Home Exam is your OWN work.
In accordance with the Declaration form, this Take-Home Exam paper cannot be copied, forwarded or
shared.
Students are reminded of UNSW’s rules regarding Academic Integrity and Plagiarism. Plagiarism is a
serious breach of ethics at UNSW and is not taken lightly. For details see Examples of plagiarism.
This Take-Home Exam is an open book/open web, further information is available “Here”.
o You are permitted to refer to your course notes, any materials provided by the course convenor
or lecturer, books, journal articles, or other material/s from the Internet.
o It is sufficient to use in-text citations that include the following information: the name of the author
or authors; the year of publication; the page number (where the information/idea can be located
on a particular page when directly quoted), For example, (McConville, 2011, p.188).
o You are required to cite your sources and attribute direct quotes appropriately when using
external sources (other than your course materials).
o When citing Internet sources, please use the following format: website/page title and date.
o If you provide in-text citations, you must provide a Reference List. The Reference list will NOT be
counted towards your word limit.
The work that you are submitting for your Take-Home Exam has NOT been previously submitted for
academic credit in this, or any other course, at UNSW or elsewhere.
The examiner may, for examination and grading purposes, reproduce and provide a copy of your
submission to another member of the University.
Turnitin may retain a copy of this Take-Home Exam submission on its database for the purpose of
future plagiarism checking.
You have NOT used third-party essay/writing services. These are NOT permitted by UNSW and where
detected, your submission WILL be treated as plagiarism in accordance with applicable policies and
procedures.
Plagiarism detected in submitted work will be treated as a failure to act responsibly, ethically and with
academic integrity and in accordance with student responsibilities found in Student Code of Conduct.
The University may take disciplinary action under the Student Misconduct Procedures.
Reproducing, publishing, posting, distributing or translating this Take-Home Exam is an infringement of
copyright and will be referred to the Student Conduct & Integrity Unit for action.
COMM5011: Data Analysis for Business (Term 3 2021) Section A – Qualitative
Student ID: z5384530
By signing below, you acknowledge and agree with each of the above statements.
Student ID: z5384530
Signature (this can be either your digital signature or simply type your Full Name):
__________________________________________________
2
COMM5011: Data Analysis for Business (Term 3 2021) Section A – Qualitative
Student ID: z5384530
COMM5011 T3 2021
Student Name: ___________________________ Student ID: ____________________________
•
Please name your file as follows:
QUAL_yourfirstname_zID_your last name_COMM5011.docx
(for example, QUAL_John_z5011234_Smith_COMM5011.docx).
Q1: (Your total word count ______)
Your answer: (Arial Font 11)
3
(20 marks, max 800 words)
COMM5011: Data Analysis for Business (Term 3 2021) Section A – Qualitative
Student ID: z5384530
Q2a: (Your total word count ______)
Your answer: (Arial Font 11)
4
(5 marks, max 200 words)
COMM5011: Data Analysis for Business (Term 3 2021) Section A – Qualitative
Student ID: z5384530
Q2b: (Your total word count ______)
Your answer: (Arial Font 11)
5
(5 marks, max 200 words)
COMM5011: Data Analysis for Business (Term 3 2021) Section A – Qualitative
Student ID: z5384530
Q2c: (Your total word count ______)
Your answer: (Arial Font 11)
6
(20 marks, max 800 words)
COMM5011: Data Analysis for Business (Term 3 2021) Section A – Qualitative
Student ID: z5384530
Reference List
7

Purchase answer to see full
attachment

  
error: Content is protected !!