MATH225N-61306ModulesWeek 5 Assignment: LabMarch 2020HomeSyl

MATH225N-61306ModulesWeek 5 Assignment: LabMarch 2020HomeSyllabusAnnouncementsResourcesModulesFilesGradesPeopleBookstoreLibrary GuidesMedia GalleryMy MediaNew WebexAcademic SupportWeek 5 Assignment: LabDueApr 5 by11:59pmPoints50Submittinga file uploadRequired ResourcesRead/review the following resources for this activity:OpenStax Textbook: Chapter 2, 6, and 7LessonWeeks 3 and 5 Excel SpreadsheetsScenario/SummaryThis week’s lab highlights the use of probability and normal distribution.Follow the directions below to gather data, calculate using Excel spreadsheets, and interpret the results.DeliverablesThe deliverable is a Word document with your answers to the questions posed below based on the data you find.Required SoftwareMicrosoft WordMicrosoft ExcelSteps to Complete Week 5 LabUse the Weeks 3 and 5 spreadsheets to help you answer the questions below.Step 1: Survey or measure 10 people to find their heights. Determinethe mean and standard deviation for this group by using the Week 3 Excelspreadsheet. Post a screen shot of the portion of the spreadsheet thathelped you determine these values. How does your height compare to themean (average) height of the group that you surveyed? Is your heighttaller, shorter, or the same as the mean of your group?Data Example of 10 people with different heightsStep 2: Give some background information on the group of people youused in your study. You might consider using the following questions toguide your answer.How did you choose the participants for your study (sampling method)?What part of the country did your study take place in?What are the age ranges of your participants?How many of each gender did you have in your study?What are other interesting factors about your group?Step 3: Use the Week 5 Excel spreadsheet for the following.(Use the Empirical Rule tab from the spreadsheet).Determine the 68%, 95%, and 99.7% values of the Empirical Rule in termsof the ten heights in your height study.What do these values tell you?Post a screen shot of your work from the Week 5 Excel spreadsheet.Week 5 Spreadsheet Example(Use the normal probability tab from the spreadsheet). Based on yourstudy results, what percent of the study participants are shorter thanyou? What percent are taller than you?Post a screen shot of your work from the Week 5 Excel spreadsheet. Example: If my height is 73 inches, then 20.86% of the relevant population is shorter. The other 79.14%, of course, is taller.Week 5 Spreadsheet ExampleStep 4: Be sure your name is on the Word document, save it, and then submit it under ‘Assignments’ and ‘Week 5: Lab’.GradingThis activity will be graded based on the Week 5 Lab Rubric.Course Outcomes (CO): 3, 4, 5Due Date: By 11:59 p.m. MT on SundayRubricWeek 5 Assignment: LabWeek 5 Assignment: Lab Criteria Ratings PtsThis criterion is linked to a Learning OutcomeMeasures of Central Tendency and Variation12.0ptsAddressesall elements of the following: *10 height values *mean of data*standard deviation of data *screenshot of values calculated onspreadsheet *comparison of heights10.2ptsAddresses4 out of 5 of the following: *10 height values *mean of data *standarddeviation of data *screenshot of values calculated on spreadsheet*comparison of heights8.4ptsAddresses3 out of 5 of the following: *10 height values *mean of data*standard deviation of data *screenshot of values calculated onspreadsheet *comparison of heights6.6ptsAddresses1 or 2 out of 5 of the following: *10 height values *mean of data*standard deviation of data *screenshot of values calculated onspreadsheet *comparison of heights0.0ptsNo Effort12.0 ptsThis criterion is linked to a Learning OutcomePopulation Data and Sampling Techniques15.0ptsAddressesall elements of the following: *Sampling method *Location *Age group ofparticipants *Gender of participants *Other factors about participants12.75ptsAddresses4 out of 5 of the following: *Sampling method *Location *Age group ofparticipants *Gender of participants *Other factors about participants10.5ptsAddresses3 out of 5 of the following: *Sampling method *Location *Age group ofparticipants *Gender of participants *Other factors about participants8.25ptsAddresses1 or 2 out of 5 of the following: *Sampling method *Location *Agegroup of participants *Gender of participants *Other factors aboutparticipants0.0ptsNo Effort15.0 ptsThis criterion is linked to a Learning OutcomeProbability, and Measures that would follow a normal distribution in life sciences15.0ptsAddressesall elements of the following: *Empirical Rule values *Interpretationof Empirical Rule values *Screenshot of Empirical spreadsheet*Interpretation of Normal Distribution spreadsheet values *Screenshot ofprobabilities/ percentiles12.75ptsAddresses4 out of 5 of the following: *Empirical Rule values *Interpretation ofEmpirical Rule values *Screenshot of Empirical spreadsheet*Interpretation of Normal Distribution spreadsheet values *Screenshot ofprobabilities/ percentiles10.5ptsAddresses3 out of 5 of the following: *Empirical Rule values *Interpretation ofEmpirical Rule values *Screenshot of Empirical spreadsheet*Interpretation of Normal Distribution spreadsheet values *Screenshot ofprobabilities/ percentiles8.25ptsAddresses1 or 2 out of 5 of the following: *Empirical Rule values*Interpretation of Empirical Rule values *Screenshot of Empiricalspreadsheet *Interpretation of Normal Distribution spreadsheet values*Screenshot of probabilities/ percentiles0.0ptsNo Effort15.0 ptsThis criterion is linked to a Learning OutcomeGrammar and Formatting8.0ptsLab is easy to read and presents material in a logical order with no grammatical errors.6.8ptsLab iseasy to read and presents material in a logical order. There are a fewgrammatical errors but they do not distract from readability.5.6ptsLab is easy to read and has few grammatical errors, but it is not logically organized.4.4ptsThere are significant grammatical errors and organizational issues that distract from readability.0.0ptsNo Effort8.0 ptsTotal Points:50.0