Ask Statistics and Probability Expert

Assignment

Learning Outcome

Apply quantitative reasoning skills to analyse business performance.

This assignment assesses the ability to use the appropriate technique to analyse the data, correctly interpret the analysis output and draw appropriate conclusions.

Apply quantitative reasoning skills to analyse business performance.

This assignment assesses the ability to use the appropriate technique to analyse the data, correctly interpret the analysis output and draw appropriate conclusions.

General Description / Requirements

The assignment requires that you analyse a data set, interpret and draw conclusions from your analysis, and then convey your conclusions in a written email. The assignment must be completed individually. The assignment, together with the appropriate Faculty assignment attachment sheet, must be submitted by the due date electronically in CloudDeakin. When submitting electronically, you must check that you have submitted the work correctly by following the instructions provided in CloudDeakin. Please note that we will NOT accept any hard copies or assignments submitted via email.

The assignment uses the file A1.xlsx which can be downloaded from CloudDeakin. Analysis of the data requires the use of techniques studied in Topics 1 to 5.

Scenario
You are Alex Cassidy, a business analyst who works for the BLITZ department store chain in their Research and Analysis department. You have been asked by the General Manager, Ms Jacinta Liu, to analyse a random sample of data collected from a recent survey of 300 randomly selected customers shopping in our stores. Her email making this request of you is reproduced below.

Email from the GM

To: Alex Cassidy

From: Jacinta Liu

Subject: Analysis of the BLITZ Department store data

Dear Alex,

Regarding the recent survey of the 300 customers in three major cities of Australia, the marketing department requires answers to the following questions. Your responses will be used as part of a report to senior management comparing customer habits and characteristics across the three cities.

1. Regarding the age of our customers and the amount they spent in our stores.

a. Can you provide a profile of our customers' age please?

b. Is there any evidence to suggest any differences in the average age of customers between the three cities?

c. Generally speaking, can we make the claim that the average amount spent per visit by all our customers is less than $105?

d. Is the amount of money spent per visit influenced by the age of the customer?
2. Regarding the shopping habits of our customers and their usage of the beauty sections within our department stores.

a. There have been some excellent instore promotions recently. Can you provide an estimate of the proportion of customers who shop in the beauty section in each of the three cities?

b. Do we have enough evidence to claim that the proportion who do shop in the beauty sections of all of our stores, could now be more than 48%?

c. Given that some of our customers are female, please indicate the likelihood that they might shop in the beauty section of our department store.

d. Is there any evidence to suggest that a relationship exists between shopping in the beauty sections of our department stores and whether or not a person is male or female?

Assignment instructions

The assignment consists of two parts:

Part 1: Data Analysis
In order to prepare a reply to the General Manager, you will need to examine and analyse the dataset thoroughly. The General Manager has asked a number of questions.
For all relevant questions in the email, you can assume that:
- a 95% confidence level is appropriate for confidence intervals and
- a 5% level of significance (that is, alpha (α) = 0.05) is appropriate for hypothesis tests.

The following guidelines for each question should be considered carefully:

Q1. Regarding customers' age and the amount of money spent on a visit.

a. You will need to produce the relevant summary statistics and suitable table(s) and graph(s).

b. Firstly, you will need to produce the relevant summary statistics. Once done, you should then use an appropriate inferential technique to determine if there is any difference in the average age of customers between the three cities.

c. Here, you will again need to generate the relevant summary statistics. Once done, you should then use an appropriate inferential technique to answer the question whether or not the average amount spent by all customers is less than $105.

d. You will need to use relevant relationship technique(s) to see whether the amount of money spent per visit is influenced by age of the customer.

Q2. Regarding the shopping habits of our customers and their usage of the beauty sections within our department stores.

a. After producing the relevant summary statistics, you will need to use an appropriate inferential technique to estimate the proportion of shoppers who are shopping in the beauty sections in each of the three cities.

b. Produce the relevant summary statistics. You will then need to use an appropriate inferential technique to determine if the proportion of all shoppers shopping in the beauty section could actually be greater than 48%.

c. This question is conditional upon the customer being a female. To assist in solving this question and the question below it (d.), you should create cross tabulations for the variables Beauty and the Gender.

General guidelines:
The analysis section you submit should be no more than 8 pages of computer output (ie. output that you have copied into your Word document from Microsoft Excel). When you conduct your analysis, you will produce much more than this initially, but you should trim it down to only show the most relevant results in your maximum of 8 pages. Where possible, it is always useful to produce both numerical and graphical statistical summaries as sometimes, something is revealed in one that is not obvious in the other. Within the Word document, your analysis should be presented in the same sequence (and contain that same numbered sequence) that the questions have been asked by Jacinta Liu (the General Manager), and be clearly labelled and grouped around each question. Poorly presented, unorganised analysis or excessive output (more than 8 pages) will be penalised.

Save your computer analysis frequently.

Part 2: Email

You are required to reply by email, detailing essential information and conclusions from your data analysis. You are allowed no more than 2 pages to convey your written conclusions.

Keep the English simple and the explanations succinct. Avoid the use of technical statistical jargon. Your reader will not necessarily understand even simple statistical terms, thus your task is to convert your analysis into plain, simple, easy to understand language.

Attachment:- Normal Distribution.rar

Statistics and Probability, Statistics

  • Category:- Statistics and Probability
  • Reference No.:- M92427208
  • Price:- $80

Priced at Now at $80, Verified Solution

Have any Question?


Related Questions in Statistics and Probability

Introduction to epidemiology assignment -assignment should

Introduction to Epidemiology Assignment - Assignment should be typed, with adequate space left between questions. Read the following paper, and answer the questions below: Sundquist K., Qvist J. Johansson SE., Sundquist ...

Question 1 many high school students take the ap tests in

Question 1. Many high school students take the AP tests in different subject areas. In 2007, of the 144,796 students who took the biology exam 84,199 of them were female. In that same year,of the 211,693 students who too ...

Basic statisticsactivity 1define the following terms1

BASIC STATISTICS Activity 1 Define the following terms: 1. Statistics 2. Descriptive Statistics 3. Inferential Statistics 4. Population 5. Sample 6. Quantitative Data 7. Discrete Variable 8. Continuous Variable 9. Qualit ...

Question 1below you are given the examination scores of 20

Question 1 Below you are given the examination scores of 20 students (data set also provided in accompanying MS Excel file). 52 99 92 86 84 63 72 76 95 88 92 58 65 79 80 90 75 74 56 99 a. Construct a frequency distributi ...

Question 1 assume you have noted the following prices for

Question: 1. Assume you have noted the following prices for paperback books and the number of pages that each book contains. Develop a least-squares estimated regression line. i. Compute the coefficient of determination ...

Question 1 a sample of 81 account balances of a credit

Question 1: A sample of 81 account balances of a credit company showed an average balance of $1,200 with a standard deviation of $126. 1. Formulate the hypotheses that can be used to determine whether the mean of all acc ...

5 of females smoke cigarettes what is the probability that

5% of females smoke cigarettes. What is the probability that the proportion of smokers in a sample of 865 females would be greater than 3%

Armstrong faber produces a standard number-two pencil

Armstrong Faber produces a standard number-two pencil called Ultra-Lite. The demand for Ultra-Lite has been fairly stable over the past ten years. On average, Armstrong Faber has sold 457,000 pencils each year. Furthermo ...

Sppose a and b are collectively exhaustive in addition pa

Suppose A and B are collectively exhaustive. In addition, P(A) = 0.2 and P(B) = 0.8. Suppose C and D are both mutually exclusive and collectively exhaustive. Further, P(C|A) = 0.7 and P(D|B) = 0.5. What are P(C) and P(D) ...

The time to complete 1 construction project for company a

The time to complete 1 construction project for company A is exponentially distributed with a mean of 1 year. Therefore: (a) What is the probability that a project will be finished in one and half years? (b) What is the ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As