Excel Practice #1

Excel Practice #1 - Answers to Excel Practice Problems Part...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Answers to Excel Practice Problems Part 1 Economics 261- Dr. Djeto Assané Fall 2011
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
A.) Descriptive Statistics Table 1 Variable Mean Standard Deviation Minimum Maximum Time 38.7 7.60 25 48 Grade 71.9 14.71 47 90 Given the data set and subsequent summary statistics, the average time spent studying for this course is 38.7 hours, while the average grade score for this course is 71.9. The minimum and maximum for each variable create a range of 23 and 43, respectively. The ranges seem extremely large for a data set so small. Sixty percent of the data in the time category fall within one standard deviation of the mean. A standard deviation of 7.60 suggests there are some extreme outliers in this data set. Similarly, eighty percent of the data in the grade category fall within one standard deviation of the mean. A standard deviation of 14.71 suggests there are also some extreme outliers in this data set. The distributions of the data sets suggest they are a skewed distribution. B.) Correlation Coefficient Table 2 Variable Time Grade Time 1 Grade .901049 1 The correlation between time spent studying and the grade received in this course is near 1
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

Excel Practice #1 - Answers to Excel Practice Problems Part...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online