MIS770 Foundation Skills in Business Analysis - Assignment Two

Assignment Two: Analysis of Click Sales Data

Please carry out an analysis of the Click Sales data (contained in the file ClickSales data.xlsx) and prepare a report for me containing answers to the following questions.

My specific questions are:

Q1. We need an overall view of both (a) the number of items sent from warehouses and (b) the review ratings that are given to us by our customer.

Q2. Relationships

1. Is there a difference in the customer review ratings when comparing male and female location managers?
2. Is there a relationship between the annual sales and the number of team members operating at that warehouse location?
3. The Business Intelligence team would like to get an understanding of the relationship between the wages paid and whether or not the location managers were male or female.

Q3. Using the random sample of 150 warehouses, the BI team would like to get an estimate of the following.

1. The average annual sales of all warehouses managed by Females.
2. The proportion of all of our stores that have a customer review rating of “high”.

Q4. The Business Intelligence team would like to compare this year’s annual wages to the industry average of $65,000.

1. The average wage for warehouse staff who do not work for Click Sales is 65,000 dollars. Is this wage we pay our Click Sales warehouse staff higher than this?
2. Based on the industry observations, it is known that elsewhere, fewer than 22% of warehouse managers are male, is this the same for Click Sales managers? That is, is the proportion of Click Sales managers who are male really less than 22%?

Q5. Appropriate Sample Size
Finally, the Business Intelligence team is concerned that a sample of 150 might be too small to draw reliable inferences and conclusion from. For a survey we intend to undertake next year, we would like your advice on the following:

1. Is a sample size of 150 suitable to make reliable estimates form?
2. What size sample should be taken in order to accurately estimate the true proportion of warehouses that have a high customer review rating to with plus and minus 5%