Statistical Analysis of Student Car Travel Time and Car Model

This assignment presents a comprehensive statistical analysis of student car travel times, incorporating data on the time taken to commute and the model of the car used. The analysis begins with defining and collecting data, followed by organizing and visualizing it using tables, charts, and frequency distributions. Descriptive statistics are then calculated, including measures of central tendency (mean, median, mode), dispersion (variance, standard deviation), and shape (skewness). The assignment proceeds to confidence interval estimation using both Z-tests and T-tests, followed by hypothesis testing to evaluate the null hypothesis regarding travel time. Finally, the paper explores correlation and linear regression to assess the relationship between travel time and car model, providing regression statistics and coefficient analysis, all using MS Excel. The conclusion summarizes the key statistical measures and techniques employed throughout the analysis.