TSTA 101– Quantitative Methods for Accounting & Finance (worth 20%)
Case Study, An Individual Assignment, Due: 22 May 2019 by 09:30 am
Structure of the assignment:
Your report must include the following sections, respectively:
1) Executive Summary (100 words). This section include:
● the primary purpose of the study
● the general methodology used
● the significant findings of each section and general conclusions
2) Table of Contents with page numbers
3) Business Problem which is restatement of the primary purpose in business language.
4) Statistical problem includes methods you have used to do your analysis.
5) Analysis: This section should present the answers to all the questions.
6) General Conclusion: This section should briefly review and summarize the inference(s).
Also indicate the limitations of the results and your recommendations for action (based on what
you have found in your study). In other words, give an overall conclusion which combine all
of the two parts of the questions. Be clear in the conclusion that you draw from your analysis,
and provide useful suggestions to the company’s CEO to understand what kind of products
need to be produced by the new production line.
• It is compulsory for all students to submit their assignments (only final version) to Turnitins
via Moodle BEFORE submitting the hard copy in the lecture. Then an ‘originality report’ will
automatically be sent to the Lecturer. Otherwise your assignment will not be marked and you
will be awarded a ZERO for this assessment task.
• You must submit your assignment to Turnitin via Moodle before the due date. No assignment
will be accepted by Turnitins after the 09:30 am on 22 May 2019. You need to submit hard copy
of the same version in the lecture on 22 May 2019.
• Including the Turnitins report at the end of your assignment is needed.
PRESENTATION OF ASSIGNMENT
1. Each part requires an output from any statistical computer package (Excel). The statistical
output must be provided.
2. Your report can be maximum 2000 words (including tables and figures), penalties will be
applied if the report is longer than this.
3. Set the font to Times New Roman, size to 12 and line spacing 1.5 for your report.
4. Do not present the data in your assignment.
5. Correct grammar and spelling is important.
6. Insert an assignment cover sheet/ signed as own.
7. Tables/graphs should be properly prepared, numbered and labelled.
8. No broken table or graph across two pages.
9. Page number is necessary.
Summary of Marking Guide
Marks awarded will be based on format (10%) and analysis (90%).
Executive Summary 10
Business Report 5
Statistical problem 5
Part 1 question 1 5
Part 1 Question 2 10
Part 2 Question 1 10
Part 2 Question 2 10
Part 3 Question 1 15
Part 3 Question 2 10
General Conclusion 10
An Australian manufacturing company is keen to develop new products and develop new
product line of shoes so that the company can expand into Asian markets more than before.
The data have been collected for 99 products from the market. The data are in an excel file
named “SHOES”. The file includes:
PRICE: Price of the shoes in dollars.
GENDER: 1 for Female product and 2 for Male product.
COUNTRY: the country in which the shoes is produced: 1 made in Thailand, 2 made in
Singapore and 3 made in China.
COST: Production cost of the shoes in dollars.
1. Construct a pie chart for prices of men and women shoes. Construct a pie chart for price for
the three countries- Thailand, Singapore and China. Present your findings.
2. Construct a cross-classification table of frequencies between gender and country. Plot a
vertical bar chart of frequency (Y variable) and gender (X variable), then group the bar charts
of genders for three countries and comment on the relationship between gender and country
1. Calculate the Mean, Median, Mode, Standard Deviation and Coefficient of Variation, for
prices for men and women shoes, separately. Compare the figures and explain that what
conclusions you can draw from these analyses? Draw a box and Whisker plot for men and
female shoes prices and comment on the shape of the graph.
2. Calculate the Mean, Median, Mode, Standard Deviation and Coefficient of Variation for
prices for the three countries – Thailand, Singapore and China, separately. Compare the figures
and explain what conclusions you can draw from these analyses? Draws a Box and Whisker
plot for each country and comment on the shape of the graph.
Answer the following hypothesis questions:
3. Determine if average prices for female shoes is less than average prices for male shoes.
Compare the result with part 1 question 1. Does the result confirm your previous findings?
(Follow the hypothesis testing steps, 0.05 level of significance, assuming “none equal
variances” of populations).
4. Using a scatter graph of price (Y variable on vertical axis) and production cost (X variable,
horizontal axis), comment on the relationship between price and cost.
Activation of Data Analysis:
1. Click on File, then click Options.
2. Click Add-Ins, and then in the Manage box, select Excel Add-ins.
3. Click Go.
4. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.
5. After you load the Analysis ToolPak, the Data Analysis command is available in the
Analysis group on the Data tab.
Highlight the column of data/ Data tab/Sort/expand the selection / A/Z
1. Highlight all data including labels
2. Insert Tab/ choose the chart.
From Menu, Data Tab, Data analysis, Descriptive statistics (highlight data for input range),
tick summary statistics and confidence interval, OK
Two sample hypothesis testing:
Excel/Data/Data Analysis/ t test, two sample assuming equal variances (or unequal)/ highlight
data for variable 1 and 2/ insert the value for Hypothesized difference equal zero and level of
*if you have highlighted the labels tick (the relevant box.
From Menu, Data Tab, Data analysis, Anova single factor highlight data for input range),
insert the value for alpha, OK
From Menu, Data Tab, Data analysis, Regression, highlight data for Input Y range and Input
X range, tick Residuals Plots boxes, OK
TSTA 101– Quantitative Methods for Accounting & Finance (worth 20%) Case StudyTSTA 101– Quantitative Methods for Accounting & Finance (worth 20%) Case StudyMay 21, 2019 in Uncategorized