Q.1 Create a Pareto chart for field of study.
Q.2 Create a histogram for height
Q.3 Create a scatter plot to illustrate the statistical relationship between GPA and expected grade in COMM (points)
Q.4 Inspect the scatter plot you have created for question 3. Does it suggest that there is some relationship between GPA and expected grade in COMM (points)? If yes, what is the relationship? Explain in short.
(Treat the data set as a sample. Round all numerical summaries to 3 decimal places (to the right of the decimal point).
Q.5 Find the mean height & the median height.
Q.6 Find the mode for age.
Q.7 Find the range for height, the variance for height & the standard deviation for height.
Q.8 Find the coefficient of variation for height.
Q.9 Find the covariance between GPA and expected grade in COMM 291 & the coefficient of correlation between GPA and expected grade in COMM 291.
Q.10. What does this coefficient of correlation between GPA and expected grade in COMM 291 tell you? Explain in short.
The post Excel data analysis | Statistics homework help appeared first on Perfect papers hoth.
