To gain some insights into the typical price consumers are willing to pay for a stand mixer, a retailer of kitchen appliances randomly selected 130 relevant invoices for transactions completed in October 2021. Descriptive statistics, computed to summarise the data, are presented in Table 1 below. NB: Some values are missing. This table has been made available in the Excel file named"MN4063QAJULY22CWK1Data"under the tabTask 1.

Required for Task 1

With reference to Table 1 in the excel file named "MN4063QAJULY22CWK1Data", copy and fill the table with the missing values that you are required to calculate below:

Expenditure () on Stand Mixers
Mean	224.00
Standard Error	6.58
Median	224.00
Mode	224.00
Standard Deviation
Sample Variance	5625.00
Kurtosis	-0.49
Skewness	-0.32
Range	301.00
Minimum	68.00
Maximum	369.00
Sum	29120.00
Count	130.00
Lower Quartile	112.00
Upper Quartile
Coefficient of Variation
Inter-quartle range (IQR)	224.00

1. Calculate the standard deviation.(Use calculator and show all the working out). [2marks]

1. Calculate the coefficient of variation.(Use calculator and show all the working out).

[2marks]

1. Calculate the interquartile range (IQR) (Use the data in the excel file provided.[2marks]

1. Interpret the Standard deviation in the context of the scenario provided.[2marks]

1. Interpret the Interquartile range in the context of the scenario provided.[2marks]