Using the spreadsheet provided

II. Using the spreadsheet provided, please answer each question. You must show work for the problems…

II. Using the spreadsheet provided, please answer each question. You must show work for the problems where this is indicated.
image.png
22 42 41 User # Gender Age Height Major Shoe Size Times Eat Out Hours Sleep 1 Female 25 62 Other 2 Male 69 Nursing/Health Sci
NO Yes No Fan of Scandal Marital Status Yes Single No Single No Single Married Single Single Single No Married Married Marr
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?
We were unable to transcribe this image
22 42 41 User # Gender Age Height Major Shoe Size Times Eat Out Hours Sleep 1 Female 25 62 Other 2 Male 69 Nursing/Health Science 3 Female 71 Nursing/Health Science 4 Male 24 73 Business Administration 5 Female 71 Business Administration 6 Female 20 59 Nursing/Health Science 7 Female 19 62 Nursing/Health Science 8 Female 40 64 Social Work/Sociology 9 Male 25 64 Other 10 Female 36 64 Social Work/Sociology 11 Male 69 Business Administration 12 Female 30 66 Biology 13 Female 65 Nursing/Health Science 14 Female 38 64 Business Administration 15 Female 29 65 Business Administration 16 Female 28 62 Education 17 Female 28 66 Business Administration 18 Male 29 71 Nursing/Health Science 19 Female 25 62 Biology 20 Female 30 65 Nursing/Health Science 21 Female 28 67 Accounting 22 Male 67 Education 23 Female 22 64 Social Work/Sociology 24 Female 23 64 Biology 25 Female 42 67 Business Administration 26 Male 66 Business Administration 27 Male 74 Other 28 Female 31 65 Nursing/Health Science 29 Female 62 Social Work/Sociology 30 Female 64 Nursing/Health Science 31 Female 63 Nursing/Health Science 32 Male 24 70 Other 33 Female 39 62 Accounting 34 Female 61 64 Education ON 000 VON COOOOOoooooOOOOO 20 20 29 19 000
NO Yes No Fan of “Scandal” Marital Status Yes Single No Single No Single Married Single Single Single No Married Married Married No Married Single No Divorced Yes Married Married Married Single No Single No Single No Married Yes Married No Single Yes Single Married Married Single Married Single Single Yes Single No Married Single Divorced Divorced Yes