INSTRUCTIONS
The survey can be used to answer many interesting questions but for this assignment you are required to focus on the specific questions listed below.
Your report must follow the format below.
· You MUST use the word document (which will be provided to you on Moodle as a separate file) to insert your answers.
Due Dates:
· Your sample of 80 (Excel file) to be submitted through Turn it in by end of week 3
· Your Report (word file) to be submitted through Turn it in by end of week 10. In addition to this, a hard copy (printed copy) of your report is to be submitted to your teacher.
1. Frequency distribution: (10 marks)
A. Complete the following frequency distribution table for each
and weight of cans XXXXXXXXXXmarks)
Class
Frequency
Relative Frequency
(%)
Cumulative Relative Frequency (%)
A
B
A
B
A
B
86 to 90
90 to 94
94 to 98
98 to 102
102 to 106
106 to 110
More than 110
Total
B. Use appropriate charts to plot the relative frequency distribution and cumulative relative frequency distribution table. ( 3 marks)
ANSWER:
C. What proportion of each
and of cans is under-filled? Recall “under-filling” means the can is under-filled by 2 or more than 2 grams? (i.e. the can contains 2 or more than 2 grams less than what is specified on the label). (3 marks)
ANSWER:
2. Under-filled or not? (7 marks)
A. Complete the following cross classification table (2 + 2)
Cross classification table by frequency
Underweight?
Total
Yes
No
Brand
A
B
Total
Cross classification table by
and total relative frequency
Underweight?
Total
Yes
No
Brand
A
B
Total
B. Use an appropriate chart to graphically display the above table.
Is the under-filling behaviour of
and A’s producer any different from that of
and B’s producer? (3 marks)
ANSWER:
Insert Graph here
Insert your Comment here
Section B: Intermediate level Analysis (20 marks)
3. Potential Demand for NT Tuna (12 marks)
A. Complete the following table (3 marks)
Discount offered
Proportion of ALL customers who said they will buy the new product
x
y
0%
5%
10%
15%
20%
25%
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 squares line” using Excel displaying its equation and the value of R-squared. (3 marks)
ANSWER:
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? If so, explain the type of relationship. (3 marks)
ANSWER:
D. What discount should be offered to customers if the producer of the NT tuna product wants to capture 25% of the existing market? (3 marks)
ANSWER:
4. Potential Demand for NT Tuna: Market captured by Brand (8 marks)
A. Complete the following table (3 marks)
Discount offered
Proportion of customers who said they will buy the new product
Brand A
Brand B
x
yA
yB
0%
5%
10%
15%
20%
25%
B. Using Excel, construct scatter plots of the discount offered on the new product (NT tuna) and the proportion of each
and’s customers who said that they will buy the new product if they are offered the stated discount.
Which
and’s customers are more loyal to their
and? (3 marks)