Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed
image text in transcribedimage text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Climate Mathematics Theory And Applications

Authors: Samuel S P Shen, Richard C J Somerville

1st Edition

1108750184, 9781108750189

More Books

Students also viewed these Mathematics questions

Question

How to calculate risk free rate when itss not given

Answered: 1 week ago