Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Instruction: Read ALL of the information carefully before you begin answering. Use the Excel built-in function recommended in completing all tasks. If you are unable
Instruction: Read ALL of the information carefully before you begin answering. Use the Excel built-in function recommended in completing all tasks. If you are unable to complete the task using the function, you may use an alternative method but this will result in the loss of some of the marks for the part. All your answers must be shown in the spreadsheet. The spreadsheet should be constructed using the Excel built-in functions such that, should any of the values in these cells be changed, then all calculations will update automatically. In awarding marks consideration will be given to the efficiency of any formulae constructed. You MUST save your work in the same file at least once every five minutes. All your answer must be presented within the colored space. You are required to download the excel file and follow the following steps before submission: 1 Save your file according to your name followed by assessment. (i.e. Ahamd bin Rosli_Practical Test) 2 Upload you answers (Excel file) in the Moodle only.(c) (i) Below data are summarized from the Satisfaction of customers. Complete the table. Mark Class Frequency (f) Mid-Point (x) fx 4.1-5.0 5 4.55 22.75 103.5125 5.1-6.0 21 5.55 116.55 646.8525 6.1-7.0 24 6.55 157.2 1029.66 7.1-8.0 31 7.55 234.05 1767.0775 8.1-9.0 18 8.55 153.9 1315.845 9.1-10.0 1 9.55 9.55 91.2025 Total 100 42.3 694 4954.15 (3 marks) (ii) With the results from part (c)(i) table, use the formula below to find the standard deviation. I fx 2 1.17383985279084 fx If If (2 marks) (iii) Compute the above population standard deviation, using an appropriate built-in function. 1.18586508507501 (1 mark) (iv) Compare results in part (c)(ii) and (c)(iii). State which of them is more accurate. Justify your answer. (1 mark)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started