Please answer all the questions 100% correctly. 1) Please explain, why is a data
ID: 3072189 • Letter: P
Question
Please answer all the questions 100% correctly.
1) Please explain, why is a data visualization software such as tableau more useful than a spreadsheet software such as Microsoft Excel? Please give at least three reasons in support of your response and use bullet/numbering format wherever applicable.(150 words)|
2) An experiment picked 100 high school students from Springfield area. Can you assume that the height of these 100 students be a normal distribution? Why? [5 points]
3) What is the difference between Mean and Median in terms of measuring the center of a set of data points? Which one would you use in the following situations and WHY? [15 points]
a) Randomly sampled 10,000 US households for measuring typical US household income.
b) Randomly sampled 100 high school students from Springfield area for measuring typical high school student height.
c) To measure the cost of shipping in Missouri, a company randomly sampled 1000 from orders placed in Missouri and recorded the actual shipping time.
Explanation / Answer
2)
We can assume that the height of these 100 students be a normal distribution
this is because of central limit theorem
the central limit theorem states that when samples from a data set with a known variance are aggregated their mean roughly equals the population mean. Said another way, CLT is a statistical theory that states that given a sufficiently large sample size from a population with a finite level of variance, the mean of all samples from the same population will be approximately equal to the mean of the population. Furthermore, all the samples will follow an approximate normal distribution pattern, with all variances being approximately equal to the variance of the population divided by each sample's size.
Please post rest questions again
You should post one question at one time