Maths Report Math Problem Example | Topics and Well Written Essays - 1000 words

Maths Report - Math Problem Example The results also indicated that the smaller engine size cars have a higher MPG as compared to the bigger engine size cars. In conclusion, there is a strong negative linear relationship between a car’s engine size and its MPG and a car with a bigger engine size has the lower MPG as compared to a car with a smaller engine size. We have been provided with the car sales data containing 99 records for car make, model, price (new), price (used), age, engine size and MPG. First, I numbered each row of data as 1, 2, 3, and so on and then I used random sampling method for selecting a sample of 30 cars data using Excel Sampling (DataïÆ'  Data AnalysisïÆ'  SamplingïÆ'  Random) as shown in below screenshot showing only first 15 car number out of 30. For the Hypothesis 1, the type of calculations I performed were mean, median, mode, minimum, maximum and range, so that I know the averages and measures of spread of the car’s engine size and cars MPG. The type of statistical diagrams I made were stem and leaf diagrams, so that I investigate the distributions of cars engine size and cars MPG and scatter graph for investigating the relationship between a car’s engine size and its MPG. For the Hypothesis 2, the type of calculations I performed were mean, median, mode, minimum, maximum and range, and also lower and upper quartiles, so as I know the averages, measures spread and five figure summary of cars MPG for both the smaller and bigger engine size cars. The type of statistical diagrams I made were cumulative frequency diagrams, so that I recalculate lower and upper quartiles and median value of cars MPG for both the smaller and bigger engine size cars, and boxplots for comparing cars MPG for both the smaller and bigger engine size cars. The average engine size of cars is about 1.69L. About half of the car’s engine size is under 1.8L and the most common engine size of cars is 1.8L. The range of the car’s engine size is 2.05L