BEO2255 Applied Statistics For Business - Group Report Part 1 - Assignment Help

Assessment Overview

Detail Length Weighting Due
You are required to Analyse a given business related data set using appropriate statistical techniques with the use of Excel functionalities and provide interpretations in understanding real-world business problems.

The purpose of this assignment is to:

Demonstrate your ability to work with other team members as a ‘team of business analysts’ in analysing and interpreting a business related data files. 

Review Content Session 1-3 in preparation for this assessment task.

No page limit 15% End of Week 1: Session 3

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. 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:

GENDER  1=Male, 2=Female
JOB  1=Full-time employment, 0=Part-time employment
AGE Age in years
INCOME Monthly Income 
BEFORE Weekly spending on milk powders before the campaign 
AFTER Weekly spending on milk powders after the campaign 

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

Elevate your statistical prowess with MyAssignmentHelp's Statistics Online Tutoring. Our seasoned tutors offer personalized guidance to tackle complex concepts with ease. From probability to data analysis, master statistics at your own pace. Trust our expertise for comprehensive support and excel in your academic journey.

Expert's Answer

Chat with our Experts

Want to contact us directly? No Problem. We are always here for you

Professional

Online Tutoring Services

17,148

Orders Delivered

4.9/5

5 Star Rating

748

PhD Experts

 

Amazing Features

Plagiarism Free

Top Quality

Best Price

On-Time Delivery

100% Money Back

24 x 7 Support

Ask a New Question
*
*
*
*
*

TOP

  Connect on WHATSAPP: +61-416-195006, Uninterrupted Access 24x7, 100% Confidential

X