代写BUS1BAN Research Project

100%原创包过,高质代写&免费提供Turnitin报告--24小时客服QQ&微信：120591129

• Weight: This assignment is worth 20% of the total marks for this subject.

• Due date:

o Random sample submission date: Friday (5pm) 9 September

o Project Submission Date: Monday (12pm) 17 October.

You are enrolled in BUS1BAN. The subject focuses on two graduate capabilities: information literacy and inquiry/research. This assignment focuses on assessing the quality of your learning and its application in real world business research at an introductory level. The assignment requires you to apply the analytical techniques taught in this subject to data collected through a survey. The online weekly videos/face-to face lecture, face-to-face workshops and weekly online quizzes will provide you with the opportunity to learn the analytical techniques needed to successfully complete this assignment. All in-semester assessments in BUS1BAN are designed to promote your understanding of the material covered in this subject and will prepare you for the final exam.

1

Project Title: An investigation into the under-filling of tuna cans and the demand for a new product.

Cans are airtight containers which preserve processed food. These are mostly easy to cook food items with extended shelf life and can be conveniently stored under a variety of conditions. The global demand for these products is on the rise for a variety of reasons. One issue that gets attention in the media every now and then is underweighting or under-filling of the product cans. Underweighting or under-filling refers to the fact that the net weight of contents in the cans turns out to be less than the one specified on the label. Click here to see some example.

This assignment creates a hypothetical scenario where a consumer interest group decides to investigate this issue in Australia for tuna cans. The group hired some student volunteers from BUS1BAN class to collect the data. The interest group also managed to get a small market research project from a potential producer of a new variety of canned tuna (interested in quantifying the demand for the new variety) who agreed to pay students a lump sum amount for their effort.

As part of the agreement, the students set up a stall in the Northland shopping centre for two month to collect data required for this analysis. The students would ask shoppers to check the weight of their tuna cans and taste the new variety of tuna. Let us refer to this as NewTaste Tuna (NT Tuna in short).

For simplicity, let us assume that (i) there are two brands of tuna cans in the market, brand A and brand B, (ii) both sold in standard cans that are supposed to weigh 100gm and (ii) both types of cans have the same price per 100gm.

The students

i. registered the type of Tuna can purchased by participants

ii. weighed the tuna cans and (a) registered its weight and (b) reported whether or not it was under-filled? (Note that students were advised that regulations allow a less than 2% difference in individual cans weights which means a can will be classified as under-filled if it weighed less than or equal to 98 grams.)

iii. Participants were requested to taste the NT tuna, cooked on the spot, and answer Yes or No to the following questions.

Will you purchase the NT tuna, instead of the brand you have purchased, if it was available in the market at:

a. 0% discount: the same price as the tuna cans they have purchased,

b. 5% discount: 5% cheaper than the tuna cans they have purchased,

c. 10% discount: 10% cheaper than the tuna cans they have purchased,

d. 15% discount: 15% cheaper than the tuna cans they have purchased,

e. 20% discount: 20% cheaper than the tuna cans they have purchased,

f. 25% discount: 25% cheaper than the tuna cans they have purchased,

A total of 645 participants participated in the survey. The data is provided to you in the excel spreadsheet. (Note: This is a hypothetical scenario and the data was generated by the subject coordinator for the purpose of this assignment and does not represent actual responses).

 代写BUS1BAN Research Project

What should you do?

 Groups: Submit the assignment in groups of three. All group members must be from the same workshop. Make sure you form your group right as soon as this assignment is uploaded.

 Select a random sample from the data: Randomly select the responses of 100 participants from the data. The Excel file provides further details about the sample selection process.

 Submit your random sample in a spreadsheet by 5pm, Friday 9 September. The sample you submit will be used to double check your calculations. This is when you will have to submit details of your group members as well.

 Submit a written report of around 1000 words (excluding tables and graphs) using Turnitin on the LMS. The report must respond to the specific questions asked in a report format. See the ‘Report Format” for details.

Marking criteria:

You are expected to use the data analysis techniques covered in this subject to answer the specific questions listed in the “Report Format” section. Marks will be allocated on the basis of correctly identifying the tools of analysis; their successful application to the survey data and the overall quality of your report. A detailed break-down of the marks is given in the “Report Format”.

3

Report Format

The survey can be used to answer many interesting questions. You are however required to focus on specific questions listed below. The report must follow the following format.

• You MUST use the word document to insert your answers which will be provided to you as a separate file.

Cover Page

Tutor Name:_______________________________________

Tutorial details (Day/Time/Location):_________________________________

Student No

Name

Student contribution*

(%)

Student Signature

*We expect all group members to contribute equally (100%) to the assignment on all topics. You are not allowed to divide sections. If a student has contributed to only some sections, the contribution of student should be equal to the marks it carries. A student with less than 100% contribution will receive marks proportional to their contribution.

YOU MUST ATTACH a signed copy of this cover sheet to the assignment.

 

B. Using Excel, (i) construct a scatter plot of the discount offered on the new product (NT tuna) and the proportion of customers who said that they will buy the new product if they are offered the stated discount and (ii) fit a least square line using Excel displaying its equation and the value of R-squared.

C. Provide an interpretation of the output (Intercept, slope and R-squared). Is there any relationship between discount offered and potential demand for the NT tuna? 6

D. What discount should be offered to customers if the producer of the NT tuna product wants to capture 25% of the existing market?

6. Potential Demand for NT Tuna: Market captured by Brand;

A. Complete the following table

Discount offered

Proportion of customers who said they will buy the new product

Brand A

 

B. Using Excel, construct scatter plots of the discount offered on the new product (NT tuna) and the proportion of each brand’s customers who said that they will buy the new product if they are offered the stated discount. Which brand’s customers are more loyal to their brand?

C. What proportion of each brand’s market will the NT tuna producer capture if it decides not to give any discount and offer the product at the same price as the other brands?

Section C: Advance scenarios (30% marks)

7. Suppose, you randomly selected a customer. How likely is it that the customer will purchase

i. brand A

ii. brand B

Provide 95% interval estimates for each of the above. Show the confidence intervals graphically and interpret your results.

8. Provide point and 95% confidence interval estimates for the weight of tuna cans, show it graphically and interpret your results.

9. Suppose brand A’s producer claimed that the average weight of their products is 100gm. Test validity of this claim at 5% level of significance. Clearly show steps involved in hypothesis testing.

10. Suppose brand B’s producer claimed that less than 20% of their cans are under-filled. Test validity of this claim at 5% level of significance. Clearly show steps involved in hypothesis testing.

7

III. Summary and discussion (15% marks):

Summarize your results and critically evaluate the survey method used in this assignment.

Some Examples:

o Is the method of data collection consistent with random sampling? (overall data collection not the random sample that you have selected).

o Should we be concerned about the fact that the data was collected at one location only (Northland Shopping centre) on multiple days?

o Can this data be representative of all customers in Melbourne/Australia?

What should we do to reduce the concerns you might have raised in your critical analysis. 
 代写BUS1BAN Research Project