TSTA101 – QUANTITATIVE METHODS FOR ACCOUNTING AND FINANCE

Mean

Median

Mode

Standard Deviation

Coefficient of variation

Pie Chart

Scatter Graph

An Australian manufacturing company is keen to develop new products and develop a 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 products and 2 for Male products.
    • COUNTRY: the country in which the shoes are produced: 1 made in Thailand, 2 made in Singapore and 3 made in China.
    • COST: Production cost of the shoes in dollars.

Part 1:

    1. Construct a pie chart for men’s and women’s shoes. 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:

    3. Calculate the Mean, Median, Mode, Standard Deviation, and Coefficient of Variation, for prices for men’s and women’s shoes, separately. Compare the figures and explain what conclusions you can draw from these analyses? Draw a box and Whisker plot for men’s and female shoe prices and comment on the shape of the graph.
    4. Calculate the Mean, Median, Mode, Standard Deviation, and Coefficient of Variation for prices for the three countries – Thailand, Singapore, and China, separately.

Part 3:

Answer the following Hypothesis Questions:

    5. Determine if average prices for female shoes are 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 “equal variances” of populations).
    6. Using a scatter graph of price (Y variable on the vertical axis) and production cost (X variable, horizontal axis), comment on the relationship between price and cost.