T-Mobile LTE * 96%- 3:36 PM webassign.net Many standard statistical methods that

Question

T-Mobile LTE * 96%- 3:36 PM webassign.net Many standard statistical methods that you will study in Part II of this book are intended for use with distributions that are symmetric and have no outliers. These methods start with the mean and standard deviation, x and s. For example, standard methods would typically be used for the IQ and GPA data here data46.dat. (a) Find x and s for the IQ data. (Round your answers to two decimal places) (b) Find the median IQ score. It is, as we expect, close to the mean. (c) Find the mean and median for the GPA data. The two measures of center differ a bit. (Round your answers to two decimal places.) What feature of the data (make a stemplot or histogram to see) explains the difference? Click on the mean for each of the following graphs. (One of these lines is the median.) ABC A BC

Explanation / Answer

a) We have given that the dataset of gpa and iq.

First we have to find mean, median and standard deviation for the iq data.

This we can find in excel.

syntax :

=average(select iq range)

Mean = 99.67

=stdev(select iq range)

s = 14.09

b)

=median(select iq range)

Median = 98.5

Yes median is closer to the mean.

c) Now we have to find mean and median for the gpa data.

Mean = 8.05

Median = 8.78

Now we have to draw histogram of the data.

We can draw histogram in excel.

steps :

ENTER data into excel sheet --> Insert --> Charts --> Column --> 2-D column --> Select first option --> right click on the bars --> Format data series --> Adjust gap width to 0 --> close

From this you get boxplot of the datasets.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.