Comparison Table For Sim Only Deal

NETWORK TEXTS MINUTES DATA $($GB OF $5$G$)$ CONTRACT $($MONTHS$)$ MONTHLY COST

Clever Network $100036070110$

CO$250018030125$

Chat Mobile $75024070128$

Handy Mobile $1000720140110$

Rebala $500$ UNLIMITED $30125$

Dovefone $8506006068$

Four Network $9004802565\mathrm{.}99$

Escot $2002407501212$

Costnet $90048050128$

S$-$ Mobile $950$ UNLIMITED $101210$

Above is a table comparing the different SIM$-$only deals offered by $10$ mobile networks. Based on the information in the table, answer the following questions $($a $$ d$)$ and ensure to show your work to get full marks for each question.

a$)$ By using appropriate cell formatting techniques outlined in this module, reproduce the above spreadsheet in Excel. Take a clear screenshot and insert it into your portfolio as your answer to this question. Ensure you include row and column identifiers in your screenshot, so it is clear that you have used Excel to reproduce the table.

b$)$ Use Excel or otherwise to find the mean average monthly cost of a SIM only contract. Please round your answer to the nearest integer.

c$)$ i$)$ Use Excel to find the median number of Gigabytes $($GB$)$ of data on offer by the ten mobile networks. Please include the formula you use for full marks.

ii$)$ Use Excel to find the mean average of Gigabytes $($GB$)$ of data on offer by the ten mobile networks. Please include the formula you use for full marks.

iii$)$ Based on your two answers in part i$)$ and ii$),$ which answer would give a better indication of the average number of Gigabytes $($GB$)$ of data on offer by the ten mobile networks.

iv$)$ Give a reason for your answer to part iii$).$

d$)$ If you were to choose between ESCOT and Rebala, which one would you personally choose? You must give a reason for your answer.