The HR of the "ABC837" company collected data regarding retirement funds. Each retirement fund is listed with its type, market cap, rating, return, risk. view the data (attached excel)

Question content area bottom

Part 1 a) [4 marks] Construct a frequency distribution (pivot table) and a bar chart (pivot chart), use the Rating variable. Arrange bars properly (from One to Five), show relative frequencies (%) on bars, add all necessary labels.

Copy the table in the box below, and upload the chart as a picture into Show work.

b) [2 marks] What is the level of measurement left parenthesis nominal comma ordinal comma interval comma ratio right parenthesis of Rating and how is it different from other levels question mark

c) [4 marks] Choose the best measure of centre (mean, median, mode) for Rating; explain why it is the best measure in this case; find its value; explain its meaning in the context of this data.

https://cdn.fbsbx.com/v/t59.2708-21/428528675_805533714745592_2097873301217950660_n.xlsx/data-2_21_2024-3_12-PM.xlsx?_nc_cat=100&ccb=1-7&_nc_sid=2b0e22&_nc_ohc=gyPFRo3hbLQAX-KSQGV&_nc_ht=cdn.fbsbx.com&oh=03_AdR4U3x1rns11TnWD3Csf9EbHswzSyiYJWiq2p4dzrdzHA&oe=65D80107&dl=1