BEO2255 Applied Statistics For Business - Assignment 1

Assessment Overview

Learning Outcomes

The learning outcomes for Part One of the group assignment are LO 3, 4 and 5.

• LO 3: Analyse business related data using appropriate SPSS/Excel functionalities to provide specific recommendations to real-world business problems;
• LO 4: Derive statistical models using statistical findings and make use of such findings in writing reports to evaluate alternative policy options and justify recommendations in decision making; and 
• LO 5: Exhibit effective interpersonal skills to successfully collaborate with and influence others in teams to achieve group outcomes whilst maintaining responsibility and accountability of own learning and professional practice 

Instructions

1. 1. This group assignment requires 3 members in each group.
   2. Students are advised to work with their own groups as allocated. 
   3. Only one soft copy of the group assignment should be submitted to your lecturer for each group.
   4. Your assignment must include names of each group member, including student IDs.
   5. No single-authored submission will be accepted.
   6. Any sort of plagiarism will warrant a "FAIL" in this unit.

Assessment Structure and Requirements

Instructions to select 100 observations:

Follow the instructions below to choose the sample:

• Write down the last two digits of ID numbers of the group members (eg, 4520225, 4267837 & 4251508, here last two digits are 25, 37 & 08);
• Choose the two smaller digits (eg 08);
• Use this as the starting row to copy 100 observations (remember to start from row 9 as the row 1 contains the labels).

Details

A community health organisation operating in a developing country has undertaken a media campaign highlighting health risks associated with milk powder consumption as opposed to fresh milk consumption. Now, they wish to assess whether their current campaign has affected people’s consumption of milk powder. To this end, they have conducted a simple survey which consists of 250 randomly selected respondents who were over the age of 18. Each respondent was interviewed before and after being exposed to the campaign. The hypothetical data in the file Assessment 1 Data contains the 250 observations from a hypothetical random sample of respondents (copy 100 observations and paste values). The data file contains the following variables:

Use Excel to perform the following tasks. Report your results in an MS Word document, including all excel outputs.

1. Use Descriptive statistics to summarise the data and develop a 95% confidence interval estimate of the mean income in the target population.
2. Find the proportion of Male respondents in the sample that had Full-time employment and develop a 95% confidence interval estimate on the proportion of Male respondents in the target population with Full-time employment.
3. Check and validate whether the weekly spending data are distributed normally. 
4. Perform a Wilcoxon Rank Sum test of the null hypothesis that the distributions of spending before being exposed to the advertising campaign are the same for Full-time workers and Part-time workers in the population of respondents. Perform the hypothesis test at 5% level of significance
5. Perform a Wilcoxon Signed Rank Test of the null hypothesis that spending before the advertising campaign exposure is the same as after for the population of customers. Perform the hypothesis test at 5% level of significance