Based on the information in the table, answer the following questions (a – d) and ensure to show your work. 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 SIMonly 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. 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. iii) Based on your two answers in part i) and ii), which answer would give a better indication of the average number of Gigabytes (
Based on the information in the table, answer the following questions (a – d) and ensure
to show your work.
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 SIMonly 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.
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.
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.
Step by step
Solved in 3 steps with 2 images
