OnlineNursingOwl
← All nursing posts

Statistics · Studypool

Data collection- excel and report

Overview

Data Collection: Students will collect two sets of data from the real world. Set 1 will be collected from a large number of observations (at least 100) for a continuous random variable from a population that is suspected to be normallydistributed. Examples of such data include the body weight of people, the circumferences of oranges, the extension length of rubber bands at the point at which they burst, etc. Set 2 will be the inter-arrival time of a sequence of 100 or more events. First, record the actual clock time (to the nearest second) of each of at least 100 consecutive events, such as the actual time that a customer enters the post office. Then, determine the interval between occurrences by taking the difference between successive event times. Consequently, Set 2 will comprise of at least 99 inter-arrival times. You may use 'second' as a unit of time. You must get instructor permission before starting to collect data for each project to ensure the relevance, quality and accuracy of your data.

Descriptive Statistics: For both Sets 1 and 2, use software to do the following:

  • Calculate the sample mean and sample standard deviation.
  • Calculate the quartiles Q1, Q2, and Q3.
  • Construct a box-and-whisker plot.
  • Construct a frequency table.
  • Construct a frequency histogram.

Report: The project report is to be written in clear English with complete sentences. Be sure to define all notations and include descriptions of all tables and figures in the text. . Your report should include a cover page, the following sections, and two appendices:

I.Data. Describe the data collection process for Sets 1 and 2 with enough detail that the reader could replicate the process. Appendices I and II should include tables of your raw data for Sets 1 and 2, respectively. The raw data for Set 2 consist of the recorded actual clock ties.

II.Descriptive Statistics: Include and explain your descriptive statistics analysis. Interpret the results of the analysis using your data application topic. Does Set 1 appear to follow a Normal Distribution? Does Set 2 appear to follow an Exponential Distribution?