# [Solution] Categorical Analysis

Q1: Assigned Problem 1: Perform a categorical analysis on fees for this sample of mutual funds. Describe your findings Assigned Problem 2: Create a frequency distribution and a histogram of the NAVs. Use eight classes of data. Edit the graph to make it professional looking. Describe your findings Assigned Problem 3: Compute the descriptive statistics for the 1-year return of the mutual funds. Describe your findings Q2Assigned Problem 1: Create a pivot table (also known as crosstabulation or a contingency table) of Race and Low Birth Weight on Excel so you can answer the following: What is the probability of randomly choosing a Black woman? What is the probability of randomly choosing a White woman AND a Low birth weight? What is the probability of randomly choosing a Black woman OR a Low birth weight? Given that the mother you selected is a White, what is the probability she had Low birth weight? Given that the mother had low birth weight, what is the probability she is Black? Assigned Problem 2: Let us assume that the Low_Birth_Weight. is a random sample from the Concordia Hospital in 2018. We are given that the mean birth weight is approximately 6.5 pounds with a standard deviation of 1.6 pounds. Note: The national standard is that a birth weight below 5.5 pounds is low. Using Microsoft Excel compute the following: What is the probability of low birth weight (< 5.5 pounds) occurring at Concordia? What is the probability of a birth weight being above the national average of 7.5 pounds? What is the probability of a birth weight being between 5 and 6 pounds? The bottom 10% of births by weight are below what weight?Q3 Assigned Problem 1: First compute the mean total weight and standard deviation of the garbage disposed of each week by the sample. Then, compute the 95% confidence interval of the mean total garbage disposed of in a week on Concordia St. Describe your findings. Assigned Problem 2: First compute the proportion of homes in the sample that recycle. Then, compute the 95% confidence interval of the proportion of homes on Concordia St. that recycle. Describe your findings. Assigned Problem 3: You wish to learn the average number of pounds of garbage disposed of in a week by the people on Concordia St. within two pounds. Using the standard deviation from problem 1 as an estimate, how large of a sample should you obtain? Assigned Problem 4: You wish to learn the proportion of homes on Concordia St. that recycle within 10% of the true population proportion and be 99% confident of the results. How large of a sample should you obtain?

Q1: Assigned Problem 1: Perform a categorical analysis on fees for this sample of mutual funds. Describe your findings Assigned Problem 2: Create a frequency distribution and a histogram of the NAVs. Use eight classes of data. Edit the graph to make it professional looking. Describe your findings Assigned Problem 3: Compute the descriptive statistics for the 1-year return of the mutual funds. Describe your findings Q2Assigned Problem 1: Create a pivot table (also known as crosstabulation or a contingency table) of Race and Low Birth Weight on Excel so you can answer the following: What is the probability of randomly choosing a Black woman? What is the probability of randomly choosing a White woman AND a Low birth weight? What is the probability of randomly choosing a Black woman OR a Low birth weight? Given that the mother you selected is a White, what is the probability she had Low birth weight? Given that the mother had low birth weight, what is the probability she is Black? Assigned Problem 2: Let us assume that the Low_Birth_Weight. is a random sample from the Concordia Hospital in 2018. We are given that the mean birth weight is approximately 6.5 pounds with a standard deviation of 1.6 pounds. Note: The national standard is that a birth weight below 5.5 pounds is low. Using Microsoft Excel compute the following: What is the probability of low birth weight (< 5.5 pounds) occurring at Concordia? What is the probability of a birth weight being above the national average of 7.5 pounds? What is the probability of a birth weight being between 5 and 6 pounds? The bottom 10% of births by weight are below what weight?Q3 Assigned Problem 1: First compute the mean total weight and standard deviation of the garbage disposed of each week by the sample. Then, compute the 95% confidence interval of the mean total garbage disposed of in a week on Concordia St. Describe your findings. Assigned Problem 2: First compute the proportion of homes in the sample that recycle. Then, compute the 95% confidence interval of the proportion of homes on Concordia St. that recycle. Describe your findings. Assigned Problem 3: You wish to learn the average number of pounds of garbage disposed of in a week by the people on Concordia St. within two pounds. Using the standard deviation from problem 1 as an estimate, how large of a sample should you obtain? Assigned Problem 4: You wish to learn the proportion of homes on Concordia St. that recycle within 10% of the true population proportion and be 99% confident of the results. How large of a sample should you obtain?
**So much stress and so little time? We’ve got you covered. Get your paper proofread, edited or written from scratch within the tight deadline.**