Get Instant Help From 5000+ Experts For

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Insights into the typical price consumers are willing to pay for a LED selfie ring light - MN4063 Au

## Task 1 - Computing mean and standard deviation

To gain some insights into the typical price consumers are willing to pay for a LED selfie ring light, an online  retailer  randomly  selected  58 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 “MN4063 Autumn CWK 1 Data” under the tab labelled Task 1.

1.  With reference  to Table 1 above  and using a calculator,  find the mean and standard  deviation. Insert your values on the table and copy into your Word document.

2.  Interpret   the   mean   and   standard   deviation   in   the   context   of   the   scenario   provided. NB: You should not describe the calculation methods or the formulae used.

It was suggested to the retailer that the 58 transaction values could also be summarised in a grouped table (see Table 2 below). Two table templates based on Table 2 have been made available in the Excel file named “MN4063 Autumn CWK 1 Data” under the tab labelled Task 2.

Required for Task 2  (Comments for task 2 should not exceed 250 words in total.) 1.Using the three table templates provided in the Excel data file as a starting point, construct three tables in Excel.
Table 2A: The first table should show the frequencies and percentage frequencies.
Table 2B: The second table should show the ‘less than’ cumulative  frequencies  and cumulative percentage frequencies.
Table 2C: Complete  the third table to estimate the mean,  variance, standard deviation and the coefficient of variation.
Transfer the three Excel tables into your Word document in a clear and professional manner. Construct the network diagram using the standard node layout (see below) introduced in the lecture.