Comparison of Two Sets of Data Lab Report Example | Topics and Well Written Essays - 1500 words

Comparison of Two Sets of Data - Lab Report Example The lab report "Comparison of Two Sets of Data" overviews two datasets of gross motor vehicle domestic weights from the year 2002 and from the year 2004. This report applied information from a secondary source for its investigation. The collected data was then subjected to statistical analysis using excel from which cumulative were developed. Further, histograms were developed to facilitate analysis of the two sets of data. Gross vehicle domestic weight refers to the maximum weight of a vehicle based on the manufacturer’s specification. It normally indicates the combined weights of all elements of a vehicle such as a frame, body, engine, devices, luggage, and passengers. This information is contained in vehicles’ registration documents. Statistical applications that offer ground for comparing and contrasting records of motor vehicle weights over periods can be used to investigate the existence of a change in a trend of gross weights. The combination of statistics from the two periods of time allows for easier analysis into identifying similarities and differences between the two sets of data. A review of the combined frequency distribution table, for example, identifies a comparative trend in the weights of the vehicles between the intervals less than 20 kipps up to 69.9 kipps. Though the paired frequencies within this range vary across the two years, the differences are significantly small, falling within a one percent disparity. A difference is observed beyond 70 kipps frequencies reported in the year 2004.... .6% 100-109.9 35 0.1% 110-119.9 13 0.0% >120 Kips 13 0.0% In order to gain a clearer insight into the two sets of data, histograms were developed as shown bellow, Histogram for the year 2002 Histogram for the year 2004 Combined results tor the two period were also calculated as shown bellow Frequency distribution table for the year 2002 and the year 2004 Bin 2002 2004 120 Kips 0.0% 0.0% Stacked histogram for the years 2002 and 2004 Combination of statistics from the two periods of time allows for easier analysis into identifying similarities and differences between the two sets of data. A review of the combined frequency distribution table, for example, identifies a comparative trend in the weights of the vehicles between the intervals from less that 20 kipps upto 69.9 kipps. Though the paired frequensies within this range varies across the two years, the differences are significantly small, falling within a one percent disparity. A difference is however observed beyond 70 kipps at w hich frequencies reported in the year 2004 are significantly higher than the frequencies reported in the year 2002. This observation is clearly identified from the stacked histogram that identifies higher percentage frequencies in the year 2002 for values lower than 70 kipps. The percentage frequencies in 2002 however goes bellow those in the year 2004 for the intervals that falls above 70 kipps. The similarity in trend of the reported data for the intervals that falls bellow 70 kipps indicates that the percentage distribution in demand, and hence production and use of vehicles