Math 221 WEEK 2 LAB Assignment Statistics Question # 00032570 Posted By: spqr Updated on: 11/20/2014 01:38 PM Due on: 12/12/2014 Subject Mathematics Topic General Mathematics Tutorials: 1 See full Answer Question FHEALTHThe required values for this lab can be computed by using either (or both) Excel and/or the TI calculator.The required graphs can be created by either (or both) Excel and/or hand-drawing.All answers must be entered on this document. Cutting and Pasting from Excel is one very acceptablemethod to enter the answers into this Word document. The finished document can be submitted in eitherelectronic form to the drop box (for the Week 2) or in hard-copy form during class.Part 1. Data Analysis for AGE variable.Open in the Excel File called FHEALTHAGE variable.WEEK 2.xlsx and compute the requested values for the1.Find the sample mean.Sample mean = ________________________2.Find the sample standard deviation.Sample Standard Deviation = ______________________3.Make a frequency distribution for the data. Start this distribution with a lower class limit of 10 andmake each class width 10.4.Create and insert a histogram for the data.5.Does the histogram appear to be bell-shaped?6.Find the median.Median = _______________________7.Find the maximum and the minimum value.Minimum value = ________________________Maximum value = _______________________8.What is the range?Range = ___________________________19.What is the first Quartile?Q1 = ________________________10.What is the second Quartile? (What is this also called?)Q2 = ______________________Q2 is also called __________________________11.What is the third Quartile?Q3 = ________________________12.What is the Interquartile Range, IQR?IQR = ___________________13.What is the 80th percentile?P80 = __________________________14a.Starting from the mean value, compute the values that are +/- one standard deviation from themean.____________________________________________________14b.Count the number of data values that are between these two computed numbers (from 14a).Number of data values within 1 standard deviation of mean = ____________________14c.This counted number corresponds to what percent of the total data values?Percent of data values within 1 standard deviation of mean = ______________________14d.Does this percent agree with the Empirical Rule? Explain why or why not.15a.Starting from the mean value, compute the values that are +/- two standard deviations from themean.____________________________________________________15b.Count the number of data values that are between these two computed numbers (from 15a).Number of data values within 2 standard deviations of mean = ______________________15c.This counted number corresponds to what percent of the total data values?Percent of data values within 2 standard deviations of mean = ________________________15d.Does this percent agree with the Empirical Rule? Explain why or why not.16a.Both the mean and the median are measures of central tendency. Both of these values werecomputed above. In this case, does one measure have any benefits over the other in describingthe center of the distribution? Does a comparison of these two values provide additional information about the shape of the distribution?16b.Similarly, both the standard deviation and the IQR are measures of variation. Both of these valueswere computed above. In this case, does one measure have any benefits over the other in describing the spread of the data? Does a comparison of the two values for Q 1 and Q3 (used tocompute the IQR) provide additional information about the shape of the distribution?2Part 2. Data Analysis for WT variable.Open in the Excel File called FHEALTHvariable. This is the weight variable.WEEK 2.xlsx and compute the requested values for the WT1.Find the sample mean.Sample mean = ________________________2.Find the sample standard deviation.Sample Standard Deviation = _____________________3.Make a frequency distribution for the data. Start this distribution with a lower class limit of 75 andmake each class width 25.4.Create a histogram for the data.5.Does the histogram appear to be bell-shaped?6.Find the median.Median = _________________________7.Find the maximum and the minimum value.Minimum value = _________________________Maximum value = _________________________8.What is the range?Range = ______________________9.What is the first Quartile?Q1 = ________________________10.What is the second Quartile? (What is this also called?)Q2 = _______________________Q2 is also called ________________11.What is the third Quartile?Q3 = _____________________12.What is the Interquartile Range, IQR?IQR = _____________________13.What is the 80th percentile?P80 = ______________________14a.Starting from the mean value, compute the values that are +/- one standard deviation from themean._____________ = _____________________ = ________314b.Count the number of data values that are between these two computed numbers (from 14a).Number of data values within 1 standard deviation of mean = ___________________14c.This counted number corresponds to what percent of the total data values?Percent of data values within 1 standard deviation of mean = ____________________14d.Does this percent agree with the Empirical Rule? Explain why or why not.15a.Starting from the mean value, compute the values that are +/- two standard deviations from themean.________________________________________15b.Count the number of data values that are between these two computed numbers (from 15a).Number of data values within 2 standard deviations of mean = ______________________15c.This counted number corresponds to what percent of the total data values?Percent of data values within 2 standard deviations of mean = _______________________15d.Does this percent agree with the Empirical Rule? Explain why or why not.16a.Both the mean and the median are measures of central tendency. Both of these values werecomputed above. In this case, does one measure have any benefits over the other in describingthe center of the distribution? Does a comparison of these two values provide additional information about the shape of the distribution?16b.Similarly, both the standard deviation and the IQR are measures of variation. Both of these valueswere computed above. In this case, does one measure have any benefits over the other in describing the spread of the data? Does a comparison of the two values for Q 1 and Q3 (used tocompute the IQR) provide additional information about the shape of the distribution?4Part 3. Random Sampling for AGE VariableCreate a simple random sample of size 20 from theferent individuals.AGE variable. Be sure to have the ages for 20 dif-1.What method did you choose to randomly select 20 different individuals to get their ages?2.Did you have any duplicate observations in your data? If yes, what actions did you take?3.List the age data you generated for the all 20 individuals.4a.What is the mean age for this simple random sample of 20 individuals?Mean = ____________________________4b.How does the mean age from 4a compare with the mean age from the Part 1 mean age?Mean age from Part 1 Number 1 = _________________Mean age from Part 3 Number 4a = __________________4c.Comment on the values from 4b above. For example, are they close, why are they different, etc.. Rating: 4.9/5

## Solution: Math 221 WEEK 2 LAB Assignment Statistics

Tutorial # 00031940Posted By: spqr Posted on: 11/20/2014 01:39 PM