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.

ANSWER - 55 GB

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.

ANSWER - 123.5 GB

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).

offer by the ten mobile networks. Please include the formula you

use for full marks.

ANSWER - 55 GB

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.

ANSWER - 123.5 GB

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).

It's impossible to know without looking at the dataset itself.

But do you know the mean could be misleading if the dataset is "not nice" (also what do I mean by not nice)?

But do you know the mean could be misleading if the dataset is "not nice" (also what do I mean by not nice)?

Original post by tonyiptony

It's impossible to know without looking at the dataset itself.

But do you know the mean could be misleading if the dataset is "not nice" (also what do I mean by not nice)?

But do you know the mean could be misleading if the dataset is "not nice" (also what do I mean by not nice)?

Although I'm inclined to agree that "you need the dataset", the wording of the question does somewhat imply you should make a decision just based on the answers to (i) and (ii). Not that I'd want to try to do so, you understand!

Original post by ade2

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.

ANSWER - 55 GB

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.

ANSWER - 123.5 GB

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).

offer by the ten mobile networks. Please include the formula you

use for full marks.

ANSWER - 55 GB

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.

ANSWER - 123.5 GB

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).

It's hard to tell without the data. For example, if the numbers go like 10,10,10,10,10,10,10,10,10, 1000000, the median is a better indicator since 1000000 props up the mean.

Just knowing the median and mean doesn't tell us much. It's really a question about data analysis and anomalies, etc in the data.

- Chemistry equation question
- Genetics Problem - 12.5?
- MAT 1996-2006 Solution Thread
- pulleys-mechanics, pls help i cant solve the whole question
- I need help in this question
- BBO 2023 solutions
- A Level Chemistry Exam Question-need help!
- Need help with A Level Simple Harmonic Motion question
- Transition Metal Ions
- STEP III and A level further maths modules
- Mat 1996 mcq
- Comparing elastic and inelastic collision unknown mass
- Physics/ Maths question help please
- 2023 STEP 3 Math
- HNC science
- Physics A G482 EWP Unofficial mark Scheme
- STEP 2016 Solutions
- Msc in mathematics and physics
- AQA A-Level War of Roses
- Chemistry help - organic analysis

Latest

Trending