Question

II. Using the spreadsheet provided, please answer each question. You must show work for the problems where this is indicated. Round all answers to the nearest hundredth where necessary. 5. Name two categories that have qualitative data. 6. Name two categories that have quantitative data that is discrete, 7. Name two categories that have quantitative data that is continuous. 8. Build a frequency chart for the category “Major". 9. Build a relative frequency chart for the category “Number of Siblings". 10. Build a frequency chart for the category “Age". Use 18 as the lower bound for the first class and use a class size of 5. 11. Using the results of #10, construct a histogram. (Be sure to provide all labels). 12. For the category of "Age" state the mean, median and mode. 13. For the category of "GPA" state the mean, median and mode. 14. For the category of "Age" state the range, the sample standard deviation, and the 5- Number-Summary. 15. Construct a box-plot for the category "Age". (Be sure to provide all labels). 16. Are there any outliers in the category "Age"? You must show your work here including the fences. 17. Find the LSRL using the category “Hours Studied" as the independent variable and the category "GPA" as the dependent variable. 18. Find the value of the correlation coefficient for problem #17. 19. Using the results from #17 above, predict a GPA for a student who studies 5 hours per week. Is this a good prediction? Why or why not?

Answer 1

5. Two categories having qualitative data :

• Favourite Pet
• Favourite Music

6. Two categories having quantitative data that is discrete :

• Sblings
• Children

7. Two categories having quantitative data that is discrete :

• GPA
• Hour Work

8. The frequency chart of the category " Major"

Major	Frequency
Other	4
Nursing/ Health science	10
Business administration	8
Social Work /Sociology	4
Biology	3
Education	3
Accounting	2

10 frequency Nursing/Health Science Other Business administration Biology Education Accounting Social Work Sociology