QUANTITATIVE METHODS
In order to gain full marks, please show full workings step by step.
Case Study 1 Maximum Word Count 1000 words
The manager of Jana’s Juice Bar is looking at cost information for the business. She is looking in particular at the purchases of apple juice, orange juice, and pineapple juice.
The following figures were collected for the past three years.
Item |
Price (pence) |
|
Quantity Purchased |
|||
|
Year 1 |
Year 2 |
Year 3 |
Year 1 |
Year 2 |
Year 3 |
Apple juice |
120 |
128 |
131 |
2,225 |
2,412 |
2,953 |
Orange juice |
152 |
163 |
178 |
1,117 |
1,588 |
3,422 |
Pineapple juice |
42 |
37 |
36 |
845 |
962 |
743 |
(i) Using Year 1 as the base year, calculate the following indices:
(a) Simple aggregate price indices for Years 2 and 3.
(b) Laspeyres price indices for Years 2 and 3.
(c) Paasche price indices for Years 2 and 3, assuming that Year 3 is the current year.
(ii)Discuss the relevance of these indices for comparing the cost of purchasing fruit juice and compare the relevant merits of each type of index.
Masiko’s Televisions have been conducting a survey in Kampala and Nansana on the age of televisions in the two cities. A sample was taken from each city and it was found that in Kampala the average age of televisions was 33 months, with a variance of 225 months, and in Nansana the average was 42 months, with a variance of 400 months. In each city there were 51 television owners surveyed.
(i) Use an appropriate hypothesis test to show whether the average age of televisions in Nansana is significantly higher than the average age of televisions in Kampala.
(ii) Use an appropriate hypothesis test to determine whether the variance in Nansana is significantly higher than the variance in Kampala.
(iii) Write a report on your findings, detailing any assumptions you have made and any further information that should be obtained.
The Operations Manager at GKA Ltd is looking at the number of times that employees in his factory turn up late for work. He is interested in examining the relationship between an employee’s annual salary and the number of late days in 2020. He has collected the following data:
Annual Salary (£000s) |
Late Days in 2020 |
x |
y |
15 |
9 |
49 |
1 |
33 |
2 |
24 |
4 |
30 |
4 |
42 |
2 |
36 |
2 |
13 |
8 |
51 |
0 |
36 |
1 |
40 |
9 |
47 |
5 |
28 |
8 |
17 |
0 |
The following summary statistics have been calculated:
Σ(𝑥 - 𝑥̅)2 |
= 2018.93 |
Σ(𝑦 - fitted 𝑦)2 |
= 118.71 |
Σ(𝑦 – 𝑦�)2 |
= 144.93 |
Σ(𝑥 – 𝑥̅)( 𝑦 – 𝑦�) |
= -230.07 |
(i) Calculate the regression statistics and determine whether the relationship is significant using an appropriate hypothesis test.
(ii) Write a report on the analysis of the data. Indicate any additional information you would require to complete a fuller analysis and include any recommendations for further analysis that you would require.
The manager of Jana’s Juice Bar commissioned a report into the sales in Harare over the past year. She has collected the following data for the period January–December 2020:
Harare Sales 2020
Month |
Sales in $000s |
Jan |
250 |
Feb |
284 |
Mar |
302 |
Apr |
316 |
May |
246 |
Jun |
380 |
Jul |
405 |
Aug |
428 |
Sept |
386 |
Oct |
292 |
Nov |
242 |
Dec |
230 |
(i) Analyse the data using Holt’s method, with a = 0.4 and g = 0.3, and produce a forecast for the next four months.
(ii) Write a report describing any assumptions you have made and commenting on the reliability of the forecasts. Discuss the relevance of any alternative models that could have been used.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme