Ikea Supply chain

How old are the students studying MU 123 ? Knowing that the number of students in MU 123 is 80 a questionair is been made to know the ages of those students as they are consider small segment from the AOU and we can from that know from this study know the avarage age of AOU students. 28 students were in the age of 18 – 21 18 student were in the age of 22 – 28 11 students were in the age of 25 – 28 9 students were in the age of 28 – 31 7 student s were in the age of 32 – 35 6 students were in the age of 35 – 40 1 student on were age above 40Part (b) Collect relevant data needed to answer your question (stage C). This will involve choosing samples or designing questionnaires and key the data into a spreadsheet. Most of the data you will need is secondary data that already exist in the internet or published literature and can be adapted for your investigation. You may refer to your text book, (Book A, pages 183 & 184) and learn more how to deal with data. When presenting your data it is important to provide the reference to the data source you are adapting. (30 marks).As it shows in the table below How old are the Students studying MU 123 Age Range 18-21 22 – 25 26-29 30-33 34-37 38-40 40 + Number 28 18 11 9 7 6 Percentage% 22. 50% 13. 75% 11 . 25% 8. 75% 7. 50% whenever the age increase the number of students decreases. 35% are the highest percentage with 28 students in their fresh years. 1. 25% are the lowest percentage with only 1 student enrolled above the age 40. 27. 5% are the number of students attending between 30 to 40 Part (c) Analyse the data that have been collected (stage A).This stage involves steps in summarising and measuring the collected data. The associated measures that we expect you use in your TMA are the mean, the mode, the median, range, interquartile range and standard deviation. You can use Microsoft Excel in presenting your data in bar charts or graphs as part of summarising your data. (mo re details on how to draw statistical pictures are explained In book D, Unit 1 1) (30 marks) calculating the mean: 1+6+7+9+11+18+28= = 1 1. 4 Calculating the meadian: Arrange the numbers by order: 1 6 7 9 11Range = 28-1 = 27 QI-6 18 IQR= 18-6=12 Standard Deviation: Meadian Deviations (d) d (power of 2) 1-114 . = -10. 4 108. 6 = -5. 4 29. 16 -4. 4 19. 36 = -2. 4 5. 76 11-11. 4 . 4 0. 16 18-11. 4 = 6. 6 43. 56 28-11. 4 = 16. 6 275. 56 The mean of d(to power of 2) 108. 6 + 29. 16 + 19. 36 + 5. 76 + 0. 16 + 43. 56 + 275. 56 = 462. 8/7 66. 11 = 8. 13 is the standard deviasion = 66. 11 Square root of At the end we realize from all the above charts how the number of students will decrease as the age increases.