TSTA 101– Quantitative Methods for Accounting & Finance (worth 20%) Case Study, An Individual Assignment

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
   • recommendations.
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.

IMPORTANT:

• 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 only need to submit your assignment to Turnitin via Moodle before the due date.

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 1500 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%).

ANALYSIS

An Australian manufacturing company is keen to develop new products and develop new product line of jackets 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 “JACKETS”. The file includes:

PRICE: Price of the jackets in dollars.

GENDER: 1 for Female product and 2 for Male product.

COUNTRY: the country in which the jackets is produced: 1 made in China, 2 made in Singapore and 3 made in Thailand.

COST: Production cost of the jackets in dollars.

QUESTIONS

Part 1:

1. Construct a pie chart for men and women jackets. Construct a pie chart 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

Part 2:

1. Calculate the Mean, Median, Mode, Standard Deviation and Coefficient of Variation, for prices for men and women jackets, 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 jackets 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.